Release notes for 370

[ebyhr]

# ClickHouse
* Support creating tables with Trino `timestamp(0)` type columns. ({issue}`10751`)

10751

[mosabua]

Added above. Does this need an extension to the type mapping section in the Clickhouse connector @ebyhr ?

[ebyhr]

@mosabua The mapping already exists at clickhouse.rst#type-mapping

[sopel39]

General:
* Add support for `DEFAULT` keyword in `ALTER TABLE...SET PROPERTIES...`. ({issue}`10331`)

SPI:
* Make `ConnetorMetadata#setTableProperties` accept null property names. ({issue}`10331`)

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

[sopel39]

General
* Improve performance of map and row types. ({issue}`10469`)

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

[mosabua]

All above added with minor rewording for your suggestions @ebyhr

[findepi]

Hive
* Fix sporadic query failure "Partition no longer exists" when working with wide tables using Glue metastore. ({issue}`10696`)

10696

[findepi]

iceberg
* Fix query failure when reading from a table that underwent partitioning evolution. ({issue]`10770`)

10770 #10739

[mosabua]

No release notes and docs for #10663 @findepi right?

[mosabua]

No release notes or docs for #10507 @losipiuk and @arhimondr right?

[mosabua]

Should we add a RN entry for #10720 @kasiafi and @findepi ?

[mosabua]

Need a RN entry and docs update for #10820 @electrum please

[arhimondr]

@mosabua Not yet :-)

[sopel39]

General:
* Fix query scheduling regression introduced in Trino 360 that caused coordinator slowness in assigning splits to workers. ({issue}`10839`)

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

[mosabua]

Updated again.

[ebyhr]

# Phoenix
* Fix incorrect result when a `date` value is older than or equal to `1899-12-31`. ({issue}`10749`)

10749

[kokosing]

Security
* Fix server start failure when using JWT and Oauth2 authentication together (`http-server.authentication.type=jwt,oauth2`. ({issue}`10811`)

10811

[sopel39]

Hive
* Improve query performance when reading ORC data. ({issue}`10575`)

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

[mosabua]

Added the above suggestions.

[findepi]

Hive
* Fix `SHOW TABLES` failure when `hive.hide-delta-lake-tables` is enabled and Glue metastore has table with no properties. ({issue}`10864`)

10864 #10865

[findepi]

Iceberg
* Fix data corruption when writing Parquet files. ({issue}`9749`)

9749 #10418

[findepi]

SPI
* Rename `ConnectorNewTableLayout`  to `ConnectorTableLayout`. ({issue}`10587`)

10587

[findepi]

General
* Fix `information_schema` query failure when `IS NOT NULL` predicate is used. ({issue}`10861`)

10861 #10867

[mosabua]

Added all above with rewording.

[dain]

SPI
* Connectors no longer need to explicitly declare handle classes.  The `ConnectorFactory.getHandleResolver` and `Connector.getHandleResolver` methods have been removed. ({issue}`10858`)

10858

[mosabua]

Above added now.

[ebyhr]

# ClickHouse
* Drop support for ClickHouse servers older than version 20.7 to avoid using a deprecated driver. You can continue to use the deprecated driver with the `clickhouse.legacy-driver` flag when connecting to old servers. ({issue}`10541`)

10801

[hashhar]

# General
* Automatically raise max open files limit to recommended value in Trino init script if required. ({issue}`8819`)

8819

[hashhar]

# Docker Image

* Change base image to `registry.access.redhat.com/ubi8/ubi` since CentOS 8 has reached end-of-line. ({issue}`10866`)

10866

[dain]

## SPI
* Remove unnecessary `Block` `writePositionTo` and `BlockBuilder` `appendStructure` methods.  Use of these methods can be replaced with the existing `Type` `appendTo` or `writeObject` methods. ({issue}`10602 `)

10602

[mosabua]

All above added again.

[sopel39]

General:
* Prevent queries deadlock when using `phased` execution policy with dynamic filters in multi-join queries. ({issue}`10868`)

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

[dain]

No release notes needed for #10875

[ebyhr]

# Cassandra
* Fix query failure when pushing predicates on `uuid` partitioned columns. ({issue}`10799`)

10856

[martint]

* Fix failure when nested subquery contains `TABLESAMPLE` clause. ({issue}`10764`)

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

[mosabua]

All above are taken care of

[kokosing]

CLI
 - Allow to choose the way how external authentication is handled by using `--external-authentication-redirect-handler` parameter. ({issue}`10248`)

10248

[kokosing]

Security
 - Shorten the latency of successful OAuth2 authentication.  ({issue}`10929`)

10929

[electrum]

# Hive connector changes

* Add configuration property `hive.single-statement-writes` to require auto-commit for writes.
  This can be used to disallow multi-statement write transactions. ({issue}`10820`)

10820

[electrum]

The SPI changes in #10806 are subsumed by #10858.

[electrum]

## Other connectors

This change applies to the Druid, MemSQL, MySQL, Oracle, Phoenix, PostgreSQL, Redshift, and SQL Server connectors.

* Remove the legacy `allow-drop-table` configuration property. This previously defaulted
  to `false`, which disallowed dropping tables, but other modifications were still allowed.
  Use {doc}`/security/built-in-system-access-control` instead, if desired. ({issue}`588`)

588

[mosabua]

All above are in