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

  • BINARY

  • 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.17, “HeatWave Limitations”.

• String and text data types:

  • CHAR

  • VARCHAR

  • TEXT

  • TINYTEXT

  • MEDIUMTEXT

  • LONGTEXT

• ENUM

  For ENUM limitations, see Section 2.17, “HeatWave Limitations”.

• JSON

  See: The JSON Data Type.