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 |