Help Center/ TaurusDB/ User Guide/ HTAP Analysis (Standard Edition)/ Syntax and Data Type Mappings Between HTAP and TaurusDB Instances

Updated on 2025-01-16 GMT+08:00

View PDF

Syntax and Data Type Mappings Between HTAP and TaurusDB Instances

Standard HTAP instances support the native syntax of StarRocks. Character string comparison and the names of databases, tables, views, users, and roles are case sensitive, but the names of columns and partitions are case insensitive. For details, see StarRocks' official documentation.

When data of TaurusDB instances is synchronized to HTAP instances, the data types will be converted. For details, see Table 1.

**Table 1** Data type conversion
Data Type	TaurusDB Instance Data Type	HTAP Instance Data Type
NUMERTIC	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	BIT
DATE TIME	DATE	DATE
	DATETIME	DATETIME
	TIMESTAMP	DATETIME
	TIME	VARCHAR
	YEAR	INT
STRING	CHAR	CHAR/VARCHAR
	VARCHAR	VARCHAR
	BINARY	VARBINARY
	VARBINARY	VARBINARY
	BLOB	VARBINARY
	TEXT	TEXT
	ENUM	VARCHAR
	SET	Not supported
SPATIAL	GEOMETRY	Not supported
	POINT	Not supported
	LINESTRING	Not supported
	POLYGON	Not supported
	MULTIPOINT	Not supported
	MULTILINESTRING	Not supported
	MULTIPOLYGON	Not supported
	GEOMETRYCOLLECTION	Not supported
JSON	JSON	JSON