Presto 0.186 Documentation

11.23. Release 0.164

11.23. Release 0.164

General Changes

  • Fix correctness issue for queries that perform DISTINCT and LIMIT on the results of a JOIN.
  • Fix correctness issue when casting between maps where the key or value is the REAL type.
  • Fix correctness issue in min_by() and max_by() when nulls are present in the comparison column.
  • Fail queries when FILTER clause is specified for scalar functions.
  • Fix planning failure for certain correlated subqueries that contain aggregations.
  • Fix planning failure when arguments to selective aggregates are derived from other selective aggregates.
  • Fix boolean expression optimization bug that can cause long planning times, planning failures and coordinator instability.
  • Fix query failure when TRY or lambda expression with the exact same body is repeated in an expression.
  • Fix split source resource leak in coordinator that can occur when a query fails.
  • Improve array_join() performance.
  • Improve error message for map subscript operator when key is not present in the map.
  • Improve client error message for invalid session.
  • Add VALIDATE mode for EXPLAIN.

Web UI Changes

  • Add resource group to query detail page.

Hive Changes

  • Fix handling of ORC files containing extremely large metadata.
  • Fix failure when creating views in file based metastore.
  • Improve performance for queries that read bucketed tables by optimizing scheduling.