Hi Team,
I would like to let you know that the Hive team released Hive 4.0.0-alpha-1.
Using this release it is possible to create, read, write Iceberg V1 tables with
Hive. There are some rough edges there but most of the queries, functions
should be working.
Just some examples:
CREATE EXTERNAL TABLE ice_t (s STRING, i INT, j INT) PARTITIONED BY SPEC
(TRUNCATE(1, s)) STORED BY ICEBERG STORED AS ORC;
INSERT INTO ice_t VALUES ('hive', 4, 4);
ALTER TABLE ice_t SET PARTITION SPEC (s);
INSERT INTO ice_t VALUES ('impala', 5, 5);
SELECT * FROM default.ice_t.entries;
SELECT * FROM default.ice_t.files;
SELECT * FROM default.ice_t.history;
SELECT * FROM ice_t FOR SYSTEM_TIME AS OF '2022-02-14 12:41:50';
SELECT * FROM ice_t FOR SYSTEM_VERSION AS OF 5074093329028989995;
If you have time feel free to check this out, and any feedback is welcome.
Thanks,
Peter
