Data Types Supported by Column-Store Tables¶
Table 1 lists the data types supported by column-store tables. Other data types that are not listed are not supported currently.
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 |