Release 0.194#
General#
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 formin(col, n)
,max(col, n)
,min_by(col1, col2, n)
, andmax_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
.
Web UI#
Fix previously empty peak memory display in the query details page.
CLI#
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.
JDBC driver#
Allow configuring connection network timeout with
setNetworkTimeout()
.Allow setting client tags via the
ClientTags
client info property.Expose update type via
getUpdateType()
onPrestoStatement
.
Hive#
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
andrespect_table_format
session properties, corresponding to thehive.storage-format
andhive.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#
Fix failure when querying
information_schema.columns
when there is no equality predicate ontable_name
.