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+.