Release 0.246

    There is a bug causing or``LIMIT`` to be incorrectly eliminated when using GROUPING SETS (())`, ``CUBE or ROLLUP, first introduced in 0.246 by #14915

    • Fix a possible integer overflow error when spilling to temporary storage.

    • Fix an error where Presto server can fail to start when using function namespace manager.

    • Add a minimum value of 30 seconds to the configuration property .

    • Add listener-based revocation model for spilling strategy PER_TASK_MEMORY_THRESHOLD.

    • Disallow literals used with Window functions as it’s not useful, expensive and most often used wrongly.

    • Add support for fragment result caching for queries with local exchange (e.g. intermediate aggregation).

    • Improve queries that have unnecessary limits and order bys. This feature is enabled by default and can be disabled by using the configuration property optimizer.skip-redundant-sort or session property skip_redundant_sort.

    • Upgrade JTS to 1.18.0.
    • Fix dynamic pruning failures for joining on null keys in hive partition.

    Contributors