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
>
>
