You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/19 01:39:05 UTC
[30/51] [partial] drill-site git commit: Website update
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/distributed-mode-prerequisites/index.html
----------------------------------------------------------------------
diff --git a/docs/distributed-mode-prerequisites/index.html b/docs/distributed-mode-prerequisites/index.html
index 43e4bfb..091c33d 100644
--- a/docs/distributed-mode-prerequisites/index.html
+++ b/docs/distributed-mode-prerequisites/index.html
@@ -9,26 +9,21 @@
<title>Distributed Mode Prerequisites - 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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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>
@@ -63,6 +58,12 @@
<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/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
<li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
</ul>
</li>
<li class='nav'>
@@ -110,7 +113,9 @@
</ul>
</div>
-
+ <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
@@ -149,14 +154,7 @@
- <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>
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
</ul>
@@ -203,6 +201,10 @@
<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>
+
+
</ul>
@@ -300,7 +302,7 @@
- <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
</ul>
@@ -357,7 +359,7 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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>
@@ -409,6 +411,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server 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>
@@ -487,6 +493,32 @@
+ <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+
+
+ </ul>
+
+
+
+ <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+
+
+
+ <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+
+
+ </ul>
+
+
+
<li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
<ul style="display: none">
@@ -563,27 +595,47 @@
<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-session/">ALTER SESSION</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/create-view/">CREATE VIEW</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/describe/">DESCRIBE</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-from/">SELECT FROM</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</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/select-having/">SELECT HAVING</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/select-limit/">SELECT LIMIT</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/select-offset/">SELECT OFFSET</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/select-order-by/">SELECT ORDER BY</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-union/">SELECT UNION</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/select-where/">SELECT WHERE</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/select-with/">SELECT WITH</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-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</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/show-files/">SHOW FILES</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</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>
@@ -782,6 +834,10 @@
<li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+
+
</ul>
@@ -800,6 +856,29 @@
<li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
+
+ <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>
+
+
+ </ul>
+
+
</ul>
</div>
@@ -807,7 +886,7 @@
</aside>
- <nav class="breadcrumbs">
+<nav class="breadcrumbs">
<li><a href="/docs/">Docs</a></li>
@@ -818,23 +897,23 @@
<li>Distributed Mode Prerequisites</li>
</nav>
- <div class="main-content-wrapper">
- <div class="main-content">
+<div class="main-content-wrapper">
+ <div class="main-content">
-
- <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/install/045-embedded-mode-prerequisites.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-
+
+ <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/install/045-embedded-mode-prerequisites.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Distributed Mode Prerequisites</h1>
+ <div class="int_title left">
+ <h1>Distributed Mode Prerequisites</h1>
- </div>
+ </div>
- <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+ <link href="/css/docpage.css" rel="stylesheet" type="text/css">
- <div class="int_text" align="left">
-
- <p>You can install Apache Drill in distributed mode on one or multiple nodes to
+ <div class="int_text" align="left">
+
+ <p>You can install Apache Drill in distributed mode on one or multiple nodes to
run it in a clustered environment.</p>
<p>To install Apache Drill in distributed mode, complete the following steps:</p>
@@ -847,27 +926,27 @@ run it in a clustered environment.</p>
<p><strong>Prerequisites</strong></p>
-<p>Before you install Apache Drill on nodes in your cluster, you must have the
-following software and services installed:</p>
+<p>Before you install Apache Drill on nodes in your cluster, install and configure the
+following software and services:</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><a href="http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html">Oracle JDK version 7</a> (Required)</li>
+<li>Configured and running a ZooKeeper quorum (Required)</li>
+<li>Configured and running a Hadoop cluster (Recommended)</li>
<li>DNS (Recommended)</li>
</ul>
+
-
- <div class="doc-nav">
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/installing-drill-in-distributed-mode/">← Installing Drill in Distributed Mode</a></span><span class="next-toc"><a href="/docs/installing-drill-on-the-cluster/">Installing Drill on the Cluster →</a></span>
</div>
-
- </div>
+
</div>
</div>
+</div>
</div>
<p class="push"></p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/drill-default-input-format/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-default-input-format/index.html b/docs/drill-default-input-format/index.html
index 5681071..39af39c 100644
--- a/docs/drill-default-input-format/index.html
+++ b/docs/drill-default-input-format/index.html
@@ -9,26 +9,21 @@
<title>Drill Default Input Format - 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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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>
@@ -63,6 +58,12 @@
<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/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
<li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
</ul>
</li>
<li class='nav'>
@@ -110,7 +113,9 @@
</ul>
</div>
-
+ <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
@@ -149,14 +154,7 @@
- <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>
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
</ul>
@@ -203,6 +201,10 @@
<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>
+
+
</ul>
@@ -300,7 +302,7 @@
- <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
</ul>
@@ -357,7 +359,7 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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>
@@ -409,6 +411,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server 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>
@@ -487,6 +493,32 @@
+ <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+
+
+ </ul>
+
+
+
+ <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+
+
+
+ <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+
+
+ </ul>
+
+
+
<li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
<ul style="display: none">
@@ -563,27 +595,47 @@
<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-session/">ALTER SESSION</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/create-view/">CREATE VIEW</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/describe/">DESCRIBE</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-from/">SELECT FROM</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</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/select-limit/">SELECT LIMIT</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/select-offset/">SELECT OFFSET</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/select-order-by/">SELECT ORDER BY</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/select-union/">SELECT UNION</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-where/">SELECT WHERE</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/select-with/">SELECT WITH</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-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</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-files/">SHOW FILES</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/show-tables/">SHOW TABLES</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li>
</ul>
@@ -782,6 +834,10 @@
<li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+
+
</ul>
@@ -800,6 +856,29 @@
<li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
+
+ <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>
+
+
+ </ul>
+
+
</ul>
</div>
@@ -807,7 +886,7 @@
</aside>
- <nav class="breadcrumbs">
+<nav class="breadcrumbs">
<li><a href="/docs/">Docs</a></li>
@@ -818,23 +897,23 @@
<li>Drill Default Input Format</li>
</nav>
- <div class="main-content-wrapper">
- <div class="main-content">
+<div class="main-content-wrapper">
+ <div class="main-content">
-
- <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/connect-a-data-source/080-drill-default-input-format.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-
+
+ <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/connect-a-data-source/080-drill-default-input-format.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Drill Default Input Format</h1>
+ <div class="int_title left">
+ <h1>Drill Default Input Format</h1>
- </div>
+ </div>
- <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+ <link href="/css/docpage.css" rel="stylesheet" type="text/css">
- <div class="int_text" align="left">
-
- <p>You can define a default input format to tell Drill what file type exists in a
+ <div class="int_text" align="left">
+
+ <p>You can define a default input format to tell Drill what file type exists in a
workspace within a file system. Drill determines the file type based on file
extensions and magic numbers when searching a workspace.</p>
@@ -854,13 +933,15 @@ fails. You can define a default input format for any of the file types that
Drill supports. Currently, Drill supports the following types:</p>
<ul>
-<li>CSV</li>
-<li>TSV</li>
-<li>PSV</li>
+<li>Avro</li>
+<li>CSV, TSV, or PSV</li>
<li>Parquet</li>
<li>JSON</li>
+<li>MapR-DB*</li>
</ul>
+<p>* Only available when you install Drill on a cluster using the mapr-drill package.</p>
+
<h2 id="defining-a-default-input-format">Defining a Default Input Format</h2>
<p>You define the default input format for a file system workspace through the
@@ -897,23 +978,23 @@ steps:</p>
<h2 id="querying-compressed-json">Querying Compressed JSON</h2>
-<p>You can use Drill 0.8 and later to query compressed JSON in .gz files as well as uncompressed files having the .json extension. First, add the gz extension to a storage plugin, and then use that plugin to query the compressed file.</p>
+<p>You can query compressed JSON in .gz files as well as uncompressed files having the .json extension. First, add the gz extension to a storage plugin, and then use that plugin to query the compressed file.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> "extensions": [
"json",
"gz"
]
</code></pre></div>
+
-
- <div class="doc-nav">
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/hive-storage-plugin/">← Hive Storage Plugin</a></span><span class="next-toc"><a href="/docs/mongodb-plugin-for-apache-drill/">MongoDB Plugin for Apache Drill →</a></span>
</div>
-
- </div>
+
</div>
</div>
+</div>
</div>
<p class="push"></p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/drill-in-10-minutes/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-in-10-minutes/index.html b/docs/drill-in-10-minutes/index.html
index e4abc29..1839f9e 100644
--- a/docs/drill-in-10-minutes/index.html
+++ b/docs/drill-in-10-minutes/index.html
@@ -9,26 +9,21 @@
<title>Drill in 10 Minutes - 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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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>
@@ -63,6 +58,12 @@
<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/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
<li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
</ul>
</li>
<li class='nav'>
@@ -110,7 +113,9 @@
</ul>
</div>
-
+ <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
@@ -149,14 +154,7 @@
- <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>
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
</ul>
@@ -203,6 +201,10 @@
<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>
+
+
</ul>
@@ -300,7 +302,7 @@
- <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
</ul>
@@ -357,7 +359,7 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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>
@@ -409,6 +411,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server 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>
@@ -487,6 +493,32 @@
+ <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+
+
+ </ul>
+
+
+
+ <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+
+
+
+ <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+
+
+ </ul>
+
+
+
<li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
<ul style="display: none">
@@ -563,27 +595,47 @@
<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-session/">ALTER SESSION</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/create-view/">CREATE VIEW</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/alter-system-command/">ALTER SYSTEM Command</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/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</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/create-view-command/">CREATE VIEW Command</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/describe-command/">DESCRIBE Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</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-group-by/">SELECT GROUP BY</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/select-having/">SELECT HAVING</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/select-limit/">SELECT LIMIT</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/select-offset/">SELECT OFFSET</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/select-order-by/">SELECT ORDER BY</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</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>
@@ -782,6 +834,10 @@
<li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+
+
</ul>
@@ -800,6 +856,29 @@
<li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
+
+ <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>
+
+
+ </ul>
+
+
</ul>
</div>
@@ -807,7 +886,7 @@
</aside>
- <nav class="breadcrumbs">
+<nav class="breadcrumbs">
<li><a href="/docs/">Docs</a></li>
@@ -816,23 +895,23 @@
<li>Drill in 10 Minutes</li>
</nav>
- <div class="main-content-wrapper">
- <div class="main-content">
+<div class="main-content-wrapper">
+ <div class="main-content">
-
- <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/tutorials/020-drill-in-10-minutes.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-
+
+ <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/tutorials/020-drill-in-10-minutes.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Drill in 10 Minutes</h1>
+ <div class="int_title left">
+ <h1>Drill in 10 Minutes</h1>
- </div>
+ </div>
- <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+ <link href="/css/docpage.css" rel="stylesheet" type="text/css">
- <div class="int_text" align="left">
-
- <h2 id="objective">Objective</h2>
+ <div class="int_text" align="left">
+
+ <h2 id="objective">Objective</h2>
<p>Use Apache Drill to query sample data in 10 minutes. For simplicity, you’ll
run Drill in <em>embedded</em> mode rather than <em>distributed</em> mode to try out Drill
@@ -840,11 +919,11 @@ without having to perform any setup tasks.</p>
<h2 id="installation-overview">Installation Overview</h2>
-<p>You can install Drill in embedded mode on a machine running Linux, Mac OS X, or Windows. For information about running Drill in distributed mode, see <a href="/docs/deploying-drill-in-a-cluster">Deploying Drill in a Cluster</a>.</p>
+<p>You can install Drill in embedded mode on a machine running Linux, Mac OS X, or Windows. For information about installing Drill in distributed mode, see <a href="/docs/installing-drill-in-distributed-mode">Installing Drill in Distributed Mode</a>.</p>
<p>This installation procedure includes how to download the Apache Drill archive and extract the contents to a directory on your machine. The Apache Drill archive contains sample JSON and Parquet files that you can query immediately.</p>
-<p>After installing Drill, you start SQLLine. SQLLine is a pure-Java console-based utility for connecting to relational databases and executing SQL commands. SQLLine is used as the shell for Drill. Drill follows the ANSI SQL: 2011 standard with <a href="/docs/sql-extensions/">extensions</a> for nested data formats and other capabilities.</p>
+<p>After installing Drill, you start the Drill shell. The Drill shell is a pure-Java console-based utility for connecting to relational databases and executing SQL commands. Drill follows the ANSI SQL: 2011 standard with <a href="/docs/sql-extensions/">extensions</a> for nested data formats and other capabilities.</p>
<h2 id="embedded-mode-installation-prerequisites">Embedded Mode Installation Prerequisites</h2>
@@ -876,33 +955,33 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
<p>Complete the following steps to install Drill: </p>
<ol>
-<li><p>Issue the following command in a terminal to download the latest, stable version of Apache Drill to a directory on your machine, or download Drill from the <a href="http://getdrill.org/drill/download/apache-drill-0.9.0.tar.gz">Drill web site</a>:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">wget http://getdrill.org/drill/download/apache-drill-0.9.0.tar.gz
+<li><p>Issue the following command in a terminal to download the latest version of Apache Drill to a directory on your machine, or download Drill from the <a href="http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz">Drill web site</a>:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">wget http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz
</code></pre></div></li>
<li><p>Copy the downloaded file to the directory where you want to install Drill. </p></li>
<li><p>Extract the contents of the Drill tar.gz file. Use sudo if necessary: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">sudo tar -xvzf apache-drill-0.9.0..tar.gz
+<div class="highlight"><pre><code class="language-text" data-lang="text">sudo tar -xvzf apache-drill-1.0.0.tar.gz
</code></pre></div></li>
</ol>
-<p>The extraction process creates the installation directory named apache-drill-0.9.0 containing the Drill software.</p>
+<p>The extraction process creates the installation directory named apache-drill-1.0.0 containing the Drill software.</p>
-<p>At this point, you can <a href="/docs/drill-in-10-minutes/#start-drill">start Drill</a>.</p>
+<p>At this point, you can start Drill.</p>
<h2 id="start-drill-on-linux-and-mac-os-x">Start Drill on Linux and Mac OS X</h2>
-<p>Launch SQLLine using the sqlline command to start to Drill in embedded mode. The command directs SQLLine to connect to Drill. The zk=local means the local node is the ZooKeeper node. Complete the following steps to launch SQLLine and start Drill:</p>
+<p>Start Drill in embedded mode using the <code>drill-embedded</code> command:</p>
<ol>
<li><p>Navigate to the Drill installation directory. For example: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">cd apache-drill-0.9.0
+<div class="highlight"><pre><code class="language-text" data-lang="text">cd apache-drill-1.0.0
</code></pre></div></li>
-<li><p>Issue the following command to launch SQLLine:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline -u jdbc:drill:zk=local
+<li><p>Issue the following command to launch Drill in embedded mode:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drill-embedded
</code></pre></div></li>
</ol>
-<p>The <code>0: jdbc:drill:zk=local></code> prompt appears. </p>
+<p>The message of the day followed by the <code>0: jdbc:drill:zk=local></code> prompt appears. </p>
<p>At this point, you can <a href="/docs/drill-in-10-minutes#query-sample-data">submit queries</a> to Drill.</p>
@@ -911,32 +990,36 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
<p>You can install Drill on Windows 7 or 8. First, set the JAVA_HOME environment variable, and then install Drill. Complete the following steps to install Drill:</p>
<ol>
-<li>Click the following link to download the latest, stable version of Apache Drill: <a href="http://getdrill.org/drill/download/apache-drill-0.9.0.tar.gz">http://getdrill.org/drill/download/apache-drill-0.9.0.tar.gz</a></li>
-<li>Move the <code>apache-drill-0.9.0.tar.gz</code> file to a directory where you want to install Drill.</li>
-<li>Unzip the <code>TAR.GZ</code> file using a third-party tool. If the tool you use does not unzip the TAR file as well as the <code>TAR.GZ</code> file, unzip the <code>apache-drill-0.9.0.tar</code> to extract the Drill software. The extraction process creates the installation directory named apache-drill-0.9.0 containing the Drill software. For example:
-<img src="/docs/img/drill-directory.png" alt="drill install dir">
-At this point, you can start Drill.<br></li>
+<li>Click the following link to download the latest version of Apache Drill: <a href="http://getdrill.org/drill/download/apache-drill-0.1.0.tar.gz">http://getdrill.org/drill/download/apache-drill-1.0.0.tar.gz</a><br></li>
+<li>Move the <code>apache-drill-1.0.0.tar.gz</code> file to a directory where you want to install Drill.<br></li>
+<li>Unzip the <code>TAR.GZ</code> file using a third-party tool. If the tool you use does not unzip the TAR file as well as the <code>TAR.GZ</code> file, unzip the <code>apache-drill-1.0.0.tar</code> to extract the Drill software. The extraction process creates the installation directory named apache-drill-1.0.0 containing the Drill software. For example:<br>
+<img src="/docs/img/drill-directory.png" alt="drill install dir"></li>
</ol>
+<p>At this point, you can start Drill. </p>
+
<h2 id="start-drill-on-windows">Start Drill on Windows</h2>
-<p>Launch SQLLine using the <strong>sqlline command</strong> to start to Drill in embedded mode. The command directs SQLLine to connect to Drill. The <code>zk=local</code> means the local node is the ZooKeeper node. Complete the following steps to launch SQLLine and start Drill:</p>
+<p>Start Drill by running the sqlline.bat file and typing a connection string, as shown in the following procedure. The <code>zk=local</code> in the connection string means the local node is the ZooKeeper node:</p>
+
+<p>Start the Drill shell using the <strong>sqlline command</strong>. The <code>zk=local</code> means the local node is the ZooKeeper node. Complete the following steps to launch the Drill shell:</p>
<ol>
-<li>Open the apache-drill-0.9.0 folder.<br></li>
-<li>Open the bin folder, and double-click the <code>sqlline.bat</code> file:
-<img src="/docs/img/drill-bin.png" alt="drill bin dir">
-The Windows command prompt opens.<br></li>
-<li>At the sqlline> prompt, type <code>!connect jdbc:drill:zk=local</code> and then press Enter:
-<img src="/docs/img/sqlline1.png" alt="sqlline"></li>
-<li>Enter the username, <code>admin</code>, and password, also <code>admin</code> when prompted.
-The <code>0: jdbc:drill:zk=local></code> prompt appears.
-At this point, you can <a href="/docs/drill-in-10-minutes#query-sample-data">submit queries</a> to Drill.</li>
+<li>Open Command Prompt.<br></li>
+<li>Open the apache-drill-1.0.0 folder. For example:<br>
+<code>cd apache-drill-1.0.0</code></li>
+<li>Go to the bin directory. For example:<br>
+<code>cd bin</code></li>
+<li>Type the following command on the command line:
+<code>sqlline.bat -u "jdbc:drill:zk=local"</code>
+<img src="/docs/img/sqlline1.png" alt="drill install dir"></li>
</ol>
+<p>At this point, you can <a href="/docs/drill-in-10-minutes#query-sample-data">run queries</a>.</p>
+
<h2 id="stopping-drill">Stopping Drill</h2>
-<p>Issue the following command when you want to exit SQLLine:</p>
+<p>Issue the following command when you want to exit the Drill shell:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">!quit
</code></pre></div>
<h2 id="query-sample-data">Query Sample Data</h2>
@@ -955,34 +1038,17 @@ configuration, refer to <a href="/docs/connect-a-data-source-introduction">Stora
<p>To view the data in the <code>employee.json</code> file, submit the following SQL query
to Drill:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` LIMIT 3;
</code></pre></div>
-<p>The query returns the following results:</p>
-
-<p><strong>Example of partial output</strong></p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">+-------------+------------+------------+------------+-------------+-----------+
-| employee_id | full_name | first_name | last_name | position_id | position_ |
-+-------------+------------+------------+------------+-------------+-----------+
-| 1101 | Steve Eurich | Steve | Eurich | 16 | Store T |
-| 1102 | Mary Pierson | Mary | Pierson | 16 | Store T |
-| 1103 | Leo Jones | Leo | Jones | 16 | Store Tem |
-| 1104 | Nancy Beatty | Nancy | Beatty | 16 | Store T |
-| 1105 | Clara McNight | Clara | McNight | 16 | Store |
-| 1106 | Marcella Isaacs | Marcella | Isaacs | 17 | Stor |
-| 1107 | Charlotte Yonce | Charlotte | Yonce | 17 | Stor |
-| 1108 | Benjamin Foster | Benjamin | Foster | 17 | Stor |
-| 1109 | John Reed | John | Reed | 17 | Store Per |
-| 1110 | Lynn Kwiatkowski | Lynn | Kwiatkowski | 17 | St |
-| 1111 | Donald Vann | Donald | Vann | 17 | Store Pe |
-| 1112 | William Smith | William | Smith | 17 | Store |
-| 1113 | Amy Hensley | Amy | Hensley | 17 | Store Pe |
-| 1114 | Judy Owens | Judy | Owens | 17 | Store Per |
-| 1115 | Frederick Castillo | Frederick | Castillo | 17 | S |
-| 1116 | Phil Munoz | Phil | Munoz | 17 | Store Per |
-| 1117 | Lori Lightfoot | Lori | Lightfoot | 17 | Store |
-+-------------+------------+------------+------------+-------------+-----------+
-1,155 rows selected (0.762 seconds)
-0: jdbc:drill:zk=local>
+<p>The query output is:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">+--------------+------------------+-------------+------------+--------------+---------------------+-----------+----------------+-------------+------------------------+----------+----------------+------------------+-----------------+---------+--------------------+
+| employee_id | full_name | first_name | last_name | position_id | position_title | store_id | department_id | birth_date | hire_date | salary | supervisor_id | education_level | marital_status | gender | management_role |
++--------------+------------------+-------------+------------+--------------+---------------------+-----------+----------------+-------------+------------------------+----------+----------------+------------------+-----------------+---------+--------------------+
+| 1 | Sheri Nowmer | Sheri | Nowmer | 1 | President | 0 | 1 | 1961-08-26 | 1994-12-01 00:00:00.0 | 80000.0 | 0 | Graduate Degree | S | F | Senior Management |
+| 2 | Derrick Whelply | Derrick | Whelply | 2 | VP Country Manager | 0 | 1 | 1915-07-03 | 1994-12-01 00:00:00.0 | 40000.0 | 1 | Graduate Degree | M | M | Senior Management |
+| 4 | Michael Spence | Michael | Spence | 2 | VP Country Manager | 0 | 1 | 1969-06-20 | 1998-01-01 00:00:00.0 | 40000.0 | 1 | Graduate Degree | S | M | Senior Management |
++--------------+------------------+-------------+------------+--------------+---------------------+-----------+----------------+-------------+------------------------+----------+----------------+------------------+-----------------+---------+--------------------+
+3 rows selected (0.827 seconds)
</code></pre></div>
<h3 id="querying-a-parquet-file">Querying a Parquet File</h3>
@@ -1016,17 +1082,16 @@ your operating system:</p>
</ul>
<p>The query returns the following results:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+
-| EXPR$0 | EXPR$1 |
-+------------+------------+
-| AFRICA | lar deposits. blithely final packages cajole. regular waters ar |
-| AMERICA | hs use ironic, even requests. s |
-| ASIA | ges. thinly even pinto beans ca |
-| EUROPE | ly final courts cajole furiously final excuse |
-| MIDDLE EAST | uickly special accounts cajole carefully blithely close reques |
-+------------+------------+
-5 rows selected (0.165 seconds)
-0: jdbc:drill:zk=local>
+<div class="highlight"><pre><code class="language-text" data-lang="text">+--------------+--------------+-----------------------+
+| R_REGIONKEY | R_NAME | R_COMMENT |
++--------------+--------------+-----------------------+
+| 0 | AFRICA | lar deposits. blithe |
+| 1 | AMERICA | hs use ironic, even |
+| 2 | ASIA | ges. thinly even pin |
+| 3 | EUROPE | ly final courts cajo |
+| 4 | MIDDLE EAST | uickly special accou |
++--------------+--------------+-----------------------+
+5 rows selected (0.409 seconds)
</code></pre></div>
<h4 id="nation-file">Nation File</h4>
@@ -1034,7 +1099,10 @@ your operating system:</p>
in embedded mode, the path to the parquet file varies between operating
systems.</p>
-<p><strong>Note:</strong> When you enter the query, include the version of Drill that you are currently running. </p>
+<div class="admonition note">
+ <p class="first admonition-title">Note</p>
+ <p class="last">When you enter the query, include the version of Drill that you are currently running. </p>
+</div>
<p>To view the data in the <code>nation.parquet</code> file, issue the query appropriate for
your operating system:</p>
@@ -1052,16 +1120,45 @@ your operating system:</p>
</ul>
<p>The query returns the following results:</p>
-
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`Users/khahn/drill/apache-drill-1.0.0-SNAPSHOT/sample-data/nation.parquet`;
++--------------+-----------------+--------------+-----------------------+
+| N_NATIONKEY | N_NAME | N_REGIONKEY | N_COMMENT |
++--------------+-----------------+--------------+-----------------------+
+| 0 | ALGERIA | 0 | haggle. carefully f |
+| 1 | ARGENTINA | 1 | al foxes promise sly |
+| 2 | BRAZIL | 1 | y alongside of the p |
+| 3 | CANADA | 1 | eas hang ironic, sil |
+| 4 | EGYPT | 4 | y above the carefull |
+| 5 | ETHIOPIA | 0 | ven packages wake qu |
+| 6 | FRANCE | 3 | refully final reques |
+| 7 | GERMANY | 3 | l platelets. regular |
+| 8 | INDIA | 2 | ss excuses cajole sl |
+| 9 | INDONESIA | 2 | slyly express asymp |
+| 10 | IRAN | 4 | efully alongside of |
+| 11 | IRAQ | 4 | nic deposits boost a |
+| 12 | JAPAN | 2 | ously. final, expres |
+| 13 | JORDAN | 4 | ic deposits are blit |
+| 14 | KENYA | 0 | pending excuses hag |
+| 15 | MOROCCO | 0 | rns. blithely bold c |
+| 16 | MOZAMBIQUE | 0 | s. ironic, unusual a |
+| 17 | PERU | 1 | platelets. blithely |
+| 18 | CHINA | 2 | c dependencies. furi |
+| 19 | ROMANIA | 3 | ular asymptotes are |
+| 20 | SAUDI ARABIA | 4 | ts. silent requests |
+| 21 | VIETNAM | 2 | hely enticingly expr |
+| 22 | RUSSIA | 3 | requests against th |
+| 23 | UNITED KINGDOM | 3 | eans boost carefully |
+| 24 | UNITED STATES | 1 | y final packages. sl |
++--------------+-----------------+--------------+-----------------------+
+25 rows selected (0.101 seconds)
+</code></pre></div>
<h2 id="summary">Summary</h2>
-<p>Now you know a bit about Apache Drill. To summarize, you have completed the
-following tasks:</p>
+<p>Now, you have been introduced to Apache Drill, which supports nested data, schema-less execution, and decentralized metadata. To summarize, you have completed the following tasks:</p>
<ul>
-<li>Learned that Apache Drill supports nested data, schema-less execution, and decentralized metadata.</li>
<li>Downloaded and installed Apache Drill.</li>
-<li>Invoked SQLLine with Drill in embedded mode.</li>
+<li>Started Drill in embedded mode.</li>
<li>Queried the sample JSON file, <code>employee.json</code>, to view its data.</li>
<li>Queried the sample <code>region.parquet</code> file to view its data.</li>
<li>Queried the sample <code>nation.parquet</code> file to view its data.</li>
@@ -1072,7 +1169,7 @@ following tasks:</p>
<p>Now that you have an idea about what Drill can do, you might want to:</p>
<ul>
-<li><a href="/docs/deploying-drill-in-a-cluster">Deploy Drill in a clustered environment.</a></li>
+<li><a href="/docs/installing-drill-on-the-cluster">Install Drill on a cluster.</a></li>
<li><a href="/docs/connect-a-data-source-introduction">Configure storage plugins to connect Drill to your data sources</a>.</li>
<li>Query <a href="/docs/querying-hive">Hive</a> and <a href="/docs/hbase-storage-plugin">HBase</a> data.</li>
<li><a href="/docs/querying-complex-data">Query Complex Data</a></li>
@@ -1084,17 +1181,17 @@ following tasks:</p>
<p>For more information about Apache Drill, explore the <a href="http://drill.apache.org">Apache Drill
web site</a>.</p>
+
-
- <div class="doc-nav">
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/tutorials-introduction/">← Tutorials Introduction</a></span><span class="next-toc"><a href="/docs/analyzing-the-yelp-academic-dataset/">Analyzing the Yelp Academic Dataset →</a></span>
</div>
-
- </div>
+
</div>
</div>
+</div>
</div>
<p class="push"></p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/drill-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-introduction/index.html b/docs/drill-introduction/index.html
index f4c5933..3cb7d6d 100644
--- a/docs/drill-introduction/index.html
+++ b/docs/drill-introduction/index.html
@@ -9,26 +9,21 @@
<title>Drill Introduction - 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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 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>
@@ -63,6 +58,12 @@
<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/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
<li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+ <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+
</ul>
</li>
<li class='nav'>
@@ -110,7 +113,9 @@
</ul>
</div>
-
+ <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
@@ -149,14 +154,7 @@
- <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>
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
</ul>
@@ -203,6 +201,10 @@
<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>
+
+
</ul>
@@ -300,7 +302,7 @@
- <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/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
</ul>
@@ -357,7 +359,7 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</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>
@@ -409,6 +411,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server 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>
@@ -487,6 +493,32 @@
+ <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+
+
+ </ul>
+
+
+
+ <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+
+
+
+ <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+ <ul style="display: none">
+
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+
+
+ </ul>
+
+
+
<li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
<ul style="display: none">
@@ -563,27 +595,47 @@
<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-session/">ALTER SESSION</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/alter-system-command/">ALTER SYSTEM Command</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/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</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/create-view-command/">CREATE VIEW Command</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/describe-command/">DESCRIBE Command</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/explain-commands/">EXPLAIN Commands</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-statements/">SELECT Statements</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</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/select-group-by/">SELECT GROUP BY</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/select-having/">SELECT HAVING</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/select-limit/">SELECT LIMIT</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</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>
@@ -782,6 +834,10 @@
<li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+
+
</ul>
@@ -800,6 +856,29 @@
<li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
+
+ <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>
+
+
+ </ul>
+
+
</ul>
</div>
@@ -807,7 +886,7 @@
</aside>
- <nav class="breadcrumbs">
+<nav class="breadcrumbs">
<li><a href="/docs/">Docs</a></li>
@@ -816,29 +895,47 @@
<li>Drill Introduction</li>
</nav>
- <div class="main-content-wrapper">
- <div class="main-content">
+<div class="main-content-wrapper">
+ <div class="main-content">
-
- <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/getting-started/010-drill-introduction.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-
+
+ <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/getting-started/010-drill-introduction.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+
- <div class="int_title">
- <h1>Drill Introduction</h1>
+ <div class="int_title left">
+ <h1>Drill Introduction</h1>
- </div>
+ </div>
- <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+ <link href="/css/docpage.css" rel="stylesheet" type="text/css">
- <div class="int_text" align="left">
-
- <p>Drill is an Apache open-source SQL query engine for Big Data exploration.
+ <div class="int_text" align="left">
+
+ <p>Drill is an Apache open-source SQL query engine for Big Data exploration.
Drill is designed from the ground up to support high-performance analysis on
the semi-structured and rapidly evolving data coming from modern Big Data
applications, while still providing the familiarity and ecosystem of ANSI SQL,
the industry-standard query language. Drill provides plug-and-play integration
-with existing Apache Hive and Apache HBase deployments. Apache Drill offers
-the following key features:</p>
+with existing Apache Hive and Apache HBase deployments. </p>
+
+<h2 id="what's-new-in-apache-drill-1.0">What's New in Apache Drill 1.0</h2>
+
+<p>Apache Drill 1.0 offers the following new features:</p>
+
+<ul>
+<li>Many performance planning and execution <a href="/docs/performance-tuning-introduction/">improvements</a>.</li>
+<li>Updated <a href="/docs/configuring-the-drill-shell/#examples-of-configuring-the-drill-shell">Drill shell</a> and now formats query results having fewer than 70 characters in a column.</li>
+<li><a href="/docs/getting-query-information/">Query audit logging</a> for getting the query history on a Drillbit.</li>
+<li>Improved connection handling.</li>
+<li>New Errors tab in the Query Profiles UI that facilitates troubleshooting and distributed storing of profiles.</li>
+<li>Support for a new storage plugin input format: <a href="http://avro.apache.org/docs/current/spec.html">Avro</a></li>
+</ul>
+
+<p>In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. To enable the DECIMAL type, set the <code>planner.enable_decimal_data_type</code> system option to <code>true</code>.</p>
+
+<h2 id="apache-drill-key-features">Apache Drill Key Features</h2>
+
+<p>Key features of Apache Drill are:</p>
<ul>
<li>Low-latency SQL queries</li>
@@ -861,44 +958,17 @@ the following key features:</p>
<li><a href="/docs/tutorials-introduction">Drill Tutorials</a></li>
</ul>
-<h2 id="videos">Videos</h2>
-
-<table>
- <tr>
- <th><a href="http://www.youtube.com/watch?feature=player_embedded&v=HITzj3ihSUk
-" target="_blank"><img src="http://img.youtube.com/vi/HITzj3ihSUk/0.jpg"
-alt="intro to Drill" width="240" height="180" border="10" />Introduction to Apache Drill</a></th>
- <th><a href="http://www.youtube.com/watch?feature=player_embedded&v=FkcegazNuio
-" target="_blank"><img src="http://img.youtube.com/vi/FkcegazNuio/0.jpg"
-alt="Tableau and Drill" width="240" height="180" border="10" />Tableau + Drill</a</th>
- </tr>
- <tr>
- <td><a href="http://www.youtube.com/watch?feature=player_embedded&v=kG6vzsk8T7E
-" target="_blank"><img src="http://img.youtube.com/vi/kG6vzsk8T7E/0.jpg"
-alt="drill config options" width="240" height="180" border="10" />Drill Configuration Options</a></td>
- <td><a href="http://www.youtube.com/watch?feature=player_embedded&v=XUIKlsX8yVM
-" target="_blank"><img src="http://img.youtube.com/vi/XUIKlsX8yVM/0.jpg"
-alt="Self-service SQL Exploration on Mongo" width="240" height="180" border="10" />Self-service SQL Exploration on MongoDB</a></td>
- </tr>
- <tr>
- <td><a href="http://www.youtube.com/watch?feature=player_embedded&v=uyN9DDCNP8o
-" target="_blank"><img src="http://img.youtube.com/vi/uyN9DDCNP8o/0.jpg"
-alt="Microstrategy and Drill" width="240" height="180" border="10" />Microstrategy + Drill</a></td>
- <td></td>
- </tr>
-</table>
-
-
-
- <div class="doc-nav">
+
+
+ <div class="doc-nav">
<span class="previous-toc"><a href="/docs/getting-started/">← Getting Started</a></span><span class="next-toc"><a href="/docs/why-drill/">Why Drill →</a></span>
</div>
-
- </div>
+
</div>
</div>
+</div>
</div>
<p class="push"></p>