drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [37/51] [partial] drill-site git commit: Cleaning up deleted content.
Date Sat, 25 Feb 2017 00:15:46 GMT
http://git-wip-us.apache.org/repos/asf/drill-site/blob/d42f2cdd/docs/deploying-drill-in-a-cluster/index.html
----------------------------------------------------------------------
diff --git a/docs/deploying-drill-in-a-cluster/index.html b/docs/deploying-drill-in-a-cluster/index.html
deleted file mode 100644
index 1d25b9f..0000000
--- a/docs/deploying-drill-in-a-cluster/index.html
+++ /dev/null
@@ -1,935 +0,0 @@
-<!DOCTYPE html>
-<html>
-
-<head>
-
-<meta charset="UTF-8">
-<meta name=viewport content="width=device-width, initial-scale=1">
-
-
-<title>Deploying Drill in a Cluster - Apache Drill</title>
-
-<link href="/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/css/style.css" rel="stylesheet" type="text/css">
-<link href="/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
-<link href="/css/code.css" rel="stylesheet" type="text/css">
-<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
-<link href="/css/responsive.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script>
-<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></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/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/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/manage-drill/">Manage Drill</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/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</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>
-
-      
-      
-
-
-
-
-<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/core-modules/">Core Modules</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-              
-            </ul>
-            
-          
-          </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/lession-1-learn-about-the-data-set/">Lession 1: Learn about the Data Set</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/lession-2-run-queries-with-ansi-sql/">Lession 2: Run Queries with ANSI SQL</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/lession-3-run-queries-on-complex-data-types/">Lession 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>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1 current_section "><a href="javascript: void(0);">Install Drill</a></li>
-          <ul class="current_section">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/install-drill-introduction/">Install Drill Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2 current"><a class="reference internal" href="/docs/deploying-drill-in-a-cluster/">Deploying Drill in a Cluster</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/">Installing Drill on Linux</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/installing-drill-on-mac-os-x/">Installing Drill on 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>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/installing-drill-in-distributed-mode/">Installing Drill in Distributed Mode</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-introduction/">Plugin Configuration Introduction</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/file-system-storage-plugin/">File System Storage Plugin</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/hive-storage-plugin/">Hive Storage Plugin</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/mongodb-plugin-for-apache-drill/">MongoDB Plugin for Apache Drill</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</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-jdbc/">Using JDBC</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a href="javascript: void(0);">Using ODBC on Linux and Mac OS X</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/odbc-on-linux-and-mac-introduction/">ODBC on Linux and Mac Introduction</a></li>
-              
-                <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/configuring-connections-on-linux-and-mac-os-x/">Configuring Connections on Linux and Mac OS X</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/driver-configuration-options/">Driver Configuration Options</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/using-a-connection-string/">Using a Connection String</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/advanced-properties/">Advanced Properties</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 ODBC on Windows</a></li>
-              <ul style="display: none">
-              
-                <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/configuring-connections-on-windows/">Configuring Connections on Windows</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/connecting-to-odbc-data-sources/">Connecting to ODBC Data Sources</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-drill-explorer-on-windows/">Using Drill Explorer on Windows</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy Analytics with Drill</a></li>
-            
-          
-          </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-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>
-              
-            </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>
-            
-          
-          </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);">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/alter-session-command/">ALTER SESSION Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN commands</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES AND SHOW SCHEMAS Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</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>
-            
-          
-          </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/develop-a-simple-function/">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 href="javascript: void(0);">Manage Drill</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/manage-drill-introduction/">Manage Drill Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-drill-in-a-dedicated-cluster/">Configuring Drill in a Dedicated Cluster</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 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/starting-stopping-drill/">Starting/Stopping Drill</a></li>
-            
-          
-            
-              <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/partition-pruning/">Partition Pruning</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/">Monitoring and Canceling Queries in the Drill Web UI</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Developer Information</a></li>
-          <ul style="display: none">
-          
-            
-              <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>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drill-patch-review-tool/">Drill Patch Review Tool</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-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>
-            
-          
-            
-              <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-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-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-8-0-release-notes/">Apache Drill 0.8.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 href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</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/install-drill/">Install Drill</a></li>
-  
-  <li>Deploying Drill in a Cluster</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/install/020-deploying-drill-in-a-cluster.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-      
-
-      <div class="int_title">
-        <h1>Deploying Drill in a Cluster</h1>
-
-      </div>
-
-      <link href="/css/docpage.css" rel="stylesheet" type="text/css">
-
-      <div class="int_text" align="left">
-        
-          <h2 id="overview">Overview</h2>
-
-<p>To run Drill in a clustered environment, complete the following steps:</p>
-
-<ol>
-<li>Install Drill on each designated node in the cluster.</li>
-<li>Configure a cluster ID and add Zookeeper information.</li>
-<li>Connect Drill to your data sources. </li>
-<li>Start Drill.</li>
-</ol>
-
-<h3 id="prerequisites">Prerequisites</h3>
-
-<p>Before you install Apache Drill on nodes in your cluster, you must have the
-following software and services installed:</p>
-
-<ul>
-<li><a href="http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html">Oracle JDK version 7</a></li>
-<li>Configured and running ZooKeeper quorum</li>
-<li>Configured and running Hadoop cluster (Recommended)</li>
-<li>DNS (Recommended)</li>
-</ul>
-
-<h3 id="installing-drill">Installing Drill</h3>
-
-<p>Complete the following steps to install Drill on designated nodes:</p>
-
-<ol>
-<li><p>Download the Drill tarball.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">curl http://getdrill.org/drill/download/apache-drill-0.8.0.tar.gz
-</code></pre></div></li>
-<li><p>Issue the following command to create a Drill installation directory and then explode the tarball to the directory:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">mkdir /opt/drill
-tar xzf apache-drill-&lt;version&gt;.tar.gz --strip=1 -C /opt/drill
-</code></pre></div></li>
-<li><p>If you are using external JAR files, edit <code>drill-env.sh,</code>located in <code>/opt/drill/conf/</code>, and define <code>HADOOP_HOME:</code></p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">export HADOOP_HOME=&quot;~/hadoop/hadoop-0.20.2/&quot;
-</code></pre></div></li>
-<li><p>In <code>drill-override.conf,</code>create a unique Drill <code>cluster ID</code>, and provide Zookeeper host names and port numbers to configure a connection to your Zookeeper quorum.</p>
-
-<ol>
-<li>Edit <code>drill-override.conf</code>located in <code>~/drill/drill-&lt;version&gt;/conf/</code>.</li>
-<li>Provide a unique <code>cluster-id</code> and the Zookeeper host names and port numbers in <code>zk.connect</code>. If you install Drill on multiple nodes, assign the same <code>cluster ID</code> to each Drill node so that all Drill nodes share the same ID. The default Zookeeper port is 2181.</li>
-</ol></li>
-</ol>
-
-<p><strong>Example</strong></p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">drill.exec: {
-  cluster-id: &quot;&lt;mydrillcluster&gt;&quot;,
-  zk.connect: &quot;&lt;zkhostname1&gt;:&lt;port&gt;,&lt;zkhostname2&gt;:&lt;port&gt;,&lt;zkhostname3&gt;:&lt;port&gt;&quot;,
-  debug.error_on_leak: false,
-  buffer.size: 6,
-  functions: [&quot;org.apache.drill.expr.fn.impl&quot;, &quot;org.apache.drill.udfs&quot;]
-}
-</code></pre></div>
-<h3 id="connecting-drill-to-data-sources">Connecting Drill to Data Sources</h3>
-
-<p>You can connect Drill to various types of data sources. Refer to <a href="/docs/connect-a-data-source-introduction">Connect
-Apache Drill to Data Sources</a> to get configuration instructions for the
-particular type of data source that you want to connect to Drill.</p>
-
-<h3 id="starting-drill">Starting Drill</h3>
-
-<p>Complete the following steps to start Drill:</p>
-
-<ol>
-<li><p>Navigate to the Drill installation directory, and issue the following command to start a Drillbit:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drillbit.sh restart
-</code></pre></div></li>
-<li><p>Issue the following command to invoke SQLLine and start Drill:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline -u jdbc:drill:
-</code></pre></div>
-<p>When connected, the Drill prompt appears.<br>
- Example: <code>0: jdbc:drill:zk=&lt;zk1host&gt;:&lt;port&gt;</code></p>
-
-<p>If you cannot connect to Drill, invoke SQLLine with the ZooKeeper quorum:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> bin/sqlline -u jdbc:drill:zk=&lt;zk1host&gt;:&lt;port&gt;,&lt;zk2host&gt;:&lt;port&gt;,&lt;zk3host&gt;:&lt;port&gt;
-</code></pre></div></li>
-<li><p>Issue the following query to Drill to verify that all Drillbits have joined the cluster:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=&lt;zk1host&gt;:&lt;port&gt; select * from sys.drillbits;
-</code></pre></div></li>
-</ol>
-
-<p>Drill provides a list of Drillbits that have joined.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+--------------+--------------------+
-|    host        | user_port    | control_port | data_port    |
-+------------+------------+--------------+--------------------+
-| &lt;host address&gt; | &lt;port number&gt;| &lt;port number&gt;| &lt;port number&gt;|
-+------------+------------+--------------+--------------------+
-</code></pre></div>
-<p><strong>Example</strong></p>
-
-<p>Now you can query data with Drill. The Drill installation includes sample data
-that you can query. Refer to <a href="/docs/querying-parquet-files/">Querying Parquet Files</a>.</p>
-
-      
-        
-          <div class="doc-nav">
-  
-  <span class="previous-toc"><a href="/docs/install-drill-introduction/">← Install Drill Introduction</a></span><span class="next-toc"><a href="/docs/installing-drill-in-embedded-mode/">Installing Drill in Embedded Mode →</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>
-
-</body>
-</html>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/d42f2cdd/docs/describe-command/index.html
----------------------------------------------------------------------
diff --git a/docs/describe-command/index.html b/docs/describe-command/index.html
deleted file mode 100644
index b01244e..0000000
--- a/docs/describe-command/index.html
+++ /dev/null
@@ -1,961 +0,0 @@
-<!DOCTYPE html>
-<html>
-
-<head>
-
-<meta charset="UTF-8">
-<meta name=viewport content="width=device-width, initial-scale=1">
-
-
-<title>DESCRIBE Command - Apache Drill</title>
-
-<link href="/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/css/style.css" rel="stylesheet" type="text/css">
-<link href="/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
-<link href="/css/code.css" rel="stylesheet" type="text/css">
-<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
-<link href="/css/responsive.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 language="javascript" type="text/javascript" src="/js/lib/jquery-1.11.1.min.js"></script>
-<script language="javascript" type="text/javascript" src="/js/lib/jquery.easing.1.3.js"></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/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/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/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</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>
-
-      
-      
-
-
-
-
-<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/core-modules/">Core Modules</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-              
-            </ul>
-            
-          
-          </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>
-            
-          
-          </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 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>
-            
-          
-          </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-user-authentication/">Configuring User Authentication</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/partition-pruning/">Partition Pruning</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-introduction/">Plugin Configuration Introduction</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/file-system-storage-plugin/">File System Storage Plugin</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/hive-storage-plugin/">Hive Storage Plugin</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/mongodb-plugin-for-apache-drill/">MongoDB Plugin for Apache Drill</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</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-jdbc/">Using JDBC</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a href="javascript: void(0);">Using ODBC on Linux and Mac OS X</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/odbc-on-linux-and-mac-introduction/">ODBC on Linux and Mac Introduction</a></li>
-              
-                <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/configuring-connections-on-linux-and-mac-os-x/">Configuring Connections on Linux and Mac OS X</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/driver-configuration-options/">Driver Configuration Options</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/using-a-connection-string/">Using a Connection String</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/advanced-properties/">Advanced Properties</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 ODBC on Windows</a></li>
-              <ul style="display: none">
-              
-                <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/configuring-connections-on-windows/">Configuring Connections on Windows</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/connecting-to-odbc-data-sources/">Connecting to ODBC Data Sources</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-drill-explorer-on-windows/">Using Drill Explorer on Windows</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/using-microstrategy-analytics-with-apache-drill/">Using MicroStrategy Analytics with Apache Drill</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/using-tibco-spotfire-with-drill/">Using Tibco Spotfire with Drill</a></li>
-            
-          
-            
-              <li class="toctree-l2"><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-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
-            
-          
-          </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-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>
-              
-            </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-ui/">Monitoring and Canceling Queries in the Drill Web UI</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1 current_section "><a href="javascript: void(0);">SQL Reference</a></li>
-          <ul class="current_section">
-          
-            
-              <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);">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="">
-              
-                <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/alter-session-command/">ALTER SESSION Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li>
-              
-                <li class="toctree-l3 current"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</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>
-            
-          
-          </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/develop-a-simple-function/">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 href="javascript: void(0);">Developer Information</a></li>
-          <ul style="display: none">
-          
-            
-              <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>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drill-patch-review-tool/">Drill Patch Review Tool</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-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>
-            
-          
-            
-              <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-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-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-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-9-0-release-notes/">Apache Drill 0.9.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 href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</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/sql-reference/">SQL Reference</a></li>
-  
-    <li><a href="/docs/sql-commands/">SQL Commands</a></li>
-  
-  <li>DESCRIBE Command</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/sql-reference/sql-commands/060-describe-command.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-      
-
-      <div class="int_title">
-        <h1>DESCRIBE Command</h1>
-
-      </div>
-
-      <link href="/css/docpage.css" rel="stylesheet" type="text/css">
-
-      <div class="int_text" align="left">
-        
-          <p>The DESCRIBE command returns information about columns in a table or view.</p>
-
-<h2 id="syntax">Syntax</h2>
-
-<p>The DESCRIBE command supports the following syntax:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">DESCRIBE [workspace.]table_name|view_name
-</code></pre></div>
-<h2 id="usage-notes">Usage Notes</h2>
-
-<p>You can issue the DESCRIBE command against views created in a workspace and
-tables created in Hive, HBase, and MapR-DB. You can issue the DESCRIBE command
-on a table or view from any schema. For example, if you are working in the
-<code>dfs.myworkspace</code> schema, you can issue the DESCRIBE command on a view or
-table in another schema. Currently, DESCRIBE does not support tables created
-in a file system.</p>
-
-<p>Drill only supports SQL data types. Verify that all data types in an external
-data source, such as Hive or HBase, map to supported data types in Drill. See
-Drill Data Type Mapping for more information.</p>
-
-<h2 id="example">Example</h2>
-
-<p>The following example demonstrates the steps that you can follow when you want
-to use the DESCRIBE command to see column information for a view and for Hive
-and HBase tables.</p>
-
-<p>Complete the following steps to use the DESCRIBE command:</p>
-
-<ol>
-<li><p>Issue the USE command to switch to a particular schema.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181&gt; use hive;
-+------------+------------+
-|   ok  |  summary   |
-+------------+------------+
-| true      | Default schema changed to &#39;hive&#39; |
-+------------+------------+
-1 row selected (0.025 seconds)
-</code></pre></div></li>
-<li><p>Issue the SHOW TABLES command to see the existing tables in the schema.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181&gt; show tables;
-+--------------+------------+
-| TABLE_SCHEMA | TABLE_NAME |
-+--------------+------------+
-| hive.default | orders     |
-| hive.default | products   |
-+--------------+------------+
-2 rows selected (0.438 seconds)
-</code></pre></div></li>
-<li><p>Issue the DESCRIBE command on a table.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181&gt; describe orders;
-+-------------+------------+-------------+
-| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
-+-------------+------------+-------------+
-| order_id  | BIGINT    | YES       |
-| month     | VARCHAR   | YES       |
-| purchdate   | TIMESTAMP  | YES        |
-| cust_id   | BIGINT    | YES       |
-| state     | VARCHAR   | YES       |
-| prod_id   | BIGINT    | YES       |
-| order_total | INTEGER | YES       |
-+-------------+------------+-------------+
-7 rows selected (0.64 seconds)
-</code></pre></div></li>
-<li><p>Issue the DESCRIBE command on a table in another schema from the current schema.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181&gt; describe hbase.customers;
-+-------------+------------+-------------+
-| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
-+-------------+------------+-------------+
-| row_key   | ANY       | NO        |
-| address   | (VARCHAR(1), ANY) MAP | NO        |
-| loyalty   | (VARCHAR(1), ANY) MAP | NO        |
-| personal  | (VARCHAR(1), ANY) MAP | NO        |
-+-------------+------------+-------------+
-4 rows selected (0.671 seconds)
-</code></pre></div></li>
-<li><p>Issue the DESCRIBE command on a view in another schema from the current schema.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181&gt; describe dfs.views.customers_vw;
-+-------------+------------+-------------+
-| COLUMN_NAME | DATA_TYPE  | IS_NULLABLE |
-+-------------+------------+-------------+
-| cust_id   | BIGINT    | NO        |
-| name      | VARCHAR   | NO        |
-| address   | VARCHAR   | NO        |
-| gender    | VARCHAR   | NO        |
-| age       | VARCHAR   | NO        |
-| agg_rev   | VARCHAR   | NO        |
-| membership  | VARCHAR | NO        |
-+-------------+------------+-------------+
-7 rows selected (0.403 seconds)
-</code></pre></div></li>
-</ol>
-
-      
-        
-          <div class="doc-nav">
-  
-  <span class="previous-toc"><a href="/docs/create-view-command/">← CREATE VIEW Command</a></span><span class="next-toc"><a href="/docs/explain-commands/">EXPLAIN Commands →</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>
-
-</body>
-</html>


Mime
View raw message