22.73. 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
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 befalse
. - 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 inCREATE 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
andLIMIT
. - 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 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 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;