Numeric Types

TINYINT
A signed one-byte integer

SMALLINT
A signed two-byte integer

INTEGER
A signed four-byte integer

BIGINT
A signed eight-byte integer

UTINYINT
An unsigned one-byte integer

USMALLINT
An unsigned two-byte integer

UINTEGER
An unsigned four-byte integer

UBIGINT
An unsigned eight-byte integer

FLOAT
A single precision floating-point number (4 bytes)

DOUBLE
A double precision floating-point number (8 bytes)

DECIMAL
A fixed-precision number with the given width (precision) and scale. Defaults to a precision of 18 and a scale of 3

---

Boolean Type

BOOLEAN
A logical Boolean (true or false)

---

String Type

STRING
A variable-length character string.

---

Date and Time Types

DATE
Calendar date (year, month, day)

TIME
A time of day (no time zone)

TIMESTAMP
A combination of time and date. Microsecond accuracy

TIMESTAMP_S
A combination of time and date, with second-level accuracy

TIMESTAMP_MS
A combination of time and date, with millisecond-level accuracy

TIMESTAMP_NS
A combination of time and date, with nanosecond-level accuracy

TIMESTAMP_TZ
A combination of time and date, using the current time zone

TIMESTAMP WITH TIME ZONE
A combination of time and date that uses the current time zone

---

Collection Types

ARRAY
An ordered, fixed-length sequence of data values of the same type

LIST
An ordered sequence of data values of the same type