HTAP标准版语法说明和数据类型对应关系

NUMERTIC TYPES

TINYINT

TINYINT

TINYINT UNSIGNED

SMALLINT

SMALLINT

SMALLINT

SMALLINT UNSIGNED

INT

MEDIUMINT

INT

INTEGER/INT

INT

INTEGER/INT UNSIGNED

BIGINT

BIGINT

BIGINT

BIGINT UNSIGNED

LARGEINT

DECIMAL/NEMERIC

DECIMAL

FLOAT

FLOAT

DOUBLE/REAL

DOUBLE

BIT

STRING

DATE TIME TYPES

DATE

DATE

DATETIME

DATETIME

TIMESTAMP

DATETIME

TIME

STRING

YEAR

INT

String Data Types

CHAR

CHAR/VARCHAR

VARCHAR

VARCHAR

BINARY

VARBINARY

VARBINARY

VARBINARY

BLOB

VARBINARY

TEXT

STRING

ENUM

STRING

SET

STRING

Spatial Data Types

GEOMETRY

STRING

POINT

STRING

LINESTRING

STRING

POLYGON

STRING

MULTIPOINT

STRING

MULTILINESTRING

STRING

MULTIPOLYGON

STRING

GEOMETRYCOLLECTION

STRING

JSON Data Types

JSON

JSON