# Data Types (/docs/reference/sql/data-types)



Data types [#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](/docs/reference/clickhouse-compatibility#service-interfaces).

RawTree type families define how SQL interprets values. Use [`Dynamic` fields](/docs/concepts/dynamic-fields) when values can have different types.

Use [raw-table JSON paths](/docs/concepts/raw-tables) to query nested values.

| Name                                                        | Aliases                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | Case-insensitive |
| ----------------------------------------------------------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ---------------- |
| <a id="aggregatefunction" />`AggregateFunction`             | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="array" />`Array`                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="bfloat16" />`BFloat16`                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="bool" />`Bool`                                       | <a id="bool" />`bool`, <a id="boolean" />`boolean`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | Yes              |
| <a id="date" />`Date`                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="date32" />`Date32`                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="datetime" />`DateTime`                               | <a id="timestamp" />`TIMESTAMP`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  | Yes              |
| <a id="datetime32" />`DateTime32`                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="datetime64" />`DateTime64`                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="decimal" />`Decimal`                                 | <a id="dec" />`DEC`, <a id="fixed" />`FIXED`, <a id="numeric" />`NUMERIC`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Yes              |
| <a id="decimal128" />`Decimal128`                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="decimal256" />`Decimal256`                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="decimal32" />`Decimal32`                             | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="decimal64" />`Decimal64`                             | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="dynamic" />`Dynamic`                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="enum" />`Enum`                                       | <a id="enum" />`ENUM`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | Yes              |
| <a id="enum16" />`Enum16`                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="enum8" />`Enum8`                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="fixedstring" />`FixedString`                         | <a id="binary" />`BINARY`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | No               |
| <a id="float32" />`Float32`                                 | <a id="float" />`FLOAT`, <a id="real" />`REAL`, <a id="single" />`SINGLE`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | No               |
| <a id="float64" />`Float64`                                 | <a id="double" />`DOUBLE`, <a id="double-precision" />`DOUBLE PRECISION`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | No               |
| <a id="geometry" />`Geometry`                               | <a id="geometry" />`GEOMETRY`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | No               |
| <a id="int128" />`Int128`                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="int16" />`Int16`                                     | <a id="smallint" />`SMALLINT`, <a id="smallint-signed" />`SMALLINT SIGNED`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       | No               |
| <a id="int256" />`Int256`                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="int32" />`Int32`                                     | <a id="int" />`INT`, <a id="int-signed" />`INT SIGNED`, <a id="integer" />`INTEGER`, <a id="integer-signed" />`INTEGER SIGNED`, <a id="mediumint" />`MEDIUMINT`, <a id="mediumint-signed" />`MEDIUMINT SIGNED`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   | No               |
| <a id="int64" />`Int64`                                     | <a id="bigint" />`BIGINT`, <a id="bigint-signed" />`BIGINT SIGNED`, <a id="signed" />`SIGNED`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | No               |
| <a id="int8" />`Int8`                                       | <a id="byte" />`BYTE`, <a id="int1" />`INT1`, <a id="int1-signed" />`INT1 SIGNED`, <a id="tinyint" />`TINYINT`, <a id="tinyint-signed" />`TINYINT SIGNED`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | No               |
| <a id="intervalday" />`IntervalDay`                         | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalhour" />`IntervalHour`                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalmicrosecond" />`IntervalMicrosecond`         | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalmillisecond" />`IntervalMillisecond`         | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalminute" />`IntervalMinute`                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalmonth" />`IntervalMonth`                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalnanosecond" />`IntervalNanosecond`           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalquarter" />`IntervalQuarter`                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalsecond" />`IntervalSecond`                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalweek" />`IntervalWeek`                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="intervalyear" />`IntervalYear`                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="ipv4" />`IPv4`                                       | <a id="inet4" />`INET4`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | No               |
| <a id="ipv6" />`IPv6`                                       | <a id="inet6" />`INET6`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | No               |
| <a id="json" />`JSON`                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="linestring" />`LineString`                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="lowcardinality" />`LowCardinality`                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="map" />`Map`                                         | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="multilinestring" />`MultiLineString`                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="multipoint" />`MultiPoint`                           | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="multipolygon" />`MultiPolygon`                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="nested" />`Nested`                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="nothing" />`Nothing`                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="nullable" />`Nullable`                               | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="point" />`Point`                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="polygon" />`Polygon`                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="qbit" />`QBit`                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="ring" />`Ring`                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="simpleaggregatefunction" />`SimpleAggregateFunction` | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="string" />`String`                                   | <a id="binary-large-object" />`BINARY LARGE OBJECT`, <a id="binary-varying" />`BINARY VARYING`, <a id="blob" />`BLOB`, <a id="bytea" />`BYTEA`, <a id="char" />`CHAR`, <a id="char-large-object" />`CHAR LARGE OBJECT`, <a id="char-varying" />`CHAR VARYING`, <a id="character" />`CHARACTER`, <a id="character-large-object" />`CHARACTER LARGE OBJECT`, <a id="character-varying" />`CHARACTER VARYING`, <a id="clob" />`CLOB`, <a id="longblob" />`LONGBLOB`, <a id="longtext" />`LONGTEXT`, <a id="mediumblob" />`MEDIUMBLOB`, <a id="mediumtext" />`MEDIUMTEXT`, <a id="national-char" />`NATIONAL CHAR`, <a id="national-char-varying" />`NATIONAL CHAR VARYING`, <a id="national-character" />`NATIONAL CHARACTER`, <a id="national-character-large-object" />`NATIONAL CHARACTER LARGE OBJECT`, <a id="national-character-varying" />`NATIONAL CHARACTER VARYING`, <a id="nchar" />`NCHAR`, <a id="nchar-large-object" />`NCHAR LARGE OBJECT`, <a id="nchar-varying" />`NCHAR VARYING`, <a id="nvarchar" />`NVARCHAR`, <a id="text" />`TEXT`, <a id="tinyblob" />`TINYBLOB`, <a id="tinytext" />`TINYTEXT`, <a id="varbinary" />`VARBINARY`, <a id="varchar" />`VARCHAR`, <a id="varchar2" />`VARCHAR2` | No               |
| <a id="time" />`Time`                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="time64" />`Time64`                                   | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | Yes              |
| <a id="tuple" />`Tuple`                                     | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="uint128" />`UInt128`                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="uint16" />`UInt16`                                   | <a id="smallint-unsigned" />`SMALLINT UNSIGNED`, <a id="year" />`YEAR`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | No               |
| <a id="uint256" />`UInt256`                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="uint32" />`UInt32`                                   | <a id="int-unsigned" />`INT UNSIGNED`, <a id="integer-unsigned" />`INTEGER UNSIGNED`, <a id="mediumint-unsigned" />`MEDIUMINT UNSIGNED`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | No               |
| <a id="uint64" />`UInt64`                                   | <a id="bigint-unsigned" />`BIGINT UNSIGNED`, <a id="bit" />`BIT`, <a id="set" />`SET`, <a id="unsigned" />`UNSIGNED`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | No               |
| <a id="uint8" />`UInt8`                                     | <a id="int1-unsigned" />`INT1 UNSIGNED`, <a id="tinyint-unsigned" />`TINYINT UNSIGNED`                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | No               |
| <a id="uuid" />`UUID`                                       | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |
| <a id="variant" />`Variant`                                 | —                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | No               |