MySQL HeatWave User Guide
MySQL HeatWave supports the following data types. Columns with
unsupported data types must be excluded, and defined as
NOT SECONDARY before loading a table. See
Section 4.2.6.1, “Exclude Table Columns”.
Numeric data types:
Temporal data types:
Temporal types are only supported with strict SQL mode. See Strict SQL Mode.
For limitations related to
TIMESTAMP data type support,
see Section 11.2.1.1, “Data Type Limitations”.
String and text data types:
For string and text data type limitations, see Section 11.2.1.1, “Data Type Limitations”.
For ENUM limitations, see
Section 11.2.1.1, “Data Type Limitations”.
JSON
As of MySQL 9.0.0, the JSON
data type supports the following functions and operators:
Cast-functions and operators, see: Section 5.3.3, “Cast Functions and Operators”.
COALESCE() and
IN(), see:
Section 5.3.4, “Comparison Functions and Operators”.
Flow control functions and operators, see: Section 5.3.5, “Control Flow Functions and Operators”.
Mathematical functions, see: Section 5.3.10, “Mathematical Functions”.
String functions and operators, see: Section 5.3.11, “String Functions and Operators”.
Learn how to perform the following tasks: