ReferenceSQL Reference

Data Types

Supported SQL data type families, aliases, and case sensitivity.

Data types

This page describes the RawTree engine binary used to generate this reference. It does not define Query API support. Descriptions retain upstream ClickHouse terminology. See SQL interface scope.

RawTree type families define how SQL interprets values. Use Dynamic fields when values can have different types.

Use raw-table JSON paths to query nested values.

NameAliasesCase-insensitive
AggregateFunction—No
Array—No
BFloat16—No
Boolbool, booleanYes
Date—Yes
Date32—Yes
DateTimeTIMESTAMPYes
DateTime32—Yes
DateTime64—Yes
DecimalDEC, FIXED, NUMERICYes
Decimal128—Yes
Decimal256—Yes
Decimal32—Yes
Decimal64—Yes
Dynamic—No
EnumENUMYes
Enum16—No
Enum8—No
FixedStringBINARYNo
Float32FLOAT, REAL, SINGLENo
Float64DOUBLE, DOUBLE PRECISIONNo
GeometryGEOMETRYNo
Int128—No
Int16SMALLINT, SMALLINT SIGNEDNo
Int256—No
Int32INT, INT SIGNED, INTEGER, INTEGER SIGNED, MEDIUMINT, MEDIUMINT SIGNEDNo
Int64BIGINT, BIGINT SIGNED, SIGNEDNo
Int8BYTE, INT1, INT1 SIGNED, TINYINT, TINYINT SIGNEDNo
IntervalDay—No
IntervalHour—No
IntervalMicrosecond—No
IntervalMillisecond—No
IntervalMinute—No
IntervalMonth—No
IntervalNanosecond—No
IntervalQuarter—No
IntervalSecond—No
IntervalWeek—No
IntervalYear—No
IPv4INET4No
IPv6INET6No
JSON—Yes
LineString—No
LowCardinality—No
Map—No
MultiLineString—No
MultiPoint—No
MultiPolygon—No
Nested—No
Nothing—No
Nullable—No
Point—No
Polygon—No
QBit—No
Ring—No
SimpleAggregateFunction—No
StringBINARY LARGE OBJECT, BINARY VARYING, BLOB, BYTEA, CHAR, CHAR LARGE OBJECT, CHAR VARYING, CHARACTER, CHARACTER LARGE OBJECT, CHARACTER VARYING, CLOB, LONGBLOB, LONGTEXT, MEDIUMBLOB, MEDIUMTEXT, NATIONAL CHAR, NATIONAL CHAR VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER LARGE OBJECT, NATIONAL CHARACTER VARYING, NCHAR, NCHAR LARGE OBJECT, NCHAR VARYING, NVARCHAR, TEXT, TINYBLOB, TINYTEXT, VARBINARY, VARCHAR, VARCHAR2No
Time—Yes
Time64—Yes
Tuple—No
UInt128—No
UInt16SMALLINT UNSIGNED, YEARNo
UInt256—No
UInt32INT UNSIGNED, INTEGER UNSIGNED, MEDIUMINT UNSIGNEDNo
UInt64BIGINT UNSIGNED, BIT, SET, UNSIGNEDNo
UInt8INT1 UNSIGNED, TINYINT UNSIGNEDNo
UUID—No
Variant—No

Server settings

Server settings for RawTree operators.

Formats

Input and output formats supported by the RawTree SQL engine.

On this page

Data types

Cookies