[jira] [Created] (IMPALA-13299) CreateTableLike to create Iceberg table based on non-Iceberg table

["Quanlong Huang (Jira)" <ji...@apache.org>]

Quanlong Huang created IMPALA-13299:
---------------------------------------

             Summary: CreateTableLike to create Iceberg table based on non-Iceberg table
                 Key: IMPALA-13299
                 URL: https://issues.apache.org/jira/browse/IMPALA-13299
             Project: IMPALA
          Issue Type: New Feature
          Components: Frontend
            Reporter: Quanlong Huang


test_delete_complextypes_mixed_files creates an Iceberg table in Hive using CTAS:
{code:sql}
create table ice_complex_delete stored by iceberg stored as orc as
select * from functional_parquet.complextypestbl; {code}
When migrating the test to Apache Hive 3.1, this needs to be converted into a CreateTable and an INSERT statement since {{STORED BY ICEBERG}} is not supported in Apache Hive 3. The table should be created using {{{}STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler'{}}}. However, CreateTableLike in Hive 3 doesn't support the {{STORED BY}} storageHandler clause. It'd be helpful if Impala can create the table itself. Then we can still use Hive to insert the ORC files.

The statement we need is
{code:sql}
create table my_ice_tbl like functional_parquet.complextypestbl stored by iceberg;

AnalysisException: functional_parquet.complextypestbl cannot be cloned into an Iceberg table because it is not an Iceberg table.{code}
Note that functional_parquet.complextypestbl is just a non-partitioned table. It'd be nice to support partitioned tables as well.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org