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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ORC | tinyint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-bit signed integer |
| ORC | smallint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 16-bit signed integer |
| ORC | int | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 32-bit signed integer |
| ORC | bigint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 64-bit signed integer |
| ORC | float | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 32-bit floating-point |
| ORC | double | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 64-bit floating-point |
| ORC | string | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length string |
| ORC | char | null | STRING | 0 | 1 | 0 | 0 | null | null | null | null | Fixed-length string |
| ORC | varchar | null | STRING | 0 | 1 | 0 | 0 | null | null | null | null | Variable-length string with max length |
| ORC | binary | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length binary |
| ORC | decimal | null | STRING | 0 | 0 | 1 | 1 | null | null | null | null | Arbitrary precision decimal |
| ORC | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Date value |
| ORC | timestamp | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp with nanosecond precision |
| ORC | timestamp_instant | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Instant in time (UTC) |
| ORC | array | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Ordered collection of elements |
| ORC | map | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Key-value map |
| ORC | struct | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Structured record |
| ORC | uniontype | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Union of types |
| DATABRICKS | boolean | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | True or false |
| DATABRICKS | byte | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 1-byte signed integer |
| DATABRICKS | short | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 2-byte signed integer |
| DATABRICKS | int | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 4-byte signed integer |
| DATABRICKS | long | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-byte signed integer |
| DATABRICKS | float | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 4-byte floating point |
| DATABRICKS | double | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-byte floating point |
| DATABRICKS | decimal | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| DATABRICKS | string | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length character string |
| DATABRICKS | char | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| DATABRICKS | binary | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Variable-length binary data |
| DATABRICKS | date | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Calendar date |
| DATABRICKS | timestamp | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp with microsecond precision |
| DATABRICKS | timestamp_ntz | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Timestamp without time zone |
| DATABRICKS | interval | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Time interval |
| DATABRICKS | array | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Ordered collection of elements |
| DATABRICKS | map | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Collection of key-value pairs |
| DATABRICKS | struct | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Structured data with named fields |
| DATABRICKS | void | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Represents missing or null values |
| SQLSERVER | bit | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Boolean value (0 or 1) |
| SQLSERVER | tinyint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 1-byte unsigned integer (0-255) |
| SQLSERVER | smallint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 2-byte integer |
| SQLSERVER | int | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 4-byte integer |
| SQLSERVER | bigint | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | 8-byte integer |
| SQLSERVER | decimal | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SQLSERVER | money | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Currency data type |
| SQLSERVER | smallmoney | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Small currency data type |
| SQLSERVER | float | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SQLSERVER | real | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Single-precision floating point |
| SQLSERVER | char | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |
| SQLSERVER | nchar | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | Fixed-length Unicode string |
| SQLSERVER | varchar | null | STRING | 0 | 0 | 0 | 0 | null | null | null | null | null |