• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. Data Types
  6. Data Types Supported by Column-Store Tables

Data Types Supported by Column-Store Tables

Table 1 lists the data types supported by column-store tables.

Table 1 Data types supported by column-store tables

Category

Data Type

Length

Supported

Numeric types

smallint

2

Yes

integer

4

Yes

bigint

8

Yes

decimal

-1

Yes

numeric

-1

Yes

real

4

Yes

double precision

8

Yes

smallserial

2

Yes

serial

4

Yes

bigserial

8

Yes

Monetary types

money

8

Yes

Character types

character varying(n), varchar(n)

-1

Yes

character(n), char(n)

n

Yes

character, char

1

Yes

text

-1

Yes

nvarchar2

-1

Yes

name

64

No

Date/time types

timestamp with time zone

8

Yes

timestamp without time zone

8

Yes

date

4

Yes

time without time zone

8

Yes

time with time zone

12

Yes

interval

16

Yes

Large objects

clob

-1

Yes

blob

-1

No

Others

...

...

No