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

Updated on 2025-06-10 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 CAUTION: Unsigned integers in TaurusDB are converted to a larger integer type for storage. When an integer is converted to an unsigned integer, ensure that no negative number exists in historical data.
	SMALLINT	SMALLINT
	SMALLINT UNSIGNED	INT
	MEDIUMINT	INT
	INTEGER/INT	INT
	INTEGER/INT UNSIGNED	BIGINT
	BIGINT	BIGINT
	BIGINT UNSIGNED	LARGEINT
	DECIMAL/NEMERIC	DECIMAL NOTE: If the precision of DECIMAL is greater than 64, the DECIMAL data type of TaurusDB instances will be converted to VARCHAR when being synchronized to HTAP instances.
	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 CAUTION: 1. When the ENUM and SET types are used, set the binlog_row_metadata parameter of TaurusDB instances to FULL. 2. Use the case-sensitive character string format during query.
	SET	VARCHAR
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