Release 0.124

    • The approx_percentile() aggregation now also accepts an array of percentages.

    • Fix correctness for some queries with IN lists. When all constants in the list are in the range of 32-bit signed integers but the test value can be outside of the range, true may be produced when the correct result should be false.

    • Add JMX stats to track authentication and authorization successes and failures.

    • Add configuration support for the system access control plugin. The system access controller can be selected and configured using . Note that Presto currently does not ship with any system access controller implementations.

    • Add support for WITH NO DATA syntax in CREATE TABLE ... AS SELECT.

    • Fix performance issue due to redundant processing in queries involving DISTINCT and .

    • Add optimization that can reduce the amount of data sent over the network for grouped aggregation queries. This feature can be enabled by optimizer.use-intermediate-aggregations config property or task_intermediate_aggregation session property.

    • Do not count expected exceptions as errors in the Hive metastore client stats.

    • Add support for pre and post control and test queries.

    If you are upgrading, you need to alter your verifier_queries table: