docs/build/plain-html/topics/impala_disable_row_runtime_filtering.html - impala - Git at Google

 <?xml version="1.0" encoding="UTF-8"?>
 <!DOCTYPE html
   PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
 <head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

 <meta name="copyright" content="(C) Copyright 2023" />
 <meta name="DC.rights.owner" content="(C) Copyright 2023" />
 <meta name="DC.Type" content="concept" />
 <meta name="DC.Title" content="DISABLE_ROW_RUNTIME_FILTERING Query Option (Impala 2.5 or higher only)" />
 <meta name="DC.Relation" scheme="URI" content="../topics/impala_query_options.html" />
 <meta name="prodname" content="Impala" />
 <meta name="prodname" content="Impala" />
 <meta name="version" content="Impala 3.4.x" />
 <meta name="version" content="Impala 3.4.x" />
 <meta name="DC.Format" content="XHTML" />
 <meta name="DC.Identifier" content="disable_row_runtime_filtering" />
 <link rel="stylesheet" type="text/css" href="../commonltr.css" />
 <title>DISABLE_ROW_RUNTIME_FILTERING Query Option (Impala 2.5 or higher only)</title>
 </head>
 <body id="disable_row_runtime_filtering">


   <h1 class="title topictitle1" id="ariaid-title1">DISABLE_ROW_RUNTIME_FILTERING Query Option (<span class="keyword">Impala 2.5</span> or higher only)</h1>


   <div class="body conbody">

     <p class="p">

       The <code class="ph codeph">DISABLE_ROW_RUNTIME_FILTERING</code> query option
       reduces the scope of the runtime filtering feature. Queries still dynamically prune
       partitions, but do not apply the filtering logic to individual rows within partitions.
     </p>


     <p class="p">
       Only applies to queries against Parquet tables. For other file formats, Impala
       only prunes at the level of partitions, not individual rows.
     </p>


     <p class="p">
         <strong class="ph b">Type:</strong> Boolean; recognized values are 1 and 0, or <code class="ph codeph">true</code> and
         <code class="ph codeph">false</code>; any other value interpreted as <code class="ph codeph">false</code>
       </p>

     <p class="p">
         <strong class="ph b">Default:</strong> <code class="ph codeph">false</code>
       </p>


     <p class="p">
         <strong class="ph b">Added in:</strong> <span class="keyword">Impala 2.5.0</span>
       </p>


     <p class="p">
         <strong class="ph b">Usage notes:</strong>
       </p>


     <p class="p">
       Impala automatically evaluates whether the per-row filters are being
       effective at reducing the amount of intermediate data. Therefore,
       this option is typically only needed for the rare case where Impala
       cannot accurately determine how effective the per-row filtering is
       for a query.
     </p>


     <p class="p">
         Because the runtime filtering feature applies mainly to resource-intensive and
         long-running queries, only adjust this query option when tuning long-running queries
         involving some combination of large partitioned tables and joins involving large tables.
       </p>


     <p class="p">
       Because this setting only improves query performance in very specific
       circumstances, depending on the query characteristics and data distribution,
       only use it when you determine through benchmarking that it improves
       performance of specific expensive queries.
       Consider setting this query option immediately before the expensive query and
       unsetting it immediately afterward.
     </p>


     <p class="p">
         <strong class="ph b">File format considerations:</strong>
       </p>


     <p class="p">
       This query option only applies to queries against HDFS-based tables
       using the Parquet file format.
     </p>


     <p class="p">
         <strong class="ph b">Kudu considerations:</strong>
       </p>


     <p class="p">
       When applied to a query involving a Kudu table, this option turns off
       all runtime filtering for the Kudu table.
     </p>


     <p class="p">
         <strong class="ph b">Related information:</strong>
       </p>

     <p class="p">
       <a class="xref" href="impala_runtime_filtering.html">Runtime Filtering for Impala Queries (Impala 2.5 or higher only)</a>,
       <a class="xref" href="impala_runtime_filter_mode.html#runtime_filter_mode">RUNTIME_FILTER_MODE Query Option (Impala 2.5 or higher only)</a>

     </p>


   </div>

 <div class="related-links">
 <div class="familylinks">
 <div class="parentlink"><strong>Parent topic:</strong> <a class="link" href="../topics/impala_query_options.html">Query Options for the SET Statement</a></div>
 </div>
 </div></body>
 </html>
	<?xml version="1.0" encoding="UTF-8"?>
	<!DOCTYPE html
	PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
	<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
	<head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

	<meta name="copyright" content="(C) Copyright 2023" />
	<meta name="DC.rights.owner" content="(C) Copyright 2023" />
	<meta name="DC.Type" content="concept" />
	<meta name="DC.Title" content="DISABLE_ROW_RUNTIME_FILTERING Query Option (Impala 2.5 or higher only)" />
	<meta name="DC.Relation" scheme="URI" content="../topics/impala_query_options.html" />
	<meta name="prodname" content="Impala" />
	<meta name="prodname" content="Impala" />
	<meta name="version" content="Impala 3.4.x" />
	<meta name="version" content="Impala 3.4.x" />
	<meta name="DC.Format" content="XHTML" />
	<meta name="DC.Identifier" content="disable_row_runtime_filtering" />
	<link rel="stylesheet" type="text/css" href="../commonltr.css" />
	<title>DISABLE_ROW_RUNTIME_FILTERING Query Option (Impala 2.5 or higher only)</title>
	</head>
	<body id="disable_row_runtime_filtering">


	<h1 class="title topictitle1" id="ariaid-title1">DISABLE_ROW_RUNTIME_FILTERING Query Option (<span class="keyword">Impala 2.5</span> or higher only)</h1>




	<div class="body conbody">

	<p class="p">

	The <code class="ph codeph">DISABLE_ROW_RUNTIME_FILTERING</code> query option
	reduces the scope of the runtime filtering feature. Queries still dynamically prune
	partitions, but do not apply the filtering logic to individual rows within partitions.
	</p>


	<p class="p">
	Only applies to queries against Parquet tables. For other file formats, Impala
	only prunes at the level of partitions, not individual rows.
	</p>


	<p class="p">
	<strong class="ph b">Type:</strong> Boolean; recognized values are 1 and 0, or <code class="ph codeph">true</code> and
	<code class="ph codeph">false</code>; any other value interpreted as <code class="ph codeph">false</code>
	</p>

	<p class="p">
	<strong class="ph b">Default:</strong> <code class="ph codeph">false</code>
	</p>


	<p class="p">
	<strong class="ph b">Added in:</strong> <span class="keyword">Impala 2.5.0</span>
	</p>


	<p class="p">
	<strong class="ph b">Usage notes:</strong>
	</p>


	<p class="p">
	Impala automatically evaluates whether the per-row filters are being
	effective at reducing the amount of intermediate data. Therefore,
	this option is typically only needed for the rare case where Impala
	cannot accurately determine how effective the per-row filtering is
	for a query.
	</p>


	<p class="p">
	Because the runtime filtering feature applies mainly to resource-intensive and
	long-running queries, only adjust this query option when tuning long-running queries
	involving some combination of large partitioned tables and joins involving large tables.
	</p>


	<p class="p">
	Because this setting only improves query performance in very specific
	circumstances, depending on the query characteristics and data distribution,
	only use it when you determine through benchmarking that it improves
	performance of specific expensive queries.
	Consider setting this query option immediately before the expensive query and
	unsetting it immediately afterward.
	</p>


	<p class="p">
	<strong class="ph b">File format considerations:</strong>
	</p>


	<p class="p">
	This query option only applies to queries against HDFS-based tables
	using the Parquet file format.
	</p>


	<p class="p">
	<strong class="ph b">Kudu considerations:</strong>
	</p>


	<p class="p">
	When applied to a query involving a Kudu table, this option turns off
	all runtime filtering for the Kudu table.
	</p>


	<p class="p">
	<strong class="ph b">Related information:</strong>
	</p>

	<p class="p">
	<a class="xref" href="impala_runtime_filtering.html">Runtime Filtering for Impala Queries (Impala 2.5 or higher only)</a>,
	<a class="xref" href="impala_runtime_filter_mode.html#runtime_filter_mode">RUNTIME_FILTER_MODE Query Option (Impala 2.5 or higher only)</a>

	</p>


	</div>

	<div class="related-links">
	<div class="familylinks">
	<div class="parentlink"><strong>Parent topic:</strong> <a class="link" href="../topics/impala_query_options.html">Query Options for the SET Statement</a></div>
	</div>
	</div></body>
	</html>