12.35. Release 0.215
General Changes
- Fix regression in 0.214 that could cause queries to produce incorrect results for queries
using map types.
- Fix reporting of the processed input data for source stages in
EXPLAIN ANALYZE.
- Fail queries that use non-leaf resource groups. Previously, they would remain queued forever.
- Improve CPU usage for specific queries (#11757).
- Extend stats and cost model to support
row_number() window function estimates.
- Improve the join type selection and the reordering of join sides for cases where
the join output size cannot be estimated.
- Add dynamic scheduling support to grouped execution. When a stage is executed
with grouped execution and the stage has no remote sources, table partitions can be
scheduled to tasks in a dynamic way, which can help mitigating skew for queries using
grouped execution. This feature can be enabled with the
dynamic_schedule_for_grouped_execution session property or the
dynamic-schedule-for-grouped-execution config property.
- Add
beta_cdf() and inverse_beta_cdf() functions.
- Split the reporting of raw input data and processed input data for source operators.
- Remove collection and reporting of raw input data statistics for the
Values,
Local Exchange, and Local Merge Sort operators.
- Simplify
EXPLAIN (TYPE IO) output when there are too many discrete components.
This avoids large output at the cost of reduced granularity.
- Add
parse_presto_data_size() function.
- Add support for
UNION ALL to optimizer’s cost model.
- Add support for estimating the cost of filters by using a default filter factor.
The default value for the filter factor can be configured with the
default_filter_factor_enabled
session property or the optimizer.default-filter-factor-enabled.
Geospatial Changes
- Add input validation checks to
ST_LineString() to conform with the specification.
- Improve spatial join performance.
- Enable spatial joins for join conditions expressed with the
ST_Within() function.
Web UI Changes
- Fix Capture Snapshot button for showing current thread stacks.
- Fix dropdown for expanding stage skew component on the query details page.
- Improve the performance of the thread snapshot component on the worker status page.
- Make the reporting of Cumulative Memory usage consistent on the query list and query details pages.
- Remove legacy thread UI.
Hive Changes
- Add predicate pushdown support for the
DATE type to the Parquet reader. This change also fixes
a bug that may cause queries with predicates on DATE columns to fail with type mismatch errors.
Redis Changes
- Prevent printing the value of the
redis.password configuration property to log files.