Release Notes

Dynamic Release Record (2026)

Product Introduction

Product Overview

Product Advantages

Product Architecture

Product Features

Application Scenarios

Purchase Guide

Billing Overview

Product Version Purchase Instructions

Execute Resource Purchase Description

Billing Modes

Overdue Policy

Refund

Preparations

Overview of Account and Permission Management

Add allowlist /security groups (Optional)

Operation Guide

Console Operation

Project Management

Data Integration

Studio

Data Development

Data Analysis

Data Science

Data Governance (with Unity Semantics)

API Documentation

History

Introduction

API Category

Making API Requests

Smart Ops Related Interfaces

Project Management APIs

Resource Group APIs

Data Development APIs

Data Asset - Data Dictionary APIs

Data Development APIs

Ops Center APIs

Data Operations Related Interfaces

Data Exploration APIs

Asset APIs

Metadata Related Interfaces

Task Operations APIs

Data Security APIs

Instance Operation and Maintenance Related Interfaces

Data Map and Data Dictionary APIs

Data Quality Related Interfaces

DataInLong APIs

Platform Management APIs

Data Source Management APIs

Data Quality APIs

Platform Management APIs

Asset Data APIs

Data Source Management APIs

Data Types

Error Codes

WeData API 2025-08-06

Service Level Agreements

Related Agreement

Data Processing And Security Agreement

Glossary

Offline Sync to COS (Parquet File) Field Mapping Guide

PDF

포커스 모드

폰트 크기

마지막 업데이트 시간: 2025-03-19 08:59:13

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
-

도움말 및 지원

문제 해결에 도움이 되었나요?

더 자세한 내용은 문의하기 또는 티겟 제출 을 통해 문의할 수 있습니다.

피드백

tencent cloud

Tencent Cloud WeData

Offline Sync to COS (Parquet File) Field Mapping Guide

1. Oracle to COS

1. Oracle to COS

2. PostgreSQL to COS

2. PostgreSQL to COS

3. SQL Server to COS

3. SQL Server to COS

4. MySQL to COS

4. MySQL to COS

5. BigQuery to COS

5. BigQuery 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	-

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	-