11.94. Release 0.124
General Changes
- Fix race in memory tracking of JOIN which could cause the cluster to become overcommitted and possibly crash.
- The 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 thelist are in the range of 32-bit signed integers but the test value can beoutside of the range, true may be produced when the correct result shouldbe 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 accesscontroller can be selected and configured using etc/access-control.properties.Note that Presto currently does not ship with any system access controllerimplementations.
- Add support for WITH NO DATA syntax in CREATE TABLE … AS SELECT.
- Fix issue where invalid plans are generated for queries with multiple aggregationsthat require input values to be cast in different ways.
- Fix performance issue due to redundant processing in queries involving DISTINCTand LIMIT.
- Add optimization that can reduce the amount of data sent over the networkfor grouped aggregation queries. This feature can be enabled byoptimizer.use-intermediate-aggregations config property ortask_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 yourverifier_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;
原文: https://prestodb.io/docs/current/release/release-0.124.html