Release 399 (6 Oct 2022)#
General#
Add operator CPU and wall time distribution to
EXPLAIN ANALYZE VERBOSE
. (#14370)Improve performance of joins. (#13352)
Remove support for the deprecated
row
tojson
cast behavior, and remove thedeprecated.legacy-row-to-json-cast
configuration property. (#14388)Fix error when using
PREPARE
withDROP VIEW
when the view name is quoted. (#14196)Fix potential planning failure for queries involving
UNION
. (#14472)Fix error when using aggregations in window expressions when the function loaded from a plugin. (#14486)
Accumulo connector#
Change the default value of the
accumulo.zookeeper.metadata.root
configuration property to/trino-accumulo
from/presto-accumulo
. (#14326)
BigQuery connector#
ClickHouse connector#
Fix bug where the intended default value of the
domain-compaction-threshold
configuration property was incorrectly used as a maximum limit. (#14350)
Delta Lake connector#
Hive connector#
Add
max-partition-drops-per-query
configuration property to limit the number of partition drops. (#12386)Add
hive.s3.region
configuration property to force S3 to connect to a specific region. (#14398)Improve performance of reading decimal columns from Parquet files. (#14260)
Reduce memory usage on the coordinator. (#14408)
Reduce query memory usage during inserts to S3. (#14212)
Change the name of the
partition_column
andpartition_value
arguments for theflush_metadata_cache
procedure topartition_columns
andpartition_values
, respectively, for parity with other procedures. (#13566)Change field name matching to be case insensitive. (#13423)
Allow setting the AWS STS endpoint and region when using a Glue metastore. (#14412)
Hudi connector#
Fix failure when reading hidden columns. (#14341)
Iceberg connector#
Improve performance of reading decimal columns from Parquet files. (#14260)
Reduce planning time for complex queries. (#14443)
Store metastore
table_type
property value in uppercase for compatibility with other Iceberg catalog implementations. (#14384)Allow setting the AWS STS endpoint and region when using a Glue metastore. (#14412)
Phoenix connector#
Fix bug where the intended default value of the
domain-compaction-threshold
configuration property was incorrectly used as a maximum limit. (#14350)
SQL Server connector#
Fix error when querying or listing tables with names that contain special characters. (#14286)