Package org.apache.flink.sql.parser.ddl

Class SqlCreateTableLike

  • All Implemented Interfaces:
    Cloneable, ExtendedSqlNode
    public class SqlCreateTableLike
extends SqlCreateTable
    SqlNode to describe the CREATE TABLE LIKE syntax. CREATE TABLE LIKE syntax is similar as CREATE TABLE syntax, besides it has LIKE sub-clause to inherit property of an existed table.

    Example: 

    
 CREATE TABLE base_table (
     id BIGINT,
     name STRING,
     tstmp TIMESTAMP,
     PRIMARY KEY(id)
 ) WITH (
     ‘connector’ = ‘kafka’,
     ‘connector.starting-offset’: ‘12345’,
     ‘format’ =  ‘json’
 )

 CREATE TABLE derived_table (
      a int
 )
 WITH (
   'connector' = 'jdbc',
   'url' = 'http://localhost:10000',
   'table-name' = 'derivedTable'
 )
 LIKE base_table;