Deze pagina is nog niet beschikbaar in uw eigen taal. We werken er hard aan om meer taalversies toe te voegen. Bedankt voor uw steun.

On this page

Show all

Help Center/ GaussDB(DWS)/ SQL Syntax Reference (9.1.0.x)/ Data Types/ Data Types Supported by Column-Store Tables

Data Types Supported by Column-Store Tables

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

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

-

-

jsonb

-

-

RoaringBitmap

-

High-efficiency bitmap, which supports the bitmap calculation of datasets of the int type.

Variable length

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback