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
>
