Range operators on
VARLEN-encoded string columns are now supported. For example, the following query, where
VARLEN-encoded string column, can now be offloaded to HeatWave:
SELECT COUNT(*) FROM lineitem WHERE L_LINESTATUS >= 1 and L_LINESTATUS <= 10;
HeatWave now supports
INSERT ... SELECTstatements where the
SELECTportion of the statement is offloaded to HeatWave for accelerated execution, and the result set is inserted into a table on the MySQL Database Service instance. Offloading the
SELECTquery to HeatWave can reduce
INSERT ... SELECTstatement execution time. For more information, see INSERT ... SELECT Statements.
VARLEN-encoded columns are now supported as data placement keys. For information about the data placement feature, see Defining Data Placement Keys.
Failure handling was improved for queries involving unsupported internal data types. Such queries now exit with an error indicating that the internal data type of the query is not supported.