nadialeiden opened a new issue, #10506: URL: https://github.com/apache/iceberg/issues/10506
### Query engine Hive 4.0.0 ### Question **Versions** Hive 4.0.0 Hadoop 3.4.1 **Problem** Hello, I have just encountered a problem regarding to Hive and Iceberg. Based on [https://iceberg.apache.org/docs/latest/hive/#feature-support](url), Hive 4 doesn't need any additional configurations to use Iceberg. Moreover, regarding the catalog, it said that if we does not specify any catalog, it will automatically set to use a HiveCatalog. So I just created the table using this command: `CREATE EXTERNAL TABLE test ( id INTEGER, name STRING ) STORED BY ICEBERG LOCATION '/user/username/datasets/icebergTest';` and then I inserted a value: `INSERT INTO test VALUES (1, 'John'), (2, 'Jane'), (3, 'Doe');` It seemed to insert without any problem, as it returned a message that said 3 rows are affected, and when I checked hive.log it does not seem to encounter a problem while inserting it. However, when I do `select * from test;` it returns nothing as follows: +----------+------------+ | test.id | test.name | +----------+------------+ +----------+------------+ It successfully generated three directories: metadata, data (containing parquet file), and a temp directory on hdfs. But I can't seem to find why Hive could not read the table. Everything works fine if I created or inserted a table without Iceberg. I have also done `DESCRIBE FORMATTED test;` it returned:  And the table looks like it saved as an iceberg table and also points to the right directory that stores the metadata. Does this has something to do with the Hive version I'm using? or something with Metastore? Any advice will be appreciated, thank you -- 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: issues-unsubscr...@iceberg.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@iceberg.apache.org For additional commands, e-mail: issues-h...@iceberg.apache.org
