Common SQL syntax

Identifiers
Valid identifiers match the following format:
identifier = "([^"]|"")*"|[A-Za-z_][A-Za-z0-9_]*;
Column types
COLUMN_TYPE = { DATE 
              | TIMESTAMP 
              | BIGINT 
              | DOUBLE 
              | STRING 
              | BOOLEAN 
              | DECIMAL(precision, scale) }
To learn more about the various data types supported, see: Data types​
Trait representation
When there is a trait in the request (e.g. CONTENT_TYPE), it can be created in two ways:
If there are no additional properties, it can be used as an identifier:
CONTENT_TYPE = JSON
If there are properties, we create it as an object_options, and add option type that represents the type of the trait:
CONTENT_TYPE = (
    TYPE = CSV
    INFER_TYPES = false
    HEADER = 'h1,h2,h3'
)

SQL command reference

SHOW CREATE command

Last modified 1yr ago