Release 0.261¶
Highlights¶
Improve performance of
SUM()
andAVG()
aggregate functions when used withDECIMAL
type.Add column comment to metadata in JDBC based connector
Add hidden column
$file_modified_time
which is the time the file containing the row was last modified.Add hidden column
$file_size
which is the size of the file containing the row.Add support to write data to paths defined by Iceberg’s
LocationProvider
instead of a hard-coded table root directory.
Details¶
General Changes¶
Fix query failures for queries with shape
AGG(IF(condition, expr))
where expr could return exceptions for rows not matchingcondition
. These failures occurred when configuration propertyoptimizer.aggregation-if-to-filter-rewrite-enabled
was enabled.Improve performance of
SUM()
andAVG()
aggregate functions when used withDECIMAL
type.Disable configuration property
optimizer.aggregation-if-to-filter-rewrite-enabled
by default.
SPI Changes¶
Add
Identity
field tocheckCanSetUser
for finer granularity of system access control.
Hive Changes¶
Add hidden column
$file_modified_time
which is the time the file containing the row was last modified.Add hidden column
$file_size
which is the size of the file containing the row.Add CPU usage statistics for file metadata reading to
RuntimeStats
table in the coordinator UI and debug mode of presto-cli.
Iceberg Changes¶
Add support to write data to paths defined by Iceberg’s
LocationProvider
instead of a hard-coded table root directory.
JDBC Changes¶
Add column comment to metadata in JDBC based connector.
Prometheus Changes¶
Fix startup error by reducing the default value of configuration property
prometheus.query-chunk-duration
from1d
to10m
.
Credits¶
Andrii Rosa, Arunachalam Thirupathi, Beinan, Dongliang Chen, George Wang, Jack Ye, James Petty, James Sun, Reetika Agrawal, Rongrong Zhong, Shixuan Fan, Sreeni Viswanadha, Swapnil Tailor, Timothy Meehan, Ying, Zhan Yuan, Zhongting Hu, linzebing