11.45. Release 0.162
Warning
The xxhash64()
function introduced in this release will return avarbinary instead of a bigint in the next release.
General Changes
- Fix correctness issue when the type of the value in the IN predicate doesnot match the type of the elements in the subquery.
- Fix correctness issue when the value on the left-hand side of an INexpression or a quantified comparison is NULL.
- Fix correctness issue when the subquery of a quantified comparison produces no rows.
- Fix correctness issue due to improper inlining of TRY arguments.
- Fix correctness issue when the right side of a JOIN produces a very large number of rows.
- Fix correctness issue for expressions with multiple nested AND and OR conditions.
- Improve performance of window functions with similar PARTITION BY clauses.
- Improve performance of certain multi-way JOINs by automatically choosing thebest evaluation order. This feature is turned off by default and can be enabledvia the reorder-joins config option or reorder_joins session property.
- Add xxhash64() and to_big_endian_64() functions.
- Add aggregated operator statistics to final query statistics.
- Allow specifying column comments for CREATE TABLE.
Hive Changes
- Fix performance regression when querying Hive tables with large numbers of partitions.
SPI Changes
- Connectors can now return optional output metadata for write operations.
- Add ability for event listeners to get connector-specific output metadata.
- Add client-supplied payload field X-Presto-Client-Info to EventListener.
原文: https://prestodb.io/docs/current/release/release-0.162.html