Release 369 (24 Jan 2022)#
General#
Add support for
Pacific/Kanton
time zone. (#10679)Display
Physical input read time
using most succinct time unit inEXPLAIN ANALYZE VERBOSE
. (#10576)Fine tune request retry mechanism in HTTP event listener. (#10566)
Add support for using PostgreSQL and Oracle as backend database for resource groups. (#9812)
Remove unnecessary spilling configuration properties
spill-order-by
andspill-window-operator
. (#10591)Remove distinction between system and user memory to simplify cluster configuration. The configuration property
query.max-total-memory-per-node
is removed. Usequery.max-memory-per-node
instead. (#10574)Use formatting specified in the SQL standard when casting
double
andreal
values tovarchar
type. (#552)Add support for
ALTER MATERIALIZED VIEW ... SET PROPERTIES
. (#9613)Add experimental implementation of task level retries. This can be enabled by setting the
retry-policy
configuration property or theretry_policy
session property totask
. (#9818)Improve query wall time by splitting workload between nodes in a more balanced way. Previous workload balancing policy can be restored via
node-scheduler.splits-balancing-policy=node
. (#10660)Prevent hanging query execution on failures with
phased
execution policy. (#10656)Catch overflow in decimal multiplication. (#10732)
Fix
UnsupportedOperationException
inmax_by
andmin_by
aggregation. (#10599)Fix incorrect results or failure when casting date to
varchar(n)
type. (#552)Fix issue where the length of log file names grow indefinitely upon log rotation. (#10738)
Security#
Allow extracting groups from OAuth2 claims from
http-server.authentication.oauth2.groups-field
. (#10262)
JDBC driver#
BigQuery connector#
ClickHouse connector#
Upgrade minimum required version to 21.3. (#10703)
Add support for renaming schemas. (#10558)
Add support for setting column comments. (#10641)
Map ClickHouse
ipv4
andipv6
types to Trinoipaddress
type. (#7098)Allow mapping ClickHouse
fixedstring
orstring
as Trinovarchar
via themap_string_as_varchar
session property. (#10601)Disable
avg
pushdown ondecimal
types to avoid incorrect results. (#10650)Fix spurious errors when metadata cache is enabled. (#10544, #10512)
Druid connector#
Hive connector#
Add support for writing Bloom filters in ORC files. (#3939)
Allow flushing the metadata cache for specific schemas, tables, or partitions with the flush_metadata_cache system procedure. (#10385)
Add support for long lived AWS Security Token Service (STS) credentials for authentication with Glue catalog. (#10735)
Ensure transaction locks in the Hive Metastore are released in case of query failure when querying Hive ACID tables. (#10401)
Disallow reading from Iceberg tables when redirects from Hive to Iceberg are not enabled. (#8693, #10441)
Improve performance of queries using range predicates when reading ORC files with Bloom filters. (#4108)
Support writing Parquet files greater than 2GB. (#10722)
Fix spurious errors when metadata cache is enabled. (#10646, #10512)
Prevent data loss during
DROP SCHEMA
when the schema location contains files that are not part of existing tables. (#10485)Fix inserting into transactional table when
task_writer_count
> 1. (#9149)Fix possible data corruption when writing data to S3 with streaming enabled. (#10710)
Iceberg connector#
Add
$properties
system table which can be queried to inspect Iceberg table properties. (#10480)Add support for
ALTER TABLE .. EXECUTE OPTIMIZE
statement. (#10497)Respect Iceberg column metrics mode when writing. (#9938)
Add support for long lived AWS Security Token Service (STS) credentials for authentication with Glue catalog. (#10735)
Improve performance of queries using range predicates when reading ORC files with Bloom filters. (#4108)
Improve select query planning performance after write operations from Trino. (#9340)
Ensure table statistics are accumulated in a deterministic way from Iceberg column metrics. (#9716)
Prevent data loss during
DROP SCHEMA
when the schema location contains files that are not part of existing tables. (#10485)Support writing Parquet files greater than 2GB. (#10722)
Fix materialized view refresh when view a query references the same table multiple times. (#10570)
Fix possible data corruption when writing data to S3 with streaming enabled. (#10710)
MySQL connector#
Oracle connector#
Phoenix connector#
Pinot connector#
Add support for basic authentication. (#9531)
PostgreSQL connector#
Add support for renaming schemas. (#8939)
Fix spurious errors when metadata cache is enabled. (#10544, #10512)
Redshift connector#
Add support for renaming schemas. (#8939)
Fix spurious errors when metadata cache is enabled. (#10544, #10512)
SingleStore (MemSQL) connector#
SQL Server connector#
SPI#
Remove support for the
ConnectorMetadata.getTableLayout()
API. (#781)