samredai commented on code in PR #5161: URL: https://github.com/apache/iceberg/pull/5161#discussion_r913804754
########## docs/hive.md: ########## @@ -24,20 +24,63 @@ menu: main # Hive Iceberg supports reading and writing Iceberg tables through [Hive](https://hive.apache.org) by using -a [StorageHandler](https://cwiki.apache.org/confluence/display/Hive/StorageHandlers). Here is the current compatibility -matrix for Iceberg Hive support: +a [StorageHandler](https://cwiki.apache.org/confluence/display/Hive/StorageHandlers). -| Feature | Hive 2.x | Hive 3.1.2 | -| ------------------------ | ---------------------- | ---------------------- | -| CREATE EXTERNAL TABLE | ✔️ | ✔️ | -| CREATE TABLE | ✔️ | ✔️ | -| DROP TABLE | ✔️ | ✔️ | -| SELECT | ✔️ (MapReduce and Tez) | ✔️ (MapReduce and Tez) | -| INSERT INTO | ✔️ (MapReduce only)️ | ✔️ (MapReduce only) | +## Feature support +Iceberg compatibility with Hive 2.x and Hive 3.1.2/3 supports the following features: + +* Creating a table +* Dropping a table +* Reading a table +* Inserting into a table (INSERT INTO) + +{{< hint warning >}} +DML operations work only with MapReduce execution engine. +{{< /hint >}} + +With Hive version 4.0.0-alpha-1 and above, +the Iceberg integration when using HiveCatalog supports the following additional features: + +* Creating an Iceberg identity-partitioned table +* Creating an Iceberg table with any partition spec, including the various transforms supported by Iceberg +* Creating a table from an existing table (CTAS table) +* Altering a table while keeping Iceberg and Hive schemas in sync +* Altering the partition schema (updating columns) +* Altering the partition schema by specifying partition transforms +* Truncating a table +* Migrating tables in Avro, Parquet, or ORC (Non-ACID) format to Iceberg +* Reading the schema of a table +* Querying Iceberg metadata tables +* Time travel applications +* Inserting into a table (INSERT INTO) +* Inserting data overwriting existing data (INSERT OVERWRITE) + +{{< hint warning >}} +DML operations work only with Tez execution engine. +{{< /hint >}} ## Enabling Iceberg support in Hive -### Loading runtime jar +### Hive 4.0.0-alpha-1 + +Hive 4.0.0-alpha-1 comes with the Iceberg 0.13.1 included. No additional downloads or jars are needed. + +### Hive 2.3.x, Hive 3.1.x + +You need to do the following steps: +* Loading runtime jar +* Enabling support +Collaborator +@samredai samredai 26 days ago +This could just be one line right? Review Comment: Ah thanks for catching this, let me open a PR -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
