When importing data into Datameer X it is important to know which type of data you are importing or need to import. When using your data within Workbooks Workbooks, certain Datameer X functions only work with certain types of data. Congruently, certain functions return only a specific type of data.
...
Datameer X field type | Parquet field type |
|---|---|
| INTEGER | INT64 |
| DATE | BINARY |
| BIG_INTEGER | BINARY |
| FLOAT | DOUBLE |
| BIG_DECIMAL | BINARY |
| STRING | BINARY UTF8 |
| BOOLEAN | BOOLEAN |
| LISTÂ (integer) | INT64 |
LIST (float) | DOUBLE |
| LIST (string) | BINARY |
| LISTÂ (Boolean) | BOOLEAN |
...
| Datameer X Field Type | Hive Field Type |
|---|---|
| STRING | STRING |
| FLOAT | DOUBLE |
| INTEGER | BIGINT |
| DATE | BIGINT |
| BIG_INTEGER | DECIMAL (38,0) |
| BIG_DECIMAL | BINARY only (Datameer uses per-record scale & precision for BIG_DECIMAL records and has a custom parquet byte encoding for storing such values. This encoding is not compatible with Hive and its fixed per-column DECIMAL scale & precision.) |
| LIST[A] | ARRAY [A] (INFO: We support recursive types) |
| BOOLEAN | BOOLEAN |
...