Release 359 (1 Jul 2021)#
General#
- Raise minimum required Java version for running Trino server to 11.0.11. (#8103) 
- Add support for row pattern recognition in window specification. (#8141) 
- Add support for SET TIME ZONE. (#8112) 
- Add - geometry_nearest_points(). (#8280)
- Add - current_groups(). (#8446)
- Add support for - varchar,- varbinaryand- datetypes to- make_set_digest(). (#8295)
- Add support for granting - UPDATEprivileges. (#8279)
- List materialized view columns in the - information_schema.columnstable. (#8113)
- Expose comments in views and materialized views in - system.metadata.table_commentscorrectly. (#8327)
- Fix query failure for certain queries with - ORDER BY ... LIMITon sorted data. (#8184)
- Fix incorrect query results for certain queries using - LIKEwith pattern against- charcolumns in the- WHEREclause. (#8311)
- Fix planning failure when using - hash_counts(). (#8248)
- Fix error message when grouping expressions in - GROUP BYqueries contain aggregations, window functions or grouping operations. (#8247)
Security#
Web UI#
- Show session timezone in query details page. (#4196) 
Docker image#
- Add support for ARM64. (#8397) 
CLI#
- Add support for logging of network traffic via the - --network-loggingcommand line option. (#8329)
BigQuery connector#
Elasticsearch connector#
Hive connector#
- Rename - hive-hadoop2connector to- hive. (#8166)
- Add support for Hive views which use - GROUP BYover a subquery that also uses- GROUP BYon matching columns. (#7635)
- Add support for granting - UPDATEprivileges when- hive.security=sql-standardis used. (#8279)
- Add support for inserting data into CSV and TEXT tables with - skip_header_line_counttable property set to 1. The same applies to creating tables with data using- CREATE TABLE ... AS SELECTsyntax. (#8390)
- Disallow creating CSV and TEXT tables with data if - skip_header_line_countis set to a value greater than 0. (#8373)
- Fix query failure when reading from a non-ORC insert-only transactional table. (#8259) 
- Fix incorrect results when reading ORC ACID tables containing deleted rows. (#8208) 
- Respect - hive.metastore.glue.get-partition-threadsconfiguration property. (#8320)
Iceberg connector#
- Do not include Hive views in - SHOW TABLESquery results. (#8153)
MongoDB connector#
- Skip creating an index for the - _schemacollection if it already exists. (#8264)
MySQL connector#
SPI#
- Introduce - ConnectorMetadata#listMaterializedViewsfor listing materialized view names. (#8113)
- Introduce - ConnectorMetadata#getMaterializedViewsfor getting materialized view definitions. (#8113)
- Enable connector to delegate materialized view refresh to itself. (#7960) 
- Allow computing HyperLogLog based approximate set summary as a column statistic during - ConnectorMetadatadriven statistics collection flow. (#8355)
- Report output column types through - EventListener. (#8405)
- Report input column information for queries involving set operations ( - UNION,- INTERSECTand- EXCEPT). (#8371)