Azure Data Lake Storage Data Type | TDV Data Type |
BYTEA | BLOB |
CHAR | CHAR |
CHARACTER | CHAR |
CHARACTER_VARYING | VARCHAR |
DECIMAL | DECIMAL |
BPCHAR | CHAR |
TEXT | CLOB |
DATE | DATE |
FLOAT | FLOAT |
LONG | CLOB |
NUMBER | DECIMAL |
RAW | BYTEA |
ROWID | VARCHAR |
UROWID | VARCHAR |
VARCHAR | VARCHAR |
VARCHAR2 | VARCHAR |
DATE | DATE |
DATETIME | TIMESTAMP |
TIMESTAMP | TIMESTAMP |
TIMESTAMPZ | TIMESTAMP |
SMALLDATETIME | TIMESTAMP |
TIME | TIME |
TIMETZ | TIME |
FLOAT | REAL |
FLOAT4 | REAL |
FLOAT8 | DOUBLE |
REAL | REAL |
INTEGER | INTEGER |
INT | INTEGER |
BIGINT | BIGINT |
INT8 | BIGINT |
INT4 | INTEGER |
INT2 | SMALLINT |
SMALLINT | SMALLINT |
BOOL | BOOLEAN |
BOOLEAN | BOOLEAN |
BIT | CHAR |
VARBIT | VARCHAR |
TINYINT | SMALLINT |
NUMERIC | NUMERIC |
UUID | CHAR |
XID | INTEGER |
XML | XML |
BOX | VARCHAR |
OID | BLOB |
BINARY_DOUBLE | DOUBLE |
DOUBLE_PRECISION | DOUBLE |
CIDR | VARCHAR |
INET | VARCHAR |
LINE | VARCHAR |
LSEG | VARCHAR |
MACADDR | VARCHAR |
MONEY | DECIMAL |
SERIAL | INTEGER |
BIGSERIAL | BIGINT |
CIRCLE | VARCHAR |
PATH | VARCHAR |
POINT | CHAR |
POLYGON | VARCHAR |
BINARY_FLOAT | REAL |