============= Release 0.124 ============= General Changes --------------- * Fix race in memory tracking of ``JOIN`` which could cause the cluster to become over committed and possibly crash. * The :func:`approx_percentile` aggregation now also accepts an array of percentages. * Allow nested row type references. * 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``. * Fail queries submitted while coordinator is starting. * 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 ``etc/access-control.properties``. 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 issue where invalid plans are generated for queries with multiple aggregations that require input values to be cast in different ways. * Fix performance issue due to redundant processing in queries involving ``DISTINCT`` and ``LIMIT``. * 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. Hive Changes ------------ * Do not count expected exceptions as errors in the Hive metastore client stats. * Improve performance when reading ORC files with many tiny stripes. Verifier -------- * Add support for pre and post control and test queries. If you are upgrading, you need to alter your ``verifier_queries`` table:: ALTER TABLE verifier_queries ADD COLUMN test_postqueries text; ALTER TABLE verifier_queries ADD COLUMN test_prequeries text; ALTER TABLE verifier_queries ADD COLUMN control_postqueries text; ALTER TABLE verifier_queries ADD COLUMN control_prequeries text;