12.21. Release 0.215

General Changes

  • Fix regression in 0.214 that could cause queries to produce incorrect results for queriesusing 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 wherethe join output size cannot be estimated.
  • Add dynamic scheduling support to grouped execution. When a stage is executedwith grouped execution and the stage has no remote sources, table partitions can bescheduled to tasks in a dynamic way, which can help mitigating skew for queries usinggrouped execution. This feature can be enabled with thedynamic_schedule_for_grouped_execution session property or thedynamic-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_enabledsession 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 fixesa 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.