Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
| ARRAY | SYSUDTLIB.MyArrayName |
| BYTE | BYTE |
| BLOB | BLOB |
| CHAR | CHAR |
| DATASET | DATASET STORAGE FORMAT AVRO |
| DATE | DATE |
| TIME | TIME |
| TIMESTAMP | TIMESTAMP |
| TIME WITH TIME ZONE | TIME WITH TIME ZONE |
| TIMESTAMP WITH TIME ZONE | TIMESTAMP WITH TIME ZONE |
| ST_Geometry | SYSUDTLIB.ST_GEOMETRY |
| MBR | SYSUDTLIB.MBR |
| INTERVAL YEAR | INTERVAL YEAR |
| INTERVAL YEAR TO MONTH | INTERVAL YEAR TO MONTH |
| INTERVAL MONTH | INTERVAL MONTH |
| INTERVAL DAY | INTERVAL DAY |
| INTERVAL DAY TO HOUR | INTERVAL DAY TO HOUR |
| INTERVAL DAY TO MINUTE | INTERVAL DAY TO MINUTE |
| INTERVAL DAY TO SECOND | INTERVAL DAY TO SECOND |
| INTERVAL HOUR | INTERVAL HOUR |
| INTERVAL HOUR TO MINUTE | INTERVAL HOUR TO MINUTE |
| INTERVAL HOUR TO SECOND | INTERVAL HOUR TO SECOND |
| INTERVAL MINUTE | INTERVAL MINUTE |
| INTERVAL MINUTE TO SECOND | INTERVAL MINUTE TO SECOND |
| INTERVAL SECOND | INTERVAL SECOND |
| JSON | JSON |
| BYTEINT | BYTEINT |
| SMALLINT | SMALLINT |
| INTEGER | INT |
| BIGINT | BIGINT |
| DECIMAL | DECIMAL |
| NUMERIC | DECIMAL |
| FLOAT | FLOAT |
| REAL | FLOAT |
| DOUBLE PRECISION | FLOAT |
| NUMBER | NUMBER |
| PERIOD(DATE) | PERIOD(DATE) |
| PERIOD(TIME) | PERIOD(TIME) |
| XML | XML |