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

Mapping Between Centralized/Distributed GaussDB and 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 DWS.

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

Type

GaussDB Data Type

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

TIMESTAMP

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)

TIMESTAMP

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

TIMESTAMP(M) WITH TIME ZONE

TIMESTAMPTZ

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

INTERVAL

INTERVAL

Time interval

Binary

BYTEA

BYTEA

Binary data ("byte array")