Data Types
The Simba Presto JDBC Connector supports many common SQL and Java data types, and converts between them.
The following table lists the supported data type mappings.
| SQL Type | Java Type |
|---|---|
|
ARRAY |
ARRAY |
|
BIGINT |
BIGINT |
|
BOOLEAN |
BOOLEAN |
|
CHAR |
CHAR |
|
DATE |
DATE |
|
DECIMAL |
DECIMAL |
|
DOUBLE |
DOUBLE |
|
FLOAT Note: Deprecated in Teradata Presto Server 0.152-t and later. |
REAL |
| HYPERLOGLOG | JAVA_OBJECT |
|
INTEGER |
INTEGER |
|
INTERVAL DAY TO SECOND |
VARCHAR |
|
INTERVAL YEAR TO MONTH |
VARCHAR |
| IPADDRESS | JAVA_OBJECT |
| IPPREFIX | JAVA_OBJECT |
|
JSON |
VARCHAR |
| KHYPERLOGLOG | JAVA_OBJECT |
|
MAP |
JAVA_OBJECT |
| P4HYPERLOGLOG | JAVA_OBJECT |
| QDIGEST | JAVA_OBJECT |
|
REAL Note: On Teradata Presto Server, only supported in versions 0.152-t and later. |
REAL |
|
ROW |
JAVA_OBJECT |
|
SMALLINT |
SMALLINT |
|
TIME |
TIME |
| TIME(P) | TIME |
|
TIME WITH TIME ZONE |
VARCHAR |
| TIME(P) WITH TIME ZONE | VARCHAR |
|
TIMESTAMP |
TIMESTAMP |
| TIMESTAMP(P) | TIMESTAMP |
|
TIMESTAMP WITH TIME ZONE |
VARCHAR |
|
TIMESTAMP(P) WITH TIME ZONE |
VARCHAR |
|
TINYINT |
TINYINT |
| UUID | JAVA_OBJECT |
|
VARBINARY |
VARBINARY |
|
VARCHAR |
VARCHAR |