presto-docs/src/main/sphinx/release/release-0.286.rst
General Changes
min_by and max_by for window functions, where results are incorrect when the function specifies number of elements to keep and the window does not have “unbounded following” in the frame. :pr:21793EXCEPT and INTERSECT queries by not pruning unreferenced output for intersect and except nodes in the PruneUnreferencedOutputs rule. :pr:21343214072134419741limit-khyperloglog-agg-group-number-enabled to control whether to limit the number of groups for aggregation functions using KHyperLogLog state. (enabled by default) :pr:2182421580/plugin/redis-hbo-provider documentation to include the correct configuration properties and added documentation for coordinator HBO configurations. :pr:2147721626adaptive_partial_aggregation (disabled by default) :pr:2097921353214862163021435skip_hash_generation_for_join_with_table_scan_input to skip hash precomputation for join when the input is table scan, and the hash is on a single big int and is not reused later. The property defaults to not enabled. :pr:20948khyperloglog-agg-group-limit to limit the maximum number of groups that khyperloglog_agg function can have. The query will fail when the limit is exceeded. (The default is 0 which means no limit). :pr:21510limit-khyperloglog-agg-group-number-enabled to control whether to limit the number of groups for aggregation functions using KHyperLogLog state. :pr:21824rewrite_expression_with_constant_expression which defaults to enabled. This optimizes queries which have an equivalence check filter or constant assignments. :pr:19836rewrite_left_join_array_contains_to_equi_join that transforms left joins with an ARRAY CONTAINS condition in the join criteria into an equi join. :pr:21420GHSA-xm7x-f3w2-4hjm <https://github.com/prestodb/presto/security/advisories/GHSA-xm7x-f3w2-4hjm>_. :pr:21024config.properties and jvm.config files. :pr:21384hadoop-apache2 to 2.7.4-12. This fixes errors like library not found: /nativelib/Linux-aarch64/libhadoop.so when running presto on ARM64. :pr:2148321101Ecosystem </ecosystem/list> documentation. :pr:21698cte_hash_partition_count session property to specify the number of buckets or writers to be used when using CTE Materialization. :pr:21625/installation/deploy-helm to Installation documentation. :pr:2181221371$changelog that allows users to track when records were added or deleted in snapshots. :pr:20937reservoir_sample <../functions/aggregate.html#reservoir_sample>_ aggregation function which is useful for generating fixed-size samples. :pr:21296exchange.async-page-transport-enabled configuration property as deprecated. :pr:2177221685map_top_n_keys_by_value which returns top n keys of a map by value. :pr:2125920887SPI Changes
ConnectorPlanOptimizer.optimize. :pr:21605Hive Connector Changes
parquet_use_column_names session property was set. :pr:2164721549hive.s3.use-instance-credentials as deprecated. :pr:21648Hudi Connector Changes
21012Iceberg Connector Changes
2171420501iceberg.pushdown-filter-enabled config property to Iceberg Connector. This config property controls the behaviour of Filter Pushdown in the Iceberg connector. :pr:20501register <../connector/iceberg.html#register-table>_ and unregister <../connector/iceberg.html#unregister-table>_ procedures for Iceberg tables. :pr:21335iceberg.delete_as_join_rewrite_enabled (enabled by default) to apply equality deletes as a join. :pr:21605"$data_sequence_number" which returns the Iceberg data sequence number of the file containing the row. :pr:21605"$path" which returns the file path containing the row. :pr:216052118921303213032157521629time travel <../connector/iceberg.html#time-travel-using-version-system-version-and-timestamp-system-time>_, enabling the retrieval of historical data with the AS OF syntax. :pr:21425time travel <../connector/iceberg.html#time-travel-using-version-system-version-and-timestamp-system-time>_ TIMESTAMP (SYSTEM_TIME) syntax includes timestamp-with-time-zone data type. It will return data based on snapshot with matching timestamp or before. :pr:21425time travel <../connector/iceberg.html#time-travel-using-version-system-version-and-timestamp-system-time>_ VERSION (SYSTEM_VERSION) syntax includes snapshot id using bigint data type. :pr:2142521399DeleteFile. :pr:216128dukongjian, AbhijitKulkarni1, Aditi Pandit, Ajay George, Ajay Gupte, Amit Dutta, Anant Aneja, Andrii Rosa, Anil Gupta Somisetty, Antoine Pultier, Arjun Gupta, Avinash Jain, Beinan, Bikramjeet Vig, Changli Liu, Christian Zentgraf, Chunxu Tang, Deepak Majeti, Diana Meehan, Facebook Community Bot, Ge Gao, Jalpreet Singh Nanda (:imjalpreet), Jason Fine, Jialiang Tan, Jimmy Lu, Jonathan Hehir, Junhao Liu, Ke, Kevin Wilfong, Krishna Pai, Linsong Wang, Luis Paolini, Lyublena Antova, Mahadevuni Naveen Kumar, Masha Basmanova, Matthew Peveler, Michael Shang, Nikhil Collooru, Nilay Pochhi, Patrick Stuedi, Paul Meng, Pedro Pedreira, Pramod, Pranjal Shankhdhar, Pratik Joseph Dabre, Reetika Agrawal, Richard Barnes, Rohit Jain, Sagar Sumit, Sergey Pershin, Sergii Druzkin, Shrinidhi Joshi, Steve Burnett, Sudheesh, Tai Le, Tim Meehan, TommyLemon, Vigneshwar Selvaraj, VishnuSanal, Vivek, Yihong Wang, Ying, Zac, Zac Blanco, Zhenxiao Luo, abhiseksaikia, feilong-liu, hainenber, jaystarshot, karteekmurthys, kedia,Akanksha, kiersten-stokes, mohsaka, pratyakshsharma, prithvip, renurajagop, rui-mo, shenhong, wangd, wypb, xiaoxmeng, xumingming