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 |