ARRAY
An array of the given component type.
Examples:
ARRAY[1, 2, 3]select array[1,2,3,4]
BOOLEAN
Represents boolean values TRUE and FALSE
DATE
Represents values having values of fields year, month, and day.
DECIMAL
Represents the numbers with precision and a scale factor of x.
DOUBLE
Represents x-byte single/variable-precision floating point numbers.
FLOAT
Represents x-byte single/variable-precision floating point numbers.
INT32
Represents a 32-bit signed two’s complement integer with a minimum value of -231 and a maximum value of 231 - 1.
INT64
Represents a 64-bit signed two’s complement integer with a minimum value of -263 and a maximum value of 263 - 1.
JSON
JSON querying is supported when the JSON data is saved in the form of a string.
STRING
Represents character string values.
STRUCT
Represents values with the structure described by a sequence of fields.
Example:
struct({value:prod,dpid:51})select tablename.columnname.structfield1.structfield2 from tablename
Last modified on October 1, 2026
