11.25. 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).
CLI Changes
- Fix an issue that would sometimes prevent queries from being cancelled when exiting from the pager.
Hive Changes
- 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.
原文: https://prestodb.io/docs/current/release/release-0.182.html