Release notes for 402

[martint]

No description provided.

[ebyhr]

# Iceberg
* Add support for skipping archive when committing a table in Glue when
  the `iceberg.glue.skip-archive` configuration property is set to true. ({issue}`13413`)

#14336

[raunaqmorarka]

# Hive, Iceberg, Delta, Hudi 
* Remove deprecated configuration properties `hive.parquet.fail-on-corrupted-statistics` and `parquet.fail-on-corrupted-statistics`. 
  The property `parquet.ignore-statistics` can be used to allow querying Parquet files with corrupted or incorrect statistics. ({issue}`14777`)

#14777

[ebyhr]

# Hive, Iceberg, Memory
* Add support for setting view column comments over `COMMENT ON COLUMN` sql command. ({issue}`10705`)

#13800

[hashhar]

# SQL Server
* Improve performance of queries involving `OR` with simple comparisons and `LIKE` predicates
  by pushing predicate computation the underlying database. ({issue}`14570`)
* Improve performance of queries involving `OR` with `IS NULL`, `IS NOT NULL` predicates, or
  involving `NOT` expression by pushing predicate computation to the underlying database.
  ({issue}`14570`)
* Improve performance of queries with predicates involving `nullif` function by
  pushing predicate computation to the underlying database. ({issue}`14570`)
* Improve performance of queries involving predicates with arithmetic
  expressions by pushing predicate computation to the underlying database. ({issue}`14570`)

#14570

[ebyhr]

# Iceberg
* Fix incorrect result when column orders in equality delete filter is different from the table definition. ({issue}`14693`)

#14813

[ebyhr]

# MongoDB
* Support predicate pushdown on `date`, `time(3)`, `timestamp(3)` and
  `timestamp(3) with time zone` columns. ({issue}`14795`)

#14795

The same entry exists in version 399 release note, but the changes in the version was insufficient.

[kokosing]

JDBC connectors
 * Make connector more interactive by reusing JDBC connection for metadata queries. It can be disabled with configuration property ``query.reuse-connection=false``. ({issue}`14653`)

#14653

[sopel39]

Hive, Delta, Iceberg:
* Improve insert query memory accounting. ({issue}`14823`)
* Fix memory leak during large insert queries. ({issue}`14823`)

#14823