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, certain Datameer X functions only work with certain types of data. Congruently, certain functions return only a specific type of data.
Also there are data requirements when using infographic widgets to visualize your data.
...
Datameer X Field Type | Hive Field Type |
---|---|
STRING | STRING |
FLOAT | DOUBLE |
INTEGER | BIGINT |
DATE | BIGINT |
BIG_INTEGER | DECIMAL (38,0) |
BIG_DECIMALBINARY only | (Datameer X 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.). So BIG_DECIMAL must not be used, if the sheet is supposed to be synced with Hive via External Systems. |
LIST[A] | ARRAY [A] (INFO: We support recursive types.) |
BOOLEAN | BOOLEAN |