Skip to main content

Release 469 (27 Jan 2025)

General​

  • Add support for the FIRST, AFTER, and LAST clauses to ALTER TABLE ... ADD COLUMN. (#20091)
  • Add the ST_GeomFromKML() function. (#24297)
  • Allow configuring the spooling client protocol behaviour with session properties. (#24655, #24757)
  • Improve stability of the cluster under load. (#24572)
  • Prevent planning failures resulting from join pushdown for modified tables. (#24447)
  • Fix parsing of negative hexadecimal, octal, and binary numeric literals. (#24601)
  • Fix failures with recursive delete operations on S3Express preventing usage for fault-tolerant execution. (#24763)

Web UI​

  • Add support for filtering queries by client tags. (#24494)

JDBC driver​

  • Add planningTimeMillis, analysisTimeMillis, finishingTimeMillis, physicalInputBytes, physicalWrittenBytes, internalNetworkInputBytes and physicalInputTimeMillis to io.trino.jdbc.QueryStats. (#24571, #24604)
  • Improve the Connection.isValid(int) method so it validates the connection and credentials, and add the validateConnection connection property. (#24127, #22684)
  • Prevent failures when using the spooling protocol with a cluster using its own certificate chain. (#24595)
  • Fix deserialization failures with SetDigest, BingTile, and Color types. (#24612)

CLI​

  • Prevent failures when using the spooling protocol with a cluster using its own certificate chain. (#24595)
  • Fix deserialization of SetDigest, BingTile, and Color types. (#24612)

BigQuery connector​

  • Allow configuration of the channel pool for gRPC communication with BigQuery. (#24638)

ClickHouse connector​

Delta Lake connector​

  • Add support for SSE-C in S3 security mapping. (#24566)
  • Allow configuring the endpoint for the Google Storage file system with the gcs.endpoint property. (#24626)
  • Improve performance of reading from new Delta Lake table data by compressing files with ZSTD by default, instead of the previous SNAPPY. (#17426)
  • Improve performance of queries on tables with large transaction log JSON files. (#24491)
  • Improve performance of reading from Parquet files with a large number of row groups. (#24618)
  • Improve performance for the OPTIMIZE statement by enabling concurrent execution. (#16985)
  • Improve performance of reading from large files on S3. (#24521)
  • Correct catalog information in JMX metrics when using file system caching with multiple catalogs. (#24510)
  • Fix table read failures when using the Alluxio file system. (#23815)
  • Fix incorrect results when updating tables with deletion vectors enabled. (#24648)
  • Fix incorrect results when reading from tables with deletion vectors enabled. (#22972)

Elasticsearch connector​

  • Improve performance of queries that reference nested fields from Elasticsearch documents. (#23069)

Faker connector​

  • Add support for views. (#24242)
  • Support generating sequences. (#24590)
  • ⚠️ Breaking change: Replace specifying constraints using WHERE clauses with the min, max, and options column properties. (#24147)

Hive connector​

  • Add support for SSE-C in S3 security mapping. (#24566)
  • Allow configuring the endpoint for the Google Storage file system with the gcs.endpoint property. (#24626)
  • Split AWS SDK client retry count metrics into separate client-level, logical retries and lower-level HTTP client retries. (#24606)
  • Improve performance of reading from Parquet files with a large number of row groups. (#24618)
  • Improve performance of reading from large files on S3. (#24521)
  • Correct catalog information in JMX metrics when using file system caching with multiple catalogs. (#24510)
  • Fix table read failures when using the Alluxio file system. (#23815)
  • Prevent writing of invalid data for NaN, Infinity, -Infinity values to JSON files. (#24558)

Hudi connector​

  • Add support for SSE-C in S3 security mapping. (#24566)
  • Allow configuring the endpoint for the Google Storage file system with the gcs.endpoint property. (#24626)
  • Improve performance of reading from Parquet files with a large number of row groups. (#24618)
  • Improve performance of reading from large files on S3. (#24521)

Iceberg connector​

  • Add support for the FIRST, AFTER, and LAST clauses to ALTER TABLE ... ADD COLUMN. (#20091)
  • Add support for SSE-C in S3 security mapping. (#24566)
  • Allow configuring the endpoint for the Google Storage file system with the gcs.endpoint property. (#24626)
  • Add $entries metadata table. (#24172)
  • Add $all_entries metadata table. (#24543)
  • Allow configuring the parquet_bloom_filter_columns table property. (#24573)
  • Allow configuring the orc_bloom_filter_columns table property. (#24584)
  • Add the rollback_to_snapshot table procedure. The existing system.rollback_to_snapshot procedure is deprecated. (#24580)
  • Improve performance when listing columns. (#23909)
  • Improve performance of reading from Parquet files with a large number of row groups. (#24618)
  • Improve performance of reading from large files on S3. (#24521)
  • Remove the oldest tracked version metadata files when write.metadata.delete-after-commit.enabled is set to true. (#19582)
  • Correct catalog information in JMX metrics when using file system caching with multiple catalogs. (#24510)
  • Fix table read failures when using the Alluxio file system. (#23815)
  • Prevent return of incomplete results by the table_changes table function. (#24709)
  • Prevent failures on queries accessing tables with multiple nested partition columns. (#24628)

Ignite connector​

  • Add support for MERGE statements. (#24443)
  • Fix failure when updating values to NULL. (#24204)

Kudu connector​

  • Add support for unpartitioned tables. (#24661)

MariaDB connector​

  • Add support for the FIRST, AFTER, and LAST clauses to ALTER TABLE ... ADD COLUMN. (#24735)
  • Fix failure when updating values to NULL. (#24204)

MySQL connector​

  • Add support for the FIRST, AFTER, and LAST clauses to ALTER TABLE ... ADD COLUMN. (#24735)
  • Fix failure when updating values to NULL. (#24204)

Oracle connector​

  • Fix failure when updating values to NULL. (#24204)

Phoenix connector​

  • Allow configuring scan page timeout with the phoenix.server-scan-page-timeout configuration property. (#24689)
  • Fix failure when updating values to NULL. (#24204)

PostgreSQL connector​

  • Fix failure when updating values to NULL. (#24204)

Redshift connector​

  • Improve performance of reading from Redshift tables. (#24117)
  • Fix failure when updating values to NULL. (#24204)

SingleStore connector​

  • Fix failure when updating values to NULL. (#24204)

Snowflake connector​

  • Fix failure when updating values to NULL. (#24204)

SQL Server connector​

  • Fix failure when updating values to NULL. (#24204)

Vertica connector​

  • Fix failure when updating values to NULL. (#24204)

SPI​

  • Remove support for connector-level event listeners and the related Connector.getEventListeners() method. (#24609)