Release notes for 393

[martint]

[ebyhr]

# Pinot
* Add support for Pinot `bytes` type. ({issue}`13427`)

#13427

[alexjo2144]

# Hive
* Fix bug where query constraints were not used when fetching table statistics.

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

[raunaqmorarka]

# ClickHouse, Druid, MariaDb, MySql, Oracle, PostgreSQL, Redshift, SingleStore, SQL server, Phoenix
* Improved performance for queries with selective joins through push down of dynamic filters to the data source. ({issue}`13334`)

#13334 #7968

[ebyhr]

# PostgreSQL
* Prevent creating or renaming to a schema with a name longer than the max length.
  Previously, the name was truncated to the max length. ({issue}`13307`)

#13307

[ebyhr]

# Delta Lake
* Add support for `NOT NULL` column constraint. ({issue}`13436`)

#13436

[ebyhr]

# Delta Lake
* Fix writing incorrect results when the partition column order is different from the table definition. ({issue}`13505`)

#13509

[findepi]

Iceberg
* Improve read query performance on Iceberg v2 tables with deletion files. ({issue}`13395`)

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

[ebyhr]

# Delta Lake
* Fix failure when reading a table having partition columns renamed by the remote data source. ({issue}`13521`)

#13539

[findepi]

Iceberg
* Allow partitioning transform over column which name contains non-letter and non-digit character. ({issue}`12226`)

#12227 #12226

[findepi]

ClickHouse
* Support `unsupported-type-handling` catalog configuration property. ({issue}`13542`)

#13542

[findepi]

Hive
* Fix writes to table with only `date` data type when using Hive metastore. ({issue}`13502`)

#13502

[ebyhr]

# MongoDB, SQL Server, PostgreSQL
* Prevent renaming to a table with a name longer than the max length.
  Previously, the name was truncated to the max length. ({issue}`13073`)

#13289

[ebyhr]

# Kafka
Fix predicate failure for negative offset value on `_timestamp` column. ({issue}`13167`)

#13170

[findepi]

# Iceberg
* Fix querying Iceberg tables which are empty and contain no table history. ({issue}`13576`)

#13576

[findepi]

# General
* Prevents inserting nulls that are results of expressions into non-nullable columns. ({issue}`13462`)

[findepi]

Iceberg
* Fix delete queries sometimes truncating the table history, as shown in the `$snapshots` system table. ({issue}`12843`)

#12843 #13485

[findepi]

Iceberg
* Fix query failure when optimizing Iceberg tables which are empty and contain no table history. ({issue}`13582`)

#13582

[findepi]

# Iceberg
* Support filtering splits based on `$file_modified_time` column predicates. ({issue}`13504`)

#13591 #13504

[raunaqmorarka]

# Hive
* Support hive bucket filtering on bucketed columns of float, double, date, list, map and bounded varchar data types. ({issue}`13553`)

#13553 #13472

[raunaqmorarka]

# Hive
* Upgrade Alluxio to 2.8.1 to fix security vulnerabilities. ({issue}`13609`)

#13609

[findepi]

Iceberg
* Fix incorrect query results when reading from a stale materialized view that was created on a table
  that was empty and contained no history. ({issue}`13574`)

#13574

[sopel39]

# General
* Make highly selective `LIMIT` queries finish as soon as required number of rows is produced ({issue}`13616`)

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

[sopel39]

General:
* Prevent queries on bucketed tables from deadlocking ({issue}`13655`)

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

[ebyhr]

# Hive
* Fix failure when reading Hive views having column names with reserved keywords. ({issue}`13450`)

#13450

[ebyhr]

# Iceberg
* Disallow specifying `NOT NULL` constraint when adding a new column. Previously, the option was ignored. ({issue}`13673`)

#13673

[ebyhr]

# Pinot
* Add support for `json` type. ({issue}`13428`)

#13428