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 |