CREATE TABLE

CREATE TABLE WITH clause

Creates a new KSQL table with the specified columns and properties.

CREATE TABLE table_name ( { column_name data_type } [, ...] )
        WITH ( property_name = expression [, ...] );

CREATE TABLE WITH clause and AS SELECT

Creates a new stream with the specified columns and properties along with the corresponding HPE Ezmeral Data Fabric Streams topic and stream.

CREATE TABLE table_name
        [WITH ( property_name = expression [, ...] )]
        AS SELECT  select_expr [, ...]
        FROM from_item [, ...]
        [ WINDOW window_expression ]
  [ WHERE condition ]
  [ GROUP BY grouping_expression ]
  [ HAVING having_expression ];