Changes in MySQL HeatWave 8.0.32 (2023-01-17, General Availability)

• Deprecation and Removal Notes

• MySQL HeatWave AutoML

• Functionality Added or Changed

Deprecation and Removal Notes

• MySQL 8.0.32 deprecates the heatwave_load_report and heatwave_advisor_report tables, and replaces them with the heatwave_autopilot_report table in the sys schema. A future release will remove them. (Bug #34727481)

MySQL HeatWave AutoML

• MySQL 8.0.32 introduces a number of changes for MySQL HeatWave AutoML routines:

  • The routines: ML_PREDICT_ROW, ML_PREDICT_TABLE, ML_EXPLAIN_ROW, and ML_EXPLAIN_TABLE now include the ml_results column, which uses JSON format to return the results.

  • The routines: ML_PREDICT_ROW, ML_PREDICT_TABLE, ML_EXPLAIN_ROW, and ML_EXPLAIN_TABLE now allow additional columns that are not required for prediction or explanation.

  • The routines: ML_PREDICT_ROW, and ML_PREDICT_TABLE now allow an options parameter in JSON format.

  • The ML_TRAIN routine also runs the ML_EXPLAIN routine with the default Permutation Importance model.

  (WL #15420)

• MySQL 8.0.32 introduces progress tracking for ML_TRAIN. Use a second MySQL Client window to track the progress of ML_TRAIN with calls to the performance schema. It also introduces the rapid_ml_operation_count status variable. (WL #15384)

Functionality Added or Changed

• MySQL HeatWave now supports the following encryption and compression functions:

  • COMPRESS()

  • MD5()

  • RANDOM_BYTES()

  • SHA()

  • SHA1()

  • SHA2()

  • UNCOMPRESS()

  • UNCOMPRESSED_LENGTH()

  (WL #15283)

• MySQL HeatWave now supports the following mathematical functions:

  • CRC32()

  • LOG2()

  • LOG10()

  • RAND()

  (WL #15256)