Release notes for 362

[martint]

Ashhar Hasan

• [x] all checked
• 08-28 22:50:33 89e61ecbfa Fix failing test due to missing comma
• 08-31 04:50:54 60e0337380 Remove obsolete test
• 08-31 04:50:54 ab46771504 Fix comment to mention memory connector instead of Cassandra
• 08-31 04:50:54 b7f4c81728 Change assertions to explicitly check for existence of table
• 09-01 12:17:45 01d38b2b92 Apply overrides from provided config when running SuiteDescribe
• 09-03 11:52:02 00281a3b1b Add SQL support section to TPC-DS connector
• 09-03 11:54:28 90f628659e Move SQL support section
• 09-03 11:54:28 d254b7f643 Correct scope of memory release
• 09-07 23:03:37 41e596a5a1 Add SQL support section to Kudu connector
• 09-07 23:06:57 5d43d97396 Document setdigest type
• 09-08 23:24:08 856331ff9e Revise async and read-through caching
• 09-09 09:44:51 b065b01559 Fix in clause handling in filter pushdown
• 09-09 11:42:35 bd4ca21f48 Minor cleanup to MemSQL query runner
• 09-09 11:42:35 c492daa585 Add main method to MemSQL query runner
• 09-09 21:36:11 11627c8b2f Fix connection name example and link to Oracle docs
• 09-09 22:39:58 108e733e56 Fix typo in PinotColumn error message
• 09-09 22:39:58 5d2631aeca Remove unused variables and functions from DynamicTableBuilder
• 09-09 22:39:58 ad7d903b8d Fixed mismatched schema names
• 09-09 22:39:58 c1cfbcb722 Fix realtime spec for alltypes table
• 09-09 23:17:33 16765453b6 Fix decoding infinite double values in Pinot
• 09-09 23:17:33 4ca11122ce Add support for pushdown of varbinary filters to Pinot
• 09-09 23:17:33 f124f10497 Fix decoding infinite real values in Pinot
• 09-10 09:31:54 2baea31697 Remove ineffective cleanup step
• 09-10 09:31:54 fd7fa04498 Upload test results as artifacts
• 09-10 09:57:37 29ac28cc48 Set updated_at to a recent value to prevent expiration by Pinot

  Dain Sundstrom

• [x] all checked
• 09-01 19:46:48 0c43e246e0 Use Optional instead of nullable in SessionContext
• 09-01 19:46:48 13b8f60c7c Remove redundant "in this catalog" from ConnectorAccessControl docs
• 09-01 19:46:48 16c528148b Add MetadataUtil.getRequiredCatalogHandle
• 09-01 19:46:48 2d3251d32f Split HttpRequestSessionContext into factory and instance
• 09-01 19:46:48 3641ca1baf Automatically add admin role to file based metastore
• 09-01 19:46:48 3cb2db9dc2 Cleanup CreateSchemaTask
• 09-01 19:46:48 3e2bd90d0c Add metadata role exists method
• 09-01 19:46:48 411ad8049d Remove catalog argument to ConnectorAccessControl methods
• 09-01 19:46:48 5ce1ae7e9f Convert SessionContext to a class
• 09-01 19:46:48 8c91ae84c7 Fix synchronization in TestWebUi
• 09-01 19:46:48 ce1eb14c12 Fix SetSchemaAuthorizationTask role validation
• 09-01 19:46:48 f386df0919 Add checkRoleExists helper method
• 09-01 20:08:58 48ec9f3665 Add Hive target max file size
• 09-02 13:36:33 e0a1f320fd Document hive.target-max-file-size configuration
• 09-03 18:26:36 230f1c6ca4 Extract abstract super class for TestHiveRoles
• 09-03 18:26:36 4b2565a98d Only send security metadata calls to connectors with an access control
• 09-03 18:26:36 56abe82113 Add optional catalog declaration to role management statements
• 09-03 18:26:36 754b6b0945 Update documentation for role management commands
• 09-03 18:26:36 7da3c1a42f Add SystemSecurityMetadata for management of system grants
• 09-03 18:26:36 868fed9990 Add role to file based system access control
• 09-03 18:26:36 9b65a9ecd7 Add system access control checks for global role management
• 09-03 18:26:36 b7c34f4b76 Add support for global role management
• 09-03 18:26:36 c4782ed7c2 Add enabled system roles to Identity
• 09-03 18:26:36 cf3b571be1 Fix output of revoke role statement
• 09-03 18:26:36 fdeec92683 Rename roles to connectorRoles in Identity
• 09-06 12:37:18 68a01e321d Fix warnings in TpchMetadata
• 09-06 12:37:18 9b6cf0cdfa Add config option to map TPCH doubles as SQL decimal

  David Phillips

• [x] all checked
• 08-30 14:32:00 b03065e86b Remove bogus INVALID_COLUMN_NAME error code
• 08-31 17:59:06 627029c60a Add documentation for additional Hive Views
• 09-03 08:50:36 3192f3604a Add query error info to cluster overview page in web UI
• 09-08 11:13:50 253a6b00bd Minor formatting improvements for grammar
• 09-08 23:19:53 710b7e043b Add toString method to PropertyMetadata
• 09-08 23:24:19 bb06a1a2fe Update Maven wrapper to 3.8.2
• 09-09 17:47:39 14a20c46cb Move top level markdown files
• 09-09 17:55:16 945d4c3195 Update to Avro 1.10.2
• 09-09 17:56:44 0b9764347d Correct connection string examples
• 09-09 17:59:34 854c72271d Update to ANTLR 4.9.2 and Jdbi 3.21.0
• 09-10 10:38:23 e0f399830c Add SQL support section to Thrift connector
• 09-10 10:43:17 1fe0f3efa6 Add SQL support section to Phoenix connector
• 09-10 10:56:39 f687bac777 Add Predicate and Column Projection Pushdown Section
• 09-10 11:08:51 0b74aced3d Add note about no Java 17 support
• 09-13 11:58:29 2e0f3b8985 Add SQL support section
• 09-14 13:43:39 d3a6c2a91d Move bin/ptl to testing directory
• 09-16 10:15:44 53d1cdfd82 Add table of contents for DEVELOPMENT
• 09-16 10:15:44 5f501c155f Clarify multiple commits in a PR
• 09-16 10:15:44 d0df4751a2 Create commits and pull requests section
• 09-16 10:47:10 905f0334c4 Only support single statement writes by default

  GitHub

• [x] all checked
• 09-09 17:58:58 1cd649ac6b Change Trino RPM architecture to noarch

  Grzegorz Kokosiński

• [x] all checked
• 08-30 01:03:59 0e8a992de7 Mock more functionalities in MockConnector
• 08-31 04:38:42 3900829b74 Update airbase to 112
• 08-31 07:42:07 3532ff9af1 Allow to override default system access control
• 09-01 22:27:57 f6b1e7e03c Accept that transaction is cancelled early in TestJdbcConnection
• 09-02 04:02:38 705023c829 Use configureTempto instead CONTAINER_TEMPTO_PROFILE_CONFIG
• 09-02 04:02:38 7c410a5c2d Extract configureTempto utility method
• 09-02 04:02:38 be32a751c3 Deprecate CONTAINER_TEMPTO_PROFILE_CONFIG
• 09-02 04:27:09 6cd93328fd Make IdentityCacheMapping accept ConnectorSession
• 09-02 04:37:41 18814a3adf Restore default system access control
• 09-03 05:30:16 3774afbebc Use URLS_SELF_ISSUER value for oauth2.issuer

  Karol Sobczak

• [ ] all checked
• 08-31 02:01:00 a79829fdac Fix incorrect currentProbePositionProducedRow value for inner join
• 09-01 00:53:40 a762fdd0a6 Remove transitionToRunning on Stage schedulingComplete()
• 09-01 01:33:40 b838333757 Improve JoinProbe
• 09-01 01:33:40 bdec9257ae Use blockBuilders.length in PageBuilder#reset()
• 09-01 01:33:40 cc622f9b25 Improve LookupJoinPageBuilder
• 09-01 12:09:46 ef10932139 Doc remove keyword sorted of window function
• 09-01 14:03:06 8d8466b9cd Introduce RowPagesBuilder#getHashChannels method and use it in tests
• 09-02 03:56:34 1fffa571cf Do not use LocalPartitionGenerator
• 09-02 03:56:34 5c65f483fe Add createRandomLongsBlock using limited number of unique values
• 09-02 03:56:34 9e4728d764 Make HashBucketFunction public and extract as top level class
• 09-02 03:56:34 a43fdbedb4 Fix hash computation bug
• 09-02 03:56:34 be88e21d90 Add more cases to BenchmarkPartitionedOutputOperator
• 09-06 02:24:51 17864424b9 Fix formatting
• 09-06 02:24:51 2b8387d0c8 Do not set stats that are not propagated for nested operators
• 09-06 02:24:51 398225762d Mark OperatorContext#getOperatorStats as private
• 09-06 02:24:51 5a9617b544 Move private method below public
• 09-06 03:25:38 15c9c5319b Optimize MarkDistinctHash for faster distinct mask creation
• 09-06 03:25:38 a673343e70 Add direct block construction helpers to BooleanType
• 09-06 13:17:29 6bd61727b2 Improve HashGenerator.getPartition performance
• 09-07 02:50:05 826558ac49 Prevent NPE when getting freshness of non-existent materialized view
• 09-07 02:50:05 a14b9ac153 Remove unthrown exception declaration from Javadoc
• 09-07 02:50:05 fff485a145 Skip displaying materialized views with missing freshness
• 09-07 03:43:44 83a62fd0e1 Produce better hash for short decimal type
• 09-07 09:27:04 c059cda3de Allow for operators to define custom metrics
• 09-07 09:27:04 d3a3054634 Rename connector metrics to metrics
• 09-10 02:51:26 ca8e71eaee Extract OperatorStats#connectorMetrics

  Martin Traverso

• [ ] all checked
• 08-31 14:30:00 c4f08c7178 Update to aircompressor 0.21
• 09-07 10:08:10 c3ff961b67 Improve Block#getLoadedBlock() and Page#getLoadedPage()
• 09-08 11:16:56 4c321a97d1 Support string joining in SQL via LISTAGG clause
• 09-08 11:59:43 639020cdb3 Add benchmarkHashPosition to BenchmarkGroupByHash
• 09-08 11:59:43 8de73806dd Add positional only utility for InterpretedHashGenerator creation
• 09-09 10:16:05 abc2d24f61 Remove totalPartitions from TaskContext
• 09-10 13:35:40 fce0521b42 Speed up construction of parquet predicate from dictionary

  Piotr Findeisen

• [x] all checked
• 08-30 08:57:21 8ab3573d74 Report actual rows when returnsEmptyResult assertion fails
• 08-30 08:57:21 94217dbed4 Rename base test class to match current convention
• 08-31 09:25:18 031fbbe323 Fix testMaterializedViewsMetadata flakiness due to lack of pruning
• 08-31 09:25:18 40a49374aa Fix test table name
• 08-31 09:25:18 8a27c4c71d Fix type of expected values
• 09-01 02:24:10 e7181f4d62 Remove useless todo list for residual expression
• 09-02 02:14:51 15a0ff379e Fix indentation
• 09-02 02:14:51 329c48d5c7 Convert deprecation comment into a javadoc
• 09-02 02:14:51 57594b87fe Remove redundant SinglenodeSparkIceberg configuration
• 09-02 02:14:51 b9df5b6e93 Test Iceberg schema top-level evolution
• 09-02 03:24:17 0ee1ad4aa4 Enforce naming convention for PTL configs
• 09-02 03:24:17 1b6bac7d56 Apply static imports consistently
• 09-02 03:24:17 2acfcc6a48 Enforce naming convention for PTL suites
• 09-02 03:24:17 86bc379ae5 Test suite name generation
• 09-02 03:24:17 90797aea6e Rename utility methods
• 09-02 03:24:17 ac7629dcb4 Split Environments utility class
• 09-03 01:03:51 00626a4df9 Split environment and config name canonicalization
• 09-03 01:03:51 823540bbd3 Update environment names to naming convention
• 09-03 01:03:51 b42a30f824 Introduce naming convention for PTL environments
• 09-03 01:03:51 eb5730767a Update environment name canonicalization tests
• 09-07 02:14:59 d47be23f97 Retain commit's failure when rollback fails
• 09-07 02:15:23 92c6cfe011 Move Hive tests's configs out of product tests
• 09-07 08:04:43 09dc0bf830 Add dereference pushdown smoke test coverage
• 09-07 08:04:43 0d0fd3bfc0 Use ID-based mapping for struct fields in Iceberg Parquet reader
• 09-07 08:04:43 a74fd535d3 Split ParquetColumnIOConverter for Hive and Iceberg
• 09-07 08:04:43 d3e22e0d21 Code cleanup in ParquetColumnIOConverter
• 09-07 08:04:43 ef5d9d1174 Fix missing defensive copy in ColumnIdentity constructor
• 09-07 08:12:57 1a71ec53f6 Test Snappy-compressed Parquet table created in Trino
• 09-07 08:12:57 3cd36e3476 Move Parquet Snappy test to different class
• 09-07 08:12:57 beef4385b3 Add Hive compression_codec integration test for all formats
• 09-08 06:34:04 0bd01d84e9 Include actually set properties in exception message
• 09-08 06:34:04 8f89f04dc6 Exercise optimized Parquet writer in Hive connector test
• 09-08 06:34:04 b3cfc0dd66 Exercise optimized Parquet writer in Hive compression product test
• 09-08 06:34:04 b3fcd966e6 Reject unexpected type in some date/time column readers
• 09-08 06:34:04 c84a413098 Read INT64 Parquet timestamp into timestamp(9) column
• 09-08 06:48:45 6349e6a44f Mark hive views testNestedGroupBy test as @Flaky
• 09-08 06:49:09 ad1a432c91 Bump snappy-java version
• 09-09 23:55:54 b5ef0c9d84 Reorder parquet_use_column_index in HiveSessionProperties
• 09-10 02:11:54 31dbbdb744 Improve explanatory comment in test
• 09-10 02:11:54 3611b0cdd1 Test Hive connector with Spark-created Parquet table
• 09-10 02:11:54 66b7658fe3 Rename hive_spark_bucketing test group to hive_spark

  Pratham

• [x] all checked
• 08-30 18:01:03 6f1297f3fc Fix issue with querying Iceberg using a structural type predicate

  Praveen Krishna

• [ ] all checked
• 09-02 22:47:04 659bf66f2d Use static import for BucketingType
• 09-02 22:47:04 8f5aa1cbca Treat table as unbucketed if bucketed on unsupported data type

  Yuya Ebihara

• [x] all checked
• 08-28 18:46:42 6883ebd8d1 Add SQL support section to Redis connector
• 08-28 18:48:43 778eb841e8 Add SQL support section to Prometheus connector
• 08-29 18:33:58 95d5f468ac Add SQL support section to Cassandra connector
• 08-30 04:16:18 9024438441 Fix query failure of predicate pushdown to BigQuery DATETIME type
• 08-30 08:47:54 1fc3ddc801 Append semicolons in DESCRIBE OUTPUT example
• 08-31 18:05:45 46b37aa41b Add SQL support section to Elasticsearch
• 08-31 21:26:35 14c4eb08ad Add SQL support section to Pinot connector
• 08-31 23:37:51 1c3807d506 Fix wrong result of BigQuery parameterized NUMERIC type
• 08-31 23:37:51 4a02a181bf Upgrade errorprone to version 2.9.0
• 09-01 21:55:48 3acb4469d3 Skip unsupported type in BigQuery connector
• 09-02 23:37:37 193db65de2 Allow using 1 as cassandra.speculative-execution.limit
• 09-05 23:48:09 647b4d4ebf Cast float64 type correctly when predicate pushdown to BigQuery
• 09-06 21:14:05 ad40bd7d65 Make table wider in BigQuery documentation
• 09-06 21:14:05 f72a5904d9 Change date/time precision in BigQuery from 3 to 6
• 09-08 04:13:37 4b45f1a777 Document ARRAY type mapping in BigQuery connector
• 09-08 06:25:00 d3d2ba7328 Delete even non-empty dataset when preparing BigQuery tests
• 09-08 16:11:39 515d41de55 Recreate Oracle container when failed to setup
• 09-09 00:28:15 6d22525e8f Support case insensitive name matching to BigQuery views
• 09-09 00:28:15 7de96aa9f2 Allow setting name prefix in TestView
• 09-09 00:28:15 a5264f7bca Prepend 'remote' to method and variables in BigQuery
• 09-09 00:28:15 b92df3c941 Allow deleting non-empty dataset in BigQuery test

  kasiafi

• [x] all checked
• 08-30 08:02:22 e961325fbf Fix row field names in JSON documentation
• 09-09 23:43:21 10a85b1991 Fix planning of recursive queries with duplicate outputs of partial plan

  Łukasz Osipiuk

• [x] all checked
• 08-31 02:34:57 f947aed8e4 Fix failure query casts varchar to shorter char
• 09-02 13:51:00 25965e9d7b Rename variable
• 09-02 13:51:00 96e7323a1b Drop unnecessary braces
• 09-02 13:51:00 b87165dcf7 Include grouping sets in JdbcTableHandle column list
• 09-02 13:51:00 d55bb1c5a8 Implement count(distinct) pushdown for PostgreSQL
• 09-06 09:20:13 821644483f Fix locking of non-partitioned transactional tables
• 09-09 02:56:47 973e71410c Record JMX metrics for calls made to the Glue statistics API

[ebyhr]

BigQuery
* Fix query failure for predicate pushdown to BigQuery `datetime` type. ({issue}`9005`)

9005

[findepi]

General
* Fix query failure when query contains a cast from `varchar` to a shorter `char`. ({issue}`9036`)

9036 https://github.com/trinodb/trino/pull/9038

[ebyhr]

BigQuery
* Fix incorrect results when using parameterized `numeric` type with non-default precision and scale. ({issue}`9060`)

9060

[sopel39]

General
* Improve join performance. ({issue}`8974`)

https://github.com/trinodb/trino/pull/8974

[dain]

Hive
* Limit maximum file size to 1 GB by default.  The limit is not exact and is performed best effort.  The limit can be set with the `target_max_file_size` session property, or the `hive.target-max-file-size` configuration property. ({issue}`7991`)

7991

[dain]

General
* Fix `ALTER SCHEMA ... SET AUTHORIZATION` to resolve roles using the catalog of the schema instead of the session catalog. ({issue}`9066`)

Hive
* Fix file-based metastore to always add the admin role by default. ({issue}`9066`)

9066

[ebyhr]

BigQuery
* Fix query failure when accessing tables having unsupported type columns. ({issue}`9086`)

9086

[ebyhr]

Cassandra
* Change minimum number of speculative executions from 2 to 1. ({issue}`9096`)

9096

[dain]

Security
* Add `IN catalog` clause to `CREATE ROLE`, `DROP ROLE`, `GRANT ROLE`, `REVOKE ROLE`, and `SET ROLE` to specify the target catalog of the statement instead of using the current session catalog.  This change is necessary to support system roles in the future.  The old behavior of these statements can be restored by setting the `deprecated.legacy-catalog-roles` config property. ({issue}`9087`)

9087

[ebyhr]

BigQuery
* Fix query failure for predicate pushdown to BigQuery `float64` type with `+infinity` or `-infinity` value. ({issue}`9122`)

9122

[sopel39]

General:
* Improve performance of queries that contain `DISTINCT` clause. ({issue}`8967`)

https://github.com/trinodb/trino/pull/8967

[dain]

TPCH
* Add support for switch mapping for floating point values between SQL `DOUBLE` and `DECIMAL` types.  The mapping can be set  the `tpch.double-type-mapping` configuration property. ({issue}`7990`)

7990

[sopel39]

General
* Improve query performance by reducing CPU overhead of repartitioning data across worker nodes. ({issue}`9102`)

https://github.com/trinodb/trino/pull/9102

[ebyhr]

BigQuery
* Chage type mapping of BigQuery `datetime` from `timestamp(3)` to `timestamp(6)` in Trino. ({issue}`9052`)
* Chage type mapping of BigQuery `time` from `time with time zone` to `time(6)` in Trino. ({issue}`9052`)
* Chage type mapping of BigQuery `timestamp` from `timestamp(3) with time zone` to `timestamp(6) with time zone` in Trino. ({issue}`9052`)

9052

[sopel39]

General
* Prevent failure when querying `system.materialized_views` and materialized view is dropped concurrently. ({issue}`9050`)

https://github.com/trinodb/trino/pull/9050

[findepi]

Iceberg
* Fix the mapping of nested fields between table metadata and Parquet file metadata. This 
  enables evolution of `row` typed columns for Iceberg tables stored in Parquet. ({issue}`9124`)

(wording borrowed from 352 notes for similar change for ORC) https://github.com/trinodb/trino/issues/8750 https://github.com/trinodb/trino/pull/9124

[findepi]

Hive
* Fix failure when writing Parquet files with Snappy compression on ARM64. ({issue}`9148`)

https://github.com/trinodb/trino/pull/9148

[martint]

* Add support for {func}`LISTAGG`. ({issue}`4835`)

https://github.com/trinodb/trino/issues/4835

[ebyhr]

BigQuery
* Support case insensitive name matching for BigQuery views. ({issue}`9164`)

9164

[hashhar]

Pinot
* Fix handling of `IN` and `NOT IN` clauses for `VARCHAR` columns in presence of aggregations. ({issue}`9133`)

9133, #9181

[hashhar]

Pinot
* Support pushdown of filters on `VARBINARY` columns to Pinot. ({issue}`9180`)

9180

[kasiafi]

General
* Fix planning of recursive queries when the recursion the base plan or the recursion step plan produce duplicate outputs.

https://github.com/trinodb/trino/pull/9153

[sopel39]

General
* Split metrics that are reported in operator stats into `connectorMetrics` and `metrics`. ({issue}`9156`)

https://github.com/trinodb/trino/pull/9156

[martint]

Hive
* Fix performance regression where reading Parquet files that contain dictionaries. ({issue}`9161`)

https://github.com/trinodb/trino/pull/9161

[Praveen2112]

Hive
* Allow reads on table if they are bucketed on unsupported data type. 

https://github.com/trinodb/trino/pull/8986

[Praveen2112]

Hive
* Optionally specify the schema which enforces that a filter on a partition key be present in the query for its table. This can be specified by setting the 
  ``hive.query-partition-filter-required-schemas`` config property or the ``query_partition_filter_required_schemas`` session property

9106

[kasiafi]

General
* Fix planning failure of INSERT statement when source table has hidden columns. ({issue}`9150`)

https://github.com/trinodb/trino/issues/9150, https://github.com/trinodb/trino/pull/9201

[phd3]

* Iceberg
- Fix failure for queries filtering on columns with array, map, or row type. ({issue}`8822`)

8822

[hashhar]

Pinot
* Fix failure for queries on `REAL` or `DOUBLE` columns having `+Infinity` or `-Infinity` values. ({issue}`9180`)

9180 (2nd and 3rd commits)

[findepi]

Hive
* Support reading Parquet timestamp stored with millisecond or microsecond precision as INT64 with logical type annotations when Hive timestamp precision is `NANOSECONDS`. ({issue}`9139`)
* Support reading Parquet timestamp stored as INT64 with nanosecond precision. ({issue}`9188`)
* Support writing Parquet timestamp stored as INT64 with nanosecond precision when experimental Parquet writer is enabled. 
  To use this, the Hive timestamp precision should be set to `NANOSECONDS`. ({issue}`9188`)

9139 #9188

[kokosing]

Hive
 * Support loading of s3 mappings via http/s url. The `hive.s3.security-mapping.config-file property` can now either point to a local file or a URL. ({issue}`6210`)

6210

[phd3]

* General
- Fix failure when querying `optimizer_rule_stats` system table. ({issue}`8700`)

8700, #9237

[losipiuk]

Hive
 * Fix incorrect table locking in Hive metastore when querying transactional and not partitioned table. ({issue}`9070`)

9070

[losipiuk]

Hive
 * Extend set of statistics reported by JMX to include metrics for calls made to the Glue statistics API. ({issue}`9100`)

9100

[losipiuk]

General
 * Limit number of metadata calls done for particular queries reading from `system.jdbc.columns` where filter on schema name is present. ({issue}`9214`)

9214

(should we mention Metadata API exposed by JDBC driver instead?)

[findepi]

Hive
* Fix `ArrayIndexOutOfBoundsException` when using the experimental Parquet writer. ({issue}`5518`)

Iceberg
* Fix `ArrayIndexOutOfBoundsException` when writing Parquet data. ({issue}`5518`)

5518 #9245

[findepi]

(should we mention Metadata API exposed by JDBC driver instead?)

@losipiuk yes

[martint]

* Fix incorrect results for aggregations that contain `DISTINCT` and `FILTER` clauses. ({issue}`9265`)

https://github.com/trinodb/trino/pull/9265

[martint]

* Improve performance for aggregations that contain a `DISTINCT` clause. ({issue}`9194`)

https://github.com/trinodb/trino/pull/9194

[kasiafi]

General
* Fix incorrect query results when row pattern involves back references. ({issue}`9109`)

https://github.com/trinodb/trino/pull/9109

[phd3]

General
* Fix failure for queries that push projections into the connectors. ({issue}`6200`)

6200, #9185, #9222

[losipiuk]

(should we mention Metadata API exposed by JDBC driver instead?)

@losipiuk yes

https://github.com/trinodb/trino/pull/9216/files#r711073226

[electrum]

## Server RPM

* Change RPM architecture to `noarch` to allow installing on any machine type. ({issue}`9187`)

9187

[electrum]

## Web UI

* Add query error info to cluster overview page. ({issue}`8762`)

8762

[electrum]

## Hive Connector

* Fix reading Avro tables written with older Avro versions that had certain semi-invalid schemas. ({issue}`9114`)

## Iceberg Connector

* Fix query failures caused by errors reading certain Avro metadata files. ({issue}`9114`)

9114

[electrum]

## SPI

* Change `Connector.isSingleStatementWritesOnly()` to return `true` by default. ({issue}`8872`)

8872

[findepi]

Iceberg
* Add support for Iceberg `uuid` type. ({issue}`6663`)

6663 #8747

[losipiuk]

## Hive Connector

* Fix possible `INSERT`/`UPDATE`/`ANALYZE` query failure when Glue metastore is in use and table statistics collection is enabled. ({issue}`9297`)

9297

[martint]

* Fix planning timeout for queries containing `IS NULL`, `AND` and `OR` predicates in the `WHERE` clause. ({issue}`9250`)
* Fix failure for queries containing `ORDER BY ... LIMIT` when columns in the subquery are known to be constant. ({issue}`9171`)

9250, #9171