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