You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by kr...@apache.org on 2015/12/18 03:01:24 UTC
[3/5] drill-site git commit: test files built w/jekyll 2.5.3
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/json-data-model/index.html
----------------------------------------------------------------------
diff --git a/docs/json-data-model/index.html b/docs/json-data-model/index.html
index 8f80749..9e657c0 100644
--- a/docs/json-data-model/index.html
+++ b/docs/json-data-model/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1135,7 +1131,7 @@ Reads all data from JSON files as VARCHAR. You need to cast numbers from VARCHAR
<p>Drill uses these types internally for reading complex and nested data structures from data sources such as JSON.</p>
-<h3 id="experimental-feature:-heterogeneous-types">Experimental Feature: Heterogeneous types</h3>
+<h3 id="experimental-feature-heterogeneous-types">Experimental Feature: Heterogeneous types</h3>
<p>The Union type allows storing different types in the same field. This new feature is still considered experimental, and must be explicitly enabled by setting the <code>exec.enabel_union_type</code> option to true.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SESSION SET `exec.enable_union_type` = true;
@@ -1231,11 +1227,11 @@ y[z].x because these references are not ambiguous. Observe the following guideli
<li>Generate key/value pairs for loosely structured data</li>
</ul>
-<h2 id="example:-flatten-and-generate-key-values-for-complex-json">Example: Flatten and Generate Key Values for Complex JSON</h2>
+<h2 id="example-flatten-and-generate-key-values-for-complex-json">Example: Flatten and Generate Key Values for Complex JSON</h2>
<p>This example uses the following data that represents unit sales of tickets to events that were sold over a period of several days in December:</p>
-<h3 id="ticket_sales.json-contents">ticket_sales.json Contents</h3>
+<h3 id="ticket_sales-json-contents">ticket_sales.json Contents</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">{
"type": "ticket",
"venue": 123455,
@@ -1266,7 +1262,7 @@ y[z].x because these references are not ambiguous. Observe the following guideli
+---------+---------+---------------------------------------------------------------+
2 rows selected (1.343 seconds)
</code></pre></div>
-<h3 id="generate-key/value-pairs">Generate Key/Value Pairs</h3>
+<h3 id="generate-key-value-pairs">Generate Key/Value Pairs</h3>
<p>Continuing with the data from <a href="/docs/json-data-model/#example:-flatten-and-generate-key-values-for-complex-json">previous example</a>, use the KVGEN (Key Value Generator) function to generate key/value pairs from complex data. Generating key/value pairs is often helpful when working with data that contains arbitrary maps consisting of dynamic and unknown element names, such as the ticket sales data in this example. For example purposes, take a look at how kvgen breaks the sales data into keys and values representing the key dates and number of tickets sold:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT KVGEN(tkt.sales) AS `key dates:tickets sold` FROM dfs.`/Users/drilluser/ticket_sales.json` tkt;
@@ -1300,7 +1296,7 @@ FROM dfs.`/Users/drilluser/drill/ticket_sales.json`;
+--------------------------------+
8 rows selected (0.171 seconds)
</code></pre></div>
-<h3 id="example:-aggregate-loosely-structured-data">Example: Aggregate Loosely Structured Data</h3>
+<h3 id="example-aggregate-loosely-structured-data">Example: Aggregate Loosely Structured Data</h3>
<p>Use flatten and kvgen together to aggregate the data from the <a href="/docs/json-data-model/#example:-flatten-and-generate-key-values-for-complex-json">previous example</a>. Make sure all text mode is set to false to sum numbers. Drill returns an error if you attempt to sum data in all text mode.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `store.json.all_text_mode` = false;
@@ -1315,7 +1311,7 @@ FROM dfs.`/Users/drilluser/drill/ticket_sales.json`;
+--------------+
1 row selected (0.244 seconds)
</code></pre></div>
-<h3 id="example:-aggregate-and-sort-data">Example: Aggregate and Sort Data</h3>
+<h3 id="example-aggregate-and-sort-data">Example: Aggregate and Sort Data</h3>
<p>Sum and group the ticket sales by date and sort in ascending order of total tickets sold.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT `right`(tkt.tot_sales.key,2) `December Date`,
@@ -1336,7 +1332,7 @@ ORDER BY TotalSales;
+----------------+-------------+
5 rows selected (0.252 seconds)
</code></pre></div>
-<h3 id="example:-access-a-map-field-in-an-array">Example: Access a Map Field in an Array</h3>
+<h3 id="example-access-a-map-field-in-an-array">Example: Access a Map Field in an Array</h3>
<p>To access a map field in an array, use dot notation to drill down through the hierarchy of the JSON data to the field. Examples are based on the following <a href="https://github.com/zemirco/sf-city-lots-json">City Lots San Francisco in .json</a>.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">{
@@ -1400,7 +1396,7 @@ FROM dfs.`/Users/drilluser/citylots.json`;
<p>More examples of drilling down into an array are shown in <a href="/docs/selecting-nested-data-for-a-column">"Selecting Nested Data for a Column"</a>.</p>
-<h3 id="example:-flatten-an-array-of-maps-using-a-subquery">Example: Flatten an Array of Maps using a Subquery</h3>
+<h3 id="example-flatten-an-array-of-maps-using-a-subquery">Example: Flatten an Array of Maps using a Subquery</h3>
<p>By flattening the following JSON file, which contains an array of maps, you can evaluate the records of the flattened data.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">{"name":"classic","fillings":[ {"name":"sugar","cal":500} , {"name":"flour","cal":300} ] }
@@ -1416,7 +1412,7 @@ SELECT flat.fill FROM (SELECT FLATTEN(t.fillings) AS fill FROM dfs.flatten.`test
</code></pre></div>
<p>Use a table alias for column fields and functions when working with complex data sets. Currently, you must use a subquery when operating on a flattened column. Eliminating the subquery and table alias in the WHERE clause, for example <code>flat.fillings[0].cal > 300</code>, does not evaluate all records of the flattened data against the predicate and produces the wrong results.</p>
-<h3 id="example:-access-map-fields-in-a-map">Example: Access Map Fields in a Map</h3>
+<h3 id="example-access-map-fields-in-a-map">Example: Access Map Fields in a Map</h3>
<p>This example uses a WHERE clause to drill down to a third level of the following JSON hierarchy to get the max_hdl greater than 160:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">{
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/kvgen/index.html
----------------------------------------------------------------------
diff --git a/docs/kvgen/index.html b/docs/kvgen/index.html
index 779e980..e2c8613 100644
--- a/docs/kvgen/index.html
+++ b/docs/kvgen/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1137,7 +1133,7 @@ array down into multiple distinct rows and further query those rows.</p>
{"key": "c", "value": "valC"}
{"key": "d", "value": "valD"}
</code></pre></div>
-<h2 id="example:-different-data-type-values">Example: Different Data Type Values</h2>
+<h2 id="example-different-data-type-values">Example: Different Data Type Values</h2>
<p>Assume that a JSON file called <code>kvgendata.json</code> includes multiple records that
look like this one:</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/learn-drill-with-the-mapr-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/learn-drill-with-the-mapr-sandbox/index.html b/docs/learn-drill-with-the-mapr-sandbox/index.html
index a7fa180..c6e79bb 100644
--- a/docs/learn-drill-with-the-mapr-sandbox/index.html
+++ b/docs/learn-drill-with-the-mapr-sandbox/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/lesson-1-learn-about-the-data-set/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-1-learn-about-the-data-set/index.html b/docs/lesson-1-learn-about-the-data-set/index.html
index c76288b..03abeda 100644
--- a/docs/lesson-1-learn-about-the-data-set/index.html
+++ b/docs/lesson-1-learn-about-the-data-set/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1094,7 +1090,7 @@ the Drill shell, type:</p>
+-------+--------------------------------------------+
1 row selected
</code></pre></div>
-<h3 id="list-the-available-workspaces-and-databases:">List the available workspaces and databases:</h3>
+<h3 id="list-the-available-workspaces-and-databases">List the available workspaces and databases:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> show databases;
+---------------------+
| SCHEMA_NAME |
@@ -1124,7 +1120,7 @@ different database schemas (namespaces) in a relational database system.</p>
This is a Hive external table pointing to the data stored in flat files on the
MapR file system. The orders table contains 122,000 rows.</p>
-<h3 id="set-the-schema-to-hive:">Set the schema to hive:</h3>
+<h3 id="set-the-schema-to-hive">Set the schema to hive:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use hive.`default`;
+-------+-------------------------------------------+
| ok | summary |
@@ -1136,7 +1132,7 @@ MapR file system. The orders table contains 122,000 rows.</p>
<p>You will run the USE command throughout this tutorial. The USE command sets
the schema for the current session.</p>
-<h3 id="describe-the-table:">Describe the table:</h3>
+<h3 id="describe-the-table">Describe the table:</h3>
<p>You can use the DESCRIBE command to show the columns and data types for a Hive
table:</p>
@@ -1155,7 +1151,7 @@ table:</p>
<p>The DESCRIBE command returns complete schema information for Hive tables based
on the metadata available in the Hive metastore.</p>
-<h3 id="select-5-rows-from-the-orders-table:">Select 5 rows from the orders table:</h3>
+<h3 id="select-5-rows-from-the-orders-table">Select 5 rows from the orders table:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select * from orders limit 5;
+------------+------------+------------+------------+------------+-------------+
| order_id | month | cust_id | state | prod_id | order_total |
@@ -1213,7 +1209,7 @@ columns typical of a time-series database.</p>
<p>The customers table contains 993 rows.</p>
-<h3 id="set-the-workspace-to-maprdb:">Set the workspace to maprdb:</h3>
+<h3 id="set-the-workspace-to-maprdb">Set the workspace to maprdb:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">use maprdb;
+-------+-------------------------------------+
| ok | summary |
@@ -1222,7 +1218,7 @@ columns typical of a time-series database.</p>
+-------+-------------------------------------+
1 row selected
</code></pre></div>
-<h3 id="describe-the-tables:">Describe the tables:</h3>
+<h3 id="describe-the-tables">Describe the tables:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> describe customers;
+--------------+------------------------+--------------+
| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
@@ -1255,7 +1251,7 @@ structure, and “ANY” represents the fact that the column value can be of any
data type. Observe the row_key, which is also simply bytes and has the type
ANY.</p>
-<h3 id="select-5-rows-from-the-products-table:">Select 5 rows from the products table:</h3>
+<h3 id="select-5-rows-from-the-products-table">Select 5 rows from the products table:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select * from products limit 5;
+--------------+----------------------------------------------------------------------------------------------------------------+-------------------+
| row_key | details | pricing |
@@ -1275,7 +1271,7 @@ and pricing) have the map data type and appear as JSON strings.</p>
<p>In Lesson 2, you will use CAST functions to return typed data for each column.</p>
-<h3 id="select-5-rows-from-the-customers-table:">Select 5 rows from the customers table:</h3>
+<h3 id="select-5-rows-from-the-customers-table">Select 5 rows from the customers table:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">+0: jdbc:drill:> select * from customers limit 5;
+--------------+-----------------------+-------------------------------------------------+---------------------------------------------------------------------------------------+
| row_key | address | loyalty | personal |
@@ -1319,7 +1315,7 @@ setup beyond the definition of a workspace.</p>
<h3 id="query-nested-clickstream-data">Query nested clickstream data</h3>
-<h4 id="set-the-workspace-to-dfs.clicks:">Set the workspace to dfs.clicks:</h4>
+<h4 id="set-the-workspace-to-dfs-clicks">Set the workspace to dfs.clicks:</h4>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use dfs.clicks;
+-------+-----------------------------------------+
| ok | summary |
@@ -1340,7 +1336,7 @@ location specified in the workspace. For example:</p>
relative to this path. The clicks directory referred to in the following query
is directly below the nested directory.</p>
-<h4 id="select-2-rows-from-the-clicks.json-file:">Select 2 rows from the clicks.json file:</h4>
+<h4 id="select-2-rows-from-the-clicks-json-file">Select 2 rows from the clicks.json file:</h4>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select * from `clicks/clicks.json` limit 2;
+-----------+-------------+-----------+---------------------------------------------------+-------------------------------------------+
| trans_id | date | time | user_info | trans_info |
@@ -1358,7 +1354,7 @@ to refer to a file in a local or distributed file system.</p>
path. This is necessary whenever the file path contains Drill reserved words
or characters.</p>
-<h4 id="select-2-rows-from-the-campaign.json-file:">Select 2 rows from the campaign.json file:</h4>
+<h4 id="select-2-rows-from-the-campaign-json-file">Select 2 rows from the campaign.json file:</h4>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select * from `clicks/clicks.campaign.json` limit 2;
+-----------+-------------+-----------+---------------------------------------------------+---------------------+----------------------------------------+
| trans_id | date | time | user_info | ad_info | trans_info |
@@ -1392,7 +1388,7 @@ for that month. The total number of records in all log files is 48000.</p>
are many of these files, but you can use Drill to query them all as a single
data source, or to query a subset of the files.</p>
-<h4 id="set-the-workspace-to-dfs.logs:">Set the workspace to dfs.logs:</h4>
+<h4 id="set-the-workspace-to-dfs-logs">Set the workspace to dfs.logs:</h4>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use dfs.logs;
+-------+---------------------------------------+
| ok | summary |
@@ -1401,7 +1397,7 @@ data source, or to query a subset of the files.</p>
+-------+---------------------------------------+
1 row selected
</code></pre></div>
-<h4 id="select-2-rows-from-the-logs-directory:">Select 2 rows from the logs directory:</h4>
+<h4 id="select-2-rows-from-the-logs-directory">Select 2 rows from the logs directory:</h4>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select * from logs limit 2;
+-------+-------+-----------+-------------+-----------+----------+---------+--------+----------+-----------+----------+-------------+
| dir0 | dir1 | trans_id | date | time | cust_id | device | state | camp_id | keywords | prod_id | purch_flag |
@@ -1420,7 +1416,7 @@ directory path on the file system.</p>
subdirectories below the logs directory. In Lesson 3, you will do more complex
queries that leverage these dynamic variables.</p>
-<h4 id="find-the-total-number-of-rows-in-the-logs-directory-(all-files):">Find the total number of rows in the logs directory (all files):</h4>
+<h4 id="find-the-total-number-of-rows-in-the-logs-directory-all-files">Find the total number of rows in the logs directory (all files):</h4>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select count(*) from logs;
+---------+
| EXPR$0 |
@@ -1432,7 +1428,7 @@ queries that leverage these dynamic variables.</p>
<p>This query traverses all of the files in the logs directory and its
subdirectories to return the total number of rows in those files.</p>
-<h1 id="what's-next">What's Next</h1>
+<h1 id="what-39-s-next">What's Next</h1>
<p>Go to <a href="/docs/lesson-2-run-queries-with-ansi-sql">Lesson 2: Run Queries with ANSI
SQL</a>.</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/lesson-2-run-queries-with-ansi-sql/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-2-run-queries-with-ansi-sql/index.html b/docs/lesson-2-run-queries-with-ansi-sql/index.html
index 6c8743b..fee72c2 100644
--- a/docs/lesson-2-run-queries-with-ansi-sql/index.html
+++ b/docs/lesson-2-run-queries-with-ansi-sql/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1072,7 +1068,7 @@ statement.</p>
<h2 id="aggregation">Aggregation</h2>
-<h3 id="set-the-schema-to-hive:">Set the schema to hive:</h3>
+<h3 id="set-the-schema-to-hive">Set the schema to hive:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use hive.`default`;
+-------+-------------------------------------------+
| ok | summary |
@@ -1081,7 +1077,7 @@ statement.</p>
+-------+-------------------------------------------+
1 row selected
</code></pre></div>
-<h3 id="return-sales-totals-by-month:">Return sales totals by month:</h3>
+<h3 id="return-sales-totals-by-month">Return sales totals by month:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select `month`, sum(order_total)
from orders group by `month` order by 2 desc;
+------------+---------+
@@ -1107,7 +1103,7 @@ database queries.</p>
<p>Note that back ticks are required for the “month” column only because “month”
is a reserved word in SQL.</p>
-<h3 id="return-the-top-20-sales-totals-by-month-and-state:">Return the top 20 sales totals by month and state:</h3>
+<h3 id="return-the-top-20-sales-totals-by-month-and-state">Return the top 20 sales totals by month and state:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select `month`, state, sum(order_total) as sales from orders group by `month`, state
order by 3 desc limit 20;
+-----------+--------+---------+
@@ -1143,7 +1139,7 @@ aliases and table aliases.</p>
<p>This query uses the HAVING clause to constrain an aggregate result.</p>
-<h3 id="set-the-workspace-to-dfs.clicks">Set the workspace to dfs.clicks</h3>
+<h3 id="set-the-workspace-to-dfs-clicks">Set the workspace to dfs.clicks</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use dfs.clicks;
+-------+-----------------------------------------+
| ok | summary |
@@ -1152,7 +1148,7 @@ aliases and table aliases.</p>
+-------+-----------------------------------------+
1 row selected
</code></pre></div>
-<h3 id="return-total-number-of-clicks-for-devices-that-indicate-high-click-throughs:">Return total number of clicks for devices that indicate high click-throughs:</h3>
+<h3 id="return-total-number-of-clicks-for-devices-that-indicate-high-click-throughs">Return total number of clicks for devices that indicate high click-throughs:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select t.user_info.device, count(*) from `clicks/clicks.json` t
group by t.user_info.device
having count(*) > 1000;
@@ -1195,7 +1191,7 @@ duplicate rows from those files): <code>clicks.campaign.json</code> and <code>cl
<h2 id="subqueries">Subqueries</h2>
-<h3 id="set-the-workspace-to-hive:">Set the workspace to hive:</h3>
+<h3 id="set-the-workspace-to-hive">Set the workspace to hive:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use hive.`default`;
+-------+-------------------------------------------+
| ok | summary |
@@ -1204,7 +1200,7 @@ duplicate rows from those files): <code>clicks.campaign.json</code> and <code>cl
+-------+-------------------------------------------+
1 row selected
</code></pre></div>
-<h3 id="compare-order-totals-across-states:">Compare order totals across states:</h3>
+<h3 id="compare-order-totals-across-states">Compare order totals across states:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select ny_sales.cust_id, ny_sales.total_orders, ca_sales.total_orders
from
(select o.cust_id, sum(o.order_total) as total_orders from hive.orders o where state = 'ny' group by o.cust_id) ny_sales
@@ -1242,7 +1238,7 @@ limit 20;
<h2 id="cast-function">CAST Function</h2>
-<h3 id="use-the-maprdb-workspace:">Use the maprdb workspace:</h3>
+<h3 id="use-the-maprdb-workspace">Use the maprdb workspace:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use maprdb;
+-------+-------------------------------------+
| ok | summary |
@@ -1275,7 +1271,7 @@ from customers t limit 5;
<li>The table alias t is required; otherwise the column family names would be parsed as table names and the query would return an error.</li>
</ul>
-<h3 id="remove-the-quotes-from-the-strings:">Remove the quotes from the strings:</h3>
+<h3 id="remove-the-quotes-from-the-strings">Remove the quotes from the strings:</h3>
<p>You can use the regexp_replace function to remove the quotes around the
strings in the query results. For example, to return a state name va instead
@@ -1298,7 +1294,7 @@ from customers t limit 1;
+-------+----------------------------------------+
1 row selected
</code></pre></div>
-<h3 id="use-a-mutable-workspace:">Use a mutable workspace:</h3>
+<h3 id="use-a-mutable-workspace">Use a mutable workspace:</h3>
<p>A mutable (or writable) workspace is a workspace that is enabled for “write”
operations. This attribute is part of the storage plugin configuration. You
@@ -1337,7 +1333,7 @@ statement.</p>
defined in data sources such as Hive, HBase, and the file system. Drill also
supports the creation of metadata in the file system.</p>
-<h3 id="query-data-from-the-view:">Query data from the view:</h3>
+<h3 id="query-data-from-the-view">Query data from the view:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select * from custview limit 1;
+----------+-------------------+-----------+----------+--------+----------+-------------+
| cust_id | name | gender | age | state | agg_rev | membership |
@@ -1352,7 +1348,7 @@ supports the creation of metadata in the file system.</p>
<p>Continue using <code>dfs.views</code> for this query.</p>
-<h3 id="join-the-customers-view-and-the-orders-table:">Join the customers view and the orders table:</h3>
+<h3 id="join-the-customers-view-and-the-orders-table">Join the customers view and the orders table:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select membership, sum(order_total) as sales from hive.orders, custview
where orders.cust_id=custview.cust_id
group by membership order by 2;
@@ -1378,7 +1374,7 @@ rows are wide, set the maximum width of the display to 10000:</p>
<p>Do not use a semicolon for this SET command.</p>
-<h3 id="join-the-customers,-orders,-and-clickstream-data:">Join the customers, orders, and clickstream data:</h3>
+<h3 id="join-the-customers-orders-and-clickstream-data">Join the customers, orders, and clickstream data:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select custview.membership, sum(orders.order_total) as sales from hive.orders, custview,
dfs.`/mapr/demo.mapr.com/data/nested/clicks/clicks.json` c
where orders.cust_id=custview.cust_id and orders.cust_id=c.user_info.cust_id
@@ -1408,7 +1404,7 @@ hive.orders table is also visible to the query.</p>
workspace, so the query specifies the full path to the file:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">dfs.`/mapr/demo.mapr.com/data/nested/clicks/clicks.json`
</code></pre></div>
-<h2 id="what's-next">What's Next</h2>
+<h2 id="what-39-s-next">What's Next</h2>
<p>Go to <a href="/docs/lesson-3-run-queries-on-complex-data-types">Lesson 3: Run Queries on Complex Data Types</a>. </p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/lesson-3-run-queries-on-complex-data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-3-run-queries-on-complex-data-types/index.html b/docs/lesson-3-run-queries-on-complex-data-types/index.html
index 3f455d0..11c312e 100644
--- a/docs/lesson-3-run-queries-on-complex-data-types/index.html
+++ b/docs/lesson-3-run-queries-on-complex-data-types/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1083,7 +1079,7 @@ exist. Here is a visual example of how this works:</p>
<p><img src="/docs/img/example_query.png" alt="drill query flow"></p>
-<h3 id="set-workspace-to-dfs.logs:">Set workspace to dfs.logs:</h3>
+<h3 id="set-workspace-to-dfs-logs">Set workspace to dfs.logs:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use dfs.logs;
+-------+---------------------------------------+
| ok | summary |
@@ -1092,7 +1088,7 @@ exist. Here is a visual example of how this works:</p>
+-------+---------------------------------------+
1 row selected
</code></pre></div>
-<h3 id="query-logs-data-for-a-specific-year:">Query logs data for a specific year:</h3>
+<h3 id="query-logs-data-for-a-specific-year">Query logs data for a specific year:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select * from logs where dir0='2013' limit 10;
+-------+-------+-----------+-------------+-----------+----------+---------+--------+----------+-----------+----------+-------------+
| dir0 | dir1 | trans_id | date | time | cust_id | device | state | camp_id | keywords | prod_id | purch_flag |
@@ -1114,7 +1110,7 @@ exist. Here is a visual example of how this works:</p>
dir0 refers to the first level down from logs, dir1 to the next level, and so
on. So this query returned 10 of the rows for February 2013.</p>
-<h3 id="further-constrain-the-results-using-multiple-predicates-in-the-query:">Further constrain the results using multiple predicates in the query:</h3>
+<h3 id="further-constrain-the-results-using-multiple-predicates-in-the-query">Further constrain the results using multiple predicates in the query:</h3>
<p>This query returns a list of customer IDs for people who made a purchase via
an IOS5 device in August 2013.</p>
@@ -1131,7 +1127,7 @@ order by `date`;
...
</code></pre></div>
-<h3 id="return-monthly-counts-per-customer-for-a-given-year:">Return monthly counts per customer for a given year:</h3>
+<h3 id="return-monthly-counts-per-customer-for-a-given-year">Return monthly counts per customer for a given year:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select cust_id, dir1 month_no, count(*) month_count from logs
where dir0=2014 group by cust_id, dir1 order by cust_id, month_no limit 10;
+----------+-----------+--------------+
@@ -1159,7 +1155,7 @@ year: 2014.</p>
analyze nested data natively without transformation. If you are familiar with
JavaScript notation, you will already know how some of these extensions work.</p>
-<h3 id="set-the-workspace-to-dfs.clicks:">Set the workspace to dfs.clicks:</h3>
+<h3 id="set-the-workspace-to-dfs-clicks">Set the workspace to dfs.clicks:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use dfs.clicks;
+-------+-----------------------------------------+
| ok | summary |
@@ -1168,7 +1164,7 @@ JavaScript notation, you will already know how some of these extensions work.</p
+-------+-----------------------------------------+
1 row selected
</code></pre></div>
-<h3 id="explore-clickstream-data:">Explore clickstream data:</h3>
+<h3 id="explore-clickstream-data">Explore clickstream data:</h3>
<p>Note that the user_info and trans_info columns contain nested data: arrays and
arrays within arrays. The following queries show how to access this complex
@@ -1185,7 +1181,7 @@ data.</p>
+-----------+-------------+-----------+---------------------------------------------------+---------------------------------------------------------------------------+
5 rows selected
</code></pre></div>
-<h3 id="unpack-the-user_info-column:">Unpack the user_info column:</h3>
+<h3 id="unpack-the-user_info-column">Unpack the user_info column:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select t.user_info.cust_id as custid, t.user_info.device as device,
t.user_info.state as state
from `clicks/clicks.json` t limit 5;
@@ -1210,7 +1206,7 @@ column name, and <code>cust_id</code> is a nested column name.</p>
<p>The table alias is required; otherwise column names such as <code>user_info</code> are
parsed as table names by the SQL parser.</p>
-<h3 id="unpack-the-trans_info-column:">Unpack the trans_info column:</h3>
+<h3 id="unpack-the-trans_info-column">Unpack the trans_info column:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select t.trans_info.prod_id as prodid, t.trans_info.purch_flag as
purchased
from `clicks/clicks.json` t limit 5;
@@ -1243,7 +1239,7 @@ notation to write interesting queries against nested array data.</p>
</code></pre></div>
<p>refers to the 21st value, assuming one exists.</p>
-<h3 id="find-the-first-product-that-is-searched-for-in-each-transaction:">Find the first product that is searched for in each transaction:</h3>
+<h3 id="find-the-first-product-that-is-searched-for-in-each-transaction">Find the first product that is searched for in each transaction:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select t.trans_id, t.trans_info.prod_id[0] from `clicks/clicks.json` t limit 5;
+------------+------------+
| trans_id | EXPR$1 |
@@ -1256,7 +1252,7 @@ notation to write interesting queries against nested array data.</p>
+------------+------------+
5 rows selected
</code></pre></div>
-<h3 id="for-which-transactions-did-customers-search-on-at-least-21-products?">For which transactions did customers search on at least 21 products?</h3>
+<h3 id="for-which-transactions-did-customers-search-on-at-least-21-products">For which transactions did customers search on at least 21 products?</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select t.trans_id, t.trans_info.prod_id[20]
from `clicks/clicks.json` t
where t.trans_info.prod_id[20] is not null
@@ -1275,7 +1271,7 @@ order by trans_id limit 5;
<p>This query returns transaction IDs and product IDs for records that contain a
non-null product ID at the 21st position in the array.</p>
-<h3 id="return-clicks-for-a-specific-product-range:">Return clicks for a specific product range:</h3>
+<h3 id="return-clicks-for-a-specific-product-range">Return clicks for a specific product range:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select * from (select t.trans_id, t.trans_info.prod_id[0] as prodid,
t.trans_info.purch_flag as purchased
from `clicks/clicks.json` t) sq
@@ -1298,7 +1294,7 @@ ordered list of products purchased rather than a random list).</p>
<h2 id="perform-operations-on-arrays">Perform Operations on Arrays</h2>
-<h3 id="rank-successful-click-conversions-and-count-product-searches-for-each-session:">Rank successful click conversions and count product searches for each session:</h3>
+<h3 id="rank-successful-click-conversions-and-count-product-searches-for-each-session">Rank successful click conversions and count product searches for each session:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select t.trans_id, t.`date` as session_date, t.user_info.cust_id as
cust_id, t.user_info.device as device, repeated_count(t.trans_info.prod_id) as
prod_count, t.trans_info.purch_flag as purch_flag
@@ -1324,7 +1320,7 @@ in descending order. Only clicks that have resulted in a purchase are counted.</
<p>To facilitate additional analysis on this result set, you can easily and
quickly create a Drill table from the results of the query.</p>
-<h3 id="continue-to-use-the-dfs.clicks-workspace">Continue to use the dfs.clicks workspace</h3>
+<h3 id="continue-to-use-the-dfs-clicks-workspace">Continue to use the dfs.clicks workspace</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> use dfs.clicks;
+-------+-----------------------------------------+
| ok | summary |
@@ -1333,7 +1329,7 @@ quickly create a Drill table from the results of the query.</p>
+-------+-----------------------------------------+
1 row selected (1.61 seconds)
</code></pre></div>
-<h3 id="return-product-searches-for-high-value-customers:">Return product searches for high-value customers:</h3>
+<h3 id="return-product-searches-for-high-value-customers">Return product searches for high-value customers:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> select o.cust_id, o.order_total, t.trans_info.prod_id[0] as prod_id
from
hive.orders as o
@@ -1357,7 +1353,7 @@ where o.order_total > (select avg(inord.order_total)
<p>This query returns a list of products that are being searched for by customers
who have made transactions that are above the average in their states.</p>
-<h3 id="materialize-the-result-of-the-previous-query:">Materialize the result of the previous query:</h3>
+<h3 id="materialize-the-result-of-the-previous-query">Materialize the result of the previous query:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> create table product_search as select o.cust_id, o.order_total, t.trans_info.prod_id[0] as prod_id
from
hive.orders as o
@@ -1379,7 +1375,7 @@ query returns (107,482) and stores them in the format specified by the storage
plugin (Parquet format in this example). You can create tables that store data
in csv, parquet, and json formats.</p>
-<h3 id="query-the-new-table-to-verify-the-row-count:">Query the new table to verify the row count:</h3>
+<h3 id="query-the-new-table-to-verify-the-row-count">Query the new table to verify the row count:</h3>
<p>This example simply checks that the CTAS statement worked by verifying the
number of rows in the table.</p>
@@ -1391,7 +1387,7 @@ number of rows in the table.</p>
+---------+
1 row selected (0.155 seconds)
</code></pre></div>
-<h3 id="find-the-storage-file-for-the-table:">Find the storage file for the table:</h3>
+<h3 id="find-the-storage-file-for-the-table">Find the storage file for the table:</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">[root@maprdemo product_search]# cd /mapr/demo.mapr.com/data/nested/product_search
[root@maprdemo product_search]# ls -la
total 451
@@ -1405,7 +1401,7 @@ stored in the location defined by the dfs.clicks workspace:</p>
</code></pre></div>
<p>There is a subdirectory that has the same name as the table you created.</p>
-<h2 id="what's-next">What's Next</h2>
+<h2 id="what-39-s-next">What's Next</h2>
<p>Complete the tutorial with the <a href="/docs/summary">Summary</a>.</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/lexical-structure/index.html
----------------------------------------------------------------------
diff --git a/docs/lexical-structure/index.html b/docs/lexical-structure/index.html
index d662837..327e0c9 100644
--- a/docs/lexical-structure/index.html
+++ b/docs/lexical-structure/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/limit-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/limit-clause/index.html b/docs/limit-clause/index.html
index e7ec631..1222b0c 100644
--- a/docs/limit-clause/index.html
+++ b/docs/limit-clause/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/log-and-debug-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/log-and-debug-introduction/index.html b/docs/log-and-debug-introduction/index.html
index 65bf13d..3e146a1 100644
--- a/docs/log-and-debug-introduction/index.html
+++ b/docs/log-and-debug-introduction/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/log-and-debug/index.html
----------------------------------------------------------------------
diff --git a/docs/log-and-debug/index.html b/docs/log-and-debug/index.html
index ac1b0df..442aafb 100644
--- a/docs/log-and-debug/index.html
+++ b/docs/log-and-debug/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/math-and-trig/index.html
----------------------------------------------------------------------
diff --git a/docs/math-and-trig/index.html b/docs/math-and-trig/index.html
index 2caadd9..4022428 100644
--- a/docs/math-and-trig/index.html
+++ b/docs/math-and-trig/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/migrating-parquet-data/index.html
----------------------------------------------------------------------
diff --git a/docs/migrating-parquet-data/index.html b/docs/migrating-parquet-data/index.html
index e01f5bf..831273a 100644
--- a/docs/migrating-parquet-data/index.html
+++ b/docs/migrating-parquet-data/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/modify-logback-xml/index.html
----------------------------------------------------------------------
diff --git a/docs/modify-logback-xml/index.html b/docs/modify-logback-xml/index.html
index 2239be9..cb328eb 100644
--- a/docs/modify-logback-xml/index.html
+++ b/docs/modify-logback-xml/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/modifying-query-planning-options/index.html
----------------------------------------------------------------------
diff --git a/docs/modifying-query-planning-options/index.html b/docs/modifying-query-planning-options/index.html
index 53c9f0f..fa7e5c8 100644
--- a/docs/modifying-query-planning-options/index.html
+++ b/docs/modifying-query-planning-options/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/mongodb-storage-plugin/index.html
----------------------------------------------------------------------
diff --git a/docs/mongodb-storage-plugin/index.html b/docs/mongodb-storage-plugin/index.html
index c8c7b36..03edcfe 100644
--- a/docs/mongodb-storage-plugin/index.html
+++ b/docs/mongodb-storage-plugin/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1225,7 +1221,7 @@ Drill data sources, including MongoDB. </p>
| -72.576142 |
+------------+
</code></pre></div>
-<h2 id="using-odbc/jdbc-drivers">Using ODBC/JDBC Drivers</h2>
+<h2 id="using-odbc-jdbc-drivers">Using ODBC/JDBC Drivers</h2>
<p>You can query MongoDB through standard
BI tools, such as Tableau and SQuirreL. For information about Drill ODBC and JDBC drivers, refer to <a href="/docs/odbc-jdbc-interfaces">Drill Interfaces</a>.</p>
@@ -1234,7 +1230,7 @@ BI tools, such as Tableau and SQuirreL. For information about Drill ODBC and JDB
<div class="doc-nav">
- <span class="previous-toc"><a href="/docs/rdbms-storage-plugin/">← RDBMS Storage Plugin</a></span><span class="next-toc"><a href="/docs/mapr-db-format/">MapR-DB Format →</a></span>
+ <span class="previous-toc"><a href="/docs/rdbms-storage-plugin/">← RDBMS Storage Plugin</a></span><span class="next-toc"><a href="/docs/s3-storage-plugin/">S3 Storage Plugin →</a></span>
</div>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html
----------------------------------------------------------------------
diff --git a/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html b/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html
index bdb6a04..715f645 100644
--- a/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html
+++ b/docs/monitoring-and-canceling-queries-in-the-drill-web-console/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/nested-data-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/nested-data-functions/index.html b/docs/nested-data-functions/index.html
index 42d74b5..a684d14 100644
--- a/docs/nested-data-functions/index.html
+++ b/docs/nested-data-functions/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/nested-data-limitations/index.html
----------------------------------------------------------------------
diff --git a/docs/nested-data-limitations/index.html b/docs/nested-data-limitations/index.html
index 1de5bfd..5f18ecb 100644
--- a/docs/nested-data-limitations/index.html
+++ b/docs/nested-data-limitations/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/odbc-configuration-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/odbc-configuration-reference/index.html b/docs/odbc-configuration-reference/index.html
index 5e00e22..064a167 100644
--- a/docs/odbc-configuration-reference/index.html
+++ b/docs/odbc-configuration-reference/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1343,7 +1339,7 @@ The Simba ODBC Driver for Apache Drill produces two log files at the location yo
<li>Save the mapr.drillodbc.ini configuration file.</li>
</ol>
-<h4 id="what's-next?-go-to-connecting-to-odbc-data-sources.">What's Next? Go to <a href="/docs/connecting-to-odbc-data-sources">Connecting to ODBC Data Sources</a>.</h4>
+<h4 id="what-39-s-next-go-to-connecting-to-odbc-data-sources">What's Next? Go to <a href="/docs/connecting-to-odbc-data-sources">Connecting to ODBC Data Sources</a>.</h4>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/odbc-jdbc-interfaces/index.html
----------------------------------------------------------------------
diff --git a/docs/odbc-jdbc-interfaces/index.html b/docs/odbc-jdbc-interfaces/index.html
index acb081c..83b5ad4 100644
--- a/docs/odbc-jdbc-interfaces/index.html
+++ b/docs/odbc-jdbc-interfaces/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/offset-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/offset-clause/index.html b/docs/offset-clause/index.html
index 3d43e6a..f5e9bff 100644
--- a/docs/offset-clause/index.html
+++ b/docs/offset-clause/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/operators/index.html
----------------------------------------------------------------------
diff --git a/docs/operators/index.html b/docs/operators/index.html
index 89ee2b9..bacc735 100644
--- a/docs/operators/index.html
+++ b/docs/operators/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/optimizing-parquet-metadata-reading/index.html
----------------------------------------------------------------------
diff --git a/docs/optimizing-parquet-metadata-reading/index.html b/docs/optimizing-parquet-metadata-reading/index.html
index be5463a..5ca7d8f 100644
--- a/docs/optimizing-parquet-metadata-reading/index.html
+++ b/docs/optimizing-parquet-metadata-reading/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/order-by-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/order-by-clause/index.html b/docs/order-by-clause/index.html
index 6ce85ef..f66d546 100644
--- a/docs/order-by-clause/index.html
+++ b/docs/order-by-clause/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/parquet-format/index.html
----------------------------------------------------------------------
diff --git a/docs/parquet-format/index.html b/docs/parquet-format/index.html
index 0eadaa1..0f0ba88 100644
--- a/docs/parquet-format/index.html
+++ b/docs/parquet-format/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1112,7 +1108,7 @@
<li>In the CTAS command, cast JSON string data to corresponding <a href="/docs/json-data-model/#data-type-mapping">SQL types</a>.</li>
</ul>
-<h3 id="example:-read-json,-write-parquet">Example: Read JSON, Write Parquet</h3>
+<h3 id="example-read-json-write-parquet">Example: Read JSON, Write Parquet</h3>
<p>This example demonstrates a storage plugin definition, a sample row of data from a JSON file, and a Drill query that writes the JSON input to Parquet output. </p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/partition-by-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/partition-by-clause/index.html b/docs/partition-by-clause/index.html
index 4f59c3a..a629bdc 100644
--- a/docs/partition-by-clause/index.html
+++ b/docs/partition-by-clause/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/partition-pruning-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/partition-pruning-introduction/index.html b/docs/partition-pruning-introduction/index.html
index 6e6e2ed..73557fa 100644
--- a/docs/partition-pruning-introduction/index.html
+++ b/docs/partition-pruning-introduction/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/partition-pruning/index.html
----------------------------------------------------------------------
diff --git a/docs/partition-pruning/index.html b/docs/partition-pruning/index.html
index aaf3c20..f106332 100644
--- a/docs/partition-pruning/index.html
+++ b/docs/partition-pruning/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/performance-tuning-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning-introduction/index.html b/docs/performance-tuning-introduction/index.html
index bd97b50..195bacf 100644
--- a/docs/performance-tuning-introduction/index.html
+++ b/docs/performance-tuning-introduction/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/performance-tuning-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning-reference/index.html b/docs/performance-tuning-reference/index.html
index b75df56..33a5311 100644
--- a/docs/performance-tuning-reference/index.html
+++ b/docs/performance-tuning-reference/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/performance-tuning/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning/index.html b/docs/performance-tuning/index.html
index 43c3506..84ff6d0 100644
--- a/docs/performance-tuning/index.html
+++ b/docs/performance-tuning/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/performance/index.html
----------------------------------------------------------------------
diff --git a/docs/performance/index.html b/docs/performance/index.html
index 90aa428..0db1800 100644
--- a/docs/performance/index.html
+++ b/docs/performance/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/persistent-configuration-storage/index.html
----------------------------------------------------------------------
diff --git a/docs/persistent-configuration-storage/index.html b/docs/persistent-configuration-storage/index.html
index d4260d1..5fcd5b5 100644
--- a/docs/persistent-configuration-storage/index.html
+++ b/docs/persistent-configuration-storage/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/physical-operators/index.html
----------------------------------------------------------------------
diff --git a/docs/physical-operators/index.html b/docs/physical-operators/index.html
index c5a1be0..b98a61a 100644
--- a/docs/physical-operators/index.html
+++ b/docs/physical-operators/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/planning-and-execution-options/index.html
----------------------------------------------------------------------
diff --git a/docs/planning-and-execution-options/index.html b/docs/planning-and-execution-options/index.html
index 7a8a69c..982d480 100644
--- a/docs/planning-and-execution-options/index.html
+++ b/docs/planning-and-execution-options/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/plugin-configuration-basics/index.html
----------------------------------------------------------------------
diff --git a/docs/plugin-configuration-basics/index.html b/docs/plugin-configuration-basics/index.html
index 809a8b3..b4b9be6 100644
--- a/docs/plugin-configuration-basics/index.html
+++ b/docs/plugin-configuration-basics/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/ports-used-by-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/ports-used-by-drill/index.html b/docs/ports-used-by-drill/index.html
index 047bce5..f5cd705 100644
--- a/docs/ports-used-by-drill/index.html
+++ b/docs/ports-used-by-drill/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/project-bylaws/index.html
----------------------------------------------------------------------
diff --git a/docs/project-bylaws/index.html b/docs/project-bylaws/index.html
index cfbcb68..3ca6fd6 100644
--- a/docs/project-bylaws/index.html
+++ b/docs/project-bylaws/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-audit-logging/index.html
----------------------------------------------------------------------
diff --git a/docs/query-audit-logging/index.html b/docs/query-audit-logging/index.html
index 1f9afa0..b8c4db9 100644
--- a/docs/query-audit-logging/index.html
+++ b/docs/query-audit-logging/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-data-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/query-data-introduction/index.html b/docs/query-data-introduction/index.html
index e6e6d97..8b53da2 100644
--- a/docs/query-data-introduction/index.html
+++ b/docs/query-data-introduction/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-data/index.html
----------------------------------------------------------------------
diff --git a/docs/query-data/index.html b/docs/query-data/index.html
index 5b4ad1a..f06c107 100644
--- a/docs/query-data/index.html
+++ b/docs/query-data/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-directory-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/query-directory-functions/index.html b/docs/query-directory-functions/index.html
index 1fd8a1d..671f064 100644
--- a/docs/query-directory-functions/index.html
+++ b/docs/query-directory-functions/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-plans-and-tuning-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/query-plans-and-tuning-introduction/index.html b/docs/query-plans-and-tuning-introduction/index.html
index e1de4a6..f737f08 100644
--- a/docs/query-plans-and-tuning-introduction/index.html
+++ b/docs/query-plans-and-tuning-introduction/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-plans-and-tuning/index.html
----------------------------------------------------------------------
diff --git a/docs/query-plans-and-tuning/index.html b/docs/query-plans-and-tuning/index.html
index 16b3e2a..329aef2 100644
--- a/docs/query-plans-and-tuning/index.html
+++ b/docs/query-plans-and-tuning/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-plans/index.html
----------------------------------------------------------------------
diff --git a/docs/query-plans/index.html b/docs/query-plans/index.html
index 1782069..751669c 100644
--- a/docs/query-plans/index.html
+++ b/docs/query-plans/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-profile-column-descriptions/index.html
----------------------------------------------------------------------
diff --git a/docs/query-profile-column-descriptions/index.html b/docs/query-profile-column-descriptions/index.html
index 1063438..3a230ed 100644
--- a/docs/query-profile-column-descriptions/index.html
+++ b/docs/query-profile-column-descriptions/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-profiles/index.html
----------------------------------------------------------------------
diff --git a/docs/query-profiles/index.html b/docs/query-profiles/index.html
index 6b9beb2..d8f8f28 100644
--- a/docs/query-profiles/index.html
+++ b/docs/query-profiles/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/query-stages/index.html
----------------------------------------------------------------------
diff --git a/docs/query-stages/index.html b/docs/query-stages/index.html
index affa937..ea72522 100644
--- a/docs/query-stages/index.html
+++ b/docs/query-stages/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-a-file-system-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-a-file-system-introduction/index.html b/docs/querying-a-file-system-introduction/index.html
index fd0295d..e9b03cc 100644
--- a/docs/querying-a-file-system-introduction/index.html
+++ b/docs/querying-a-file-system-introduction/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-a-file-system/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-a-file-system/index.html b/docs/querying-a-file-system/index.html
index 12abf19..e641832 100644
--- a/docs/querying-a-file-system/index.html
+++ b/docs/querying-a-file-system/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-complex-data-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-complex-data-introduction/index.html b/docs/querying-complex-data-introduction/index.html
index 4a0401b..b8843dd 100644
--- a/docs/querying-complex-data-introduction/index.html
+++ b/docs/querying-complex-data-introduction/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-complex-data/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-complex-data/index.html b/docs/querying-complex-data/index.html
index 6696386..a733434 100644
--- a/docs/querying-complex-data/index.html
+++ b/docs/querying-complex-data/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-directories/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-directories/index.html b/docs/querying-directories/index.html
index 8db2bb6..76205cd 100644
--- a/docs/querying-directories/index.html
+++ b/docs/querying-directories/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-hbase/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-hbase/index.html b/docs/querying-hbase/index.html
index 5d2c84c..7703906 100644
--- a/docs/querying-hbase/index.html
+++ b/docs/querying-hbase/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1059,7 +1055,7 @@ How to use optimization features in Drill 1.2 and later<br></li>
How to use Drill 1.2 to leverage new features introduced by <a href="https://issues.apache.org/jira/browse/HBASE-8201">HBASE-8201 Jira</a></li>
</ul>
-<h2 id="tutorial--querying-hbase-data">Tutorial--Querying HBase Data</h2>
+<h2 id="tutorial-querying-hbase-data">Tutorial--Querying HBase Data</h2>
<p>This tutorial shows how to connect Drill to an HBase data source, create simple HBase tables, and query the data using Drill.</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-hive/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-hive/index.html b/docs/querying-hive/index.html
index 1d779a9..abd53d1 100644
--- a/docs/querying-hive/index.html
+++ b/docs/querying-hive/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-json-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-json-files/index.html b/docs/querying-json-files/index.html
index 9d76356..dc1e7f0 100644
--- a/docs/querying-json-files/index.html
+++ b/docs/querying-json-files/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1050,7 +1046,7 @@
<p>To query complex JSON files, you need to understand the <a href="/docs/json-data-model/">"JSON Data Model"</a>. This section provides a trivial example of querying a sample file that Drill installs. </p>
-<h2 id="about-the-employee.json-file">About the employee.json File</h2>
+<h2 id="about-the-employee-json-file">About the employee.json File</h2>
<p>The sample file, <code>employee.json</code>, is packaged in the Foodmart data JAR in Drill's
classpath: </p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-parquet-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-parquet-files/index.html b/docs/querying-parquet-files/index.html
index 91aef5f..dc0e74c 100644
--- a/docs/querying-parquet-files/index.html
+++ b/docs/querying-parquet-files/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-plain-text-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-plain-text-files/index.html b/docs/querying-plain-text-files/index.html
index 46641a2..6ac2eb2 100644
--- a/docs/querying-plain-text-files/index.html
+++ b/docs/querying-plain-text-files/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1079,7 +1075,7 @@ found" error if references to files in queries do not match these condition
"delimiter": "|"
}
</code></pre></div>
-<h2 id="select-*-from-a-csv-file">SELECT * FROM a CSV File</h2>
+<h2 id="select-from-a-csv-file">SELECT * FROM a CSV File</h2>
<p>The first query selects rows from a <code>.csv</code> text file. The file contains seven
records:</p>
@@ -1110,7 +1106,7 @@ each row.</p>
+-----------------------------------+
7 rows selected (0.089 seconds)
</code></pre></div>
-<h2 id="columns[n]-syntax">Columns[n] Syntax</h2>
+<h2 id="columns-n-syntax">Columns[n] Syntax</h2>
<p>You can use the <code>COLUMNS[n]</code> syntax in the SELECT list to return these CSV
rows in a more readable, column by column, format. (This syntax uses a zero-
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-sequence-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-sequence-files/index.html b/docs/querying-sequence-files/index.html
index 44d4794..4f47267 100644
--- a/docs/querying-sequence-files/index.html
+++ b/docs/querying-sequence-files/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1051,7 +1047,7 @@
<p>Sequence files are flat files storing binary key value pairs.
Drill projects sequence files as table with two columns 'binary_key', 'binary_value'.</p>
-<h3 id="querying-sequence-file.">Querying sequence file.</h3>
+<h3 id="querying-sequence-file">Querying sequence file.</h3>
<p>Start drill shell</p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT *
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-system-tables/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-system-tables/index.html b/docs/querying-system-tables/index.html
index ade0399..c236302 100644
--- a/docs/querying-system-tables/index.html
+++ b/docs/querying-system-tables/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
@@ -1108,7 +1104,7 @@ requests.</p>
<p>Query the drillbits, version, options, boot, threads, and memory tables in the sys database.</p>
-<h3 id="query-the-drillbits-table.">Query the drillbits table.</h3>
+<h3 id="query-the-drillbits-table">Query the drillbits table.</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181> select * from drillbits;
+-------------------+------------+--------------+------------+---------+
| hostname | user_port | control_port | data_port | current|
@@ -1136,7 +1132,7 @@ True means the Drillbit is connected to the session or client running the
query. This Drillbit is the Foreman for the current session.<br></li>
</ul>
-<h3 id="query-the-version-table.">Query the version table.</h3>
+<h3 id="query-the-version-table">Query the version table.</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181> select * from version;
+-------------------------------------------+--------------------------------------------------------------------+----------------------------+--------------+----------------------------+
| commit_id | commit_message | commit_time | build_email | build_time |
@@ -1160,7 +1156,7 @@ example.</li>
The time that the release was built.</li>
</ul>
-<h3 id="query-the-options-table.">Query the options table.</h3>
+<h3 id="query-the-options-table">Query the options table.</h3>
<p>Drill provides system, session, and boot options that you can query.</p>
@@ -1202,7 +1198,7 @@ The default value, which is of the double, float, or long double data type;
otherwise, null.</li>
</ul>
-<h3 id="query-the-boot-table.">Query the boot table.</h3>
+<h3 id="query-the-boot-table">Query the boot table.</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181> select * from boot limit 10;
+--------------------------------------+----------+-------+---------+------------+-------------------------+-----------+------------+
| name | kind | type | status | num_val | string_val | bool_val | float_val |
@@ -1240,7 +1236,7 @@ The default value, which is of the double, float, or long double data type;
otherwise, null.</li>
</ul>
-<h3 id="query-the-threads-table.">Query the threads table.</h3>
+<h3 id="query-the-threads-table">Query the threads table.</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181> select * from threads;
+--------------------+------------+----------------+---------------+
| hostname | user_port | total_threads | busy_threads |
@@ -1263,7 +1259,7 @@ The peak thread count on the node.</li>
The current number of live threads (daemon and non-daemon) on the node.</li>
</ul>
-<h3 id="query-the-memory-table.">Query the memory table.</h3>
+<h3 id="query-the-memory-table">Query the memory table.</h3>
<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181> select * from memory;
+--------------------+------------+---------------+-------------+-----------------+---------------------+-------------+
| hostname | user_port | heap_current | heap_max | direct_current | jvm_direct_current | direct_max |
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f06d8933/docs/querying-the-information-schema/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-the-information-schema/index.html b/docs/querying-the-information-schema/index.html
index 4cb8f97..f32fd2f 100644
--- a/docs/querying-the-information-schema/index.html
+++ b/docs/querying-the-information-schema/index.html
@@ -373,10 +373,6 @@
- <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li>
-
-
-
<li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>