Release notes for 369

[martint]

No description provided.

[ebyhr]

# BigQuery
* Fix query failure when reading `numeric` or `bignumeric` type. ({issue}`10564`)

#10565

[Praveen2112]

# SPI
* Remove legacy table layout objects from SPI

#10490

[hashhar]

# PostgreSQL
* Add support for [renaming schemas](/sql/alter-schema). ({issue}`8939`)

# Redshift
* Add support for [renaming schemas](/sql/alter-schema). ({issue}`8939`)

#8939

[Praveen2112]

# Hive
* Add support for writing Bloom filters in ORC files. ({issue}`3939`)

#10343

[findepi]

Iceberg
- Add `ALTER TABLE .. EXECUTE OPTIMIZE` statement support. ({issue}`10497`)

#10497

[findepi]

each JDBC connector
* Fix spurious errors when metadata cache is enabled. ({issue}`10544`, {issue}`10512`)

#10544 #10512

[sopel39]

General
* Display `Physical input read time` using most succinct time unit in `EXPLAIN ANALYZE VERBOSE`. ({issue}`10576`)

#10576

[findepi]

Hive
* Fix inserting into transactional table when task_writer_count > 1

#9149 #10460

[mosabua]

All added to PR

[sopel39]

Iceberg:
* Fix materialized view refresh when view query references same table multiple times. ({issue}`10570`)

#10570

[losipiuk]

General:
* Fine tune request retry mechanism in `http` event listener. Previously requests were not retried for some errors for which it makes sense (e.g. if low-level communication problem occurred). ({issue}`10566`)

#10566

[findepi]

Iceberg
* Improve select query planning performance after writes done via Trino. ({issue}`9340`)

#9340 #10105

[ebyhr]

# ClickHouse
* Allow mapping ClickHouse `fixedstring` or `string` as Trino `varchar` via the `map_string_as_varchar` session property. ({issue}`10601`)

#10601

[mosabua]

@findepi can you confirm that no release notes entry is needed for #10591 ? Or suggest an entry?

[mosabua]

@martint @dain do we need a release notes entry for #10599 ?

[findepi]

can you confirm that no release notes entry is needed for #10591 ?

As any config removal, this ought me mentioned.

[dain]

For #10599

* Fix UnsupportedOperationException in max_by and min_by aggregation.  ({issue}`10599 `)

[ebyhr]

# ClickHouse
* Map ClickHouse `ipv4` and `ipv6` types to Trino `ipaddress` type. ({issue}`7098`)

#10611

[losipiuk]

Hive:
* Allow flushing cache for specific partition via :func:`flush_metadata_cache` function.  ({issue}`10385`)

#10385

[findepi]

* Add Iceberg $properties system table

#10480

[mosabua]

All above added again (with minor rewording and formatting as necessary)

[mosabua]

Fyi, I decided to add a RN entry in general for #10423 @electrum

[mosabua]

For #10480 .. can @findepi and @findinpath work together to get the info added to the ongoing PR about hidden tables for Iceberg and get that merged asap please?

[mosabua]

For #10605 .. @sopel39 I think we dont need RN or docs .. right?

[mosabua]

@findepi do we need to add RN entry and docs for #10441 ?

[findinpath]

Hive
* Explicitly disallow reading from Iceberg tables when redirects from Hive to Iceberg are not enabled.

#8693 #10441

[ebyhr]

# Oracle
* Map Oracle `date` to Trino `timestamp(0)` type. ({issue}`10626`)
* Fix performance regression of predicate pushdown on indexed `date` columns. ({issue}`10626`)

#10638

[findepi]

Hive and perhaps Iceberg
* Improve performance when reading ORC files with Bloom filters with range predicates. ({issue}`4108`)

#4108 #9868

[hashhar]

# General
* Add support for using PostgreSQL and Oracle with database backed resource groups. ({issue}`9812`)

#9812

[ebyhr]

# ClickHouse
* Upgrade minimum required version to 21.3. ({issue}`10703`)
* Disable `avg` pushdown on `decimal` types to avoid incorrect results. ({issue}`10650`)

#10703

[mosabua]

All above added again.

[mosabua]

@hashhar @posulliv do we need some sort of doc update / addition for #9812 ?

[kasiafi]

# General
* Fix incorrect results or failure when casting date to bounded `varchar` type. ({issue}`552`)

#10678

[kasiafi]

# General
* Use formatting specified in the SQL standard when casting `double` and `real` values to `varchar` type. ({issue}`552`)

#10657

[findepi]

bigquery
* Remove ``bigquery.case-insensitive-name-matching.cache-ttl`` configuration option. It was previously ignored. ({issue}`10697`)

#10697 #10725

[mosabua]

All above added.

[mosabua]

@martint @arhimondr .. need a release notes entry for #9818

[arhimondr]

@mosabua This feature is not yet usable. We shouldn't probably mention it just yet.

[findepi]

General

Remove distinction between system and user memory. This simplifies cluster configuration.
The configuration property `query.max-total-memory-per-node` is removed, 
`query.max-memory-per-node` should be used instead. ({issue}`10574`)

#10574

[losipiuk]

Hive, Iceberg

Fix possible data corruption when writing data to S3 with streaming enabled ({issue}`10710 `)

#10710
#10716
#10729

[dain]

Hive, Iceberg

Add support for long lived STS credentials to Glue Metastore. ({issue}`10735`)

#10735

[mosabua]

All above added with minor tweaks. On to verification..

[mosabua]

@mosabua This feature is not yet usable. We shouldn't probably mention it just yet.

Got an answer how to mention if from @martint .. see the PR

[sopel39]

General:
* Improve query wall time by splitting workload between nodes in a more balanced way. 
  Previous workload balancing policy can be restored via `node-scheduler.splits-balancing-policy=node`. ({issue}`10660`)

#10660

[kokosing]

Security
 - Allow extracting groups from OAuth2 claims by using ``http-server.authentication.oauth2.groups-field``. ({issue}`10262`)
 #10262

[mosabua]

Added up to here again.

[mosabua]

RN entry for #10722 @martint ?

[mosabua]

RN entry for #10619 @findepi @electrum ?

[sopel39]

General
* Add support for `ALTER MATERIALIZED VIEW ... SET PROPERTIES`. ({issue}`9613`)

#9613

[mosabua]

Added MV update @sopel39 and filed #10774 for you ..