Release 361 (27 Aug 2021)#
General#
- Add support for subqueries in - MATCH_RECOGNIZEand- WINDOWclause. (#8736)
- Add - system.metadata.materialized_viewstable that contains detailed information about materialized views. (#8796)
- Support table redirection for - INSERT,- UPDATEand- DELETEoperations. (#8683)
- Improve performance of - sum()and- avg()aggregations on- decimalvalues. (#8878)
- Improve performance for queries using - INpredicate with moderate to large number of constants. (#8833)
- Fix failures of specific queries accessing - rowcolumns with with field names that would require quoting when used as an identifier. (#8845)
- Fix incorrect results for queries with a comparison between a - varcharcolumn and a- charconstant. (#8984)
- Fix invalid result when two decimals are added together. This happened in certain queries where decimals had different precision. (#8973) 
- Prevent dropping or renaming objects with an incompatible SQL command. For example, - DROP TABLEno longer allows dropping a view. (#8869)
Security#
- Add support for OAuth2/OIDC opaque access tokens. The property - http-server.authentication.oauth2.audiencehas been removed in favor of using- http-server.authentication.oauth2.client-id, as expected by OIDC. The new property- http-server.authentication.oauth2.additional-audiencessupports audiences which are not the- client-id. Additionally, the new property- http-server.authentication.oauth2.issueris now required; tokens which are not issued by this URL will be rejected. (#8641)
JDBC driver#
BigQuery connector#
- Fix incorrect result when using BigQuery - timetype. (#8999)
Cassandra connector#
ClickHouse connector#
Druid connector#
- Allow limiting the size of the metadata cache via the - metadata.cache-maximum-sizeconfiguration property. (#8652)
Elasticsearch connector#
- Add support for reading fields as - jsonvalues. (#7308)
Hive connector#
- Expose - <view>$propertiessystem table for Trino and Hive views. (#8805)
- Add support for translating Hive views which contain common table expressions. (#5977) 
- Add support for translating Hive views which contain outer parentheses. (#8789) 
- Add support for translating Hive views which use the - from_utc_timestampfunction. (#8502)
- Add support for translating Hive views which use the - datefunction. (#8789)
- Add support for translating Hive views which use the - pmodfunction. (#8935)
- Prevent creating of tables that have column names containing commas, or leading or trailing spaces. (#8954) 
- Improve performance of updating Glue table statistics for partitioned tables. (#8839) 
- Change default Glue statistics read/write parallelism from 1 to 5. (#8839) 
- Improve performance of querying Parquet data for files containing column indexes. (#7349) 
- Fix query failure when inserting data into a Hive ACID table which is not explicitly bucketed. (#8899) 
Iceberg connector#
- Fix reading or writing Iceberg tables that previously contained a partition field that was later dropped. (#8730) 
- Allow reading from Iceberg tables which specify the Iceberg - write.object-storage.pathtable property. (#8573)
- Allow using randomized location when creating a table, so that future table renames or drops do not interfere with new tables created with the same name. This can be enabled using the - iceberg.unique-table-locationconfiguration property. (#6063)
- Return proper query results for queries accessing multiple snapshots of single Iceberg table. (#8868) 
MemSQL connector#
- Allow limiting the size of the metadata cache via the - metadata.cache-maximum-sizeconfiguration property. (#8652)
MongoDB connector#
- Add - timestamp_objectid()function. (#8824)
- Enable - mongodb.socket-keep-aliveconfig property by default. (#8832)
MySQL connector#
Oracle connector#
- Allow limiting the size of the metadata cache via the - metadata.cache-maximum-sizeconfiguration property. (#8652)
Phoenix connector#
- Allow limiting the size of the metadata cache via the - metadata.cache-maximum-sizeconfiguration property. (#8652)
Pinot connector#
- Implement aggregation pushdown for - count,- avg,- min,- max,- sum,- count(DISTINCT)and- approx_distinct. It is enabled by default and can be disabled using the configuration property- pinot.aggregation-pushdown.enabledor the catalog session property- aggregation_pushdown_enabled. (#4140)
- Allow - httpsURLs in- pinot.controller-urls. (#8617)
- Fix failures when querying - information_schema.columnswith a filter on the table name. (#8307)
PostgreSQL connector#
Redshift connector#
- Allow limiting the size of the metadata cache via the - metadata.cache-maximum-sizeconfiguration property. (#8652)