12.42. Release 0.194

    • Fix planning performance regression that can affect queries over Hive tableswith many partitions.
    • Fix deadlock in memory management logic introduced in the previous release.
    • Restrict n (number of result elements) to 10,000 or less formin(col, n), max(col, n), min_by(col1, col2, n), and max_by(col1, col2, n).
    • Improve error message when a session property references an invalid catalog.
    • Reduce memory usage of histogram() aggregation function.
    • Improve coordinator CPU efficiency when discovering splits.
    • Include minimum and maximum values for columns in .

    Web UI Changes

    • Fix previously empty peak memory display in the query details page.
    • Fix regression in CLI that makes it always print “query aborted by user” whenthe result is displayed with a pager, even if the query completes successfully.
    • Return a non-zero exit status when an error occurs.
    • Add —ignore-errors option to continue processing in batch mode when an error occurs.

    JDBC Driver Changes

    • Allow configuring connection network timeout with setNetworkTimeout().
    • Allow setting client tags via the ClientTags client info property.
    • Expose update type via getUpdateType() on PrestoStatement.
    • Consistently fail queries that attempt to read partitions that are offline.Previously, the query can have one of the following outcomes: fail as expected,skip those partitions and finish successfully, or hang indefinitely.
    • Allow setting username used to access Hive metastore via the config property.
    • Add hive_storage_format and respect_table_format session properties, corresponding tothe hive.storage-format and hive.respect-table-format config properties.
    • Reduce ORC file reader memory consumption by allocating buffers lazily.Buffers are only allocated for columns that are actually accessed.

    Cassandra Changes