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

• Date and time 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.16, “Limitations”.

• String data types:

  • CHAR

  • VARCHAR

  • TEXT-types including TEXT, TINYTEXT, MEDIUMTEXT, and LONGTEXT.

• ENUM

  For ENUM limitations, see Section 2.16, “Limitations”.