Databend Data Types
Databend supports SQL data types in several categories:
- Boolean Data Types
- Numeric Data Types
- Date & Time Data Types
- String Data Types
- Semi-structured Data Types
General-Purpose Data Types
| Name | Storage Size | Min Value | Max Value | Description |
|---|---|---|---|---|
| BOOLEAN | 1 byte | Logical boolean (true/false) | ||
| TINYINT | 1 byte | -128 | 127 | |
| SMALLINT | 2 bytes | -32768 | 32767 | |
| INT | 4 bytes | -2147483648 | 2147483647 | |
| BIGINT | 8 bytes | -9223372036854775808 | 9223372036854775807 | |
| FLOAT | 4 bytes | -3.40282347e+38 | 3.40282347e+38 | |
| DOUBLE | 8 bytes | -1.7976931348623157E+308 | 1.7976931348623157E+308 | |
| DATE | 2 bytes | 1000-01-01 | 9999-12-31 | YYYY-MM-DD |
| DATETIME | 4 bytes | 1970-01-01 00:00:00 | 2105-12-31 23:59:59 | YYYY-MM-DD hh:mm:ss |
| TIMESTAMP | 8 bytes | 1677-09-21 00:12:44.000 | 2262-04-11 23:47:16.854 | YYYY-MM-DD hh:mm:ss.ff |
| VARCHAR | variable |
Semi-structured Data Types
Databend supports three Semi-structured types: ARRAY, OBJECT and VARIANT.
| Name | Build From Values | Description |
|---|---|---|
| ARRAY | [1,2,3] | Zero-based indexed list, each value can have difference data type. |
| OBJECT | {"a":1,"b":{"c":2}} | Collection of key-value pairs, each key is a VARCHAR, and each value is a VARIANT. |
| VARIANT | [1,{"a":1,"b":{"c":2}}] | Collection of elements of different data types., including ARRAY and OBJECT. |