Release 366 (14 Dec 2021)#
General#
- Add support for automatic query retries. This feature can be turned on by setting the - retry-policyconfig property or the- retry_policysession property to- retry. (#9361)
- Add CREATE privilege kind to SQL grammar. Note that this permission is not used by any existing security systems, but is available for plugins. (#10206) 
- Add support for - DENYstatement in the engine. Note that this statement is not supported by any existing security systems, but is available for plugins. (#10205)
- Reduce lock contention during query execution. (#10246, #10239) 
- Improve query performance through optimizations to in-memory representations. (#10225) 
- Reduce query latency for contended clusters or complex queries with multiple stages. (#10249) 
- Fix incorrect results or failure when casting numeric values to - varchar(n)type. (#552)
- Remove support for spilling aggregations containing - ORDER BYor- DISTINCTclauses and associated configuration properties- spill-distincting-aggregations-enabled,- spill-ordering-aggregations-enabled. (#10183)
Elasticsearch connector#
- Read extended metadata from the - _meta.trinoindex mapping attribute.- _meta.prestois still supported for backward compatibility. (#8383)
Hive connector#
Iceberg connector#
- Fix incorrect query results for tables partitioned on columns of type - binary. (#9755)
MemSQL connector#
- Fix incorrect result when a - datevalue is older than or equal to- 1582-10-14. (#10054)
MySQL connector#
- Fix incorrect result when a - datevalue is older than or equal to- 1582-10-14. (#10054)
Phoenix connector#
- Avoid running into out of memory errors with certain types of queries. (#10143) 
Prometheus connector#
- Support configuring a read timeout via the - prometheus.read-timeoutconfig property. (#10101)
PostgreSQL connector#
- Fix incorrect result when a - datevalue is older than or equal to- 1582-10-14. (#10054)