Skip to main content
Data typeDescriptionExamples
ARRAYAn array of the given component type.ARRAY[1, 2, 3]
select array[1,2,3,4]
BOOLEANRepresents boolean values TRUE and FALSE.TRUE, FALSE
SELECT if(TRUE, 1, 2)
DATERepresents values having values of fields year, month, and day.DATE '2024-03-15'
SELECT CAST('2024-03-15' AS DATE)
DECIMALRepresents the numbers with precision and a scale factor of x.CAST(12.50 AS DECIMAL(8,2))
SELECT CAST('7.25' AS DECIMAL(8,2))
DOUBLERepresents x-byte single/variable-precision floating point numbers.CAST(4 AS DOUBLE)
SELECT sqrt(CAST(4 AS DOUBLE))
FLOATRepresents x-byte single/variable-precision floating point numbers.CAST(1.5 AS FLOAT)
SELECT CAST('1.5' AS FLOAT)
INT32Represents a 32-bit signed two’s complement integer with a minimum value of -231 and a maximum value of 231 - 1.CAST(16 AS INT)
SELECT CAST('42' AS INTEGER)
INT64Represents a 64-bit signed two’s complement integer with a minimum value of -263 and a maximum value of 263 - 1.CAST(6 AS BIGINT)
SELECT CAST(9223372036854775807 AS BIGINT)
JSONJSON querying is supported when the JSON data is saved in the form of a string.'{"a":7}'
SELECT json_extract('{"a":7}', '$.a')
STRINGRepresents character string values.'aBc'
SELECT upper('aBc')
STRUCTRepresents values with the structure described by a sequence of fields.struct({value:prod,dpid:51})
select tablename.columnname.structfield1.structfield2 from tablename
Last modified on October 16, 2026