2.11 Supported Data Types

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 2.2.2.1, “Excluding 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 2.19.2, “Data Type Limitations”.

• String and text data types:

  • CHAR

  • VARCHAR

  • TEXT

  • TINYTEXT

  • MEDIUMTEXT

  • LONGTEXT

  • VECTOR

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

• ENUM

  For ENUM limitations, see Section 2.19.2, “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 2.14.3, “Cast Functions and Operators”.

  • COALESCE() and IN(), see: Section 2.14.4, “Comparison Functions and Operators”.

  • Flow control functions and operators, see: Section 2.14.5, “Control Flow Functions and Operators”.

  • Mathematical functions, see: Section 2.14.10, “Mathematical Functions”.

  • String functions and operators, see: Section 2.14.11, “String Functions and Operators”.