Offline Sync to COS (Parquet File) Field Mapping Guide

1. Oracle to COS
Oracle Field Type
Mapped to COS (Parquet File) Field Type
Remark
CHAR
STRING
-
VARCHAR2
STRING
-
NVARCHAR2
STRING
-
NCHAR
STRING
-
NUMBER
DECIMAL
-
INTEGER
BIGINT
-
FLOAT
DOUBLE
-
LONG
STRING
-
BINARY_FLOAT
FLOAT
-
BINARY_DOUBLE
DOUBLE
-
DATE
STRING
No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP
STRING
No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP WITH TIME ZONE
TIMESTAMP
With time zone
INTERVAL YEAR TO MONTH
STRING
-
INTERVAL DAY TO SECOND
STRING
-
BLOB
STRING
-
CLOB
STRING
-
NCLOB
STRING
-
RAW
STRING
-
LONG RAW
STRING
-
ROWID
STRING
-
UROWID
STRING
-
2. PostgreSQL to COS
PostgreSQL Field Type
Mapped to COS (Parquet File) Field Type
Remark
BIT
STRING
-
BIT VARYING
STRING
-
BOOLEAN
BOOLEAN
-
BOX
STRING
-
BYTEA
STRING
-
CHARACTER
STRING
-
CHARACTER VARYING
STRING
-
CIDR
STRING
-
CIRCLE
STRING
-
DATE
TIMESTAMP
-
DOUBLE PRECISION
FLOAT
-
INET
STRING
-
INTEGER
INT
-
INTERVAL
STRING
-
JSON
STRING
-
JSONB
STRING
-
LINE
STRING
-
LSEG
STRING
-
MACADDR
STRING
-
MACADDR8
STRING
-
MONEY
STRING
-
NUMERIC
DECIMAL
-
PATH
STRING
-
PG_LSN
STRING
-
PG_SNAPSHOT
STRING
-
POINT
STRING
-
POLYGON
STRING
-
REAL(FLOAT4)
FLOAT
-
SMALLINT
INT
-
SMALLSERIAL
INT
-
SERIAL
INT
-
TEXT
STRING
-
TIME  WITHOUT TIME ZONE 
STRING
No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP  WITHOUT TIME ZONE
STRING
No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP  WITH TIME ZONE(TIMESTAMPTZ)
TIMESTAMP
With time zone
TSQUERY
STRING
-
TSVECTOR
STRING
-
UUID
STRING
-
XML
STRING
-
ARRAY
STRING
-
3. SQL Server to COS
SQL Server Field Type
Mapped to COS (Parquet File) Field Type
Remark
TINYINT
INT
-
SMALLINT
INT
-
INT
INT
-
BIGINT
BIGINT
-
BIT
BOOLEAN
-
DECIMAL
DECIMAL
-
NUMERIC
DECIMAL
-
MONEY
DECIMAL
-
SMALLMONEY
DECIMAL
-
FLOAT
FLOAT
-
REAL
FLOAT
-
DATE
STRING
-
TIME
STRING
No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
DATETIME2
TIMESTAMP
-
DATETIMEOFFSET
TIMESTAMP
-
DATETIME
TIMESTAMP
-
SMALLDATETIME
STRING
-
CHAR
STRING
-
VARCHAR
STRING
-
TEXT
STRING
-
NCHAR
STRING
-
NVARCHAR
STRING
-
NTEXT
STRING
-
BINARY
STRING
-
VARBINARY
STRING
-
IMAGE
STRING
-
CURSOR
STRING
-
GEOGRAPHY
STRING
-
GEOMETRY
STRING
-
HIERARCHYID
STRING
-
JSON
STRING
-
ROWVERSION
BIGINT
-
SQL_VARIANT
STRING
-
UNIQUEIDENTIFIER
STRING
-
XML
STRING
-
4. MySQL to COS
MySQL Field Types
Mapped to COS (Parquet File) Field Type
Remark
BIT
STRING
-
TINYINT
INT
-
BOOL
BOOLEAN
-
BOOLEAN
BOOLEAN
-
SMALLINT
INT
-
MEDIUMINT
INT
-
INT
INT
-
BIGINT
BIGINT
-
DECIMAL
DECIMAL
-
NUMERIC
DECIMAL
-
FIXED
DECIMAL
-
FLOAT
FLOAT
-
DOUBLE
DOUBLE
-
REAL
FLOAT
-
DATE
STRING
-
TIME
STRING
No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
DATETIME
STRING
No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP
TIMESTAMP
With time zone
YEAR
INT
-
CHAR
CHAR
-
VARCHAR
CHAR
-
BINARY
STRING
-
VARBINARY
STRING
-
TINYBLOB
STRING
-
BLOB
STRING
-
TEXT 
STRING
-
MEDIUMBLOB
STRING
-
MEDIUMTEXT 
STRING
-
LONGTEXT 
STRING
-
SET
STRING
-
GEOMETRY
STRING
-
POINT
STRING 
-
LINESTRING
STRING 
-
POLYGON
STRING 
-
MULTIPOINT
STRING 
-
MULTILINESTRING
STRING 
-
MULTIPOLYGON
STRING 
-
GEOMETRYCOLLECTION
STRING 
-
JSON
STRING
-
5. BigQuery to COS
BigQuery Field Type
Mapped to COS (Parquet File) Field Type
Remark
ARRAY
STRING
-
BOOL
BOOLEAN
-
BYTES
STRING
-
DATE
STRING
No time zone
DATETIME
STRING
No time zone
TIME
STRING
No time zone
TIMESTAMP
TIMESTAMP
With time zone
GEOGRAPHY
STRING
-
INTERVAL
STRING 
-
JSON
STRING
-
INT64
BIGINT
-
NUMERIC
DECIMAL
-
BIGNUMERIC
STRING
-
FLOAT64
DOUBLE
-
RANGE
STRING
-
STRING
STRING
-
STRUCT<...>
STRING
-

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

Oracle Field Type	Mapped to COS (Parquet File) Field Type	Remark
CHAR	STRING	-
VARCHAR2	STRING	-
NVARCHAR2	STRING	-
NCHAR	STRING	-
NUMBER	DECIMAL	-
INTEGER	BIGINT	-
FLOAT	DOUBLE	-
LONG	STRING	-
BINARY_FLOAT	FLOAT	-
BINARY_DOUBLE	DOUBLE	-
DATE	STRING	No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP	STRING	No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP WITH TIME ZONE	TIMESTAMP	With time zone
INTERVAL YEAR TO MONTH	STRING	-
INTERVAL DAY TO SECOND	STRING	-
BLOB	STRING	-
CLOB	STRING	-
NCLOB	STRING	-
RAW	STRING	-
LONG RAW	STRING	-
ROWID	STRING	-
UROWID	STRING	-

PostgreSQL Field Type	Mapped to COS (Parquet File) Field Type	Remark
BIT	STRING	-
BIT VARYING	STRING	-
BOOLEAN	BOOLEAN	-
BOX	STRING	-
BYTEA	STRING	-
CHARACTER	STRING	-
CHARACTER VARYING	STRING	-
CIDR	STRING	-
CIRCLE	STRING	-
DATE	TIMESTAMP	-
DOUBLE PRECISION	FLOAT	-
INET	STRING	-
INTEGER	INT	-
INTERVAL	STRING	-
JSON	STRING	-
JSONB	STRING	-
LINE	STRING	-
LSEG	STRING	-
MACADDR	STRING	-
MACADDR8	STRING	-
MONEY	STRING	-
NUMERIC	DECIMAL	-
PATH	STRING	-
PG_LSN	STRING	-
PG_SNAPSHOT	STRING	-
POINT	STRING	-
POLYGON	STRING	-
REAL(FLOAT4)	FLOAT	-
SMALLINT	INT	-
SMALLSERIAL	INT	-
SERIAL	INT	-
TEXT	STRING	-
TIME WITHOUT TIME ZONE	STRING	No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP WITHOUT TIME ZONE	STRING	No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP WITH TIME ZONE(TIMESTAMPTZ)	TIMESTAMP	With time zone
TSQUERY	STRING	-
TSVECTOR	STRING	-
UUID	STRING	-
XML	STRING	-
ARRAY	STRING	-

SQL Server Field Type	Mapped to COS (Parquet File) Field Type	Remark
TINYINT	INT	-
SMALLINT	INT	-
INT	INT	-
BIGINT	BIGINT	-
BIT	BOOLEAN	-
DECIMAL	DECIMAL	-
NUMERIC	DECIMAL	-
MONEY	DECIMAL	-
SMALLMONEY	DECIMAL	-
FLOAT	FLOAT	-
REAL	FLOAT	-
DATE	STRING	-
TIME	STRING	No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
DATETIME2	TIMESTAMP	-
DATETIMEOFFSET	TIMESTAMP	-
DATETIME	TIMESTAMP	-
SMALLDATETIME	STRING	-
CHAR	STRING	-
VARCHAR	STRING	-
TEXT	STRING	-
NCHAR	STRING	-
NVARCHAR	STRING	-
NTEXT	STRING	-
BINARY	STRING	-
VARBINARY	STRING	-
IMAGE	STRING	-
CURSOR	STRING	-
GEOGRAPHY	STRING	-
GEOMETRY	STRING	-
HIERARCHYID	STRING	-
JSON	STRING	-
ROWVERSION	BIGINT	-
SQL_VARIANT	STRING	-
UNIQUEIDENTIFIER	STRING	-
XML	STRING	-

MySQL Field Types	Mapped to COS (Parquet File) Field Type	Remark
BIT	STRING	-
TINYINT	INT	-
BOOL	BOOLEAN	-
BOOLEAN	BOOLEAN	-
SMALLINT	INT	-
MEDIUMINT	INT	-
INT	INT	-
BIGINT	BIGINT	-
DECIMAL	DECIMAL	-
NUMERIC	DECIMAL	-
FIXED	DECIMAL	-
FLOAT	FLOAT	-
DOUBLE	DOUBLE	-
REAL	FLOAT	-
DATE	STRING	-
TIME	STRING	No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
DATETIME	STRING	No time zone (if the time is in milliseconds, STRING will lose millisecond accuracy)
TIMESTAMP	TIMESTAMP	With time zone
YEAR	INT	-
CHAR	CHAR	-
VARCHAR	CHAR	-
BINARY	STRING	-
VARBINARY	STRING	-
TINYBLOB	STRING	-
BLOB	STRING	-
TEXT	STRING	-
MEDIUMBLOB	STRING	-
MEDIUMTEXT	STRING	-
LONGTEXT	STRING	-
SET	STRING	-
GEOMETRY	STRING	-
POINT	STRING	-
LINESTRING	STRING	-
POLYGON	STRING	-
MULTIPOINT	STRING	-
MULTILINESTRING	STRING	-
MULTIPOLYGON	STRING	-
GEOMETRYCOLLECTION	STRING	-
JSON	STRING	-

BigQuery Field Type	Mapped to COS (Parquet File) Field Type	Remark
ARRAY	STRING	-
BOOL	BOOLEAN	-
BYTES	STRING	-
DATE	STRING	No time zone
DATETIME	STRING	No time zone
TIME	STRING	No time zone
TIMESTAMP	TIMESTAMP	With time zone
GEOGRAPHY	STRING	-
INTERVAL	STRING	-
JSON	STRING	-
INT64	BIGINT	-
NUMERIC	DECIMAL	-
BIGNUMERIC	STRING	-
FLOAT64	DOUBLE	-
RANGE	STRING	-
STRING	STRING	-
STRUCT<...>	STRING	-

tencent cloud

New User Offers

Next-Generation CDN：EdgeOne

Elasticsearch Service Special Offers

Free Tier

Tencent Cloud Startup Program

Special Offers

Lighthouse Special Offers

Cloud Object Storage Special Offers

Featured Products

New Products

Education

Tencent Cloud Online Education Solutions

Gaming

Gaming Solution

Game Media Solutions

Financial Services

Financial Services Solution

Audio & Video

Audio/Video Solution

LVB Recording Solution

Interactive Classroom Solution

Interactive Live Streaming Solution

Audio Chat Social Networking Solution

Real Estate

Tencent Cloud LinkBase(Weiling)

E-commerce

E-commerce retail solutions

Compute

Cloud Virtual Machine

Auto Scaling

Batch Compute

CVM Dedicated Host

Database

TencentDB for MySQL

TencentDB for Redis®

TencentDB for CTSDB

TDSQL for MySQL

Data Transfer Service

TencentDB for MongoDB

TencentDB for PostgreSQL

TencentDB for SQL Server

TencentDB for TcaplusDB

Video Service

Cloud Streaming Services

Video on Demand

Media Processing Service

Cloud Application Rendering

Cloud Contact Center

Game Multimedia Engine

Chat

Real-time Communication

Tencent Effect SDK

AI and Machine Learning

Image Creation Large Model

Face Fusion

eKYC

Optical Character Recognition

Video Creation Large Model

Industry Applications

Tencent HealthCare Omics Platform

Container and Middleware

TDMQ for CKafka

Serverless Cloud Function

Tencent Kubernetes Engine

Tencent Kubernetes Engine for Serverless

Networking

Cloud Load Balancer

Virtual Private Cloud

Direct Connect

Cloud Connect Network

NAT Gateway

VPN Connection

Bandwidth Package

Anycast Internet Acceleration

Elastic Network Interface

Flow Logs

Global Application Acceleration Platform

Security

Captcha