Release 0.142#
General#
- Fix planning bug for - JOINcriteria that optimizes to a- FALSEexpression.
- Fix planning bug when the output of - UNIONdoesn’t match the table column order in- INSERTqueries.
- Fix error when - ORDER BYclause in window specification refers to the same column multiple times.
- Add support for complex grouping operations - - CUBE,- ROLLUPand- GROUPING SETS.
- Add support for - IF NOT EXISTSin- CREATE TABLE ASqueries.
- Add - substring()function.
- Add - http.server.authentication.krb5.keytabconfig option to set the location of the Kerberos keytab file explicitly.
- Add - optimize_metadata_queriessession property to enable the metadata-only query optimization.
- Improve support for non-equality predicates in - JOINcriteria.
- Add support for non-correlated subqueries in aggregation queries. 
- Improve performance of - json_extract().
Hive#
- 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-formatconfig option was being ignored.
- Add hive.compression-codec config option to control compression used when writing. The default is now - GZIPfor all formats.
- Collect and expose end-to-end execution time JMX metric for requests to AWS services.