SELECT CAST(CAST(enum_col AS FLOAT) AS CHAR(3)) FROM tbl_name;
Support was added for
SELECT DISTINCTqueries that order the result set by a column that is not defined in the
SELECTlist. For example, the following query can now be offloaded to HeatWave for execution:
SELECT DISTINCT a FROM t1 ORDER BY c DESC;
Query plan statistics are now collected and stored in a statistics cache when a query is executed in HeatWave. When a new query shares query execution plan nodes with previously executed queries, the actual statistics collected from previously executed queries are used instead of estimated statistics, which improves query execution plans, cost estimations, execution times, and memory efficiency.
The statistics cache is an LRU structure. When cache capacity is reached, the least recently used entries are evicted from the cache as new entries are added. The maximum number of entries permitted in the statistics cache is defined by the
rapid_stats_cache_max_entriessetting. The number of entries permitted by default is 65536, which is enough to store statistics for 4000 to 5000 unique queries of medium complexity.
Support was added for: