Release 477 (24 Sep 2025)#

General#

  • Add Lakehouse connector. (#25347)

  • Add support for ALTER MATERIALIZED VIEW ... SET AUTHORIZATION. (#25910)

  • Add support for default column values when creating tables or adding new columns. (#25679)

  • Add support for ALTER VIEW ... REFRESH. (#25906)

  • Add support for managing and querying table branches. (#25751, #26300, #26136)

  • Add the cosine_distance() function for sparse vectors. (#24027)

  • ⚠️ Breaking change: Improve precision and scale inference for arithmetic operations with decimal values. The previous behavior can be restored by setting the deprecated.legacy-arithmetic-decimal-operators config property to true. (#26422)

  • ⚠️ Breaking change: Remove the HTTP server event listener plugin from the server binary distribution and the Docker container. (#25967)

  • ⚠️ Breaking change: Enforce requirement for catalogs to be deployed in all nodes. (#26063)

  • Add query.max-write-physical-size configuration property and query_max_write_physical_size session property to allow configuring limits on the amount of data written by a query. (#25955)

  • Add system.metadata.tables_authorization, system.metadata.schemas_authorization, system.metadata.functions_authorization tables that expose the information about the authorization for given entities. (#25907)

  • Add physical data scan tracking to resource groups. (#25003)

  • Add internal_network_input_bytes column to system.runtime.tasks table. (#26524)

  • Add support for Geometry type in to_geojson_geometry(). (#26451)

  • Remove raw_input_bytes and raw_input_rows columns from system.runtime.tasks table. (#26524)

  • Do not include catalogs that failed to load in system.metadata.catalogs. (#26493)

  • Simplify node discovery configuration for Kubernetes-like environments that provide DNS names for all workers when the discovery.type config property is set to dns. (#26119)

  • Improve memory usage for certain queries involving row_number(), rank(), dense_rank(), and ORDER BY ... LIMIT. (#25946)

  • Improve memory usage for queries involving GROUP BY. (#25879)

  • Reduce memory required for queries containing aggregations with a DISTINCT or ORDER BY clause. (#26276)

  • Improve performance of simple queries in clusters with small number of nodes. (#26525)

  • Improve cluster stability when querying slow data sources and queries terminate early or are cancelled. (#26602)

  • Improve join and aggregation reliability when spilling. (#25892, #25976)

  • Ensure spill files are cleaned up for queries involving GROUP BY. (#26141)

  • Reduce out-of-memory errors for queries involving joins. (#26142)

  • Fix incorrect results for queries involving GROUP BY when spilling is enabled. (#25892)

  • Fix failure when aggregation exists in other expressions in GROUP BY AUTO. (#25987)

  • Fix incorrect results for queries involving joins using ST_Contains(), ST_Intersects(), and ST_Distance() functions. (#26021)

  • Fix out-of-memory failures when the client spooling protocol is enabled. (#25999)

  • Fix worker crashes due to JVM out-of-memory errors when running GROUP BY queries with aggregations containing an ORDER BY clause. (#26276)

  • Fix incorrectly ignored grant when access is granted through groups via SET SESSION AUTHORIZATION. (#26344)

  • Fix incorrect results for geometry_to_bing_tiles, where the tiles wouldn’t cover the full geometry area. (#26459)

  • Fix over-reporting the amount of memory used when aggregating over ROW values when nested inside of an ARRAY type (#26405)

  • Improve accounting of physical input metrics in output of EXPLAIN ANALYZE. (#26637)

Web UI#

CLI#

  • Add support for keyboard navigation with Alt+↑ or Alt+↓ in query history. (#26138)

Delta Lake connector#

  • Add support for using GCS without credentials. (#25810)

  • Rename s3.socket-read-timeout config property to s3.socket-timeout. (#26263)

  • Add metrics for data read from filesystem cache in EXPLAIN ANALYZE VERBOSE output. (#26342)

  • Improve resource utilization when using Alluxio. (#26121)

  • Improve resource utilization by releasing native filesystem resources as soon as possible. (#26085)

  • Improve throughput for write-heavy queries on Azure when the azure.multipart-write-enabled config option is set to true. (#26225)

  • Reduce query failures due to S3 throttling. (#26407)

  • Avoid worker crashes due to out-of-memory errors when decoding unusually large Parquet footers. (#25973)

  • Fix incorrect results when reading from Parquet files produced by old versions of PyArrow. (#26058)

  • Fix writing malformed checkpoint files when deletion vector is enabled. (#26145)

  • Fix failure when reading tables that contain null values in variant columns. (#26016, #26184)

  • Fix incorrect results when reading decimal numbers from Parquet files and the declared precision differs from the precision described in the Parquet metadata. (#26203)

  • Fix incorrect results when a table uses deletion vector and its partition path contains special characters. (#26299)

Exasol connector#

  • Add support for Exasol hashtype type. (#26512)

  • Improve performance for queries involving LIMIT. (#26592)

Hive connector#

  • Add support for using GCS without credentials. (#25810)

  • Add support for reading tables using the Esri JSON format. (#25241)

  • Add support for extended_boolean_literal in text-file formats. (#21156)

  • Add metrics for data read from filesystem cache in EXPLAIN ANALYZE VERBOSE output. (#26342)

  • Add support for Twitter Elephantbird protobuf deserialization. (#26305)

  • Rename s3.socket-read-timeout config property to s3.socket-timeout. (#26263)

  • Improve throughput for write-heavy queries on Azure when the azure.multipart-write-enabled config option is set to true. (#26225)

  • Reduce query failures due to S3 throttling. (#26407)

  • Avoid worker crashes due to out-of-memory errors when decoding unusually large Parquet footers. (#25973)

  • Improve resource utilization when using Alluxio. (#26121)

  • Fix incorrect results when reading from Parquet files produced by old versions of PyArrow. (#26058)

  • Fix reading partition_projection_format column property for date partition projection. (#25642)

  • Fix incorrect results when reading decimal numbers from Parquet files and the declared precision differs from the precision described in the Parquet metadata. (#26203)

  • Fix physical input read time metric for tables containing text files. (#26612)

  • Add support for reading Hive OpenCSV tables with quoting and escaping disabled. (#26619)

HTTP Event Listener#

  • Add support for configuring the HTTP method to use via the http-event-listener.connect-http-method config property. (#26181)

Hudi connector#

  • Add support for configuring batch size for reads on Parquet files using the parquet.max-read-block-row-count configuration property or the parquet_max_read_block_row_count session property. (#25981)

  • Add support for using GCS without credentials. (#25810)

  • Rename s3.socket-read-timeout config property to s3.socket-timeout. (#26263)

  • Improve resource utilization when using Alluxio. (#26121)

  • Improve throughput for write-heavy queries on Azure when the azure.multipart-write-enabled config option is set to true. (#26225)

  • Reduce query failures due to S3 throttling. (#26407)

  • Avoid worker crashes due to out-of-memory errors when decoding unusually large Parquet footers. (#25973)

  • Fix incorrect results when reading from Parquet files produced by old versions of PyArrow. (#26058)

  • Fix incorrect results when reading decimal numbers from Parquet files and the declared precision differs from the precision described in the Parquet metadata. (#26203)

Iceberg connector#

  • Add support for SIGV4 as an independent authentication scheme. It can be enabled by setting the iceberg.rest-catalog.security config property to SIGV4. The iceberg.rest-catalog.sigv4-enabled config property is no longer supported. (#26218)

  • Add support for using GCS without credentials. (#25810)

  • Allow configuring the compression codec to use for reading a table via the compression_codec table property. The compression_codec session is no longer supported. (#25755)

  • Add metrics for data read from filesystem cache in EXPLAIN ANALYZE VERBOSE output. (#26342)

  • Rename s3.socket-read-timeout config property to s3.socket-timeout. (#26263)

  • Improve performance of expire_snapshots procedure. (#26230)

  • Improve performance of remove_orphan_files procedure. (#26326, #26438)

  • Improve performance of queries on $files metadata table. (#25677)

  • Improve performance of writes to Iceberg tables when task retries are enabled. (#26620)

  • Reduce memory usage of remove_orphan_files procedure. (#25847)

  • Improve throughput for write-heavy queries on Azure when the azure.multipart-write-enabled config option is set to true. (#26225)

  • Reduce query failures due to S3 throttling. (#26407, #26432)

  • Avoid worker crashes due to out-of-memory errors when decoding unusually large Parquet footers. (#25973)

  • Improve resource utilization when using Alluxio. (#26121)

  • Reduce amount of metadata generated in writes to Iceberg tables. (#15439)

  • Fix performance regression and potential query failures for REFRESH MATERIALIZED VIEW. (#26051)

  • Fix incorrect results when reading from Parquet files produced by old versions of PyArrow. (#26058)

  • Fix failure for optimize_manifests procedure when top-level partition columns contain null values. (#26185)

  • Fix incorrect results when reading decimal numbers from Parquet files and the declared precision differs from the precision described in the Parquet metadata. (#26203)

  • Fix coordinator out-of-memory failures when running OPTIMIZE_MANIFESTS on partitioned tables. (#26323)

Kafka Event Listener#

  • Add support for configuring the max request size with the kafka-event-listener.max-request-size config property. (#26129)

  • Add support for configuring the batch size with the kafka-event-listener.batch-size config property. (#26129)

Memory connector#

  • Add support for default column values. (#25679)

  • Add support for ALTER VIEW ... REFRESH. (#25906)

MongoDB connector#

  • Fix failure when reading array type with different element types. (#26585)

MySQL Event Listener#

  • Ignore startup failure if mysql-event-listener.terminate-on-initialization-failure is disabled. (#26252)

OpenLineage Event Listener#

  • Add user identifying fields to the OpenLineage trino_query_context facet. (#26074)

  • Add query_id field to trino_metadata facet. (#26074)

  • Allow customizing the job facet name with the openlineage-event-listener.job.name-format config property. (#25535)

PostgreSQL connector#

  • Add support for geometry types when PostGIS is installed in schemas other than public. (#25972)

SPI#

  • Remove ConnectorSession from Type.getObjectValue. (#25945)

  • Remove unused NodeManager.getEnvironment method. (#26096)

  • Remove @Experimental annotation. (#26200)

  • Remove deprecated ConnectorPageSource.getNextPage method. (#26222)

  • Remove support for EventListener#splitCompleted. (#26436) and ConnectorMetadata.refreshMaterializedView. (#26455)

  • Remove unused CatalogHandle class. (#26520)

  • Change the signature of ConnectorMetadata.beginRefreshMaterializedView and ConnectorMetadata.finishRefreshMaterializedView. Table handles for other catalogs are no longer passed to these methods. (#26454)

  • Deprecate NodeManager.getCurrentNode in favor of ConnectorContext.getCurrentNode. (#26096)

  • Deprecate ConnectorMetadata.delegateMaterializedViewRefreshToConnector. (#26455)

  • Remove totalBytes and totalRows from io.trino.spi.eventlistener.QueryStatistics. (#26524)