presto-docs/src/main/sphinx/release/release-0.297.rst
/connector/hive-security for details on how to allow them. #26803 <https://github.com/prestodb/presto/pull/26803>_#26926 <https://github.com/prestodb/presto/pull/26926>_predicate stitching <admin/materialized-views:Predicate Stitching (USE_STITCHING Mode)> in MaterializedViewRewrite. #26728 <https://github.com/prestodb/presto/pull/26728>_transaction <connector/iceberg:Transaction support> on snapshot isolation level. #25003 <https://github.com/prestodb/presto/pull/25003>_MERGE command in the Iceberg connector. #25470 <https://github.com/prestodb/presto/pull/25470>_/sql/create-vector-index, which creates vector search indexes on table columns with configurable index properties and partition filtering using an UPDATING FOR clause. #27307 <https://github.com/prestodb/presto/pull/27307>_/connector/lance for reading and writing LanceDB datasets. #27185 <https://github.com/prestodb/presto/pull/27185>_#26879 <https://github.com/prestodb/presto/pull/26879>_General Changes
DESCRIBE and SHOW COLUMNS queries hanging in PLANNING state on clusters with single-node execution enabled. #27456 <https://github.com/prestodb/presto/pull/27456>_EXPLAIN TYPE IO to support columns with temporal types. #26942 <https://github.com/prestodb/presto/pull/26942>_#27059 <https://github.com/prestodb/presto/pull/27059>_DEFINER rights to require CREATE_VIEW_WITH_SELECT_COLUMNS on base tables. #26902 <https://github.com/prestodb/presto/pull/26902>_experimental.max-total-running-task-count-to-not-execute-new-query) is enabled. #27146 <https://github.com/prestodb/presto/pull/27146>_#26639 <https://github.com/prestodb/presto/pull/26639>_LIKE '%substring%' pattern matching by rewriting to STRPOS instead of CARDINALITY(SPLIT(...)), improving CPU and memory efficiency. #27311 <https://github.com/prestodb/presto/pull/27311>_UNNEST by adding a PushdownThroughUnnest optimizer rule that pushes projections and filter through the unnest when possible. This rule is controlled using the pushdown_through_unnest session property (default enabled). #27125 <https://github.com/prestodb/presto/pull/27125>_MIN, MAX, ARBITRARY, or APPROX_DISTINCT to a constant input by replacing them with the constant directly. Controlled by the simplify_aggregations_over_constant session property (disabled by default). #27246 <https://github.com/prestodb/presto/pull/27246>_IN) queries where the probe/source side is a UNION by pushing the join through the union. Controlled by the optimizer.push-semi-join-through-union configuration property or the push_semi_join_through_union session property (disabled by default). #27176 <https://github.com/prestodb/presto/pull/27176>_#26941 <https://github.com/prestodb/presto/pull/26941>_IF expressions IF(x, IF(y, v, E), E) to IF(x AND y, v, E) when the outer and inner else branches are identical. Handles arbitrary nesting depth and both null and non-null else branches. #27267 <https://github.com/prestodb/presto/pull/27267>_#27188 <https://github.com/prestodb/presto/pull/27188>_pre_aggregate_before_grouping_sets. #27290 <https://github.com/prestodb/presto/pull/27290>_COALESCE expressions over join keys by simplifying them based on join type, enabling bucketed join optimizations. Controlled by the simplify_coalesce_over_join_keys session property (disabled by default). #27250 <https://github.com/prestodb/presto/pull/27250>_CREATE BRANCH. #26898 <https://github.com/prestodb/presto/pull/26898>_#23614 <https://github.com/prestodb/presto/pull/23614>_#23614 <https://github.com/prestodb/presto/pull/23614>_admin/properties:\`resource-manager.http-server-enabled`` and :ref:admin/properties:``internal-communication.resource-manager-communication-protocol``. #26635 https://github.com/prestodb/presto/pull/26635`_/develop/openlineage-event-listener for configuration details. #27249 <https://github.com/prestodb/presto/pull/27249>_USE_STITCHING mode for materialized_view_stale_read_behavior session property to selectively recompute stale data instead of full recomputation. #26728 <https://github.com/prestodb/presto/pull/26728>_materialized_view_force_stale session property for testing stale read behavior. #26728 <https://github.com/prestodb/presto/pull/26728>_materialized_view_staleness_window session property to configure acceptable staleness duration. #26728 <https://github.com/prestodb/presto/pull/26728>_http-server.https.keystore.scan-interval-seconds configuration flag to scan the keystore file periodically for new certs. #26739 <https://github.com/prestodb/presto/pull/26739>_webui-enabled configuration property. #26682 <https://github.com/prestodb/presto/pull/26682>_/admin/jmx-metrics for metadata operations. #26875 <https://github.com/prestodb/presto/pull/26875>_admin/properties-session:\`materialized_view_stale_read_behavior`` session property and :ref:admin/properties:``materialized-view-stale-read-behavior``configuration property.#26764 https://github.com/prestodb/presto/pull/26764`_materialized_view_query_rewrite_cost_based_selection_enabled session property. #27222 <https://github.com/prestodb/presto/pull/27222>_#26794 <https://github.com/prestodb/presto/pull/26794>_admin/properties:\`optimizer.remote-function-names-for-fixed-parallelism``configuration property to control the number of tasks for remote project node.#27044 https://github.com/prestodb/presto/pull/27044`_optimizer.skip-pushdown-through-exchange-for-remote-projection configuration property or the skip_pushdown_through_exchange_for_remote_projection session property (disabled by default). #26943 <https://github.com/prestodb/presto/pull/26943>_America/Coyhaique timezone (Chile's Aysén Region). #26981 <https://github.com/prestodb/presto/pull/26981>_CREATE TABLE AS SELECT and INSERT from materialized views. #27227 <https://github.com/prestodb/presto/pull/27227>_/sql/create-vector-index, which creates vector search indexes on table columns with configurable index properties and partition filtering using an UPDATING FOR clause. #27307 <https://github.com/prestodb/presto/pull/27307>_materialized_views table to the information schema. #26688 <https://github.com/prestodb/presto/pull/26688>_CREATE TABLE AS SELECT with IF NOT EXISTS. #27083 <https://github.com/prestodb/presto/pull/27083>_ADD COLUMN DEFAULT. #27353 <https://github.com/prestodb/presto/pull/27353>_WHEN MATCHED THEN DELETE clause in MERGE INTO statements, completing the SQL:2011 MERGE specification. #27409 <https://github.com/prestodb/presto/pull/27409>_CTAS and INSERT statements. #27302 <https://github.com/prestodb/presto/pull/27302>_CREATE TAG. #27113 <https://github.com/prestodb/presto/pull/27113>_experimental.max-total-running-task-count-to-not-execute-new-query with :ref:admin/properties:\`max-total-running-task-count-to-not-execute-new-query``. This is backwards compatible. #27146 https://github.com/prestodb/presto/pull/27146`_#26926 <https://github.com/prestodb/presto/pull/26926>_#26981 <https://github.com/prestodb/presto/pull/26981>_Prestissimo (Native Execution) Changes
rank and dense_rank functions. Use session property :ref:presto_cpp/properties-session:\`optimizer.optimize_top_n_rank``to enable the rewrite.#24138 https://github.com/prestodb/presto/pull/24138`_TEXTFILE format. #25995 <https://github.com/prestodb/presto/pull/25995>_native_max_target_file_size session property to control the maximum target file size for writers. When a file exceeds this size during writing, the writer will close the current file and start writing to a new file. See :ref:connector/hive:hive session properties. #27054 <https://github.com/prestodb/presto/pull/27054>_presto_cpp/properties-session:\`native_aggregation_compaction_bytes_threshold`` and :ref:presto_cpp/properties-session:``native_aggregation_compaction_unused_memory_ratio``session properties to control string compaction during global aggregation.#26874 https://github.com/prestodb/presto/pull/26874`_presto_cpp/properties-session:\`native_merge_join_output_batch_start_size``session property to control the initial output batch size for merge joins, with optional dynamic adjustment based on observed row sizes (disabled by default).#27086 https://github.com/prestodb/presto/pull/27086`_#24602 <https://github.com/prestodb/presto/pull/24602>_presto_cpp.worker_runtime_uptime_secs to track worker process runtime. #26979 <https://github.com/prestodb/presto/pull/26979>_v1/expressions in sidecar for expression optimization. See :doc:/presto_cpp/sidecar. #26475 <https://github.com/prestodb/presto/pull/26475>_presto_cpp/properties:\`ssd-cache-max-entries``configuration property to limit SSD cache entries and prevent unbounded metadata memory growth (default value: 10M entries, ~500MB metadata).#26795 https://github.com/prestodb/presto/pull/26795`_Security Changes
img-src 'http: https:' in response to CWE-693 <https://cwe.mitre.org/data/definitions/693.html>. #26790 <https://github.com/prestodb/presto/pull/26790>hive.restrict-procedure-call for ranger and sql-standard access control. It defaults to true, meaning procedure calls are restricted. To allow procedure calls, set this configuration property to false. #26803 <https://github.com/prestodb/presto/pull/26803>_#26803 <https://github.com/prestodb/presto/pull/26803>_#26803 <https://github.com/prestodb/presto/pull/26803>_CVE-2025-67721 <https://www.cve.org/CVERecord?id=CVE-2025-67721>. #27152 <https://github.com/prestodb/presto/pull/27152>CVE-2024-53990 <https://github.com/advisories/GHSA-mfj5-cf8g-g2fv>_ and CVE-2025-12183 <https://github.com/advisories/GHSA-vqf4-7m7x-wgfc>. #26820 <https://github.com/prestodb/presto/pull/26820>CVE-2026-33871 <https://github.com/advisories/GHSA-w9fj-cfpg-grvv>_ and CVE-2025-67735 <https://github.com/advisories/GHSA-84h7-rjj3-6jx4>. #27464 <https://github.com/prestodb/presto/pull/27464>CVE-2025-66453 <https://github.com/advisories/GHSA-3w8q-xq97-5j7x>. #26820 <https://github.com/prestodb/presto/pull/26820>flatted from 3.3.3 to 3.4.2 in response to GHSA-rf6f-7fwh-wjgh <https://github.com/WebReflection/flatted/security/advisories/GHSA-rf6f-7fwh-wjgh>_ addressing a HIGH severity prototype pollution vulnerability ( CWE-1321 <https://cwe.mitre.org/data/definitions/1321.html>_ ) in the parse() function. This dependency is used by the UI development tooling and does not affect production runtime. #27402 <https://github.com/prestodb/presto/pull/27402>_handlebars from 4.7.8 to 4.7.9 in response to multiple security advisories including GHSA-2w6w-674q-4c4q <https://github.com/handlebars-lang/handlebars.js/security/advisories/GHSA-2w6w-674q-4c4q>, GHSA-3mfm-83xf-c92r <https://github.com/handlebars-lang/handlebars.js/security/advisories/GHSA-3mfm-83xf-c92r>, GHSA-xhpv-hc6g-r9c6 <https://github.com/handlebars-lang/handlebars.js/security/advisories/GHSA-xhpv-hc6g-r9c6>, GHSA-xjpj-3mr7-gcpf <https://github.com/handlebars-lang/handlebars.js/security/advisories/GHSA-xjpj-3mr7-gcpf>, GHSA-9cx6-37pm-9jff <https://github.com/handlebars-lang/handlebars.js/security/advisories/GHSA-9cx6-37pm-9jff>, GHSA-2qvq-rjwj-gvw9 <https://github.com/handlebars-lang/handlebars.js/security/advisories/GHSA-2qvq-rjwj-gvw9>, GHSA-7rx3-28cr-v5wh <https://github.com/handlebars-lang/handlebars.js/security/advisories/GHSA-7rx3-28cr-v5wh>, and GHSA-442j-39wm-28r2 <https://github.com/handlebars-lang/handlebars.js/security/advisories/GHSA-442j-39wm-28r2>. This dependency is used by the ts-jest testing framework and does not affect production runtime. #27447 <https://github.com/prestodb/presto/pull/27447>_webpack from 5.97.1 to 5.104.1 to address security vulnerabilities including a user information bypass in HttpUriPlugin and SSRF prevention improvements. This is a development dependency used for building the Presto UI and does not affect production runtime. #27105 <https://github.com/prestodb/presto/pull/27105>_CVE-2025-69873 <https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2025-69873>. #27154 <https://github.com/prestodb/presto/pull/27154>CVE-2020-26237 <https://github.com/advisories/GHSA-vfrc-7r7c-w9mx>. #26907 <https://github.com/prestodb/presto/pull/26907>CVE-2025-13465 <https://github.com/advisories/GHSA-xxjr-mmjv-4gpg>. #27009 <https://github.com/prestodb/presto/pull/27009>CVE-2025-13465 <https://github.com/advisories/GHSA-xxjr-mmjv-4gpg>. #27051 <https://github.com/prestodb/presto/pull/27051>CVE-2025-66566 <https://nvd.nist.gov/vuln/detail/CVE-2025-66566>_ and CVE-2025-12183 <https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2025-12183>. #26931 <https://github.com/prestodb/presto/pull/26931>CVE-2025-59250 <https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2025-59250>. #26674 <https://github.com/prestodb/presto/pull/26674>CVE-2026-33891 <https://www.cve.org/CVERecord?id=CVE-2026-33891>_ (DoS in BigInteger.modInverse), CVE-2026-33894 <https://www.cve.org/CVERecord?id=CVE-2026-33894>_ (RSA-PKCS signature forgery), CVE-2026-33895 <https://www.cve.org/CVERecord?id=CVE-2026-33895>_ (Ed25519 signature forgery), and CVE-2026-33896 <https://www.cve.org/CVERecord?id=CVE-2026-33896>_ (basicConstraints bypass in certificate chain verification). This dependency is used by webpack-dev-server for development and does not affect production runtime. #27448 <https://github.com/prestodb/presto/pull/27448>_CVE-2025-68161 <https://nvd.nist.gov/vuln/detail/CVE-2025-68161>. #26885 <https://github.com/prestodb/presto/pull/26885>Access-Control-Allow-Origin header validation for cross-origin requests and restricts WebSocket connections from IP addresses in the Origin header unless explicitly configured using allowedHosts. This dependency is used for local development only and does not affect production runtime. #26275 <https://github.com/prestodb/presto/pull/26275>_CVE-2026-24281 <https://github.com/advisories/GHSA-7xrh-hqfc-g7qr>, CVE-2026-24308 <https://github.com/advisories/GHSA-crhr-qqj8-rpxc>. #27319 <https://github.com/prestodb/presto/pull/27319>_CVE-2025-5115 <https://nvd.nist.gov/vuln/detail/CVE-2025-5115>. #26739 <https://github.com/prestodb/presto/pull/26739>Web UI Changes
MERGE statement in the Presto SQL Client web app. #26825 <https://github.com/prestodb/presto/pull/26825>_Cassandra Connector Changes
#27100 <https://github.com/prestodb/presto/pull/27100>_Delta Lake Connector Changes
SHOW CREATE TABLE command. #26986 <https://github.com/prestodb/presto/pull/26986>_#26670 <https://github.com/prestodb/presto/pull/26670>_Druid Connector Changes
#26723 <https://github.com/prestodb/presto/pull/26723>_Hive Connector Changes
textfile_field_delim, textfile_escape_delim, textfile_collection_delim, and textfile_mapkey_delim. #27167 <https://github.com/prestodb/presto/pull/27167>_#26918 <https://github.com/prestodb/presto/pull/26918>_skip_header_line_count and skip_footer_line_count. See :ref:connector/hive:avro configuration properties. #26446 <https://github.com/prestodb/presto/pull/26446>_#26670 <https://github.com/prestodb/presto/pull/26670>_Hudi Connector Changes
#26670 <https://github.com/prestodb/presto/pull/26670>_Iceberg Connector Changes
#23645 <https://github.com/prestodb/presto/pull/23645>_INSERT operations into Iceberg V3 tables. #27021 <https://github.com/prestodb/presto/pull/27021>_$metadata_log_entries. #24302 <https://github.com/prestodb/presto/pull/24302>_CREATE BRANCH support for Iceberg. #26898 <https://github.com/prestodb/presto/pull/26898>_iceberg.materialized-view-max-changed-partitions config property (default: 100) to limit partition tracking for predicate stitching. #26728 <https://github.com/prestodb/presto/pull/26728>_stale_read_behavior and staleness_window table properties for materialized views. See :ref:connector/iceberg:table properties. #26764 <https://github.com/prestodb/presto/pull/26764>_#27021 <https://github.com/prestodb/presto/pull/27021>_connector/iceberg:rewrite manifests procedure for Iceberg. #26888 <https://github.com/prestodb/presto/pull/26888>_transaction <connector/iceberg:Transaction support> on snapshot isolation level. #25003 <https://github.com/prestodb/presto/pull/25003>_MERGE command in the Iceberg connector. #25470 <https://github.com/prestodb/presto/pull/25470>_connector/iceberg:materialized views in Iceberg catalog. #26958 <https://github.com/prestodb/presto/pull/26958>_SMALLINT and TINYINT columns by mapping them to Iceberg INTEGER type. #27461 <https://github.com/prestodb/presto/pull/27461>_iceberg.security property in the Iceberg catalog properties file. The supported types are allow-all and file. See :ref:connector/iceberg:authorization. #26803 <https://github.com/prestodb/presto/pull/26803>_3. #27021 <https://github.com/prestodb/presto/pull/27021>_#23614 <https://github.com/prestodb/presto/pull/23614>_#23614 <https://github.com/prestodb/presto/pull/23614>_#26918 <https://github.com/prestodb/presto/pull/26918>_#27147 <https://github.com/prestodb/presto/pull/27147>_#26728 <https://github.com/prestodb/presto/pull/26728>_#27021 <https://github.com/prestodb/presto/pull/27021>_ADD COLUMN DEFAULT. #27353 <https://github.com/prestodb/presto/pull/27353>_#26374 <https://github.com/prestodb/presto/pull/26374>_rewrite_data_files <connector/iceberg:Rewrite Data Files> procedure in Iceberg connector. #26374 <https://github.com/prestodb/presto/pull/26374>_CREATE TAG support for Iceberg. #27113 <https://github.com/prestodb/presto/pull/27113>_#26670 <https://github.com/prestodb/presto/pull/26670>_#26879 <https://github.com/prestodb/presto/pull/26879>_#26879 <https://github.com/prestodb/presto/pull/26879>_#26879 <https://github.com/prestodb/presto/pull/26879>_Lance Connector Changes
#27324 <https://github.com/prestodb/presto/pull/27324>_/connector/lance for reading and writing LanceDB datasets. #27185 <https://github.com/prestodb/presto/pull/27185>_Pinot Connector Changes
#26151 <https://github.com/prestodb/presto/pull/26151>_#26725 <https://github.com/prestodb/presto/pull/26725>_#26684 <https://github.com/prestodb/presto/pull/26684>_SPI Changes
Connector.beginTransaction in a backward compatible way to support passing the autocommit context into connector transactions. #25003 <https://github.com/prestodb/presto/pull/25003>_Documentation Changes
functions/plugin-loaded-functions:array functions. #26926 <https://github.com/prestodb/presto/pull/26926>_/develop/table-functions. #27367 <https://github.com/prestodb/presto/pull/27367>_/functions/table. #27333 <https://github.com/prestodb/presto/pull/27333>_/presto_cpp/limitations. #27120 <https://github.com/prestodb/presto/pull/27120>_Aditi Pandit, Adrian Carpente (Denodo), Ajay Kharat, Alexey Matskoff, Allen Shen, Amit Dutta, Anant Aneja, Andrii Rosa, Apurva Kumar, Artem Selishchev, Auden Woolfson, Beinan, Chandrakant Vankayalapati, Chandrashekhar Kumar Singh, Christian Zentgraf, Deepak Majeti, Deepak Mehra, Denis Krivenko, Dilli-Babu-Godari, Dong Wang, Garima Uttam, Ge Gao, Han Yan, HeidiHan0000, Henry Dikeman, Ishaan Bansal, Ivan Ponomarev, Jalpreet Singh Nanda, Jay Feldblum, Jay Narale, Jiaqi Zhang, Joe Abraham, KNagaVivek, Karthikeyan, Ke, Ke Wang, Kevin Tang, Kiersten Stokes, Kyle Wong, Li, LingBin, Linsong Wang, Lithin Purushothaman, Madhavan, Maria Basmanova, Mariam AlMesfer, Matt Karrmann, Miguel Blanco Godón, Namya Sehgal, Natasha Sehgal, Naveen Mahadevuni, Nikhil Collooru, Nivin C S, PRASHANT GOLASH, Pedro Pedreira, Ping Liu, Prabhu Shankar, Pradeep Vaka, Pramod Satya, Pratik Joseph Dabre, Pratik Pugalia, Pratyaksh Sharma, Reetika Agrawal, Rui Mo, Saurabh Mahawar, Sayari Mukherjee, Sergey Pershin, Shahim Sharafudeen, Shang Ma, Shrinidhi Joshi, Simon Eves, Sreeni Viswanadha, Steve Burnett, Swapnil, Timothy Meehan, Vrindha Ramachandran, Vyacheslav Andreykiv, Wei He, XiaoDu, Xiaoxuan, Xin Zhang, Yihong Wang, Ying, Zac, adheer-araokar, bibith4, dependabot[bot], feilong-liu, iahs, inf, jja725, jkhaliqi, lexprfuncall, maniloya, mohsaka, nishithakbhaskaran, rdtr, shelton408, sumi-mathew, tanjialiang