Release 347 (25 Nov 2020)#
General#
Add
ALTER VIEW ... SET AUTHORIZATION
syntax for changing owner of the view. (#5789)Add support for
INTERSECT ALL
andEXCEPT ALL
. (#2152)Add
contains_sequence()
function. (#5593)Support defining cluster topology (used for query scheduling) using network subnets. (#4862)
Improve query performance by reducing worker to worker communication overhead. (#5905, #5949)
Allow disabling client HTTP response compression, which can improve throughput over fast network links. Compression can be disabled globally via the
query-results.compression-enabled
config property, for CLI via the--disable-compression
flag, and for the JDBC driver via thedisableCompression
driver property. (#5818)Rename
rewrite-filtering-semi-join-to-inner-join
session property torewrite_filtering_semi_join_to_inner_join
. (#5954)Throw a user error when session property value cannot be decoded. (#5731)
Fix query failure when expressions that produce values of type
row
are used in aVALUES
clause. (#3398)
Server#
A minimum Java version of 11.0.7 is now required for Presto to start. This is to mitigate JDK-8206955. (#5957)
Security#
JDBC driver#
Implement
addBatch()
,clearBatch()
andexecuteBatch()
methods inPreparedStatement
. (#5507)
CLI#
Add support for providing queries to presto-cli via shell redirection. (#5881)
Docker image#
Update Presto docker image to use CentOS 8 as the base image. (#5920)
Hive connector#
Add support for
ALTER VIEW ... SET AUTHORIZATION
SQL syntax to change the view owner. This supports Presto and Hive views. (#5789)Allow configuring HDFS replication factor via the
hive.dfs.replication
config property. (#1829)Add access checks for tables in Hive Procedures. (#1489)
Decrease latency of
INSERT
andCREATE TABLE AS ...
queries by updating table and column statistics in parallel. (#3638)Fix leaking S3 connections when querying Avro tables. (#5562)
Kudu connector#
Add dynamic filtering support. It can be enabled by setting a non-zero duration value for
kudu.dynamic-filtering.wait-timeout
config property ordynamic_filtering_wait_timeout
session property. (#5594)
MongoDB connector#
Improve performance of queries containing a
LIMIT
clause. (#5870)
Other connectors#
Improve query performance by compacting large pushed down predicates for the PostgreSQL, MySQL, Oracle, Redshift and SQL Server connectors. Compaction threshold can be changed using the
domain-compaction-threshold
config property ordomain_compaction_threshold
session property. (#6057)Improve performance for the PostgreSQL, MySQL, SQL Server connectors for certain complex queries involving aggregation and predicates by pushing the aggregation and predicates computation into the remote database. (#4112)