THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
| Database | Supported | Comment | Not Supported | Comment |
| CREATE | SHOW DATABASES LIKE | Show databases filtering by a regular expression. Missing Catalog API. | ||
| DROP | ||||
| ALTER | ||||
| USE | ||||
| SHOW | ||||
| DESCRIBE | We don't have a TableEnvironment API for this. Perhaps it's easier to implement when FLIP-84 is in place. | |||
| Table | CREATE | Support specifying EXTERNAL, PARTITIONED BY, ROW FORMAT, STORED AS, LOCATION and table properties. Data types will also be in HiveQL syntax, e.g. STRUCT | Bucketed tables | |
| DROP | CREATE LIKE | Wait for FLIP-110 | ||
| ALTER | Include rename, update table properties, update SerDe properties, update fileformat and update location. | CREATE AS | Missing underlying functionalities, e.g. create the table when the job succeeds. | |
| SHOW | Temporary tables | Missing underlying functionalities, e.g. removing the files of the temporary table when session ends. | ||
| DESCRIBE | SKEWED BY [STORED AS DIRECTORIES] | Currently we don't use the skew info of a Hive table. | ||
| STORED BY | We don't support Hive table with a storage handler yet. | |||
| UNION type | ||||
| TRANSACTIONAL tables | ||||
| DROP PURGE | Data will be deleted w/o going to trash. Applies to either a table or partitions. Missing Catalog API. | |||
| TRUNCATE | Remove all rows from a table or partitions. Missing Catalog APIs. | |||
| TOUCH, PROTECTION, COMPACT, CONCATENATE, UPDATE COLUMNS | Applies to either a table or partitions. Too Hive-specific or missing underlying functionalities. | |||
| SHOW TABLES 'regex' | Show tables filtering by a regular expression. Missing Catalog API. | |||
| FOREIGN KEY, UNIQUE, DEFAULT, CHECK | These constraints are currently not used by the Hive connector. | |||
| Partition | ALTER | Include add, drop, update fileformat and update location. | Exchange, Discover, Retention, Recover, (Un)Archive | Too Hive-specific or missing underlying functionalities. |
| SHOW | Support specifying partial spec | RENAME | Update a partition's spec. Missing Catalog API. | |
| DESCRIBE | We don't have a TableEnvironment API for this. Perhaps it's easier to implement when FLIP-84 is in place. | ALTER with partial spec | Alter multiple partitions matching a partial spec. Missing Catalog API. | |
| Column | ALTER | Change name, type, position, comment for a single column. Add new columns. Replace all columns. | ||
| Function | CREATE | CREATE FUNCTION USING FILE|JAR… | To support this, we need to be able to dynamically add resources to a session. | |
| DROP | RELOAD | Hive-specific | ||
| SHOW | SHOW FUNCTIONS LIKE | Show functions filtering by a regular expression. Missing Catalog API. | ||
| View | CREATE | Wait for FLIP-71 | SHOW VIEWS LIKE | Show views filtering by a regular expression. Missing Catalog API. |
| DROP | Wait for FLIP-71 | |||
| ALTER | Wait for FLIP-71 | |||
| SHOW | Wait for FLIP-71 | |||
| DESCRIBE | Wait for FLIP-71 |
...