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 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 Changes¶
Fix previously empty peak memory display in the query details page.
CLI Changes¶
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 Changes¶
Allow configuring connection network timeout with
setNetworkTimeout()
.Allow setting client tags via the
ClientTags
client info property.Expose update type via
getUpdateType()
onPrestoStatement
.
Hive Changes¶
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 Changes¶
Fix failure when querying
information_schema.columns
when there is no equality predicate ontable_name
.