12.52. Release 0.194

General Changes

Fix planning performance regression that can affect queries over Hive tables with many partitions.
Fix deadlock in memory management logic introduced in the previous release.
Add word_stem() function.
Restrict n (number of result elements) to 10,000 or less for min(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 SHOW STATS.

Fix regression in CLI that makes it always print “query aborted by user” when the result is displayed with a pager, even if the query completes successfully.
Return a non-zero exit status when an error occurs.
Add --client-info option for specifying client info.
Add --ignore-errors option to continue processing in batch mode when an error occurs.

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 hive.metastore.username config property.
Add hive_storage_format and respect_table_format session properties, corresponding to the 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.

Fix failure when querying information_schema.columns when there is no equality predicate on table_name.