Release 0.222¶
Warning
This release contains a regression which may cause Presto to incorrectly
remove certain CAST
operations.
General Changes¶
Fix incorrect results when dividing certain decimal numbers (#12930).
Fix planning failure for certain join queries caused by invalid distribution type (#12354).
Add support for automatically retrying failed buckets when using grouped execution. Currently this is supported for certain
INSERT
queries using the Hive connector. This can be enabled with therecoverable_grouped_execution
session property or therecoverable-grouped-execution-enabled
configuration property (#12124).Add support for grouped execution for queries with no joins or aggregations. This can be enabled with the
grouped_execution_for_eligible_table_scans
session property or theexperimental.grouped-execution-for-eligible-table-scans-enabled
configuration property (#12934).Add configuration property
max-concurrent-materializations
and session propertymax_concurrent_materializations
to limit the number of plan sections that will run concurrently when using materialized exchanges.Add support for computing
approx_distinct()
over BingTile values.Add
merge_hll()
to merge an array of HyperLogLogs.Add bitwise shift operations,
bitwise_arithmetic_shift_right()
,bitwise_logical_shift_right()
andbitwise_shift_left()
.
Web UI Changes¶
Add completed and total lifespans to the Presto Coordinator UI.
Hive Connector Changes¶
Fix failures for
information_schema
queries when a table has an invalid storage format.Improve query execution time over bucketed table with large buckets.
Add config property
hive.metastore.glue.catalogid
to configure the Glue catalog ID.
SPI Changes¶
Add experimental interface
ConnectorPlanOptimizer
to allow connectors to participate in query plan optimization (e.g., filter pushdown) (#13102).Rename
LogicalRowExpressions::TRUE
andLogicalRowExpressions::FALSE
toLogicalRowExpressions::TRUE_CONSTANT
andLogicalRowExpressions::FALSE_CONSTANT
respectively to avoid collision withjava.lang.Boolean
.