Release notes for 397

[martint]

No description provided.

[findepi]

Iceberg
* Refresh materialized view atomically. Previously, when a refresh was about to finish, there was a short time window
  during which the materialized view could appear empty. ({issue}`14145`)

#14145

[findepi]

Iceberg
* Prevent table corruption when changing table and it is not clear whether committing
  to Hive metastore succeeded or not. ({issue}`14118`)

#14118

[raunaqmorarka]

# Hive, Delta
* The `parquet.experimental-optimized-writer.enabled` property is now deprecated.
`parquet.optimized-writer.enabled` is the new property for enabling the optimized parquet writer. 
({issue}`14137`)

#14137

[findepi]

Iceberg
* Improve performance of queries that contain predicates involving `date_trunc` with `hour` unit
  on `date`, `timestamp` or `timestamp with time zone` partition columns. ({issue}`14161`)

#14161

[findepi]

Iceberg
* Reduce query latency when using Glue catalog. ({issue}`13875`)

#13875

[findepi]

JDBC
* Fix calling application resource exhaustion when it cancels statements without consuming result set's rows. ({issue}`14176`)

#14176 #7374 #13775

[findepi]

General
* Fix `EXPLAIN (TYPE IO)` query failure for certain queries with redundant table scans.
  Previously, the explain could fail for example when reading from an empty partitioned Hive table. ({issue}`10398`)

#12349 #10398

[findepi]

Hive
* Fix query failure when reading from a Hive view and `hive.hive-views.run-as-invoker` 
  and `hive.hive-views.legacy-translation` are both enabled. ({issue}`14077`)

#14077

[findepi]

Hive
* Allow reading from a partitioned table after a column data type was changed in Hive from `decimal` to `varchar` or `string`. ({issue}`2817`)

#2817 #14172

[findepi]

## Iceberg connector
* Improve query performance of reads after `DELETE` removes all rows from a file. ({issue}`14198`)

#14198

[Twilightuse]

trino-jdbc 406 a lot of connection in timed_wating, there is the thread stack
"OkHttp ConnectionPool" #3363 daemon prio=5 os_prio=0 tid=0x00007f403810d800 nid=0x1195 in Object.wait() [0x00007f362a373000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at java.lang.Object.wait(Object.java:460)
at io.trino.jdbc.$internal.okhttp3.internal.connection.RealConnectionPool.lambda$new$0(RealConnectionPool.java:62)

• locked <0x0000000722d630e0> (a io.trino.jdbc.$internal.okhttp3.internal.connection.RealConnectionPool)
  at io.trino.jdbc.$internal.okhttp3.internal.connection.RealConnectionPool$$Lambda$2010/1587346617.run(Unknown Source)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:750)

Locked ownable synchronizers:

• <0x000000072287d118> (a java.util.concurrent.ThreadPoolExecutor$Worker)
  "OkHttp ConnectionPool" Add EventListener to HiveConnector #3358 daemon prio=5 os_prio=0 tid=0x00007f3eb0095000 nid=0x118d in Object.wait() [0x00007f362ab7b000]
  java.lang.Thread.State: TIMED_WAITING (on object monitor)
  at java.lang.Object.wait(Native Method)
  at java.lang.Object.wait(Object.java:460)
  at io.trino.jdbc.$internal.okhttp3.internal.connection.RealConnectionPool.lambda$new$0(RealConnectionPool.java:62)
• locked <0x0000000722ae7c90> (a io.trino.jdbc.$internal.okhttp3.internal.connection.RealConnectionPool)
  at io.trino.jdbc.$internal.okhttp3.internal.connection.RealConnectionPool$$Lambda$2010/1587346617.run(Unknown Source)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:750)

Locked ownable synchronizers:

• <0x000000072261f628> (a java.util.concurrent.ThreadPoolExecutor$Worker)
  a