Online
v0.9.0
Tables
dialect_data_types 367 records
| dialect | type_name | type_template | datada_type | is_default | supports_length | supports_precision | supports_scale | default_length | default_precision | default_scale | max_length | description |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PARQUET | enum | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Enumerated type |
| PARQUET | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date (days since epoch) |
| PARQUET | time_millis | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time in milliseconds |
| PARQUET | time_micros | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time in microseconds |
| PARQUET | timestamp_millis | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp in milliseconds |
| PARQUET | timestamp_micros | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp in microseconds |
| PARQUET | decimal | null | STRING | 0 | 0 | 1 | 1 | null | null | null | null | Arbitrary precision decimal |
| PARQUET | json | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON data stored as string |
| PARQUET | bson | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | BSON data |
| PARQUET | list | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Array/List type |
| PARQUET | map | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Key-value map type |
| PARQUET | struct | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Structured/record type |
| JSON | string | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON string type |
| JSON | integer | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON integer type (no decimals) |
| JSON | number | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON number type (includes decimals) |
| JSON | boolean | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON boolean type |
| JSON | null | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON null type |
| JSON | object | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON object type (nested structure) |
| JSON | array | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON array type |
| POSTGRESQL | smallint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 2-byte signed integer (-32768 to 32767) |
| POSTGRESQL | integer | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 4-byte signed integer (-2147483648 to 2147483647) |
| POSTGRESQL | bigint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-byte signed integer |
| POSTGRESQL | smallserial | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 2-byte auto-incrementing integer |
| POSTGRESQL | serial | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 4-byte auto-incrementing integer |
| POSTGRESQL | bigserial | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-byte auto-incrementing integer |
| POSTGRESQL | numeric | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Exact numeric with selectable precision |
| POSTGRESQL | real | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 4-byte floating-point number |
| POSTGRESQL | double precision | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-byte floating-point number |
| POSTGRESQL | money | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Currency amount |
| POSTGRESQL | character varying | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length character string |
| POSTGRESQL | character | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Fixed-length character string |
| POSTGRESQL | text | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length character string without limit |
| POSTGRESQL | bytea | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Binary data (byte array) |
| POSTGRESQL | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Calendar date (year, month, day) |
| POSTGRESQL | time | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time of day without time zone |
| POSTGRESQL | time with time zone | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time of day with time zone |
| POSTGRESQL | timestamp | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date and time without time zone |
| POSTGRESQL | timestamp with time zone | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date and time with time zone |
| POSTGRESQL | interval | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time span |
| POSTGRESQL | boolean | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Logical boolean (true/false) |
| POSTGRESQL | uuid | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Universally unique identifier |
| POSTGRESQL | json | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON data (stored as text) |
| POSTGRESQL | jsonb | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | JSON data (stored as binary) |
| POSTGRESQL | inet | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | IPv4 or IPv6 host address |
| POSTGRESQL | cidr | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | IPv4 or IPv6 network |
| POSTGRESQL | macaddr | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | MAC address |
| POSTGRESQL | macaddr8 | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | MAC address (EUI-64 format) |
| POSTGRESQL | point | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Point on a plane |
| POSTGRESQL | line | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Infinite line |
| POSTGRESQL | lseg | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Line segment |