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 }

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 an option type that represents the type of the trait:

CONTENT_TYPE = (
    TYPE = CSV
    INFER_TYPES = false
    HEADER = 'h1,h2,h3'
)