On Tue, Apr 25, 2023 at 4:07 PM Ryan Blue <b...@tabular.io> wrote: > 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. > Just put up a Spark PR to implement CREATE TABLE LIKE in DSv2: https://github.com/apache/spark/pull/40963. Let me know if it works for you.
Spark CREATE TABLE LIKE only copies metadata from source table, not data. The PR copies table properties. It also adds a conf for excluding some properties as necessary. > 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 > -- John Zhuge
