Release notes for 406

[martint]

No description provided.

[hashhar]

# BigQuery
* Fix possible incorrect results for certain queries like `COUNT(*)` when the table has
  recently been written to in BigQuery. ({issue}`14981`)

#14981, #15542

[raunaqmorarka]

# Hive, Hudi, Iceberg, Delta
* Fixes a bug which could lead to more data than necessary getting read from parquet files for queries with filters. ({issue}`15552`)

#15552

[ebyhr]

# Hive
* Fix incorrect `schema already exists` error caused by a client timeout when
  creating a new schema. ({issue}`15174`)

#15565

[raunaqmorarka]

# Hive, Hudi, Iceberg, Delta
* Improve accounting of memory usage by parquet reader. ({issue}`15554`)

#15554 #10061

[raunaqmorarka]

# Hive, Hudi, Delta, Iceberg
* Improve performance of reading from parquet files. ({issue}`15498`)

#15498

[ebyhr]

# Iceberg
* Fix failure when a subquery contains time travel. ({issue}`15607`)

#15607

[raunaqmorarka]

# General
* Fix query failure for outer joins in fault tolerant execution. ({issue}`15608`)

#15608

[raunaqmorarka]

# Hive, Hudi, Delta, Iceberg
* Improve performance of queries with filters or projections on low cardinality string columns stored in parquet files. ({issue}`15269`)

#15269 #2020

[raunaqmorarka]

# Hive
* Improve performance of queries with filters when bloom filter indexes are present in parquet files. Usage of bloom filters from parquet files can be disabled using the catalog configuration property `parquet.use-bloom-filter` or the catalog session property `parquet_use_bloom_filter`. ({issue}`14428`)

#14428

[ebyhr]

# PostgreSQL
* Add support for changing column types. ({issue}`15515`)

#15591

[ebyhr]

# Delta Lake
* Fix failure when converting JSON statistics to Parquet format. ({issue}`15496`)

#15517

[raunaqmorarka]

# General
* Fix planner estimates for queries with filters on columns without statistics. ({issue}`15642`)

#15642 #15605

[raunaqmorarka]

# General
* Improve planner estimates for queries containing outer joins over a topN operation. ({issue}`15428`)

#15428

[raunaqmorarka]

# Hive, Hudi, Iceberg, Delta
* Fix query failure due to missing nulls counts in parquet column indexes. ({issue}`15706`)

#15706

[ebyhr]

# Iceberg
* Fix failure when reading columns whose type was changed from `float` to `double` by other query engines. ({issue}`15650`)

#15681

[sopel39]

General
* Make table scan memory usage reporting more accurate. ({issue}`15711`)

#15711

[ebyhr]

# MongoDB
* Fix bug when dropping schemas and `mongodb.case-insensitive-name-matching` is enabled.
  Previously, the statement succeeded, but the schema wasn't dropped. ({issue}`15716`)

#15717

[ebyhr]

# Iceberg
* Fix incorrect results when reading or writing `NaN` with `real` or `double` types on partitioned columns. ({issue}`15723`)

#15727

[ebyhr]

# Hive
* * Add support for table redirections to the Hudi connector. ({issue}`14750`)

#15551

[findepi]

General
* Improve performance of queries parsing  date values in ISO 8861 format. ({issue}`15548`)

#15548 #15229

[hashhar]

# Hive

* Disallow UPDATE/DELETE on Hive ACID transactional tables to prevent correctness
  issues when `deprecated.legacy-update-delete-implementation` is set to true. ({issue}`12731`)

#12731, #15684

[ebyhr]

# Iceberg
* Add support for changing column types. ({issue}`15515`)

#15651

[ebyhr]

# Iceberg
* Add support for JDBC catalog. ({issue}`9968`)

#11772

[raunaqmorarka]

# General
* Improve performance of queries with selective joins. ({issue}`15569`)

#15569 #14797

[ebyhr]

# Cassandra
* Fix incorrect results when Cassandra `list`, `map` and `set` types contain user defined types. ({issue}`15771`)

#15796

[sopel39]

Hive/Iceberg/Delta
* Reduce latency for insert queries for unpartitioned tables. ({issue}`15708`)

#15708

[ebyhr]

# General
* Add support for `CHECK` constraints in `INSERT` statement. ({issue}`14964`)

#14964