Foreign Table Type Mapping
ORC/Parquet Type | Tacnode Type |
---|
BOOLEAN | BOOLEAN |
TINYINT | SMALLINT |
SMALLINT | SMALLINT |
INT | INTEGER |
BIGINT | BIGINT |
FLOAT | REAL |
DOUBLE | DOUBLE PRECISION |
DECIMAL(p,s) | DECIMAL(p,s) |
STRING | TEXT |
VARCHAR(n) | VARCHAR(n) |
CHAR(n) | CHAR(n) |
BINARY | BYTEA |
TIMESTAMP | TIMESTAMP |
DATE | DATE |
ARRAY | type[] |
MAP | Not Available |
STRUCT | Not Available |
Iceberg Type | Tacnode Type |
---|
boolean | BOOLEAN |
int | INTEGER |
long | BIGINT |
float | REAL |
double | DOUBLE PRECISION |
decimal(p,s) | DECIMAL(p,s) |
string | TEXT |
uuid | UUID |
fixed(n) | BYTEA |
binary | BYTEA |
date | DATE |
time | TIME |
timestamp | TIMESTAMP |
timestamptz | TIMESTAMPTZ |
list | type[] |
map | Not Available |
struct | Not Available |
DeltaLake Type | Tacnode Type |
---|
boolean | BOOLEAN |
short | SMALLINT |
integer | INTEGER |
long | BIGINT |
float | REAL |
double | DOUBLE PRECISION |
decimal(p,s) | DECIMAL(p,s) |
string | TEXT |
varchar(n) | VARCHAR(n) |
char(n) | CHAR(n) |
binary | BYTEA |
date | DATE |
timestamp | TIMESTAMP |
array | type[] |
map | Not Available |
struct | Not Available |