19.25. 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().

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.