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
> 

Reply via email to