The congratulation is due to the Iceberg and the Hive community! Thanks everyone and keep up the good work!
> On 2022. Apr 7., at 19:22, Wing Yew Poon <wyp...@cloudera.com.INVALID> wrote: > > Congratulations on the release, making available this functionality for Hive > users! > > > On Thu, Apr 7, 2022 at 9:11 AM Peter Vary <pv...@cloudera.com.invalid> wrote: > 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 >