XTDB Data Types
XTDB data types are implemented using Apache Arrow.
Scalar Types
XTDB Type | Arrow Vector Type | Description | SQL Example | Datalog Example |
---|---|---|---|---|
|
64-bit Signed Integer |
|
|
|
|
3-Value Boolean: true (1), false (0), or null |
|
|
|
|
Date Without Time |
|
|
|
|
64-bit Floating Point Number |
|
|
|
|
32-bit Floating Point Number |
|
|
|
|
32-bit Signed Integer |
|
|
|
|
Day/Time Interval |
|
|
|
|
Year/Month Interval |
|
|
|
|
<a pair of TIMESTAMPs> |
Time Period (for use in Temporal Predicates; not usable as a column type) |
|
|
|
16-bit Signed Integer |
|
|
|
|
Timestamp without a Timezone offset |
|
|
|
|
Timestamp with a Timezone offset |
|
|
|
|
Time of day with nanosecond precision |
|
|
|
|
Universally Unique Identifier |
|
|
|
|
Universal Resource Identifier |
|
|
|
|
Variable-Length Binary String (Byte Array) |
|
|
|
|
Variable-Length String with UTF8 character encoding |
|
|
|
|
TBD |
EDN Keyword |
|
|
Note
|
The types marked with an asterisk (UuidVector , UriVector ) are Apache Arrow extension types.
|
Collection Types
XTDB supports arbitrarily nested data.
XTDB Type | Arrow Vector Type | Description | SQL Example | Datalog Example |
---|---|---|---|---|
|
Array/List/Vector of Values |
|
|
|
|
Object/Struct/Map of key-value pairs |
|
|
|
|
Arrow extension type |
Set of distinct, unordered values |
|
|
Prev
Installation