4.2.1 Supported Data Types for MySQL HeatWave

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:

  • BIGINT

  • BOOL

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INT

  • INTEGER

  • MEDIUMINT

  • SMALLINT

  • TINYINT

• Temporal data types:

  • DATE

  • DATETIME

  • TIME

  • TIMESTAMP

  • YEAR

  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:

  • CHAR

  • VARCHAR

  • TEXT

  • TINYTEXT

  • MEDIUMTEXT

  • LONGTEXT

  • VECTOR

  For string and text data type limitations, see Section 11.2.1.1, “Data Type Limitations”.

• ENUM

  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”.

What's Next

• Learn how to perform the following tasks:

  • Run queries

  • Modify tables

  • Retrieve MySQL HeatWave Metadata

  • Optimize workloads for OLAP and OLTP

  • Monitor MySQL HeatWave processes