http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/kvgen/index.html
----------------------------------------------------------------------
diff --git a/docs/kvgen/index.html b/docs/kvgen/index.html
index 39b2e45..bf70d73 100644
--- a/docs/kvgen/index.html
+++ b/docs/kvgen/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/learn-drill-with-the-mapr-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/learn-drill-with-the-mapr-sandbox/index.html 
b/docs/learn-drill-with-the-mapr-sandbox/index.html
index 0908930..8094f30 100644
--- a/docs/learn-drill-with-the-mapr-sandbox/index.html
+++ b/docs/learn-drill-with-the-mapr-sandbox/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/lesson-1-learn-about-the-data-set/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-1-learn-about-the-data-set/index.html 
b/docs/lesson-1-learn-about-the-data-set/index.html
index 4f8f023..82e938c 100644
--- a/docs/lesson-1-learn-about-the-data-set/index.html
+++ b/docs/lesson-1-learn-about-the-data-set/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/lesson-2-run-queries-with-ansi-sql/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-2-run-queries-with-ansi-sql/index.html 
b/docs/lesson-2-run-queries-with-ansi-sql/index.html
index eb8f254..f8882f6 100644
--- a/docs/lesson-2-run-queries-with-ansi-sql/index.html
+++ b/docs/lesson-2-run-queries-with-ansi-sql/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/lesson-3-run-queries-on-complex-data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-3-run-queries-on-complex-data-types/index.html 
b/docs/lesson-3-run-queries-on-complex-data-types/index.html
index 93bada6..1027916 100644
--- a/docs/lesson-3-run-queries-on-complex-data-types/index.html
+++ b/docs/lesson-3-run-queries-on-complex-data-types/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/lexical-structure/index.html
----------------------------------------------------------------------
diff --git a/docs/lexical-structure/index.html 
b/docs/lexical-structure/index.html
index cf46d85..77915f6 100644
--- a/docs/lexical-structure/index.html
+++ b/docs/lexical-structure/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/limit-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/limit-clause/index.html b/docs/limit-clause/index.html
index f75d8fa..6a5ae54 100644
--- a/docs/limit-clause/index.html
+++ b/docs/limit-clause/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/log-and-debug-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/log-and-debug-introduction/index.html 
b/docs/log-and-debug-introduction/index.html
index 3f76ef7..1042bba 100644
--- a/docs/log-and-debug-introduction/index.html
+++ b/docs/log-and-debug-introduction/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           
@@ -1060,7 +1068,7 @@
 
     </div>
 
-     Apr 12, 2016
+     Jun 29, 2016
 
     <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
@@ -1068,18 +1076,24 @@
       
         <p>You can use the Drill logs in conjunction with query profiles to 
troubleshoot issues that you encounter. Drill uses Logback as its default 
logging system. Logback behavior is defined by configurations set in 
<code>&lt;drill_installation_directory&gt;/conf/logback.xml</code>. </p>
 
-<p>You can configure Logback to enable specific loggers for particular 
components. You can also enable Logback to output log messages to Lilith, a 
desktop application that you can use for socket logging. By default, Drill 
outputs log files to <code>/var/log/drill</code>.</p>
+<p>You can configure Logback to enable specific loggers for particular 
components. You can also enable Logback to output log messages to Lilith, a 
desktop application that you can use for socket logging. By default, Drill 
outputs log files to <code>$DRILL_HOME/logs</code>. You can edit the 
<code>DRILL_LOG_DIR</code> variable in <code>drill-env.sh</code> to change the 
location of the log directory, if needed.</p>
 
-<p>Drill provides two standard output files:  </p>
+<p>Drill outputs two standard log files:  </p>
 
 <ul>
-<li>drillbit.out</li>
-<li>drill.log</li>
+<li><code>drillbit.out</code></li>
+<li><code>drill.log</code></li>
 </ul>
 
-<p>Drill also provides a special file, drillbit_queries.json, on each Drill 
node. This log provides the QueryID and profile for every query run on a 
Drillbit. The Profile view in the Drill Web Console lists the last one-hundred 
queries that Drill ran. To see information for queries beyond the last 
one-hundred, you can view the drillbit_queries.json file on each Drill node.</p>
+<p>Drill provides a special file, <code>drillbit_queries.json</code>, on each 
Drill node. This log provides the QueryID and profile for every query run on a 
Drillbit. The Profile view in the Drill Web Console lists the last one-hundred 
queries that Drill ran. To see information for queries beyond the last 
one-hundred, you can view the <code>drillbit_queries.json</code> file on each 
Drill node.</p>
+
+<p>Drill provides <a href="/docs/query-audit-logging/">audit logging</a> of 
queries executed by various drillbits in the cluster. </p>
+
+<p>As of Drill 1.7, you can access the log files generated by the Drillbit 
process running on a particular node from the Logs page in the Drill Web 
Console. Currently, you can only see the logs for the Drillbit process running 
on the node used to access the Web Console.</p>
+
+<p>In a web browser, navigate to the Drill Web Console at 
<code>http://&lt;host_ip_address&gt;:8047</code> and click on 
<strong>Logs</strong> to access the Logs page. The Logs page provides a list of 
links that correlate with the log files stored in 
<code>$DRILL_HOME/logs</code>.  </p>
 
-<p>Drill also provides <a href="/docs/query-audit-logging/">audit logging</a> 
of queries executed by various drillbits in the cluster. </p>
+<p><img src="http://i.imgur.com/HsZ7p1H.png"; alt="Drill Web Console Logs 
page"></p>
 
     
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/log-and-debug/index.html
----------------------------------------------------------------------
diff --git a/docs/log-and-debug/index.html b/docs/log-and-debug/index.html
index cd020eb..1550e38 100644
--- a/docs/log-and-debug/index.html
+++ b/docs/log-and-debug/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           
@@ -1086,7 +1094,7 @@
       
         <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/physical-operators/">← Physical 
Operators</a></span><span class="next-toc"><a 
href="/docs/log-and-debug-introduction/">Log and Debug Introduction 
→</a></span>
+  <span class="previous-toc"><a href="/docs/monitoring-metrics/">← 
Monitoring Metrics</a></span><span class="next-toc"><a 
href="/docs/log-and-debug-introduction/">Log and Debug Introduction 
→</a></span>
 </div>
 
     

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/mapr-db-format/index.html
----------------------------------------------------------------------
diff --git a/docs/mapr-db-format/index.html b/docs/mapr-db-format/index.html
index 31cdfd1..d4be2f4 100644
--- a/docs/mapr-db-format/index.html
+++ b/docs/mapr-db-format/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/math-and-trig/index.html
----------------------------------------------------------------------
diff --git a/docs/math-and-trig/index.html b/docs/math-and-trig/index.html
index dc8ba52..fe4d242 100644
--- a/docs/math-and-trig/index.html
+++ b/docs/math-and-trig/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/migrating-parquet-data/index.html
----------------------------------------------------------------------
diff --git a/docs/migrating-parquet-data/index.html 
b/docs/migrating-parquet-data/index.html
index 8047dbc..0b0a737 100644
--- a/docs/migrating-parquet-data/index.html
+++ b/docs/migrating-parquet-data/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/modify-logback-xml/index.html
----------------------------------------------------------------------
diff --git a/docs/modify-logback-xml/index.html 
b/docs/modify-logback-xml/index.html
index fce1d34..cea4764 100644
--- a/docs/modify-logback-xml/index.html
+++ b/docs/modify-logback-xml/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/modifying-query-planning-options/index.html
----------------------------------------------------------------------
diff --git a/docs/modifying-query-planning-options/index.html 
b/docs/modifying-query-planning-options/index.html
index dc644b2..a1fd22e 100644
--- a/docs/modifying-query-planning-options/index.html
+++ b/docs/modifying-query-planning-options/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/mongodb-storage-plugin/index.html
----------------------------------------------------------------------
diff --git a/docs/mongodb-storage-plugin/index.html 
b/docs/mongodb-storage-plugin/index.html
index f67d123..06bb329 100644
--- a/docs/mongodb-storage-plugin/index.html
+++ b/docs/mongodb-storage-plugin/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html
----------------------------------------------------------------------
diff --git 
a/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html 
b/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html
index 0a8a917..7282a86 100644
--- a/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html
+++ b/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/monitoring-metrics/index.html
----------------------------------------------------------------------
diff --git a/docs/monitoring-metrics/index.html 
b/docs/monitoring-metrics/index.html
new file mode 100644
index 0000000..6ff99c6
--- /dev/null
+++ b/docs/monitoring-metrics/index.html
@@ -0,0 +1,1187 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+<meta name=viewport content="width=device-width, initial-scale=1">
+
+
+<title>Monitoring Metrics - Apache Drill</title>
+
+<link 
href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 
rel="stylesheet" type="text/css"/>
+<link href='//fonts.googleapis.com/css?family=PT+Sans' rel='stylesheet' 
type='text/css'/>
+<link href="/css/site.css" rel="stylesheet" type="text/css"/>
+
+<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/>
+<link rel="icon" href="/favicon.ico" type="image/x-icon"/>
+
+<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" 
language="javascript" type="text/javascript"></script>
+<script 
src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" 
language="javascript" type="text/javascript"></script>
+<script language="javascript" type="text/javascript" 
src="/js/modernizr.custom.js"></script>
+<script language="javascript" type="text/javascript" 
src="/js/script.js"></script>
+<script language="javascript" type="text/javascript" 
src="/js/drill.js"></script>
+
+</head>
+
+
+<body onResize="resized();">
+  <div class="page-wrap">
+    <div class="bui"></div>
+
+<div id="menu" class="mw">
+<ul>
+  <li class='toc-categories'>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa 
fa-bars"></i></a>
+  </li>
+  <li class="logo"><a href="/"></a></li>
+  <li class='expand-menu'>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span 
class='expand-icon'><i class="fa fa-bars"></i></span></a>
+  </li>
+  <li class='clear-float'></li>
+  <li class="documentation-menu">
+    <a href="/docs/">Documentation</a>
+    <ul>
+      
+        <li><a href="/docs/getting-started/">Getting Started</a></li>
+      
+        <li><a href="/docs/architecture/">Architecture</a></li>
+      
+        <li><a href="/docs/tutorials/">Tutorials</a></li>
+      
+        <li><a href="/docs/install-drill/">Install Drill</a></li>
+      
+        <li><a href="/docs/configure-drill/">Configure Drill</a></li>
+      
+        <li><a href="/docs/connect-a-data-source/">Connect a Data 
Source</a></li>
+      
+        <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
+      
+        <li><a href="/docs/query-data/">Query Data</a></li>
+      
+        <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+      
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
+        <li><a href="/docs/sql-reference/">SQL Reference</a></li>
+      
+        <li><a href="/docs/data-sources-and-file-formats/">Data Sources and 
File Formats</a></li>
+      
+        <li><a href="/docs/develop-custom-functions/">Develop Custom 
Functions</a></li>
+      
+        <li><a href="/docs/troubleshooting/">Troubleshooting</a></li>
+      
+        <li><a href="/docs/developer-information/">Developer 
Information</a></li>
+      
+        <li><a href="/docs/release-notes/">Release Notes</a></li>
+      
+        <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
+      
+        <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+      
+    </ul>
+  </li>
+  <li class='nav'>
+    <a href="/community-resources/">Community</a>
+    <ul>
+      <li><a href="/team/">Team</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/community-resources/">Community Resources</a></li>
+    </ul>
+  </li>
+  <li class='nav'><a href="/faq/">FAQ</a></li>
+  <li class='nav'><a href="/blog/">Blog</a></li>
+  <li id="twitter-menu-item"><a href="https://twitter.com/apachedrill"; 
title="apachedrill on twitter" target="_blank"><img 
src="/images/twitter_32_26_white.png" alt="twitter logo" align="center"></a> 
</li>
+  <li class='search-bar'>
+    <form id="drill-search-form">
+      <input type="text" placeholder="Search Apache Drill" 
id="drill-search-term" />
+      <button type="submit">
+        <i class="fa fa-search"></i>
+      </button>
+    </form>
+  </li>
+  <li class="d">
+    <a href="/download/">
+      <i class="fa fa-cloud-download"></i> Download
+    </a>
+  </li>
+</ul>
+</div>
+
+    <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
+      
+
+
+
+
+<aside class="sidebar">
+  <div class="docsidebar">
+    <div class="docsidebarwrapper">
+      <ul style="display: block;">
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Getting 
Started</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/drill-introduction/">Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/why-drill/">Why Drill</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: 
void(0);">Architecture</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/architecture-introduction/">Architecture Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/drill-query-execution/">Drill Query Execution</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/core-modules/">Core Modules</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/performance/">Performance</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: 
void(0);">Tutorials</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/tutorials-introduction/">Tutorials Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/drill-in-10-minutes/">Drill in 10 Minutes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/analyzing-the-yelp-academic-dataset/">Analyzing the Yelp Academic 
Dataset</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Learn 
Drill with the MapR Sandbox</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/about-the-mapr-sandbox/">About the MapR Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill 
Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/getting-to-know-the-drill-sandbox/">Getting to Know the Drill 
Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lesson-1-learn-about-the-data-set/">Lesson 1: Learn about the Data 
Set</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lesson-2-run-queries-with-ansi-sql/">Lesson 2: Run Queries with 
ANSI SQL</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lesson-3-run-queries-on-complex-data-types/">Lesson 3: Run Queries 
on Complex Data Types</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/summary/">Summary</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic 
Datasets</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/analyzing-social-media/">Analyzing Social Media</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/analyzing-data-using-window-functions/">Analyzing Data Using Window 
Functions</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Install 
Drill</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/install-drill-introduction/">Install Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/migrating-parquet-data/">Migrating Parquet Data</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Installing 
Drill in Embedded Mode</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/embedded-mode-prerequisites/">Embedded Mode Prerequisites</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-linux-and-mac-os-x/">Installing Drill on Linux 
and Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-on-linux-and-mac-os-x/">Starting Drill on Linux and 
Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-windows/">Installing Drill on Windows</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-on-windows/">Starting Drill on Windows</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Installing 
Drill in Distributed Mode</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/distributed-mode-prerequisites/">Distributed Mode 
Prerequisites</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-the-cluster/">Installing Drill on the 
Cluster</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-in-distributed-mode/">Starting Drill in Distributed 
Mode</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/starting-the-web-console/">Starting the Web Console</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Configure 
Drill</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configure-drill-introduction/">Configure Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-drill-memory/">Configuring Drill Memory</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Configuring a Multitenant Cluster</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-a-multitenant-cluster-introduction/">Configuring a 
Multitenant Cluster Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-multitenant-resources/">Configuring Multitenant 
Resources</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-resources-for-a-shared-drillbit/">Configuring Resources 
for a Shared Drillbit</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-user-impersonation/">Configuring User 
Impersonation</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-inbound-impersonation/">Configuring Inbound 
Impersonation</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-user-authentication/">Configuring User 
Authentication</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-user-impersonation-with-hive-authorization/">Configuring
 User Impersonation with Hive Authorization</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-web-console-and-rest-api-security/">Configuring Web 
Console and REST API Security</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Configuration Options</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuration-options-introduction/">Configuration Options 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/start-up-options/">Start-Up Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/planning-and-execution-options/">Planning and Execution 
Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/persistent-configuration-storage/">Persistent Configuration 
Storage</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/ports-used-by-drill/">Ports Used by Drill</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Connect a Data 
Source</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/connect-a-data-source-introduction/">Connect a Data Source 
Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/storage-plugin-registration/">Storage Plugin Registration</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Storage 
Plugin Configuration</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/workspaces/">Workspaces</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-default-input-format/">Drill Default Input Format</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hive-storage-plugin/">Hive Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/rdbms-storage-plugin/">RDBMS Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/mongodb-storage-plugin/">MongoDB Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/mapr-db-format/">MapR-DB Format</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">ODBC/JDBC 
Interfaces</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/interfaces-introduction/">Interfaces Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-the-jdbc-driver/">Using the JDBC Driver</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on 
Windows</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Installing 
the ODBC Driver</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-linux/">Installing the Driver on 
Linux</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-mac-os-x/">Installing the Driver on Mac OS 
X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-windows/">Installing the Driver on 
Windows</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-tdc-file-on-windows/">Installing the TDC File on 
Windows</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Configuring ODBC</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/odbc-configuration-reference/">ODBC Configuration Reference</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-odbc-on-linux/">Configuring ODBC on Linux</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-odbc-on-mac-os-x/">Configuring ODBC on Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-odbc-on-windows/">Configuring ODBC on Windows</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/testing-the-odbc-connection/">Testing the ODBC Connection</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Using 
Drill Explorer</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-explorer-introduction/">Drill Explorer Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/connecting-drill-explorer-to-data/">Connecting Drill Explorer to 
Data</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/browsing-data-and-defining-views/">Browsing Data and Defining 
Views</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Using 
Drill with BI Tools</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-drill-with-bi-tools-introduction/">Using Drill with BI Tools 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/tableau-examples/">Tableau Examples</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-apache-drill/">Using 
MicroStrategy Analytics with Apache Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-tibco-spotfire-desktop-with-drill/">Using Tibco Spotfire 
Desktop with Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco 
Spotfire Server with Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-qlik-sense-with-drill/">Using Qlik Sense with Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with 
Tableau 9 Desktop</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with 
Tableau 9 Server</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-information-builders-webfocus-with-apache-drill/">Using 
Information Builders’ WebFOCUS with Apache Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-jreport-with-drill/">Configuring JReport with 
Drill</a></li>
+              
+            </ul>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Query 
Data</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/query-data-introduction/">Query Data Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Querying a 
File System</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-a-file-system-introduction/">Querying a File System 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-avro-files/">Querying Avro Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-json-files/">Querying JSON Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-parquet-files/">Querying Parquet Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-plain-text-files/">Querying Plain Text Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-directories/">Querying Directories</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-sequence-files/">Querying Sequence Files</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-hbase/">Querying HBase</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Querying 
Complex Data</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-complex-data-introduction/">Querying Complex Data 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-flat-data/">Selecting Flat Data</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-sql-functions-clauses-and-joins/">Using SQL Functions, 
Clauses, and Joins</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-nested-data-for-a-column/">Selecting Nested Data for a 
Column</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-multiple-columns-within-nested-data/">Selecting Multiple 
Columns Within Nested Data</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-hive/">Querying Hive</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-the-information-schema/">Querying the INFORMATION 
SCHEMA</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-system-tables/">Querying System Tables</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-and-canceling-queries-in-the-drill-web-console/">Monitoring
 and Canceling Queries in the Drill Web Console</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1 current_section "><a href="javascript: 
void(0);">Performance Tuning</a></li>
+          <ul class="current_section">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/performance-tuning-introduction/">Performance Tuning 
Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Partition 
Pruning</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/partition-pruning-introduction/">Partition Pruning 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/how-to-partition-data/">How to Partition Data</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/optimizing-parquet-metadata-reading/">Optimizing Parquet Metadata 
Reading</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hive-metadata-caching/">Hive Metadata Caching</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/choosing-a-storage-format/">Choosing a Storage Format</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Query 
Plans and Tuning</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-plans-and-tuning-introduction/">Query Plans and Tuning 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/join-planning-guidelines/">Join Planning Guidelines</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/guidelines-for-optimizing-aggregation/">Guidelines for Optimizing 
Aggregation</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/modifying-query-planning-options/">Modifying Query Planning 
Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sort-based-and-hash-based-memory-constrained-operators/">Sort-Based 
and Hash-Based Memory-Constrained Operators</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/enabling-query-queuing/">Enabling Query Queuing</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/">Controlling
 Parallelization to Balance Performance with Multi-Tenancy</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Identifying Performance Issues</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-plans/">Query Plans</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-profiles/">Query Profiles</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Performance Tuning Reference</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-profile-column-descriptions/">Query Profile Column 
Descriptions</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/physical-operators/">Physical Operators</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2 current"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Log and 
Debug</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/error-messages/">Error Messages</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/modify-logback-xml/">Modify logback.xml</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/query-audit-logging/">Query Audit Logging</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">SQL 
Reference</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/sql-reference-introduction/">SQL Reference Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Data 
Types</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/supported-data-types/">Supported Data Types</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/handling-different-data-types/">Handling Different Data 
Types</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/lexical-structure/">Lexical Structure</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/operators/">Operators</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Functions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/about-sql-function-examples/">About SQL Function Examples</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/math-and-trig/">Math and Trig</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/data-type-conversion/">Data Type Conversion</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/date-time-functions-and-arithmetic/">Date/Time Functions and 
Arithmetic</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/string-manipulation/">String Manipulation</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/aggregate-and-aggregate-statistical/">Aggregate and Aggregate 
Statistical</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/functions-for-handling-nulls/">Functions for Handling Nulls</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL Window 
Functions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sql-window-functions-introduction/">SQL Window Functions 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/aggregate-window-functions/">Aggregate Window Functions</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sql-window-functions-examples/">SQL Window Functions 
Examples</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Nested 
Data Functions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/nested-data-limitations/">Nested Data Limitations</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/flatten/">FLATTEN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/kvgen/">KVGEN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/repeated-count/">REPEATED_COUNT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/repeated-contains/">REPEATED_CONTAINS</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/query-directory-functions/">Query Directory Functions</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Commands</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/reset/">RESET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/alter-system/">ALTER SYSTEM</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/partition-by-clause/">PARTITION BY Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/create-view/">CREATE VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/describe/">DESCRIBE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drop-view/">DROP VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/explain/">EXPLAIN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/select/">SELECT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/select-list/">SELECT List</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/from-clause/">FROM Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/group-by-clause/">GROUP BY Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/having-clause/">HAVING Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/limit-clause/">LIMIT Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/offset-clause/">OFFSET Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/order-by-clause/">ORDER BY Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/union-set-operator/">UNION Set Operator</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/with-clause/">WITH Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW 
SCHEMAS</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/show-files/">SHOW FILES</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/show-tables/">SHOW TABLES</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/use/">USE</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Conditional Expressions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/case/">CASE</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/reserved-keywords/">Reserved Keywords</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/sql-extensions/">SQL Extensions</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Data Sources 
and File Formats</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/data-sources-and-file-formats-introduction/">Data Sources and File 
Formats Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type 
Mapping</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive 
UDF</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/parquet-format/">Parquet Format</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/json-data-model/">JSON Data Model</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/text-files-csv-tsv-psv/">Text Files: CSV, TSV, PSV</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/sequence-files/">Sequence Files</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Develop Custom 
Functions</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/develop-custom-functions-introduction/">Develop Custom Functions 
Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/developing-a-simple-function/">Developing a Simple Function</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/tutorial-develop-a-simple-function/">Tutorial: Develop a Simple 
Function</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/developing-an-aggregate-function/">Developing an Aggregate 
Function</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/adding-custom-functions-to-drill/">Adding Custom Functions to 
Drill</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-custom-functions-in-queries/">Using Custom Functions in 
Queries</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/custom-function-interfaces/">Custom Function Interfaces</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" 
href="/docs/troubleshooting/">Troubleshooting</a></li>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Developer 
Information</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/rest-api/">REST API</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Develop 
Drill</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Contribute 
to Drill</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution 
Guidelines</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/apache-drill-contribution-ideas/">Apache Drill Contribution 
Ideas</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Design 
Docs</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-plan-syntax/">Drill Plan Syntax</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/rpc-overview/">RPC Overview</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-stages/">Query Stages</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/useful-research/">Useful Research</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/value-vectors/">Value Vectors</a></li>
+              
+            </ul>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Release 
Notes</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-5-0-release-notes/">Apache Drill 1.5.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-4-0-release-notes/">Apache Drill 1.4.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-3-0-release-notes/">Apache Drill 1.3.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-2-0-release-notes/">Apache Drill 1.2.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-1-0-release-notes/">Apache Drill 1.1.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-7-0-release-notes/">Apache Drill 0.7.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-6-0-release-notes/">Apache Drill 0.6.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 
Release Notes (Apache Drill Alpha)</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 
Release Notes (Apache Drill Alpha)</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-4-0-release-notes/">Apache Drill 0.4.0 Release 
Notes</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Sample 
Datasets</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/aol-search/">AOL Search</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/enron-emails/">Enron Emails</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/wikipedia-edit-history/">Wikipedia Edit History</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" 
href="/docs/project-bylaws/">Project Bylaws</a></li>
+        
+      
+      </ul>
+
+    </div>
+  </div>
+</aside>
+
+
+<nav class="breadcrumbs">
+  <li><a href="/docs/">Docs</a></li>
+ 
+  
+    <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+  
+  <li>Monitoring Metrics</li>
+</nav>
+
+<div class="main-content-wrapper">
+  <div class="main-content">
+
+    
+      <a class="edit-link" 
href="https://github.com/apache/drill/blob/gh-pages/_docs/performance-tuning/070-monitoring-metrics.md";
 target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
+
+    <div class="int_title left">
+      <h1>Monitoring Metrics</h1>
+
+    </div>
+
+     
+
+    <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+
+    <div class="int_text" align="left">
+      
+        <p>As of Drill 1.7, Drill uses JMX (<a 
href="https://docs.oracle.com/javase/tutorial/jmx/";>Java Management 
Extensions</a>) to monitor queries at runtime. JMX provides the architecture to 
dynamically manage and monitor applications. JMX collects Drill system-level 
metrics that you can access through the Metrics tab in the Drill Web Console or 
a remote JMX monitoring tool, such as JConsole or the VisualVM + MBeans plugin. 
The Web Console Metrics tab contains the collected metrics as tables, counters, 
histograms, and gauges via JMX.  </p>
+
+<h2 id="remote-monitoring">Remote Monitoring</h2>
+
+<p>You can enable the remote JMX Java feature to monitor a specific JVM from a 
remote location. You can enable remote JMX with or without authentication. See 
the <a 
href="http://docs.oracle.com/javase/7/docs/technotes/guides/management/agent.html";>Java
 documentation</a>. </p>
+
+<p>In <code>$DRILL_HOME/conf/drill-env.sh</code>, use the 
<code>DRILLBIT_JAVA_OPTS</code> variable to pass the relevant parameters. For 
example, to add remote monitoring on port 8048 without authentication:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">   
export DRILLBIT_JAVA_OPTS=”$DRILLBIT_JAVA_OPTS -Dcom.sun.management.jmxremote 
-Dcom.sun.management.jmxremote.authenticate=false 
-Dcom.sun.management.jmxremote.ssl=false 
-Dcom.sun.management.jmxremote.port=8048”  
+</code></pre></div>
+<h2 id="disabling-drill-metrics">Disabling Drill Metrics</h2>
+
+<p>JMX metric collection is enabled, by default. You can disable the metrics 
option if needed. </p>
+
+<p>In <code>$DRILL_HOME/conf/drill-env.sh</code>, set the 
<code>drill.metrics.jmx.enabled</code> option to false through the 
<code>DRILLBIT_JAVA_OPTS</code> variable. Add the variable in 
<code>drill-env.sh</code> if it does not exist:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">   
export DRILLBIT_JAVA_OPTS=&quot;$DRILLBIT_JAVA_OPTS 
-Ddrill.metrics.jmx.enabled=false&quot;
+</code></pre></div>
+<p>The following table lists the predefined Drill system-level metrics that 
you can view through a JMX monitoring tool or the Drill Web Console:  </p>
+
+<table><thead>
+<tr>
+<th>Metric</th>
+<th>Description</th>
+</tr>
+</thead><tbody>
+<tr>
+<td>drill.queries.running</td>
+<td>The   number of queries running for which the Drillbit is the Foreman.</td>
+</tr>
+<tr>
+<td>drill.queries.completed</td>
+<td>The   number of queries completed, canceled, or failed for which the 
Drillbit was   the Foreman.</td>
+</tr>
+<tr>
+<td>drill.fragments.running</td>
+<td>The   number of query fragments currently running in the Drillbit.</td>
+</tr>
+<tr>
+<td>drill.allocator.root.used</td>
+<td>The   amount of memory (in bytes) used by the internal memory 
allocator.</td>
+</tr>
+<tr>
+<td>drill.allocator.root.peak</td>
+<td>The   peak amount of memory (in bytes) used by the internal memory 
allocator.</td>
+</tr>
+<tr>
+<td>heap.used</td>
+<td>The   amount of heap memory (in bytes) used by the JVM.</td>
+</tr>
+<tr>
+<td>non-heap.used</td>
+<td>The   amount of non-heap memory (in bytes) used by the JVM.</td>
+</tr>
+<tr>
+<td>count</td>
+<td>The   number of live threads, including daemon and non-daemon threads.</td>
+</tr>
+<tr>
+<td>fd.usage</td>
+<td>The   ratio of used file descriptors to total file descriptors on *nix 
systems.</td>
+</tr>
+<tr>
+<td>direct.used</td>
+<td>The   amount of direct memory (in bytes) used by the JVM. This metric is 
useful for   debugging Drill issues.</td>
+</tr>
+<tr>
+<td>runnable.count</td>
+<td>The   number of threads executing an action in the JVM. This metric is 
useful for   debugging Drill issues.</td>
+</tr>
+<tr>
+<td>waiting.count</td>
+<td>The   number of threads waiting to execute. Typically, threads waiting on 
other   threads to perform an action. This metric is useful for debugging Drill 
  issues.</td>
+</tr>
+<tr>
+<td>blocked.count</td>
+<td>The   number of threads that are blocked because they are waiting on a 
monitor   lock. This metric is useful for debugging Drill issues.</td>
+</tr>
+</tbody></table>
+
+    
+      
+        <div class="doc-nav">
+  
+  <span class="previous-toc"><a href="/docs/physical-operators/">← Physical 
Operators</a></span><span class="next-toc"><a href="/docs/log-and-debug/">Log 
and Debug →</a></span>
+</div>
+
+    
+    </div>
+  </div>
+</div>
+
+  </div>
+  <p class="push"></p>
+<div id="footer" class="mw">
+<div class="wrapper">
+Copyright © 2012-2014 The Apache Software Foundation, licensed under the 
Apache License, Version 2.0.<br>
+Apache and the Apache feather logo are trademarks of The Apache Software 
Foundation. Other names appearing on the site may be trademarks of their 
respective owners.<br/><br/>
+</div>
+</div>
+
+  <script>
+(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+ga('create', 'UA-53379651-1', 'auto');
+ga('send', 'pageview');
+</script>
+<script type="text/javascript" 
src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-548b2caa33765e8d" 
async="async"></script>
+</body>
+</html>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/nested-data-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/nested-data-functions/index.html 
b/docs/nested-data-functions/index.html
index f1eac47..44e6cc5 100644
--- a/docs/nested-data-functions/index.html
+++ b/docs/nested-data-functions/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/nested-data-limitations/index.html
----------------------------------------------------------------------
diff --git a/docs/nested-data-limitations/index.html 
b/docs/nested-data-limitations/index.html
index 51033f1..4404ab3 100644
--- a/docs/nested-data-limitations/index.html
+++ b/docs/nested-data-limitations/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/odbc-configuration-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/odbc-configuration-reference/index.html 
b/docs/odbc-configuration-reference/index.html
index 2ea10f7..e5ab8d0 100644
--- a/docs/odbc-configuration-reference/index.html
+++ b/docs/odbc-configuration-reference/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/odbc-jdbc-interfaces/index.html
----------------------------------------------------------------------
diff --git a/docs/odbc-jdbc-interfaces/index.html 
b/docs/odbc-jdbc-interfaces/index.html
index aade1a9..b41e2f0 100644
--- a/docs/odbc-jdbc-interfaces/index.html
+++ b/docs/odbc-jdbc-interfaces/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/offset-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/offset-clause/index.html b/docs/offset-clause/index.html
index f6772e8..d4e38ca 100644
--- a/docs/offset-clause/index.html
+++ b/docs/offset-clause/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/operators/index.html
----------------------------------------------------------------------
diff --git a/docs/operators/index.html b/docs/operators/index.html
index 643b98e..8d9fa55 100644
--- a/docs/operators/index.html
+++ b/docs/operators/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/optimizing-parquet-metadata-reading/index.html
----------------------------------------------------------------------
diff --git a/docs/optimizing-parquet-metadata-reading/index.html 
b/docs/optimizing-parquet-metadata-reading/index.html
index 96322ab..294548f 100644
--- a/docs/optimizing-parquet-metadata-reading/index.html
+++ b/docs/optimizing-parquet-metadata-reading/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/order-by-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/order-by-clause/index.html b/docs/order-by-clause/index.html
index f501455..e38f322 100644
--- a/docs/order-by-clause/index.html
+++ b/docs/order-by-clause/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/20e54951/docs/parquet-format/index.html
----------------------------------------------------------------------
diff --git a/docs/parquet-format/index.html b/docs/parquet-format/index.html
index 2325ce4..565f589 100644
--- a/docs/parquet-format/index.html
+++ b/docs/parquet-format/index.html
@@ -623,6 +623,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
           </ul>
         
       
@@ -947,6 +951,10 @@
           <ul style="display: none">
           
             
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
             
           

Reply via email to