SQL Data Types

These are the supported data types for your queries.

Data TypeDescription
Boolean
  • True
  • False
Integer
  • TINYINT
  • SMALLINT
  • INTEGER
  • BIGINT
Floating-point
  • REAL
  • DOUBLE
Fixed-precisionDECIMAL. The decimal type takes two literal parameters:
  • precision - total number of digits
  • scale - number of digits in fractional part. It's optional and defaults to 0.
String
  • VARCHAR
  • VARBINARY
Structural
  • ARRAY
  • MAP - A map between the given component types.
  • ROW - A structure made up of fields that allows mixed types.
HyperLogLogHyperLogLog
T-DigestTDigest - Captures approximate distribution of data.

These data types are supported: DOUBLE, BIGINT, VARCHAR, TIMESTAMP, TIMESTAMP WITH TIME ZONE, and DATE.