Release 0.175#
General#
- Fix “position is not valid” query execution failures. 
- Fix memory accounting bug that can potentially cause - OutOfMemoryError.
- Fix regression that could cause certain queries involving - UNIONand- GROUP BYor- JOINto fail during planning.
- Fix planning failure for - GROUP BYqueries containing correlated subqueries in the- SELECTclause.
- Fix execution failure for certain - DELETEqueries.
- Reduce occurrences of “Method code too large” errors. 
- Reduce memory utilization for certain queries involving - ORDER BY.
- Improve performance of map subscript from O(n) to O(1) when the map is produced by an eligible operation, including the map constructor and Hive readers (except ORC and optimized Parquet). More read and write operations will take advantage of this in future releases. 
- Add - enable_intermediate_aggregationssession property to enable the use of intermediate aggregations within un-grouped aggregations.
- Add support for - INTERVALdata type to- avg()and- sum()aggregation functions.
- Add support for - INTas an alias for the- INTEGERdata type.
- Add resource group information to query events. 
Hive#
- Make table creation metastore operations idempotent, which allows recovery when retrying timeouts or other errors. 
MongoDB#
- Rename - mongodb.connection-per-hostconfig option to- mongodb.connections-per-host.