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.

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