12.120. Release 0.142
General Changes
- Fix planning bug for
JOIN criteria that optimizes to a FALSE expression.
- Fix planning bug when the output of
UNION doesn’t match the table column order
in INSERT queries.
- Fix error when
ORDER BY clause in window specification refers to the same column multiple times.
- Add support for complex grouping operations
-
CUBE, ROLLUP and GROUPING SETS.
- Add support for
IF NOT EXISTS in CREATE TABLE AS queries.
- Add
substring() function.
- Add
http.server.authentication.krb5.keytab config option to set the location of the Kerberos
keytab file explicitly.
- Add
optimize_metadata_queries session property to enable the metadata-only query optimization.
- Improve support for non-equality predicates in
JOIN criteria.
- Add support for non-correlated subqueries in aggregation queries.
- Improve performance of
json_extract().
Hive Changes
- Change ORC input format to report actual bytes read as opposed to estimated bytes.
- Fix cache invalidation when renaming tables.
- Fix Parquet reader to handle uppercase column names.
- Fix issue where the
hive.respect-table-format config option was being ignored.
- Add hive.compression-codec config option to control
compression used when writing. The default is now
GZIP for all formats.
- Collect and expose end-to-end execution time JMX metric for requests to AWS services.
