3.17 Supported Data Types

HeatWave AutoML supports the following data types:

• FLOAT

• DOUBLE

• INT

• TINYINT

• SMALLINT

• MEDIUMINT

• BIGINT

• INT UNSIGNED

• TINYINT UNSIGNED

• SMALLINT UNSIGNED

• MEDIUMINT UNSIGNED

• BIGINT UNSIGNED

• VARCHAR

• CHAR

• DATE.

• TIME.

• DATETIME.

• TIMESTAMP.

• YEAR.

• TINYTEXT.

• TEXT.

• MEDIUMTEXT.

• LONGTEXT.

HeatWave AutoML uses TfidfVectorizer to pre-process TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT and appends the results to the data set. HeatWave AutoML has the following limitations for text usage:

• The ML_PREDICT_TABLE ml_results column contains the prediction results and the data. This combination must be less than 65,532 characters.

• HeatWave AutoML only supports datasets in the English language.

• HeatWave AutoML does not support text columns with NULL values.

• HeatWave AutoML does not support a text target column.

• HeatWave AutoML does not support recommendation tasks with a text column.

• For the forecasting task, endogenous_variables cannot be text.

DECIMAL data type columns are not supported. Remove them or convert them to FLOAT.