Using Apache IcebergPDF version

Create table as select feature

You can create an Iceberg table based on an existing Hive or Impala table.

The create table as select (CTAS) query can optionally include a partitioning spec for the table being created.

CREATE EXTERNAL TABLE ctas STORED BY ICEBERG AS SELECT i, t, j FROM ice_1;
CREATE TABLE ctas STORED BY ICEBERG AS SELECT i, b FROM ice_11;