2.10 Supported Data Types

HeatWave supports the following data types. Columns with unsupported data types must be excluded (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 supported only with strict SQL mode. See Strict SQL Mode.

  For limitations related to TIMESTAMP data type support, see Section 2.18, “HeatWave MySQL Limitations”.

• String and text data types:

  • CHAR

  • VARCHAR

  • TEXT

  • TINYTEXT

  • MEDIUMTEXT

  • LONGTEXT

  • VECTOR

• ENUM

  For ENUM limitations, see Section 2.18, “HeatWave MySQL Limitations”.

• JSON

  The JSON data type is supported as of MySQL 8.2.0-u1.

  As of MySQL 9.0.0, the JSON data type supports the following:

  • Section 2.12.3, “Cast Functions and Operators”.

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

  • Section 2.12.5, “Control Flow Functions and Operators”.

  • Section 2.12.10, “Mathematical Functions”.

  • Section 2.12.11, “String Functions and Operators”.