Release 0.261

    • 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.

    • Fix query failures for queries with shape AGG(IF(condition, expr)) where expr could return exceptions for rows not matching . These failures occurred when configuration property optimizer.aggregation-if-to-filter-rewrite-enabled was enabled.

    • Disable configuration property optimizer.aggregation-if-to-filter-rewrite-enabled by default.

    SPI Changes

    • Add Identity field to for finer granularity of system access control.

    • 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.
    • Add column comment to metadata in JDBC based connector.

    Prometheus Changes

    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