Foreign Table Type Mapping

ORC/Parquet Type Mapping

ORC/Parquet TypeTacnode Type
BOOLEANBOOLEAN
TINYINTSMALLINT
SMALLINTSMALLINT
INTINTEGER
BIGINTBIGINT
FLOATREAL
DOUBLEDOUBLE PRECISION
DECIMAL(p,s)DECIMAL(p,s)
STRINGTEXT
VARCHAR(n)VARCHAR(n)
CHAR(n)CHAR(n)
BINARYBYTEA
TIMESTAMPTIMESTAMP
DATEDATE
ARRAYtype[]
MAPNot Available
STRUCTNot Available

Iceberg Type Mapping

Iceberg TypeTacnode Type
booleanBOOLEAN
intINTEGER
longBIGINT
floatREAL
doubleDOUBLE PRECISION
decimal(p,s)DECIMAL(p,s)
stringTEXT
uuidUUID
fixed(n)BYTEA
binaryBYTEA
dateDATE
timeTIME
timestampTIMESTAMP
timestamptzTIMESTAMPTZ
listtype[]
mapNot Available
structNot Available

DeltaLake Type Mapping

DeltaLake TypeTacnode Type
booleanBOOLEAN
shortSMALLINT
integerINTEGER
longBIGINT
floatREAL
doubleDOUBLE PRECISION
decimal(p,s)DECIMAL(p,s)
stringTEXT
varchar(n)VARCHAR(n)
char(n)CHAR(n)
binaryBYTEA
dateDATE
timestampTIMESTAMP
arraytype[]
mapNot Available
structNot Available

On this page