Help Center/ DataArts Studio/ User Guide/ DataArts Migration (Real-Time Jobs)/ Field Type Mapping/ Mapping Between Centralized/Distributed GaussDB and GaussDB(DWS) Field Types
Updated on 2025-08-05 GMT+08:00

Mapping Between Centralized/Distributed GaussDB and GaussDB(DWS) Field Types

DataArts Migration converts the source field type to the destination field type based on the default rule, and creates tables and synchronizes data in real time.

Field Type Mapping Rules

The following table lists the field types supported by a job that migrates data from GaussDB to GaussDB(DWS).

Table 1 Field types supported by a job that migrates data from GaussDB to GaussDB(DWS)

Type

GaussDB Data Type

GaussDB(DWS) Data Type

Description

String

CHAR(M)

CHAR(M)

Fixed-length string, filled with spaces

VARCHAR(M)

VARCHAR(M)

Variable-length string with an upper limit of length

TEXT

TEXT

Variable-length string with no upper limit of length, similar to VARCHAR without length declaration

Value

BOOLEAN

BOOL

Logical Boolean value (true/false)

SMALLINT

SMALLINT

int2

INTEGER

INTEGER

int/int4

BIGINT

BIGINT

int8

DECIMAL(M,D)

DECIMAL(M,D)

Accurate number with precision

NUMERIC(M,D)

NUMERIC(M,D)

Equivalent to NUMERIC

REAL

REAL

Single-precision floating point number (4 bytes)

DOUBLE

DOUBLE

Double-precision floating point number (8 bytes). It can also be represented by FLOAT without precision.

Date and time

DATE

TMESTAMP

If the source data is a date (1970-01-01), it will be converted to a timestamp containing the date and time (1970-01-01 00:00:00).

TIME(M)

TIME

Time of a day (08:00:00)

TIME(M) WITH TIME ZONE

TIMETZ

Time of a day, with the time zone (08:00:00)

TIMESTAMP(M)

TMESTAMP

Date and time without the time zone (1970-01-01 00:00:00)

TIMESTAMP(M) WITH TIME ZONE

TMESTAMPTZ

Date and time with the time zone (1970-01-01 00:00:00). It is TMESTAMPTZ.

INTERVAL

INTERVAL

Time interval

Binary

BYTEA

BYTEA

Binary data ("byte array")