docs/build/plain-html/topics/impala_resource_trace_ratio.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="RESOURCE_TRACE_RATIO Query Option (Impala 3.2 or higher only)" />
 <meta name="DC.Relation" scheme="URI" content="../topics/impala_set.html" />
 <meta name="prodname" content="Impala" />
 <meta name="version" content="Impala 3.4.x" />
 <meta name="DC.Format" content="XHTML" />
 <meta name="DC.Identifier" content="resource_trace_ratio" />
 <link rel="stylesheet" type="text/css" href="../commonltr.css" />
 <title>RESOURCE_TRACE_RATIO Query Option (Impala 3.2 or higher only)</title>
 </head>
 <body id="resource_trace_ratio">


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


   <div class="body conbody">

     <p class="p">
       The <code class="ph codeph">RESOURCE_TRACE_RATIO</code> query option specifies the ratio of queries
       where the CPU usage info will be included in the profiles. Collecting CPU usage and
       sending it around adds a slight overhead during query execution. This query option lets
       you control whether to collect additional information to diagnose the resource usage.
     </p>


     <p class="p">
       For example, setting <code class="ph codeph">RESOURCE_TRACE_RATIO=1</code> adds a trace of the CPU usage
       to the profile of each query.
     </p>


     <p class="p">
       Setting <code class="ph codeph">RESOURCE_TRACE_RATIO=0.5</code> means that randomly selected half of all
       queries will have that information collected by the coordinator and included in the
       profiles.
     </p>


     <p class="p">
       Setting <code class="ph codeph">RESOURCE_TRACE_RATIO=0</code> means that CPU usage will not be tracked
       and included in the profiles.
     </p>


     <p class="p">
       Values from 0 to 1 are allowed.
     </p>


     <p class="p">
       <strong class="ph b">Type:</strong> Number
     </p>


     <p class="p">
       <strong class="ph b">Default:</strong> 0
     </p>


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


   </div>


 <div class="related-links">
 <div class="familylinks">
 <div class="parentlink"><strong>Parent topic:</strong> <a class="link" href="../topics/impala_set.html">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="RESOURCE_TRACE_RATIO Query Option (Impala 3.2 or higher only)" />
	<meta name="DC.Relation" scheme="URI" content="../topics/impala_set.html" />
	<meta name="prodname" content="Impala" />
	<meta name="version" content="Impala 3.4.x" />
	<meta name="DC.Format" content="XHTML" />
	<meta name="DC.Identifier" content="resource_trace_ratio" />
	<link rel="stylesheet" type="text/css" href="../commonltr.css" />
	<title>RESOURCE_TRACE_RATIO Query Option (Impala 3.2 or higher only)</title>
	</head>
	<body id="resource_trace_ratio">


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






	<div class="body conbody">

	<p class="p">
	The <code class="ph codeph">RESOURCE_TRACE_RATIO</code> query option specifies the ratio of queries
	where the CPU usage info will be included in the profiles. Collecting CPU usage and
	sending it around adds a slight overhead during query execution. This query option lets
	you control whether to collect additional information to diagnose the resource usage.
	</p>


	<p class="p">
	For example, setting <code class="ph codeph">RESOURCE_TRACE_RATIO=1</code> adds a trace of the CPU usage
	to the profile of each query.
	</p>


	<p class="p">
	Setting <code class="ph codeph">RESOURCE_TRACE_RATIO=0.5</code> means that randomly selected half of all
	queries will have that information collected by the coordinator and included in the
	profiles.
	</p>


	<p class="p">
	Setting <code class="ph codeph">RESOURCE_TRACE_RATIO=0</code> means that CPU usage will not be tracked
	and included in the profiles.
	</p>


	<p class="p">
	Values from 0 to 1 are allowed.
	</p>


	<p class="p">
	<strong class="ph b">Type:</strong> Number
	</p>


	<p class="p">
	<strong class="ph b">Default:</strong> 0
	</p>


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


	</div>


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