Disable Dynamic Filtering | QueryGrid - Disabling Dynamic Filtering - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem
When using subqueries that could make a conditional query false, regardless of the contents of any rows from its FROM clause, Presto initiator queries can get stuck running continuously. Disabling the dynamic filtering can help avoid problems when using subqueries.
Example query that can be problematic when enable_dynamic_filtering is not disabled:
select * from remote_table where col1 = (select null);
  1. [Optional] To avoid any risk of queries getting stuck, Teradata recommends doing one of the following if you anticipate using subqueries that could trivialize a WHERE clause:
    • Set the session property enable_dynamic_filtering to false
    • Add the following line to the Presto config.properties file:

      experimental.enable_dynamic_filtering=false