SQL Reference

SQL lies at the heart of a Decodable pipeline. Let's get into the details.

Decodable supports the same SQL dialect as Apache Calcite. Specifically, Decodable pipelines run SQL INSERT statements where the INSERT INTO and FROM clauses refer to your Decodable streams by name.

Data Types

Type
ARRAY
BIGINT
BOOLEAN
BYTES
CHAR
DATE
DECIMAL
DOUBLE
FLOAT
INTEGER
INTERVAL
MAP
MULTISET
ROW
SMALLINT
STRING
TIME
TIMESTAMP
TIMESTAMP_LTZ
TINYINT
VARCHAR