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:
-
Date and time data types:
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:
-
For
ENUM
limitations, see Section 2.16, “Limitations”.