tencent cloud

CREATE TABLE Table name
  (
    { <Column definition> | <Calculated column definition> }[ , ...n]
    [ <Watermark definition> ]
    [ <Definitions of table constraints such as the primary key> ][ , ...n]
  )
  [COMMENT ‍Table comments]
  [PARTITIONED BY (grouped column name 1, grouped column name 2, ...)]
  WITH (key 1=value 1, key 2=value 2, ...)
  [ LIKE another table [( <LIKE clause> )] ]

<Column definition>:
  Column name Column type [ <Definitions of column constraints> ] [COMMENT Column ‍comments]

<Definitions of column constraints>:
  [CONSTRAINT constraint name] PRIMARY KEY NOT ENFORCED

<Definitions of table constraints>:
  [CONSTRAINT constraint name] PRIMARY KEY (column 1, column 2, ...) NOT ENFORCED

<Calculated column definition>:
  Column name AS calculated column expression [COMMENT column comments]

<Watermark definition>:
  WATERMARK FOR a ROWTIME column AS a watermark generation expression

<LIKE clause>:
{
   { INCLUDING | EXCLUDING } { ALL | CONSTRAINTS | PARTITIONS }
 | { INCLUDING | EXCLUDING | OVERWRITING } { GENERATED | OPTIONS | WATERMARKS } 
}[, ...]

WATERMARK FOR a ROWTIME column AS a watermark generation expression

CREATE TABLE StudentRecord (
    Id BIGINT,
    StudentName STRING,
    RegistrationTime TIMESTAMP(3),
    WATERMARK FOR RegistrationTime AS RegistrationTime - INTERVAL '3' MINUTE
) WITH ( ... ... );

WATERMARK FOR A ROWTIME column AS A ROWTIME column

WATERMARK FOR my_time AS my_time

WATERMARK FOR a ROWTIME column AS a ROWTIME column - INTERVAL 'Time window' Time unit

WATERMARK FOR my_time AS my_time - INTERVAL '3' SECOND

CREATE TABLE A (
    Id BIGINT,
    StudentName STRING,
    RegistrationTime TIMESTAMP(3)
) WITH ( ... Some parameters ... );

CREATE TABLE B (
    WATERMARK FOR RegistrationTime AS RegistrationTime - INTERVAL '3' MINUTE
) WITH ( ... Some other parameters ... ) LIKE `A`;