Data Types Supported by Column-Store Tables

Updated on 2024-12-18 GMT+08:00

View PDF

Table 1 lists the data types supported by column-store tables. Other data types that are not listed are not supported currently.

**Table 1** Data types supported by column-store tables
Category	Data Type	Description	Length
Numeric Type	smallint	Small integer, also called INT2	2
	integer	Typical choice for integer, also called INT4	4
	bigint	Big integer, also called INT8	8
	decimal	Arbitrary precision type	Variable length
	numeric	Arbitrary precision type	Variable length
	real	Single-precision floating point	4
	double precision	Double-precision floating point	8
	smallserial	Two-byte auto-incrementing integer	2
	serial	Four-byte auto-incrementing integer	4
	bigserial	Eight-byte auto-incrementing integer	8
Monetary Type	money	Currency amount	8
Character Type	character varying(n), varchar(n)	Variable-length string	Variable length
	character(n), char(n)	Fixed-length string	n
	character, char	Single-byte internal type	1
	text	Variable-length string	Variable length
	nvarchar2	Variable-length string	Variable length
	clob	A big text object	Variable length
Date/Time Type	timestamp with time zone	Date and time (with time zone)	8
	timestamp without time zone	Date and time	8
	date	Date and time (Oracle compatibility mode); date (other compatibility modes)	When using Oracle compatibility mode, the storage space is 8 bytes, whereas in other compatibility modes, it is 4 bytes.
	time without time zone	Time within one day.	8
	time with time zone	Time within one day (with time zone)	12
	interval	Time interval	16
JSON Type	json	-	-
JSON Type	jsonb	-	-
RoaringBitmap	-	High-efficiency bitmap, which supports the bitmap calculation of datasets of the int type.	Variable length