Apache Drill Data Type | TDV Data Type |
ANY | LONGVARCHAR |
BIGINT | BIGINT |
BIGSERIAL | BIGINT |
BINARY | BINARY |
BINARY_DOUBLE | DOUBLE |
BINARY_FLOAT | REAL |
BIT | CHAR |
BOOL | BOOLEAN |
BOX | VARCHAR |
BPCHAR | CHAR |
BYTEA | BLOB |
CHAR | CHAR |
CHARACTER | CHAR |
CHARACTER_VARYING | VARCHAR |
CID | CHAR |
CIDR | VARCHAR |
DATE | DATE |
DATETIME | TIMESTAMP |
DOUBLE | DOUBLE |
DOUBLE_PECISION | DOUBLE |
FLOAT | REAL |
FLOAT4 | REAL |
FLOAT8 | DOUBLE |
INET | VARCHAR |
INT | INTEGER |
INT2 | SMALLINT |
INT4 | INTEGER |
INT8 | BIGINT |
INTEGER | INTEGER |
INTERVAL | INTERVAL_DAY_TO_SECOND |
INTERVAL_DAY | INTERVAL_DAY |
INTERVAL_DAY_TO_HOUR | INTERVAL_DAY_TO_HOUR |
INTERVAL_DAY_TO_MINUTE | INTERVAL_DAY_TO_MINUTE |
INTERVAL_DAY_TO_SECOND | INTERVAL_DAY_TO_SECOND |
INTERVAL_HOUR | INTERVAL_HOUR |
INTERVAL_HOUR_TO_MINUTE | INTERVAL_HOUR_TO_MINUTE |
INTERVAL_HOUR_TO_SECOND | INTERVAL_HOUR_TO_SECOND |
INTERVAL_MINUTE | INTERVAL_MINUTE |
INTERVAL_MINUTE_TO_SECOND | INTERVAL_MINUTE_TO_SECOND |
INTERVAL_MONTH | INTERVAL_MONTH |
INTERVAL_SECOND | INTERVAL_SECOND |
INTERVAL_YEAR | INTERVAL_YEAR |
INTERVAL_YEAR_TO_MONTH | INTERVAL_YEAR_TO_MONTH |
LINE | VARCHAR |
LONG | CLOB |
MACADDR | VARCHAR |
NUMBER | DECIMAL |
NUMERIC | NUMERIC |
OID | BLOB |
PATH | VARCHAR |
POINT | CHAR |
REAL | REAL |
ROWID | VARCHAR |
SERIAL | INTEGER |
SMALLDATETIME | TIMESTAMP |
SMALLINT | SMALLINT |
TEXT | CLOB |
TIME | TIME |
TIMESTAMP | TIMESTAMP |
TIMESTAMPTZ | TIMESTAMP |
TIMETZ | TIME |
TINYINT | TINYINT |
UROWID | VARCHAR |
UUID | CHAR |
VARBIT | VARCHAR |
VARCHAR | VARCHAR |
VARCHAR2 | VARCHAR |
XID | INTEGER |
XML | XML |