Data Types

The Simba Drill JDBC Connector supports many common data formats, converting between Drill, SQL, and Java data types.

The following table lists the supported data type mappings.

Drill Type SQL Type Java Type

BIGINT

BIGINT

BIGINT

BIT

BOOLEAN

BOOLEAN

DATE

DATE

DATE

DATETIME

DATE

DATE

FLOAT4

FLOAT

REAL

FLOAT8

DOUBLE

DOUBLE

INT

INT

INTEGER

SMALLINT

SMALLINT

SMALLINT

TIMESTAMP

TIMESTAMP

TIMESTAMP

TINYINT

TINYINT

TINYINT

VARCHAR

VARCHAR

VARCHAR

VARDECIMAL DECIMAL BIGDECIMAL