Release 361 (27 Aug 2021)#
General#
Add support for subqueries in
MATCH_RECOGNIZE
andWINDOW
clause. (#8736)Add
system.metadata.materialized_views
table that contains detailed information about materialized views. (#8796)Support table redirection for
INSERT
,UPDATE
andDELETE
operations. (#8683)Improve performance of
sum()
andavg()
aggregations ondecimal
values. (#8878)Improve performance for queries using
IN
predicate with moderate to large number of constants. (#8833)Fix failures of specific queries accessing
row
columns with with field names that would require quoting when used as an identifier. (#8845)Fix incorrect results for queries with a comparison between a
varchar
column and achar
constant. (#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 TABLE
no longer allows dropping a view. (#8869)
Security#
Add support for OAuth2/OIDC opaque access tokens. The property
http-server.authentication.oauth2.audience
has been removed in favor of usinghttp-server.authentication.oauth2.client-id
, as expected by OIDC. The new propertyhttp-server.authentication.oauth2.additional-audiences
supports audiences which are not theclient-id
. Additionally, the new propertyhttp-server.authentication.oauth2.issuer
is now required; tokens which are not issued by this URL will be rejected. (#8641)
JDBC driver#
BigQuery connector#
Fix incorrect result when using BigQuery
time
type. (#8999)
Cassandra connector#
ClickHouse connector#
Druid connector#
Allow limiting the size of the metadata cache via the
metadata.cache-maximum-size
configuration property. (#8652)
Elasticsearch connector#
Add support for reading fields as
json
values. (#7308)
Hive connector#
Expose
<view>$properties
system 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_timestamp
function. (#8502)Add support for translating Hive views which use the
date
function. (#8789)Add support for translating Hive views which use the
pmod
function. (#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.path
table 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-location
configuration 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-size
configuration property. (#8652)
MongoDB connector#
Add
timestamp_objectid()
function. (#8824)Enable
mongodb.socket-keep-alive
config property by default. (#8832)
MySQL connector#
Oracle connector#
Allow limiting the size of the metadata cache via the
metadata.cache-maximum-size
configuration property. (#8652)
Phoenix connector#
Allow limiting the size of the metadata cache via the
metadata.cache-maximum-size
configuration property. (#8652)
Pinot connector#
Implement aggregation pushdown for
count
,avg
,min
,max
,sum
,count(DISTINCT)
andapprox_distinct
. It is enabled by default and can be disabled using the configuration propertypinot.aggregation-pushdown.enabled
or the catalog session propertyaggregation_pushdown_enabled
. (#4140)Allow
https
URLs inpinot.controller-urls
. (#8617)Fix failures when querying
information_schema.columns
with a filter on the table name. (#8307)
PostgreSQL connector#
Redshift connector#
Allow limiting the size of the metadata cache via the
metadata.cache-maximum-size
configuration property. (#8652)