Supported Data Types

VAST Database supports the following Apache Arrow, Trino, and Apache Spark data types:

VAST Database data type	Arrow data type	Trino data type	Spark data type
UINT8, UINT16, UINT32, UINT64	UINT8, UINT16, UINT32, UINT64	n/a	n/a
INT8, INT16, INT32, INT64	INT8, INT16, INT32, INT64	TINYINT, SMALLINT, INTEGER, BIGINT	TINYINT, SMALLINT, INTEGER, BIGINT
BOOL	BOOL	BOOLEAN	BOOLEAN
FLOAT32, FLOAT64	FLOAT, DOUBLE	REAL, DOUBLE	REAL, DOUBLE
STRING	STRING	VARCHAR	STRING
BINARY	BINARY	VARBINARY	BINARY
DECIMAL128	DECIMAL128	DECIMAL	DECIMAL
DATE32	DATE32	DATE	DATE
TIMESTAMP	TIMESTAMP	TIMESTAMP	TIMESTAMP
TIMESTAMP WITH TZ	TIMESTAMP	TIMESTAMP WITH TIMEZONE	TIMESTAMP
TIME32	TIME32	TIME	n/a
TIME64	TIME64	TIME	n/a
MAP	MAP	MAP	MapType
ARRAY	LIST	ARRAY	ArrayType
ROW	STRUCT	ROW	StructType
UUID	UUID	UUID	CHAR(16)

Tip
Pay attention to precision settings when dealing with data types that have a configurable precision. For example, a data type of timestamp specified in a Parquet file can be seen as timestamp(3) in Trino (as a result of a Trino default setting) while processed as timestamp(6) in VAST Database.