Release notes for 352

[findepi]

Dain Sundstrom

• all checked
• 01-08 15:31:31 23a57d6 Refactor MemoryRevokingScheduler to avoid redundant work
• 01-08 15:31:31 5b29c2c Add SqlTask#getTaskState() and SqlTask#getTaskCreateTime()
• 01-08 15:31:31 5ca24b0 Fix MemoryRevokingScheduler from re-visiting tasks for the same query
• 01-11 13:22:35 0ecbb75 Use AtomicIntegerFieldUpdater for LocalExchange PageReference
• 01-11 13:22:35 1d2c5d4 Refactor ExchangeClient#pollPage
• 01-11 13:22:35 1db6bc2 Improve LocalExchangeSource locking behaviors
• 01-11 13:22:35 261831b Reduce synchronization in LocalExchangeMemoryManager
• 01-11 13:22:35 74605d0 Add unsynchronized fast paths to reduce contention in ExchangeClient
• 01-11 13:22:35 9537b02 Remove synchronized for final field read in MemoryPool#getMaxBytes()
• 01-11 13:22:35 a04bc4e Cache isBlocked in various operators
• 01-23 12:31:22 27f536f Use assert for ExchangeClient lock holder sanity check
• 01-23 12:31:22 8ba1661 Use assert for HttpPageBufferClient lock holder sanity check
• 01-23 12:31:22 ca05392 Use assert for LocalExchangeSource lock holder sanity check
• 01-23 12:31:22 ddc7a3a Use assert for ClientBuffer lock holder sanity check
• 01-23 12:31:22 eb0f66c Reduce OutputBufferMemoryManager contention
• 01-25 12:13:53 2fde53f Change KdbTreeTree stack type back to Object

David Phillips

• all checked
• 01-04 15:02:16 fda1f32 Fix documentation logo for menu on mobile
• 01-04 17:46:09 3259156 Update logo in README
• 01-05 09:51:20 de1cb66 Use sentence case in titles consistently
• 01-05 14:16:49 24b5e2d Use cause instead of suppressed for OperatorNotFound
• 01-05 16:10:20 d6b76fb Update documentation for ALTER TABLE and CREATE TABLE
• 01-07 11:37:07 f04496a Hive performance properties table replaces presto pr 5845
• 01-07 12:46:58 0360436 Add sections for release per year
• 01-07 21:54:01 fa0f7ce Update to OkHttp 3.14.9
• 01-08 12:06:31 d4751bf Remove outdated comment from TimestampType
• 01-09 21:09:24 d35fe54 Fix missing backtick in Iceberg documentation
• 01-12 12:00:49 01c4740 Require Java 11.0.7 for building
• 01-12 12:01:58 2cbf865 Remove unnecessary code after OkHttp upgrade
• 01-18 08:39:40 a0f8973 Extract AbstractBearerAuthenticator
• 01-18 08:39:40 ad4fde1 Add token polling for query submission authenticator
• 01-19 15:31:39 690d966 Remove "changes" from release note sections
• 01-20 12:36:33 6188c66 Use embedded memory database in Hydra container
• 01-20 12:36:33 dcb6f0b Support Auth Servers with self-signed certificates
• 01-30 19:05:47 6ef6769 Override Accumulo Docker entrypoint for Mac
• 02-03 08:36:35 072ac47 Change Trino to match Hive on column rename/drop/add
• 02-03 14:51:08 86bc2a3 Support SQL UPDATE in the Presto Engine
• 02-03 14:51:08 cf68459 Implement SQL UPDATE for Hive ACID Tables

Grzegorz Kokosiński

• all checked
• 01-04 05:48:18 d091da2 Use dedicated modules for Kafka Schema Registry
• 01-04 12:01:19 0e301f3 Code cleanup
• 01-04 12:01:19 1c07317 Remove Kafka topic creation in tests
• 01-04 12:10:56 36e4042 Add product tests for Kafka Schema Registry and Avro
• 01-04 12:10:56 55ee15f Add javax.ws.rs to Kafka plugin
• 01-04 12:10:56 8877cfa Remove unnecessary topic creations in Kafka product tests
• 01-04 12:10:56 b553802 Use ClassLoaderSafeConnectorMetadata in Kafka
• 01-04 12:10:56 c16bd1b Remove duplication in constants
• 01-04 12:10:56 c614d31 Do not use tempto requirements for Kafka Avro read tests
• 01-04 23:59:09 0b1bcb0 Close testing kafka after query runner
• 01-04 23:59:09 0e114d5 Inline createConfluentProducer methods
• 01-04 23:59:09 15c8d61 Remove debug timestamp test dump
• 01-04 23:59:09 18ac9a5 Update latest Kafka for testing to 6.0.1
• 01-04 23:59:09 1b671df Extract TestingKafka::sendMessages
• 01-04 23:59:09 883c659 Close testing kafka instance after tests
• 01-04 23:59:09 bd1c6ff Fix formatting
• 01-04 23:59:09 c243626 Retry sending kafka message in tests
• 01-04 23:59:09 d140309 Merge TestingKafka classes
• 01-04 23:59:09 e3b40c8 Add logging for testing Kafka dockers
• 01-05 10:54:47 d3a4b68 Mark Kafka Schema Registry flaky tests
• 01-05 10:54:47 f177357 Do not reuse schema registry testing environment
• 01-07 03:01:09 bc312ab Support JWK with certificate chain
• 01-07 06:37:23 91d1303 Use AssertJ core version from Airbase for druid
• 01-12 04:15:36 4bcd5b5 Use assertEventually in TestKafkaAvroReadsSmokeTest
• 01-12 05:07:58 13910a8 Use varargs method to pass command to containers
• 01-12 05:07:58 1b68565 Improve audience support in OAuth2 authenticator
• 01-12 05:07:58 1e9a7c2 Upgrade Hydra docker image
• 01-12 05:07:58 31c5f7f Mark testSuccessfulFlow test flaky
• 01-12 05:07:58 b777864 Use epoch seconds in invalid JWT test
• 01-12 05:07:58 e80712b Fix OAuth2 Web UI authentication filter tests
• 01-13 03:18:32 1125cf9 Allow parameterized prepared statements in SHOW STATS
• 01-14 00:36:12 693cfb6 Add OAuth2 support to JDBC
• 01-15 05:08:16 c07f87a Use eventual assertion with query stats
• 01-19 04:12:46 d6a1217 Verify cookie in tests is present
• 01-19 11:55:34 6596309 Use secure cookie for UI OAuth2 token
• 01-19 11:55:34 861232e Add scopes to OAuth2 configuration
• 01-19 11:55:34 cd3da24 Add nonce parameter validation
• 01-21 02:41:46 4ce5a2e Decompress Kinesis message if needed
• 01-21 02:41:46 5f68daf Add stream and shard names to log
• 01-22 00:30:14 35a60b8 Start JWK service in OAuth2 module
• 01-24 10:07:54 539e846 Skip Kinesis decompression when kinesisCompressionCodec is UNCOMPRESSED
• 01-25 11:48:22 0d3bb55 Enable http server authentication in Hydra setup
• 01-25 11:48:22 363ab1b Skip nonce validation for REST challenges
• 01-25 11:48:22 42e9cc2 Rename nonce cookie to avoid name collision
• 01-25 11:48:22 88a7998 Send unauthorized response to /ui/api calls
• 01-28 00:59:11 c2fbe7e Restore @flaky annotations for 'Error committing write to Hive'
• 01-28 00:59:11 f40d2fa Move 'Error committing write to Hive' retry to Trino query executor

Karol Sobczak

• all checked
• 01-04 02:23:01 10f3d15 Rename configs in thrift.properties
• 01-04 02:23:01 468f072 Fix plugin.bundles paths in config.properties
• 01-04 04:15:26 466f284 Add rank() window operator test
• 01-05 04:08:19 856fcb1 Upgrade benchto to 0.14
• 01-05 04:39:49 0486167 Properly implement GroupedTopNRankBuilder within stub
• 01-05 04:39:49 1b57c60 Clean up for GroupedTopNRowNumberAccumulator
• 01-05 04:39:49 2b92c8d Tighten WindowFilterPushDown predicate domain check
• 01-05 04:39:49 3cf4efd Fix TopNRowNumberOperator incorrectly swapped types
• 01-05 04:39:49 3d164a6 Copy GroupedTopNRowNumberBuilder as new rank builder template
• 01-05 04:39:49 425156f Allow LongLong2LongOpenCustomBigHashMap to explicitly set null keys
• 01-05 04:39:49 47310aa Extract GroupedTopNBuilder as an interface
• 01-05 04:39:49 5cbe3ad Add GroupedTopNRankAccumulator for streaming rank
• 01-05 04:39:49 842a8e9 Add optimizer capability to produce streaming topN rank() plans
• 01-05 04:39:49 859c866 Rename TopNRowNumber* => TopNRanking*
• 01-05 04:39:49 8d4a1d7 Replace optimizer.optimize-top-n-row-number config with general version
• 01-05 04:39:49 ab4d9cd Add planner scaffolding to enable streaming topn RANK and DENSE_RANK
• 01-05 04:39:49 ade8af1 Force TopNRankingOperator compatibility with current Window behavior
• 01-05 04:39:49 c9855da Remove extra space from TopNRowNumberOperator
• 01-05 04:39:49 f811c56 Fix typo in GroupedTopNBuilder
• 01-05 06:26:07 a8de1c5 Fix master failure with out-of-date webui build
• 01-07 04:29:33 03c9ce3 Fix StreamingAggregationOperator with proper DISTINCT grouping semantics
• 01-07 04:29:33 5c7882f Add NOT DISTINCT operations to PagesHashStrategy
• 01-07 04:29:33 93ea855 Fix WindowOperator with proper DISTINCT peer group semantics
• 01-07 04:29:33 d4a909b Revert "Force TopNRankingOperator compatibility with current Window behavior"
• 01-08 01:16:19 bd5cd0b Add partition count parameter to BenchmarkHashBuildAndJoin
• 01-08 04:16:50 4f6a8f4 Extend BenchmarkHashAndStreamingAggregationOperators
• 01-08 04:16:50 627c072 Increase warmup iteration count
• 01-08 04:16:50 ce79625 Ensure address is not -1
• 01-14 01:29:43 d886239 Use long for {Primitive}BigArray#capacity
• 01-14 08:50:15 1b7787d Add JoinNode#maySkipOutputDuplicates
• 01-14 08:50:15 4421ee6 Optimize execution for joins below empty aggregation
• 01-14 08:50:15 8b68733 Fix formatting
• 01-14 08:50:15 8e6d2d5 Add "may skip output duplicates" as part of tpcds/tpcds plans testing
• 01-25 02:00:02 7604d06 Prefer ifPresent functional style in iterative rules
• 01-26 02:31:08 9c954ff Mark testOutputDuplicatesInsensitiveJoin as Flaky

Martin Traverso

• all checked
• 01-22 10:10:07 625eec1 Migrate WindowFilterPushdown to rule framework
• 01-26 15:32:53 693f71b Add static import
• 01-26 15:32:53 8436c95 Support WINDOW clause
• 01-26 15:32:53 e548a4e Fix test case

Piotr Findeisen

• all checked
• 01-04 12:11:08 91aa464 Mark TestHivePartitionsTable as flaky due to "committing"
• 01-04 12:11:29 dca3d89 Use the Redshift JDBC driver in the Redshift connector
• 01-04 13:33:04 2bcf5d9 Rename JdbcClient.getColumnMappings to toColumnMappings
• 01-04 13:33:04 d649dca Rename JdbcClient.toTrinoType to toColumnMapping
• 01-04 14:19:05 8228acb Fix array subscripting for SQL types represented as Objects
• 01-04 23:36:36 6a9be6b Simplify docker image configuration
• 01-05 07:54:48 2161800 Allow JDBC connector to control aggregation pushdown for tables
• 01-06 14:23:25 4f24c50 Allow custom timestamp precision in Hive structural types
• 01-06 14:23:25 5310c8a Improve timestamp test cases used in Hive storage format tests
• 01-06 14:23:25 6b03098 Fix type of TimestampAndPrecision.getPrecision
• 01-06 14:23:25 8e3b9af Improve data providers in TestHiveStorageFormats
• 01-08 02:52:47 65c9386 Fix javadoc wording for applyTopN
• 01-08 02:54:21 d97db32 Do not overwrite version of zt-exec in module
• 01-08 03:15:21 3a64f51 Disable array test in Cassandra more properly
• 01-08 03:15:21 57da5d6 Fix supportsArrays declaration in Phoenix tests
• 01-08 03:15:21 8500ab0 Verify supportsArrays correctness
• 01-08 13:07:26 190710b Use READ_COMMITED + SNAPSHOT_ISOLATION (RCSI) level for SqlServer
• 01-10 09:34:06 03d6bcb Short-circuit TupleDomain.columnWiseUnion
• 01-10 09:34:06 96cca5e Short-circuit TupleDomain overlaps
• 01-10 13:02:01 204d3d5 Migrate some occurances of fail() to assertThatThrownBy
• 01-11 01:07:50 2bcb184 Test public method instead of its implementation detail
• 01-11 01:07:50 aa06af7 Remove meaningless test cases
• 01-11 01:07:50 c130d44 Add more SortedRangeSet tests
• 01-11 05:17:38 2bbed53 Remove dead code
• 01-11 05:17:38 c5d893b Remove redundant toIntExact invocation on int
• 01-11 05:17:38 ffebdf3 Update limitations documented in Type.getJavaType
• 01-11 05:23:34 07a9700 Remove redundant picocli TypeConverters
• 01-11 05:23:34 0b02df2 Update picocli to 4.6.1
• 01-11 05:23:34 0c81a51 Describe default values in env up command
• 01-13 03:44:15 1bf1951 Update maven-shade-plugin to 3.2.4
• 01-13 13:46:32 82e8f93 Represent SortedRangeSet as a sorted list
• 01-13 13:46:32 82eb511 Benchmark SortedRangeSet methods
• 01-13 13:46:32 e3a5764 Remove unused Range, Marker serialization
• 01-13 14:31:07 1d1de54 Prefer java functional interfaces over Guava
• 01-13 14:44:07 330b51c Allow TrinoDriver to specify user to run query as
• 01-14 02:04:14 222f761 Support LZO-compressed Sequencefile table
• 01-14 02:04:14 7df8ff4 Remove unused test dependencies
• 01-14 02:04:14 c493221 Remove unused enum option
• 01-15 13:02:36 bbc42c0 Report server version for "Compiler failed"
• 01-17 13:10:32 4c36acf Use onHive() to access Hive query executor
• 01-18 02:29:26 0df459f Allow passing --session-user in the CLI
• 01-18 03:53:45 0b4a46a Extract helper session to separate class
• 01-18 03:53:45 1623ab5 Inline returned expression
• 01-18 03:53:45 ece6227 Show actual values in Range#toString
• 01-18 05:22:41 165b439 Update error-prone to 2.5.1
• 01-19 03:07:18 6bcff55 Remove obsolete conversion
• 01-19 03:07:18 d49a952 Inline SqlServerClient.toColumnMapping(JdbcTypeHandle)
• 01-19 05:03:35 a306082 Enable UseEnumSwitch error-prone check
• 01-19 07:22:20 2425b7b Update assertJ core to 3.18.1
• 01-20 04:17:53 549a407 Rename errorprone profile
• 01-20 05:07:12 a51bf68 Remove use of test priorities and dependsOnMethods from Prometheus tests
• 01-20 14:35:31 1144a5b Enable FallThrough error-prone check
• 01-20 14:35:31 23ba76f Indicate no fall-through in switch
• 01-20 14:35:31 55df60d Indicate intentional switch fall through with a comment
• 01-20 14:35:31 811b11a Remove redundant curly brackets
• 01-20 14:35:31 de20cd8 Add missing break in switch in test
• 01-22 04:29:12 db906c3 Deprecate JdbcClient.supportsGroupingSets
• 01-22 04:29:25 4abdb48 Give column a name
• 01-22 04:29:25 bb7ef11 Simplify SQL Server limit function
• 01-22 07:07:00 126bbf7 Separate query rendering from statement creation in QueryBuilder
• 01-22 07:07:00 2171a20 Remove redundant aliases in generated queries
• 01-22 07:07:00 a633152 Deprecate QueryBuilder.buildSql
• 01-22 07:07:00 a9565d6 Simplify DruidJdbcClient.buildSql override
• 01-22 07:17:34 13819b6 Rename test helper
• 01-22 07:17:34 18540cf Expose H2 database name in TestingDatabase
• 01-22 07:17:34 926a531 Remove unused import
• 01-22 07:17:34 a11d208 Allow matching multiple nodes in isNotFullyPushedDown
• 01-22 07:17:34 fb49b1c Add more pushdown tests
• 01-22 14:06:44 232c3f4 Use connectorProperties map instead of individual parameters for Oracle
• 01-22 14:06:44 b35fb06 Test Oracle case insensitive mapping
• 01-22 14:09:27 f0b20a9 Add geospatial plugin to start from default server main
• 01-25 01:25:54 02b59cd Use Query-based table handles in JDBC connectors
• 01-25 01:25:54 6442c96 Accept PreparedQuery in QueryBuilder
• 01-25 01:25:54 75baaae Represent query-based relation in JdbcTableHandle
• 01-25 01:25:54 96c3e0c Remove Presto reference
• 01-25 01:25:54 a66bde6 Remove JdbcColumnHandle.isSynthetic
• 01-25 05:05:51 090cc95 Pick Jackson version 2.11.4 from airbase
• 01-25 05:05:51 5ca5f82 Pick Joda version 2.10.9 from airbase
• 01-25 05:09:27 2d27a5f Document why covar_samp and covar_pop pushdowns are not implemented for SQL Server
• 01-27 04:20:48 9876d32 Add pushdown for statistical aggregate functions to MySQL connector
• 01-27 14:13:49 27d6f24 Add pattern for multi-variable aggregation functions
• 01-28 07:35:09 4a9a55f Document statistical aggregation function pushdown for MySQL
• 01-28 07:51:56 133a084 Do not install SystemAccessControl on workers in tests

Pratham

• all checked
• 01-06 13:57:11 09e1c02 Implement getTableProperties for Iceberg Connector
• 01-06 13:57:11 2e5733c Extract method for computing identity partition column ids
• 01-06 13:57:11 6841634 Move some helper methods to IcebergUtil
• 01-12 12:41:55 7fd62db Rename various Presto references to Trino
• 01-14 09:49:15 1b4dfe0 Fix example reference in resource groups documentation
• 01-14 12:57:24 07e53e8 Rename test file to use Trino instead of Presto
• 01-19 14:02:00 97bbafa Add property to allow fetching file sizes in Trino

Praveen Krishna

• all checked
• 01-04 05:43:51 23a4334 Pass ParsedSchema to SchemaParser
• 01-06 01:23:55 15f5e87 Drop table and other objects in SQL Server tests
• 01-06 01:23:55 1627f49 Get Data compression only for non-indexed SQL Server tables
• 01-06 01:23:55 65d482c Optimize query to match schema name
• 01-11 06:43:14 0020d49 Use testing docker images from GHCR
• 01-11 18:27:27 c9a9f9c Inject SchemaRegistryClient via Provider
• 01-22 02:10:21 ababf74 Add docs for data_compression table property in SQLServer

Yuya Ebihara

• all checked
• 01-05 00:16:30 663f8a5 Add support for version function
• 01-24 15:24:03 92fef2c Document square bracket and quote example of json path
• 01-24 21:35:09 152abe9 Add test for aggregating BigQuery view more than once
• 01-24 21:35:09 54beed2 Upgrade Google Could library bom to 16.3.0

Łukasz Osipiuk

• all checked
• 01-04 05:18:50 2aa8c20 Add coercion test filtering rules for Hive 2.1
• 01-05 01:15:32 07793e9 Add tests for querying Hive views with timestamps
• 01-05 01:15:32 4c69b49 Add hive_timestamp_nanos catalog to product tests
• 01-05 01:15:32 6264f21 Add test for querying Presto view referencing Hive table with timestamps
• 01-05 01:15:32 a646556 Extract method
• 01-05 01:15:32 d3b0c52 Drop improper contant use
• 01-05 01:15:32 dbbe3cf Select role for all catalogs
• 01-05 09:12:07 39a9945 Expose AWS HTTP Client stats via JMX
• 01-08 03:22:43 3e5ea65 Use method reference
• 01-08 03:22:43 468e134 Replace negated isPresent with isEmpty
• 01-08 03:22:43 4e51233 Remove redundant casts
• 01-08 03:22:43 5bec883 Make fields final
• 01-08 03:22:43 6fea78a Simplify assertion
• 01-08 03:22:43 85e2f43 Enable StaticQualifiedUsingExpression error check
• 01-08 03:22:43 9958385 Remove unneeded field
• 01-08 03:22:43 bc77f13 Inline redundant variable
• 01-08 03:22:43 c5d0b68 Access method in static manner
• 01-08 03:22:43 d0e1bb0 Simplify building collection out of stream
• 01-08 03:22:43 d202aad Drop unneeded modifier
• 01-08 03:22:43 d52d60d Use UTF_8 constant
• 01-08 03:22:43 ecde09c Drop unneeded semicolon
• 01-11 10:12:48 9b44633 Refactor TestHiveCoercion
• 01-12 08:25:54 f689de4 Enable views in BigQuery tests
• 01-12 11:23:03 462515f Fix TestBigQueryIntegrationSmokeTest.testShowCreateTable
• 01-13 14:59:16 60fccde Remove redundant strategy.fail-fast from MemSQL CI
• 01-14 01:31:04 4be5220 Conditionally run BigQuery tests which require GCE access
• 01-14 01:31:04 d73b998 Extract BigQuery tests as separete CI job
• 01-15 06:25:15 c55c54c Retry Hive queries that fail with 'Error committing write to Hive'
• 01-19 13:27:08 139412f Enable ImmutableSetForContains error-prone check
• 01-19 13:27:08 b3a10cc Enable UnnecessaryMethodReference error-prone check
• 01-19 13:27:08 efb1efa Enable OptionalMapUnusedValue error-prone check
• 01-19 13:27:08 fbbccf6 Enable UnnecessaryOptionalGet error-prone check
• 01-20 01:50:53 ee613cb Update airbase to 106
• 01-20 04:57:21 b9d31a2 Remove unnecessary exclusions
• 01-20 04:57:21 cd3c192 Remove dependency after upgrading to Guava 30.1
• 01-22 10:48:42 070b8cc Detect and enable snapshot isolation if available for SqlServer
• 01-25 01:54:25 cb7d776 Move listApplicableTablePrivileges to SqlStandardAccessControl
• 01-25 01:54:25 db8ec39 Make ThriftMetastoreUtil not depend on SemiTransactionalHiveMetastore
• 01-25 01:54:25 f646219 Make method private
• 01-25 02:22:50 d2845e0 Remove repeated error-prone check
• 01-25 23:59:02 91e0f05 Add getTableTypes extension point to BaseJdbcClient
• 01-27 02:35:21 4a026ff Use correct container log path for Trino nodes
• 01-28 03:59:57 056c0e2 Add a backup Coordinator to test multi coordinators

[findepi]

Redshift Connector
* Use dedicated Redshift JDBC driver to access Redshift. As a result, `connection-url` in catalog configuration files
  needs to be updated from `jdbc:postgresql:...` to `jdbc:redshift:...`. ({issue}`6465`)

#6465

[findepi]

General
* Fix query failure when using element of `array(timestamp(p))` in a complex expression for `p` greater than 6. ({issue}`6350`)

#6350 #6467

[findepi]

## Docker Image Changes

* Remove support for configuration directory `/usr/lib/trino/etc`. The configuration should be provided in `/etc/trino`.

#6497

[ebyhr]

General
* Add {func}`version` function. ({issue}`4627`)

#4627 #4629

[sopel39]

General:
* Improve performance of queries using {func}`rank()` window function. ({issue}`6333`)

#6333

[phd3]

Iceberg Connector:

* Optimize cardinality-insensitive aggregations (max, min, distinct, approx_distinct) over identity partition columns with `optimizer.optimize-metadata-queries` config property or `optimize_metadata_queries` session property. ({issue}`5199`)

#5199

[findepi]

Hive
* Support reading timestamp with microsecond or nanosecond precision (as configured with `hive.timestamp-precision` property) nested within
  `array`, `map` or `struct` data types. ({issue}`5195`)

#5195 #5695

[kokosing]

Web UI
* Support JWK with certificate chain for OAuth2 authorization. ({issue}`6428`)

#6428

[sopel39]

General:
* Fix window and streaming aggregation semantics regarding peer rows. Now peer rows are
  not distinct from each other, while previously they had to been equal. ({issue}`6472`) 

#6472

[findepi]

SQL Server
* Avoid query failures due to transaction deadlocks in SQL Server by using transaction snapshot isolation. ({issue}`6274`)

#6274 #6545

[kokosing]

Web UI
* Optionally verify JWT audience (`aud`) field for OAuth2 Web UI authentication. ({issue}`6501`)

#6501

[kokosing]

General
Allow prepared statement parameters for `SHOW STATS`. ({issue}`6582`)

#6582

[findepi]

General
* Improve query planning time. ({issue}`6544`)

#6544

[findepi]

JDBC
* Support user impersonation when using password-based authentication. This is configured using `sessionUser`
  connection URL parameter. Previously user impersonation was possible only with other authentication mechanisms. ({issue}`6549`)

#6549

[kokosing]

JDBC
* Add OAuth2 authentication support.({issue}`6576`)

#6576

[findepi]

Hive
* Support reading from table in Sequencefile format that uses LZO compression. ({issue}`6452`)

#6452

[sopel39]

General
* Improve joins performance. ({issue} `5981`)

#5981

[Praveen2112]

SqlServer
* Fix failure when querying tables having index and constraint.  ({issue} `6464`)

#6471

[findepi]

CLI
* Support user impersonation when using password-based authentication. This is configured using `--session-user`
  command line parameter. Previously user impersonation was possible only with other authentication mechanisms. ({issue}`6567`)

#6567 #6593

[kokosing]

Web UI
- Add scopes to `OAuth2` configuration. ({issue}`6580`)
- Prevent from reply attacks in `OAuth2` by using `nonce ` cookie when `openid` scope is requested. ({issue}`6580`)

#6580

[phd3]

Iceberg

* Provide  `use_file_size_from_metadata` catalog session property and `iceberg.use-file-size-from-metadata` config 
   property to fix query failures on tables with wrong file sizes stored in the metadata. (issue`{6369}`)

#6539 , #6369

[kokosing]

Kinesis
* Support GZIP message compression. ({issue}`6442`)

#6442

[ebyhr]

BigQuery
* Fix query failure when executing `count(*)` without `WHERE` clause for views more than once. ({issue}`6706`)

#6706, #6696

[findepi]

PostgreSQL, MySQL, SQL Server
* Improve performance for certain complex queries involving aggregation and predicates (e.g. `HAVING` clause) by
  by pushing the aggregation and predicates computation into the remote database. ({issue}`6667`)

#6667

[findepi]

General
* Update tzdata version to 2020d. As a result, queries can no longer reference `US/Pacific-New` zone, as it has been removed. ({issue}`6660`)

#6660

[martint]

* Add support for `WINDOW` clause. ({issue}`651`)

#651

[findepi]

MySQL
* Improve performance for certain queries using `stddev_pop`, `stddev_samp`, `var_pop`, `var_samp` aggregation functions
  by pushing the aggregation and predicates computation into the remote database. ({issue}`6673`)

#6673

[martint]

* Improve performance of {func}`sum` and {func}`avg` for `decimal` types. ({issue}`6951`)

#6591

[losipiuk]

Hive
* Expose AWS HTTP Client stats via JMX. ({issue}`6503`)

#6503

[dain]

* Fix failure when using geospatial functions in JOIN clause when `spatial_partitioning_table_name` is set. ({issue}`6587`)

#6587

[findepi]

SQL Server
* Honor precision of SQL Server's `datetime2` type . ({issue}`6654`)
* Add support for Trino `timestamp` type in `CREATE TABLE` statement, by mapping it to SQL Server's `datetime2` type.
  Previously, it was incorrectly mapped to SQL Server's `timestamp` type. ({issue}`6654`)

#6654

[findepi]

PostgreSQL
* Improve performance for certain queries using `stddev_pop`, `stddev_samp`, `var_pop`, `var_samp`,
  `covar_pop`, `covar_samp`, `corr`, `regr_intercept`, `regr_slope` aggregation functions
  by pushing the aggregation and predicates computation into the remote database. ({issue}`6731`)

#6731

[sopel39]

General
* Add ``plan-with-table-node-partitioning`` feature config that corresponds to
  existing ``plan_with_table_node_partitioning`` session property. ({issue}`6811`)

#6811

[losipiuk]

Hive
* Allow specifying S3 KMS Key ID used for client side encryption via security mapping config and extra credentials ({issue}`6802`)

#6802

[findepi]

Hive
* Fix writing incorrect `timestamp` values within `row`, `array` or `map` when using Parquet file format. ({issue}`6760`)

#6760 #6717

[phd3]

Iceberg
* Add `iceberg.max-partitions-per-writer` config property to allow configuring the limit on partitions per writer. ({issue}`6650`)

#6684 #6650

[ebyhr]

BigQuery
* Add a system table `view_definition` which exposes BigQuery view definition. ({issue}`3687`)

#3687

[phd3]

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

#6520

[losipiuk]

Hive
* Fix possible S3 connection leak on query failure. ({issue}`6849`)

#6849

[electrum]

# General

* Allow configuring HTTP client used for OAuth2 authentication. ({issue}`6600`)

#6600

[electrum]

#  General

* Add token polling client API for OAuth2 authentication. ({issue}`6625`)

#6625

[electrum]

# JDBC Driver

* Add OAuth2 authentication. ({issue}`6576`)

#6576

[electrum]

# General

* Add support for {doc}`/sql/update`. ({issue}`5861`)

# Hive Connector

* Add `UPDATE` support for ACID tables. ({issue}`5861`)

#5861

[electrum]

# Hive Connector

* Match columns by index rather than by name by default for ORC ACID tables. ({issue}`6479`)
* Match columns by name rather than by index by default for Parquet files. ({issue}`6479`)
* Remove the `hive.partition-use-column-names` configuration property and the
  `partition_use_column_names ` session property. This is now determined automatically. ({issue}`6479`)

#6479

[losipiuk]

# SPI

* Add support for join pushdown via the `ConnectorMetadata.applyJoin()` method. ({issue}`6752`)

#6752