Pucheng, what engine are you interested in? This works fine in Trino: CREATE TABLE table_copy (LIKE source_table INCLUDING PROPERTIES)
I don’t know if it works in Hive, and last time I checked it was not implemented for DSv2 in Spark. The Spark problem should be an easy fix. Ryan On Tue, Apr 25, 2023 at 2:43 PM Steve Zhang <hongyue_zh...@apple.com.invalid> wrote: > Hey Pengcheng, > > Are you looking for CTAS as in > https://iceberg.apache.org/docs/latest/spark-ddl/#create-table--as-select? I > think you can also specify explicit location as part of create statement in > https://iceberg.apache.org/docs/latest/spark-ddl/#create-table > > Thanks, > Steve Zhang > > > > On Apr 25, 2023, at 1:46 PM, Pucheng Yang <py...@pinterest.com.INVALID> > wrote: > > Hi all, > > I wonder how folks in the community deal with the cases where you want to > create a test table from an existing iceberg table? In Hive, what we > normally do is to run a query "create table x like y location z". But we > can't do this for the Iceberg table. > > If this is a feature that is missing, should we collaborate to build a > similar feature? > > Thanks > > > -- Ryan Blue Tabular