Release 357 (21 May 2021)#
General#
- Add support for subquery expressions that return multiple columns. Example: - SELECT x = (VALUES (1, 'a'))(#7773, #7863)
- Allow aggregation pushdown when - COUNT(1)is used with- GROUP BY. (#7251)
- Add support for - CURRENT_CATALOGand- CURRENT_SCHEMA. (#7824)
- Add - format_number()function. (#1878)
- Change - rowto- jsoncast to produce JSON objects instead of JSON arrays. This behavior can be restored with the- deprecated.legacy-row-to-json-castconfiguration option. (#3536)
- Print dynamic filters summary in - EXPLAIN ANALYZE. (#7874)
- Improve performance for queries using - INpredicate with a short list of constants. (#7840)
- Release memory immediately when queries involving window functions fail. (#7947) 
- Fix incorrect handling of row expressions for - INpredicates, quantified comparisons and scalar subqueries. Previously, the queries would succeed where they should have failed with a type mismatch error. (#7797)
- Fix failure when using - PREPAREwith a- GRANTstatement that contains quoted SQL keywords. (#7941)
- Fix cluster instability after executing certain large - EXPLAINqueries. (#8017)
Security#
- Enforce materialized view creator security policies when view is fresh. (#7618) 
- Use system truststore for OAuth2 and JWK for JWT authentication. Previously, the truststore configured for internal communication was used. This means that globally trusted certificates will work by default. (#7936) 
- Fix handling of SNI for multiple TLS certificates. (#8007) 
Web UI#
- Make the UI aware of principal-field (configured with - http-server.authentication.oauth2.principal-field) when- web-ui.authentication.typeis set to- oauth2. (#7526)
JDBC driver#
CLI#
- Add - clearcommand to clear the screen. (#7632)
BigQuery connector#
ClickHouse connector#
Elasticsearch connector#
Kinesis connector#
- Add - kinesis.table-description-refresh-intervalconfiguration property to set the refresh interval for fetching table descriptions from S3. (#1609)
Kudu connector#
- Fix query failures for grouped execution on range partitioned tables. (#7738) 
MongoDB connector#
Pinot connector#
- Add support for complex filter expressions in passthrough queries. (#7161) 
Other connectors#
This change applies to the Druid, MemSQL, MySQL, Oracle, Phoenix, PosgreSQL, Redshift, and SQL Server connectors.
- Add rule support for identifier mapping. The rules can be configured via the - case-insensitive-name-matching.config-fileconfiguration property. (#7841)