Data Type
Last updated:2025-05-09 11:51:19
This document provides a detailed list of the data types supported by the read-only analysis engine.
Numeric Data Types
Type Classification | Type | Support Status and Description |
Numeric Data Types | TINYINT | Supported |
| SMALLINT | Supported |
| MEDIUMINT | Supported |
| INT | Supported |
| BIGINT | Supported |
| DECIMAL and NUMERIC | Supported |
| FLOAT | Supported |
| DOUBLE | Supported |
| BIT | Supported Note: In the read-only analysis engine, the BIT data type is supported by converting it to an unsigned INT type. As a result, BIT data is only supported in numeric comparison scenarios within the read-only analysis engine. |
Date and Time Data Types | DATE | Supported |
| DATETIMESTAMP | Supported |
| TIMESTAMP | Supported |
| TIME | Supported |
| YEAR | Supported |
Character Data Types | CHAR | Supported |
| VARCHAR | Supported |
| BINARY | Supported |
| BLOB | Supported |
| TEXT | Supported |
| ENUM | Supported Note: In the read-only analysis engine, the ENUM and SET data types are supported by converting them to the STRING type. As a result, related expressions or specialized functions such as & and FIND_IN_SET are not supported. |
| SET | |
Spatial Data Types | GEOMETRY | Not supported. |
| POINT | Not supported. |
| LINESTRING | Not supported. |
| POLYGON | Not supported. |
JSON Data Types | JSON | Supported Note: The JSON data type is supported starting from read-only analysis engine kernel version 2.2410.1.0. It is not supported in version 1.2404.x. |
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback