Release 0.204
Improve performance of correlated subqueries when filters from outer query can be propagated to the subquery.
Add support for all geometry types in ST_Area().
Add function.
Add to_big_endian_32() and functions.
Make lpad() and functions support in addition to
VARCHAR
.Allow using arrays of mismatched lengths with zip_with(). The missing positions are filled with .
Track execution statistics of
AddExchanges
and optimizer rules.
Event Listener Changes
- Add resource estimates to query events.
Display resource estimates in Web UI query details page.
Resource Group Changes
- Fix unnecessary queuing in deployments where no resource group configuration was specified.
Fix memory accounting for sort buffer used for writing sorted bucketed tables.
Disallow creating tables with unsupported partition types.
Support overwriting partitions for insert queries. This behavior is controlled by session property
insert_existing_partitions_behavior
.Prevent the optimized ORC writer from writing excessively large stripes for highly compressed, dictionary encoded columns.
Enable optimized Parquet reader and predicate pushdown by default.
Cassandra Connector Changes
Optimize partition list retrieval for Cassandra 2.2+.