11.48. Release 0.182

General Changes

Fix correctness issue that causes corr() to return positive numbers for inverse correlations.
Fix the EXPLAIN query plan for tables that are partitionedon TIMESTAMP or DATE columns.
Fix query failure when when using certain window functions that take arrays or maps as arguments (e.g., approx_percentile()).
Implement subtraction for all TIME and TIMESTAMP types.
Improve planning performance for queries that join multiple tables witha large number columns.
Improve the performance of joins with only non-equality conditions by usinga nested loops join instead of a hash join.
Improve the performance of casting from JSON to ARRAY or MAP types.
Add a new IPADDRESS type to represent IP addresses.
Add to_milliseconds() function to convert intervals (day to second) to milliseconds.
Add support for column aliases in CREATE TABLE AS statements.
Add a config option to reject queries during cluster initialization.Queries are rejected if the active worker count is less than thequery-manager.initialization-required-workers property while thecoordinator has been running for less than query-manager.initialization-timeout.
Add TPCDS Connector. This connector provides a set of schemas tosupport the TPC Benchmark™ DS (TPC-DS).

Fix an issue that would sometimes prevent queries from being cancelled when exiting from the pager.

Fix reading decimal values in the optimized Parquet reader when they are backedby the int32 or int64 types.
Add a new experimental ORC writer implementation optimized for Presto.We have some upcoming improvements, so we recommend waiting a few releases beforeusing this in production. The new writer can be enabled with thehive.orc.optimized-writer.enabled configuration property or with theorc_optimized_writer_enabled session property.