A command to create a table with the same definition of the given existing table. In the target table definition, the table comment is always empty but the column comments are identical to the ones defined in the source table.

The CatalogTable attributes copied from the source table are storage(inputFormat, outputFormat, serde, compressed, properties), schema, provider, partitionColumnNames, bucketSpec by default.

Use "CREATE TABLE t1 LIKE t2 USING file_format" to specify new provider for t1. For Hive compatibility, use "CREATE TABLE t1 LIKE t2 STORED AS hiveFormat" to specify new file storage format (inputFormat, outputFormat, serde) for t1.

The syntax of using this command in SQL is:

CREATE TABLE [IF NOT EXISTS] [db_name.]table_name
LIKE [other_db_name.]existing_table_name
[USING provider |
 [
  [ROW FORMAT row_format]
  [STORED AS file_format] [WITH SERDEPROPERTIES (...)]
 ]
]
[locationSpec]
[TBLPROPERTIES (property_name=property_value, ...)]