drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [03/25] drill git commit: title changes, multitenant doc review changes
Date Tue, 12 May 2015 05:56:45 GMT
title changes, multitenant doc review changes


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/80bbe062
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/80bbe062
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/80bbe062

Branch: refs/heads/gh-pages
Commit: 80bbe0620885de7d1e9926d40693d9175ecb8a35
Parents: 22d4df3
Author: Kristine Hahn <khahn@maprtech.com>
Authored: Thu May 7 15:45:58 2015 -0700
Committer: Kristine Hahn <khahn@maprtech.com>
Committed: Thu May 7 15:45:58 2015 -0700

----------------------------------------------------------------------
 _data/docs.json                                 | 170 +++++++++----------
 _docs/030-configuring-user-imperso.textClipping |   0
 .../010-configure-drill-introduction.md         |   9 +-
 .../020-configuring-drill-memory.md             |   5 +-
 ...guring-a-multitenant-cluster-introduction.md |   8 +-
 .../050-configuring-multitenant-resources.md    |  44 ++---
 .../060-configuring-a-shared-drillbit.md        |   6 +-
 .../060-tibco-spotfire with Drill.md            |  50 ++++++
 ...-apache-drill-with-tibco-spotfire-desktop.md |  50 ------
 .../sql-commands/030-create-table-as-command.md |   2 +-
 .../sql-commands/050-create-view-command.md     |   2 +-
 .../sql-commands/070-explain-commands.md        |   2 +-
 .../090-show-databases-and-show-schemas.md      |   2 +-
 13 files changed, 167 insertions(+), 183 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_data/docs.json
----------------------------------------------------------------------
diff --git a/_data/docs.json b/_data/docs.json
index 91d3fe5..4ced7af 100644
--- a/_data/docs.json
+++ b/_data/docs.json
@@ -50,7 +50,7 @@
                 }
             ], 
             "children": [], 
-            "next_title": "CREATE TABLE AS (CTAS) command", 
+            "next_title": "CREATE TABLE AS (CTAS) Command", 
             "next_url": "/docs/create-table-as-ctas-command/", 
             "parent": "SQL Commands", 
             "previous_title": "ALTER SESSION Command", 
@@ -624,7 +624,7 @@
             "title": "CASE", 
             "url": "/docs/case/"
         }, 
-        "CREATE TABLE AS (CTAS) command": {
+        "CREATE TABLE AS (CTAS) Command": {
             "breadcrumbs": [
                 {
                     "title": "SQL Commands", 
@@ -636,16 +636,16 @@
                 }
             ], 
             "children": [], 
-            "next_title": "CREATE VIEW command", 
+            "next_title": "CREATE VIEW Command", 
             "next_url": "/docs/create-view-command/", 
             "parent": "SQL Commands", 
             "previous_title": "ALTER SYSTEM Command", 
             "previous_url": "/docs/alter-system-command/", 
             "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as-command.md", 
-            "title": "CREATE TABLE AS (CTAS) command", 
+            "title": "CREATE TABLE AS (CTAS) Command", 
             "url": "/docs/create-table-as-ctas-command/"
         }, 
-        "CREATE VIEW command": {
+        "CREATE VIEW Command": {
             "breadcrumbs": [
                 {
                     "title": "SQL Commands", 
@@ -660,10 +660,10 @@
             "next_title": "DESCRIBE Command", 
             "next_url": "/docs/describe-command/", 
             "parent": "SQL Commands", 
-            "previous_title": "CREATE TABLE AS (CTAS) command", 
+            "previous_title": "CREATE TABLE AS (CTAS) Command", 
             "previous_url": "/docs/create-table-as-ctas-command/", 
             "relative_path": "_docs/sql-reference/sql-commands/050-create-view-command.md", 
-            "title": "CREATE VIEW command", 
+            "title": "CREATE VIEW Command", 
             "url": "/docs/create-view-command/"
         }, 
         "Compiling Drill from Source": {
@@ -1731,10 +1731,10 @@
                 }
             ], 
             "children": [], 
-            "next_title": "EXPLAIN commands", 
+            "next_title": "EXPLAIN Commands", 
             "next_url": "/docs/explain-commands/", 
             "parent": "SQL Commands", 
-            "previous_title": "CREATE VIEW command", 
+            "previous_title": "CREATE VIEW Command", 
             "previous_url": "/docs/create-view-command/", 
             "relative_path": "_docs/sql-reference/sql-commands/060-describe-command.md", 
             "title": "DESCRIBE Command", 
@@ -2760,7 +2760,7 @@
             "title": "Driver Configuration Options", 
             "url": "/docs/driver-configuration-options/"
         }, 
-        "EXPLAIN commands": {
+        "EXPLAIN Commands": {
             "breadcrumbs": [
                 {
                     "title": "SQL Commands", 
@@ -2778,7 +2778,7 @@
             "previous_title": "DESCRIBE Command", 
             "previous_url": "/docs/describe-command/", 
             "relative_path": "_docs/sql-reference/sql-commands/070-explain-commands.md", 
-            "title": "EXPLAIN commands", 
+            "title": "EXPLAIN Commands", 
             "url": "/docs/explain-commands/"
         }, 
         "Embedded Mode Prerequisites": {
@@ -4561,8 +4561,8 @@
                         }
                     ], 
                     "children": [], 
-                    "next_title": "Using Apache Drill with Tibco Spotfire Desktop", 
-                    "next_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", 
+                    "next_title": "Using Tibco Spotfire", 
+                    "next_url": "/docs/using-tibco-spotfire/", 
                     "parent": "ODBC/JDBC Interfaces", 
                     "previous_title": "Using Drill Explorer on Windows", 
                     "previous_url": "/docs/using-drill-explorer-on-windows/", 
@@ -4583,9 +4583,9 @@
                     "parent": "ODBC/JDBC Interfaces", 
                     "previous_title": "Using MicroStrategy Analytics with Drill", 
                     "previous_url": "/docs/using-microstrategy-analytics-with-drill/", 
-                    "relative_path": "_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md", 
-                    "title": "Using Apache Drill with Tibco Spotfire Desktop", 
-                    "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/"
+                    "relative_path": "_docs/odbc-jdbc-interfaces/060-tibco-spotfire.md", 
+                    "title": "Using Tibco Spotfire", 
+                    "url": "/docs/using-tibco-spotfire/"
                 }
             ], 
             "next_title": "Interfaces Introduction", 
@@ -5167,8 +5167,8 @@
             "next_title": "Query Data Introduction", 
             "next_url": "/docs/query-data-introduction/", 
             "parent": "", 
-            "previous_title": "Using Apache Drill with Tibco Spotfire Desktop", 
-            "previous_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", 
+            "previous_title": "Using Tibco Spotfire", 
+            "previous_url": "/docs/using-tibco-spotfire/", 
             "relative_path": "_docs/070-query-data.md", 
             "title": "Query Data", 
             "url": "/docs/query-data/"
@@ -5930,16 +5930,16 @@
                 }
             ], 
             "children": [], 
-            "next_title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+            "next_title": "SHOW DATABASES and SHOW SCHEMAS Command", 
             "next_url": "/docs/show-databases-and-show-schemas-command/", 
             "parent": "SQL Commands", 
-            "previous_title": "EXPLAIN commands", 
+            "previous_title": "EXPLAIN Commands", 
             "previous_url": "/docs/explain-commands/", 
             "relative_path": "_docs/sql-reference/sql-commands/080-select.md", 
             "title": "SELECT Statements", 
             "url": "/docs/select-statements/"
         }, 
-        "SHOW DATABASES AND SHOW SCHEMAS Command": {
+        "SHOW DATABASES and SHOW SCHEMAS Command": {
             "breadcrumbs": [
                 {
                     "title": "SQL Commands", 
@@ -5957,7 +5957,7 @@
             "previous_title": "SELECT Statements", 
             "previous_url": "/docs/select-statements/", 
             "relative_path": "_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md", 
-            "title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+            "title": "SHOW DATABASES and SHOW SCHEMAS Command", 
             "url": "/docs/show-databases-and-show-schemas-command/"
         }, 
         "SHOW FILES Command": {
@@ -5975,7 +5975,7 @@
             "next_title": "SHOW TABLES Command", 
             "next_url": "/docs/show-tables-command/", 
             "parent": "SQL Commands", 
-            "previous_title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+            "previous_title": "SHOW DATABASES and SHOW SCHEMAS Command", 
             "previous_url": "/docs/show-databases-and-show-schemas-command/", 
             "relative_path": "_docs/sql-reference/sql-commands/100-show-files.md", 
             "title": "SHOW FILES Command", 
@@ -6064,7 +6064,7 @@
                         }
                     ], 
                     "children": [], 
-                    "next_title": "CREATE TABLE AS (CTAS) command", 
+                    "next_title": "CREATE TABLE AS (CTAS) Command", 
                     "next_url": "/docs/create-table-as-ctas-command/", 
                     "parent": "SQL Commands", 
                     "previous_title": "ALTER SESSION Command", 
@@ -6085,13 +6085,13 @@
                         }
                     ], 
                     "children": [], 
-                    "next_title": "CREATE VIEW command", 
+                    "next_title": "CREATE VIEW Command", 
                     "next_url": "/docs/create-view-command/", 
                     "parent": "SQL Commands", 
                     "previous_title": "ALTER SYSTEM Command", 
                     "previous_url": "/docs/alter-system-command/", 
                     "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as-command.md", 
-                    "title": "CREATE TABLE AS (CTAS) command", 
+                    "title": "CREATE TABLE AS (CTAS) Command", 
                     "url": "/docs/create-table-as-ctas-command/"
                 }, 
                 {
@@ -6109,10 +6109,10 @@
                     "next_title": "DESCRIBE Command", 
                     "next_url": "/docs/describe-command/", 
                     "parent": "SQL Commands", 
-                    "previous_title": "CREATE TABLE AS (CTAS) command", 
+                    "previous_title": "CREATE TABLE AS (CTAS) Command", 
                     "previous_url": "/docs/create-table-as-ctas-command/", 
                     "relative_path": "_docs/sql-reference/sql-commands/050-create-view-command.md", 
-                    "title": "CREATE VIEW command", 
+                    "title": "CREATE VIEW Command", 
                     "url": "/docs/create-view-command/"
                 }, 
                 {
@@ -6127,10 +6127,10 @@
                         }
                     ], 
                     "children": [], 
-                    "next_title": "EXPLAIN commands", 
+                    "next_title": "EXPLAIN Commands", 
                     "next_url": "/docs/explain-commands/", 
                     "parent": "SQL Commands", 
-                    "previous_title": "CREATE VIEW command", 
+                    "previous_title": "CREATE VIEW Command", 
                     "previous_url": "/docs/create-view-command/", 
                     "relative_path": "_docs/sql-reference/sql-commands/060-describe-command.md", 
                     "title": "DESCRIBE Command", 
@@ -6154,7 +6154,7 @@
                     "previous_title": "DESCRIBE Command", 
                     "previous_url": "/docs/describe-command/", 
                     "relative_path": "_docs/sql-reference/sql-commands/070-explain-commands.md", 
-                    "title": "EXPLAIN commands", 
+                    "title": "EXPLAIN Commands", 
                     "url": "/docs/explain-commands/"
                 }, 
                 {
@@ -6169,10 +6169,10 @@
                         }
                     ], 
                     "children": [], 
-                    "next_title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                    "next_title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                     "next_url": "/docs/show-databases-and-show-schemas-command/", 
                     "parent": "SQL Commands", 
-                    "previous_title": "EXPLAIN commands", 
+                    "previous_title": "EXPLAIN Commands", 
                     "previous_url": "/docs/explain-commands/", 
                     "relative_path": "_docs/sql-reference/sql-commands/080-select.md", 
                     "title": "SELECT Statements", 
@@ -6196,7 +6196,7 @@
                     "previous_title": "SELECT Statements", 
                     "previous_url": "/docs/select-statements/", 
                     "relative_path": "_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md", 
-                    "title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                    "title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                     "url": "/docs/show-databases-and-show-schemas-command/"
                 }, 
                 {
@@ -6214,7 +6214,7 @@
                     "next_title": "SHOW TABLES Command", 
                     "next_url": "/docs/show-tables-command/", 
                     "parent": "SQL Commands", 
-                    "previous_title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                    "previous_title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                     "previous_url": "/docs/show-databases-and-show-schemas-command/", 
                     "relative_path": "_docs/sql-reference/sql-commands/100-show-files.md", 
                     "title": "SHOW FILES Command", 
@@ -6995,7 +6995,7 @@
                                 }
                             ], 
                             "children": [], 
-                            "next_title": "CREATE TABLE AS (CTAS) command", 
+                            "next_title": "CREATE TABLE AS (CTAS) Command", 
                             "next_url": "/docs/create-table-as-ctas-command/", 
                             "parent": "SQL Commands", 
                             "previous_title": "ALTER SESSION Command", 
@@ -7016,13 +7016,13 @@
                                 }
                             ], 
                             "children": [], 
-                            "next_title": "CREATE VIEW command", 
+                            "next_title": "CREATE VIEW Command", 
                             "next_url": "/docs/create-view-command/", 
                             "parent": "SQL Commands", 
                             "previous_title": "ALTER SYSTEM Command", 
                             "previous_url": "/docs/alter-system-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as-command.md", 
-                            "title": "CREATE TABLE AS (CTAS) command", 
+                            "title": "CREATE TABLE AS (CTAS) Command", 
                             "url": "/docs/create-table-as-ctas-command/"
                         }, 
                         {
@@ -7040,10 +7040,10 @@
                             "next_title": "DESCRIBE Command", 
                             "next_url": "/docs/describe-command/", 
                             "parent": "SQL Commands", 
-                            "previous_title": "CREATE TABLE AS (CTAS) command", 
+                            "previous_title": "CREATE TABLE AS (CTAS) Command", 
                             "previous_url": "/docs/create-table-as-ctas-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/050-create-view-command.md", 
-                            "title": "CREATE VIEW command", 
+                            "title": "CREATE VIEW Command", 
                             "url": "/docs/create-view-command/"
                         }, 
                         {
@@ -7058,10 +7058,10 @@
                                 }
                             ], 
                             "children": [], 
-                            "next_title": "EXPLAIN commands", 
+                            "next_title": "EXPLAIN Commands", 
                             "next_url": "/docs/explain-commands/", 
                             "parent": "SQL Commands", 
-                            "previous_title": "CREATE VIEW command", 
+                            "previous_title": "CREATE VIEW Command", 
                             "previous_url": "/docs/create-view-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/060-describe-command.md", 
                             "title": "DESCRIBE Command", 
@@ -7085,7 +7085,7 @@
                             "previous_title": "DESCRIBE Command", 
                             "previous_url": "/docs/describe-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/070-explain-commands.md", 
-                            "title": "EXPLAIN commands", 
+                            "title": "EXPLAIN Commands", 
                             "url": "/docs/explain-commands/"
                         }, 
                         {
@@ -7100,10 +7100,10 @@
                                 }
                             ], 
                             "children": [], 
-                            "next_title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                            "next_title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                             "next_url": "/docs/show-databases-and-show-schemas-command/", 
                             "parent": "SQL Commands", 
-                            "previous_title": "EXPLAIN commands", 
+                            "previous_title": "EXPLAIN Commands", 
                             "previous_url": "/docs/explain-commands/", 
                             "relative_path": "_docs/sql-reference/sql-commands/080-select.md", 
                             "title": "SELECT Statements", 
@@ -7127,7 +7127,7 @@
                             "previous_title": "SELECT Statements", 
                             "previous_url": "/docs/select-statements/", 
                             "relative_path": "_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md", 
-                            "title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                            "title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                             "url": "/docs/show-databases-and-show-schemas-command/"
                         }, 
                         {
@@ -7145,7 +7145,7 @@
                             "next_title": "SHOW TABLES Command", 
                             "next_url": "/docs/show-tables-command/", 
                             "parent": "SQL Commands", 
-                            "previous_title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                            "previous_title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                             "previous_url": "/docs/show-databases-and-show-schemas-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/100-show-files.md", 
                             "title": "SHOW FILES Command", 
@@ -8127,23 +8127,6 @@
             "title": "Useful Research", 
             "url": "/docs/useful-research/"
         }, 
-        "Using Apache Drill with Tibco Spotfire Desktop": {
-            "breadcrumbs": [
-                {
-                    "title": "ODBC/JDBC Interfaces", 
-                    "url": "/docs/odbc-jdbc-interfaces/"
-                }
-            ], 
-            "children": [], 
-            "next_title": "Query Data", 
-            "next_url": "/docs/query-data/", 
-            "parent": "ODBC/JDBC Interfaces", 
-            "previous_title": "Using MicroStrategy Analytics with Drill", 
-            "previous_url": "/docs/using-microstrategy-analytics-with-drill/", 
-            "relative_path": "_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md", 
-            "title": "Using Apache Drill with Tibco Spotfire Desktop", 
-            "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/"
-        }, 
         "Using Custom Functions in Queries": {
             "breadcrumbs": [
                 {
@@ -8207,8 +8190,8 @@
                 }
             ], 
             "children": [], 
-            "next_title": "Using Apache Drill with Tibco Spotfire Desktop", 
-            "next_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", 
+            "next_title": "Using Tibco Spotfire", 
+            "next_url": "/docs/using-tibco-spotfire/", 
             "parent": "ODBC/JDBC Interfaces", 
             "previous_title": "Using Drill Explorer on Windows", 
             "previous_url": "/docs/using-drill-explorer-on-windows/", 
@@ -8546,6 +8529,23 @@
             "title": "Using SQL Functions, Clauses, and Joins", 
             "url": "/docs/using-sql-functions-clauses-and-joins/"
         }, 
+        "Using Tibco Spotfire": {
+            "breadcrumbs": [
+                {
+                    "title": "ODBC/JDBC Interfaces", 
+                    "url": "/docs/odbc-jdbc-interfaces/"
+                }
+            ], 
+            "children": [], 
+            "next_title": "Query Data", 
+            "next_url": "/docs/query-data/", 
+            "parent": "ODBC/JDBC Interfaces", 
+            "previous_title": "Using MicroStrategy Analytics with Drill", 
+            "previous_url": "/docs/using-microstrategy-analytics-with-drill/", 
+            "relative_path": "_docs/odbc-jdbc-interfaces/060-tibco-spotfire.md", 
+            "title": "Using Tibco Spotfire", 
+            "url": "/docs/using-tibco-spotfire/"
+        }, 
         "Using a Connection String": {
             "breadcrumbs": [
                 {
@@ -10173,8 +10173,8 @@
                         }
                     ], 
                     "children": [], 
-                    "next_title": "Using Apache Drill with Tibco Spotfire Desktop", 
-                    "next_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", 
+                    "next_title": "Using Tibco Spotfire", 
+                    "next_url": "/docs/using-tibco-spotfire/", 
                     "parent": "ODBC/JDBC Interfaces", 
                     "previous_title": "Using Drill Explorer on Windows", 
                     "previous_url": "/docs/using-drill-explorer-on-windows/", 
@@ -10195,9 +10195,9 @@
                     "parent": "ODBC/JDBC Interfaces", 
                     "previous_title": "Using MicroStrategy Analytics with Drill", 
                     "previous_url": "/docs/using-microstrategy-analytics-with-drill/", 
-                    "relative_path": "_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md", 
-                    "title": "Using Apache Drill with Tibco Spotfire Desktop", 
-                    "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/"
+                    "relative_path": "_docs/odbc-jdbc-interfaces/060-tibco-spotfire.md", 
+                    "title": "Using Tibco Spotfire", 
+                    "url": "/docs/using-tibco-spotfire/"
                 }
             ], 
             "next_title": "Interfaces Introduction", 
@@ -10585,8 +10585,8 @@
             "next_title": "Query Data Introduction", 
             "next_url": "/docs/query-data-introduction/", 
             "parent": "", 
-            "previous_title": "Using Apache Drill with Tibco Spotfire Desktop", 
-            "previous_url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/", 
+            "previous_title": "Using Tibco Spotfire", 
+            "previous_url": "/docs/using-tibco-spotfire/", 
             "relative_path": "_docs/070-query-data.md", 
             "title": "Query Data", 
             "url": "/docs/query-data/"
@@ -11093,7 +11093,7 @@
                                 }
                             ], 
                             "children": [], 
-                            "next_title": "CREATE TABLE AS (CTAS) command", 
+                            "next_title": "CREATE TABLE AS (CTAS) Command", 
                             "next_url": "/docs/create-table-as-ctas-command/", 
                             "parent": "SQL Commands", 
                             "previous_title": "ALTER SESSION Command", 
@@ -11114,13 +11114,13 @@
                                 }
                             ], 
                             "children": [], 
-                            "next_title": "CREATE VIEW command", 
+                            "next_title": "CREATE VIEW Command", 
                             "next_url": "/docs/create-view-command/", 
                             "parent": "SQL Commands", 
                             "previous_title": "ALTER SYSTEM Command", 
                             "previous_url": "/docs/alter-system-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as-command.md", 
-                            "title": "CREATE TABLE AS (CTAS) command", 
+                            "title": "CREATE TABLE AS (CTAS) Command", 
                             "url": "/docs/create-table-as-ctas-command/"
                         }, 
                         {
@@ -11138,10 +11138,10 @@
                             "next_title": "DESCRIBE Command", 
                             "next_url": "/docs/describe-command/", 
                             "parent": "SQL Commands", 
-                            "previous_title": "CREATE TABLE AS (CTAS) command", 
+                            "previous_title": "CREATE TABLE AS (CTAS) Command", 
                             "previous_url": "/docs/create-table-as-ctas-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/050-create-view-command.md", 
-                            "title": "CREATE VIEW command", 
+                            "title": "CREATE VIEW Command", 
                             "url": "/docs/create-view-command/"
                         }, 
                         {
@@ -11156,10 +11156,10 @@
                                 }
                             ], 
                             "children": [], 
-                            "next_title": "EXPLAIN commands", 
+                            "next_title": "EXPLAIN Commands", 
                             "next_url": "/docs/explain-commands/", 
                             "parent": "SQL Commands", 
-                            "previous_title": "CREATE VIEW command", 
+                            "previous_title": "CREATE VIEW Command", 
                             "previous_url": "/docs/create-view-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/060-describe-command.md", 
                             "title": "DESCRIBE Command", 
@@ -11183,7 +11183,7 @@
                             "previous_title": "DESCRIBE Command", 
                             "previous_url": "/docs/describe-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/070-explain-commands.md", 
-                            "title": "EXPLAIN commands", 
+                            "title": "EXPLAIN Commands", 
                             "url": "/docs/explain-commands/"
                         }, 
                         {
@@ -11198,10 +11198,10 @@
                                 }
                             ], 
                             "children": [], 
-                            "next_title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                            "next_title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                             "next_url": "/docs/show-databases-and-show-schemas-command/", 
                             "parent": "SQL Commands", 
-                            "previous_title": "EXPLAIN commands", 
+                            "previous_title": "EXPLAIN Commands", 
                             "previous_url": "/docs/explain-commands/", 
                             "relative_path": "_docs/sql-reference/sql-commands/080-select.md", 
                             "title": "SELECT Statements", 
@@ -11225,7 +11225,7 @@
                             "previous_title": "SELECT Statements", 
                             "previous_url": "/docs/select-statements/", 
                             "relative_path": "_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md", 
-                            "title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                            "title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                             "url": "/docs/show-databases-and-show-schemas-command/"
                         }, 
                         {
@@ -11243,7 +11243,7 @@
                             "next_title": "SHOW TABLES Command", 
                             "next_url": "/docs/show-tables-command/", 
                             "parent": "SQL Commands", 
-                            "previous_title": "SHOW DATABASES AND SHOW SCHEMAS Command", 
+                            "previous_title": "SHOW DATABASES and SHOW SCHEMAS Command", 
                             "previous_url": "/docs/show-databases-and-show-schemas-command/", 
                             "relative_path": "_docs/sql-reference/sql-commands/100-show-files.md", 
                             "title": "SHOW FILES Command", 

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/030-configuring-user-imperso.textClipping
----------------------------------------------------------------------
diff --git a/_docs/030-configuring-user-imperso.textClipping b/_docs/030-configuring-user-imperso.textClipping
deleted file mode 100644
index e69de29..0000000

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/configure-drill/010-configure-drill-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/010-configure-drill-introduction.md b/_docs/configure-drill/010-configure-drill-introduction.md
index 6efe513..62f17f3 100644
--- a/_docs/configure-drill/010-configure-drill-introduction.md
+++ b/_docs/configure-drill/010-configure-drill-introduction.md
@@ -2,6 +2,9 @@
 title: "Configure Drill Introduction"
 parent: "Configure Drill"
 ---
-When using Drill, you need to make sufficient memory available Drill and other workloads running on the cluster. You might want to modify options for performance or functionality. For example, the default storage format for CTAS
-statements is Parquet. Using a configuration option, you can modify the default setting so that output data
-is stored in CSV or JSON format. The section covers the many options you can configure and how to configure memory resources for Drill running along side other workloads. This section also includes ports used by Drill.
+When using Drill, you need to make sufficient memory available Drill when running Drill alone or along side other workloads on the cluster. The next section, ["Configuring Drill Memory"]({{site.baseurl}}/docs/configuring-drill-memory) describes how to configure memory for a Drill cluster. Configuring other resources for [multitenancy clusters]({{site.baseurl}}/docs/configuring-multitenant-resources) or for [sharing a Drillbit]({{site.baseurl}}/docs/configuring-a-shared-drillbit) on a cluster is covered later.
+
+You can also modify options for performance or functionality. For example, changing the default storage format is a typical functional change. The default storage format for CTAS
+statements is Parquet. Using a configuration option, you can modify Drill to store the output data in CSV or JSON format. 
+
+The section, ["Configuration Options Introduction"]({{site.baseurl}}/docs/configuration-options-introduction) summarizes the many options you can configure. 

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/configure-drill/020-configuring-drill-memory.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/020-configuring-drill-memory.md b/_docs/configure-drill/020-configuring-drill-memory.md
index 150ce1f..81487d1 100644
--- a/_docs/configure-drill/020-configuring-drill-memory.md
+++ b/_docs/configure-drill/020-configuring-drill-memory.md
@@ -33,5 +33,8 @@ The drill-env.sh file contains the following options:
 
     export DRILL_JAVA_OPTS="-Xms1G -Xmx$DRILL_MAX_HEAP -XX:MaxDirectMemorySize=$DRILL_MAX_DIRECT_MEMORY -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea"
 
-The DRILL_MAX_DIRECT_MEMORY is the Java direct memory. The DRILL_MAX_HEAP is the maximum theoretical heap limit for the JVM. Xmx specifies the maximum memory allocation pool for a Java Virtual Machine (JVM). Xms specifies the initial memory allocation pool.
+* DRILL_MAX_DIRECT_MEMORY is the Java direct memory. 
+* DRILL_MAX_HEAP is the maximum theoretical heap limit for the JVM. 
+* Xmx specifies the maximum memory allocation pool for a Java Virtual Machine (JVM). 
+* Xms specifies the initial memory allocation pool.
 

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md b/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md
index 978d374..80edfc8 100644
--- a/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md
+++ b/_docs/configure-drill/030-configuring-a-multitenant-cluster-introduction.md
@@ -3,9 +3,7 @@ title: "Configuring a Multitenant Cluster Introduction"
 parent: "Configuring a Multitenant Cluster"
 ---
 
-Drill supports multiple users sharing a Drillbit. You can also run separate Drillbits running on different nodes in the cluster.
-
-Drill typically runs along side other workloads, including the following:  
+Drill supports multiple users sharing a Drillbit and running separate Drillbits on different nodes in the cluster. Drill typically runs along side other workloads, including the following:  
 
 * Mapreduce  
 * Yarn  
@@ -13,10 +11,10 @@ Drill typically runs along side other workloads, including the following:
 * Hive and Pig  
 * Spark  
 
-You need to plan and configure these resources for use with Drill and other workloads: 
+You need to plan and configure the following resources for use with Drill and other workloads: 
 
 * [Memory]({{site.baseurl}}/docs/configuring-multitenant-resources)  
 * [CPU]({{site.baseurl}}/docs/configuring-multitenant-resources#how-to-manage-drill-cpu-resources)  
 * Disk  
 
-Configure, memory, queues, and parallelization when users [share a Drillbit]({{site.baseurl}}/docs/configuring-resources-for-a-shared-drillbit).
\ No newline at end of file
+When users share a Drillbit, [configure queues]({{site.baseurl}}/docs/configuring-resources-for-a-shared-drillbit#configuring-query-queuing) and [parallelization]({{site.baseurl}}/docs/configuring-resources-for-a-shared-drillbit#configuring-parallelization) in addition to memory.
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/configure-drill/050-configuring-multitenant-resources.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/050-configuring-multitenant-resources.md b/_docs/configure-drill/050-configuring-multitenant-resources.md
index 53341fb..f8ca673 100644
--- a/_docs/configure-drill/050-configuring-multitenant-resources.md
+++ b/_docs/configure-drill/050-configuring-multitenant-resources.md
@@ -2,27 +2,17 @@
 title: "Configuring Multitenant Resources"
 parent: "Configuring a Multitenant Cluster"
 ---
-Drill operations are memory and CPU-intensive. Currently, Drill resources are managed outside MapR Warden service in terms of configuring the resources as well as enforcing the resource usage within the limit. Configure memory for Drill in a multitenant by modifying drill-env.sh. <Add detail on property names etc>
+Drill operations are memory and CPU-intensive. Currently, Drill resources are managed outside of any cluster management service, such as the MapR warden service. In a multitenant or any other type of cluster, YARN-enabled or not, you configure memory and memory usage limits for Drill by modifying drill-env.sh as described in ["Configuring Drill Memory"]({{site.baseurl}}/docs/configuring-drill-memory).
 
-3. To ensure Warden account for resources required for Drill, make sure the following properties are set appropriately in warden.drill-bits.conf. For reference on the meaning of the properties refer to the following MapR doc <add link>
-
-service.heapsize.min
-service.heapsize.max
-service.heapsize.percent
-
-The percent should always be considered as the one to change, it is more intuitive to understand and grows/shrinks according to different node's configuration. 
-
-It will be good if someone in Drill QA could try it out and see if it fits Drill's needs. 
-
- 
-
-Note that these properties should be set in addition to configuring the resources the in drill-env.conf even if you didnt change the defaults in drill-env.sh. Setting up memory limit in drill-env.sh tells Drill how much resources to use during query execution and setting up these warden-drill-bits.conf tells warden not to commit these resources to some other process. In near future, we expect to provide a more deeper integration on these settings
-\<give an example>
-
-4. This configuration is same whether you use Drill is enabled cluster or non-YARN cluster.
+Configure a multitenant cluster to account for resources required for Drill. For example, on a MapR cluster, ensure warden accounts for resources required for Drill. Configuring `drill-env.sh` allocates resources for Drill to use during query execution, while configuring the following properties in `warden-drill-bits.conf` prevents warden from committing the resources to other processes.
 
+    service.heapsize.min=<some value in MB>
+    service.heapsize.max=<some value in MB>
+    service.heapsize.percent=<a whole number>
 
+{% include startimportant.html %}Set the `service.heapsize` properties in `warden.drill-bits.conf` regardless of whether you changed defaults in `drill-env.sh` or not.{% include endimportant.html %}
 
+The section, ["Configuring Drill in a YARN-enabled MapR Cluster"]({{site.baseurl}}/docs/configuring-multitenant-resources#configuring-drill-in-a-yarn-enabled-mapr-cluster) shows an example of setting the `service.heapsize` properties. The `service.heapsize.percent` is the percentage of memory for the service bounded by minimum and maximum values. Typically, users change `service.heapsize.percent`. Using a percentage has the advantage of increasing or decreasing resources according to different node's configuration. For more information about the `service.heapsize` properties, see the section, ["warden.<servicename>.conf"](http://doc.mapr.com/display/MapR/warden.%3Cservicename%3E.conf).
 
 You need to statically partition the cluster to designate which partition handles which workload. To configure resources for Drill in a MapR cluster, modify one or more of the following files in `/opt/mapr/conf/conf.d` that the installation process creates. 
 
@@ -32,16 +22,6 @@ You need to statically partition the cluster to designate which partition handle
 
 Configure Drill memory by modifying `warden.drill-bits.conf` in YARN and non-YARN clusters. Configure other resources by modifying `warden.nodemanager.conf `and `warden.resourcemanager.conf `in a YARN-enabled cluster.
 
-## Configuring Drill Memory in a Mixed Cluster
-
-Add the following lines to the `warden.drill-bits.conf` file to configure memory resources for Drill:
-
-    service.heapsize.min=<some value in MB>
-    service.heapsize.max=<some value in MB>
-    service.heapsize.percent=<a whole number>
-
-The service.heapsize.percent is the percentage of memory for the service bounded by minimum and maximum values.
-
 ## Configuring Drill in a YARN-enabled MapR Cluster
 
 To add Drill to a YARN-enabled cluster, change memory resources to suit your application. For example, you have 120G of available memory that you allocate to following workloads in a Yarn-enabled cluster:
@@ -69,11 +49,11 @@ ResourceManager and NodeManager memory in `warden.resourcemanager.conf` and
     service.heapsize.max=325
     service.heapsize.percent=2
 
-Change these settings for NodeManager and ResourceManager to reconfigure the total memory required for YARN services to run. If you want to place an upper limit on memory set YARN_NODEMANAGER_HEAPSIZE or YARN_RESOURCEMANAGER_HEAPSIZE environment variable in /opt/mapr/hadoop/hadoop-2.5.1/etc/hadoop/yarn-env.sh. The -Xmx option is not set, allowing memory on to grow as needed.
+Change these settings for NodeManager and ResourceManager to reconfigure the total memory required for YARN services to run. If you want to place an upper limit on memory set YARN_NODEMANAGER_HEAPSIZE or YARN_RESOURCEMANAGER_HEAPSIZE environment variable in `/opt/mapr/hadoop/hadoop-2.5.1/etc/hadoop/yarn-env.sh`. The `-Xmx` option is not set, allowing memory on to grow as needed.
 
 ### MapReduce v1 Resources
 
-The following default settings in /opt/mapr/conf/warden.conf control MapReduce v1 memory:
+The following default settings in `/opt/mapr/conf/warden.conf` control MapReduce v1 memory:
 
     mr1.memory.percent=50
     mr1.cpu.percent=50
@@ -94,9 +74,9 @@ Configure memory for other services in the same manner, as described in [MapR do
 
 For more information about managing memory in a MapR cluster, see the following sections in the MapR documentation:
 
-* [Memory Allocation for Nodes](http://doc.mapr.com/display/MapR40x/Memory+Allocation+for+Nodes)  
-* [Cluster Resource Allocation](http://doc.mapr.com/display/MapR40x/Cluster+Resource+Allocation)  
-* [Customizing Memory Settings for MapReduce v1](http://doc.mapr.com/display/MapR40x/Customize+Memory+Settings+for+MapReduce+v1)  
+* [Memory Allocation for Nodes](http://doc.mapr.com/display/MapR/Memory+Allocation+for+Nodes)  
+* [Cluster Resource Allocation](http://doc.mapr.com/display/MapR/Cluster+Resource+Allocation)  
+* [Customizing Memory Settings for MapReduce v1](http://doc.mapr.com/display/MapR/Customize+Memory+Settings+for+MapReduce+v1)  
 
 ## How to Manage Drill CPU Resources
 Currently, you do not manage CPU resources within Drill. [Use Linux `cgroups`](http://en.wikipedia.org/wiki/Cgroups) to manage the CPU resources.
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/configure-drill/060-configuring-a-shared-drillbit.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/060-configuring-a-shared-drillbit.md b/_docs/configure-drill/060-configuring-a-shared-drillbit.md
index 3f83736..69ae187 100644
--- a/_docs/configure-drill/060-configuring-a-shared-drillbit.md
+++ b/_docs/configure-drill/060-configuring-a-shared-drillbit.md
@@ -2,9 +2,9 @@
 title: "Configuring Resources for a Shared Drillbit"
 parent: "Configuring a Multitenant Cluster"
 ---
-To manage a cluster in which multiple users share a Drillbit, you configure Drill queuing and parallelization in addition to memory, as described in the previous section.
+To manage a cluster in which multiple users share a Drillbit, you configure Drill queuing and parallelization in addition to memory, as described in the previous section, ["Configuring Drill Memory"]({{site.baseurl}}/docs/configuring-drill-memory/).
 
-##Configuring Drill Query Queuing
+##Configuring Query Queuing
 
 Set [options in sys.options]({{site.baseurl}}/docs/configuration-options-introduction/) to enable and manage query queuing, which is turned off by default. There are two types of queues: large and small. You configure a maximum number of queries that each queue allows by configuring the following options in the `sys.options` table:
 
@@ -26,7 +26,7 @@ The exec.queue.threshold default is 30 million, which is the estimated rows to b
 
 The Drill queuing configuration in this example tends to give many users running small queries a rapid response. Users running a large query might experience some delay until an earlier-received large query returns, freeing space in the large queue to process queries that are waiting.
 
-## Controlling Parallelization
+## Configuring Parallelization
 
 By default, Drill parallelizes operations when number of records manipulated within a fragment reaches 100,000. When parallelization of operations is high, the cluster operates as fast as possible, which is fine for a single user. In a contentious multi-tenant situation, however, you need to reduce parallelization to levels based on user needs.
 

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/odbc-jdbc-interfaces/060-tibco-spotfire with Drill.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/060-tibco-spotfire with Drill.md b/_docs/odbc-jdbc-interfaces/060-tibco-spotfire with Drill.md
new file mode 100755
index 0000000..65c5d64
--- /dev/null
+++ b/_docs/odbc-jdbc-interfaces/060-tibco-spotfire with Drill.md	
@@ -0,0 +1,50 @@
+---
+title: "Using Tibco Spotfire with Drill"
+parent: "ODBC/JDBC Interfaces"
+---
+Tibco Spotfire Desktop is a powerful analytic tool that enables SQL statements when connecting to data sources. Spotfire Desktop can utilize the powerful query capabilities of Apache Drill to query complex data structures. Use the MapR Drill ODBC Driver to configure Tibco Spotfire Desktop with Apache Drill.
+
+To use Spotfire Desktop with Apache Drill, complete the following steps:
+
+1.  Install the Drill ODBC Driver from MapR.
+2.	Configure the Spotfire Desktop data connection for Drill.
+
+----------
+
+
+### Step 1: Install and Configure the MapR Drill ODBC Driver 
+
+Drill uses standard ODBC connectivity to provide easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version that you download correlates with the Apache Drill version that you use. Ideally, you should upgrade to the latest version of Apache Drill and the MapR Drill ODBC Driver. 
+
+Complete the following steps to install and configure the driver:
+
+1.    Download the 64-bit MapR Drill ODBC Driver for Windows from the following location:<br> [http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)     
+**Note:** Spotfire Desktop 6.5.1 utilizes the 64-bit ODBC driver.
+2.    Complete steps 2-8 under on the following page to install the driver:<br> 
+[http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/](http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/)
+3.    Complete the steps on the following page to configure the driver:<br>
+[http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/](http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/)
+
+----------
+
+
+### Step 2: Configure the Spotfire Desktop Data Connection for Drill 
+Complete the following steps to configure a Drill data connection: 
+
+1. Select the **Add Data Connection** option or click the Add Data Connection button in the menu bar, as shown in the image below:![](http://i.imgur.com/p3LNNBs.png)
+2. When the dialog window appears, click the **Add** button, and select **Other/Database** from the dropdown list.![](http://i.imgur.com/u1g9kaT.png)
+3. In the Open Database window that appears, select **Odbc Data Provider** and then click **Configure**. ![](http://i.imgur.com/8Gu0GAZ.png)
+4. In the Configure Data Source Connection window that appears, select the Drill DSN that you configured in the ODBC administrator, and enter the relevant credentials for Drill.<br> ![](http://i.imgur.com/Yd6BKls.png) 
+5. Click **OK** to continue. The Spotfire Desktop queries the Drill metadata for available schemas, tables, and views. You can navigate the schemas in the left-hand column. After you select a specific view or table, the relevant SQL displays in the right-hand column. 
+![](http://i.imgur.com/wNBDs5q.png)
+6. Optionally, you can modify the SQL to work best with Drill. Simply change the schema.table.* notation in the SELECT statement to simply * or the relevant column names that are needed. 
+Note that Drill has certain reserved keywords that you must put in back ticks [ ` ] when needed. See [Drill Reserved Keywords](http://drill.apache.org/docs/reserved-keywords/).
+7. Once the SQL is complete, provide a name for the Data Source and click **OK**. Spotfire Desktop queries Drill and retrieves the data for analysis. You can use the functionality of Spotfire Desktop to work with the data.
+![](http://i.imgur.com/j0MWorh.png)
+
+**NOTE:** You can use the SQL statement column to query data and complex structures that do not display in the left-hand schema column. A good example is JSON files in the file system.
+
+**SQL Example:**<br>
+SELECT t.trans_id, t.`date`, t.user_info.cust_id as cust_id, t.user_info.device as device FROM dfs.clicks.`/clicks/clicks.campaign.json` t
+
+----------

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md
----------------------------------------------------------------------
diff --git a/_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md b/_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md
deleted file mode 100755
index a559c71..0000000
--- a/_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md
+++ /dev/null
@@ -1,50 +0,0 @@
----
-title: "Using Apache Drill with Tibco Spotfire Desktop"
-parent: "ODBC/JDBC Interfaces"
----
-Tibco Spotfire Desktop is a powerful analytic tool that enables SQL statements when connecting to data sources. Spotfire Desktop can utilize the powerful query capabilities of Apache Drill to query complex data structures. Use the MapR Drill ODBC Driver to configure Tibco Spotfire Desktop with Apache Drill.
-
-To use Spotfire Desktop with Apache Drill, complete the following steps:
-
-1.  Install the Drill ODBC Driver from MapR.
-2.	Configure the Spotfire Desktop data connection for Drill.
-
-----------
-
-
-### Step 1: Install and Configure the MapR Drill ODBC Driver 
-
-Drill uses standard ODBC connectivity to provide easy data exploration capabilities on complex, schema-less data sets. Verify that the ODBC driver version that you download correlates with the Apache Drill version that you use. Ideally, you should upgrade to the latest version of Apache Drill and the MapR Drill ODBC Driver. 
-
-Complete the following steps to install and configure the driver:
-
-1.    Download the 64-bit MapR Drill ODBC Driver for Windows from the following location:<br> [http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/](http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/)     
-**Note:** Spotfire Desktop 6.5.1 utilizes the 64-bit ODBC driver.
-2.    Complete steps 2-8 under on the following page to install the driver:<br> 
-[http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/](http://drill.apache.org/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/)
-3.    Complete the steps on the following page to configure the driver:<br>
-[http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/](http://drill.apache.org/docs/step-2-configure-odbc-connections-to-drill-data-sources/)
-
-----------
-
-
-### Step 2: Configure the Spotfire Desktop Data Connection for Drill 
-Complete the following steps to configure a Drill data connection: 
-
-1. Select the **Add Data Connection** option or click the Add Data Connection button in the menu bar, as shown in the image below:![](http://i.imgur.com/p3LNNBs.png)
-2. When the dialog window appears, click the **Add** button, and select **Other/Database** from the dropdown list.![](http://i.imgur.com/u1g9kaT.png)
-3. In the Open Database window that appears, select **Odbc Data Provider** and then click **Configure**. ![](http://i.imgur.com/8Gu0GAZ.png)
-4. In the Configure Data Source Connection window that appears, select the Drill DSN that you configured in the ODBC administrator, and enter the relevant credentials for Drill.<br> ![](http://i.imgur.com/Yd6BKls.png) 
-5. Click **OK** to continue. The Spotfire Desktop queries the Drill metadata for available schemas, tables, and views. You can navigate the schemas in the left-hand column. After you select a specific view or table, the relevant SQL displays in the right-hand column. 
-![](http://i.imgur.com/wNBDs5q.png)
-6. Optionally, you can modify the SQL to work best with Drill. Simply change the schema.table.* notation in the SELECT statement to simply * or the relevant column names that are needed. 
-Note that Drill has certain reserved keywords that you must put in back ticks [ ` ] when needed. See [Drill Reserved Keywords](http://drill.apache.org/docs/reserved-keywords/).
-7. Once the SQL is complete, provide a name for the Data Source and click **OK**. Spotfire Desktop queries Drill and retrieves the data for analysis. You can use the functionality of Spotfire Desktop to work with the data.
-![](http://i.imgur.com/j0MWorh.png)
-
-**NOTE:** You can use the SQL statement column to query data and complex structures that do not display in the left-hand schema column. A good example is JSON files in the file system.
-
-**SQL Example:**<br>
-SELECT t.trans_id, t.`date`, t.user_info.cust_id as cust_id, t.user_info.device as device FROM dfs.clicks.`/clicks/clicks.campaign.json` t
-
-----------

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/sql-reference/sql-commands/030-create-table-as-command.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/030-create-table-as-command.md b/_docs/sql-reference/sql-commands/030-create-table-as-command.md
index 5bab011..8e0a4e1 100644
--- a/_docs/sql-reference/sql-commands/030-create-table-as-command.md
+++ b/_docs/sql-reference/sql-commands/030-create-table-as-command.md
@@ -1,5 +1,5 @@
 ---
-title: "CREATE TABLE AS (CTAS) command"
+title: "CREATE TABLE AS (CTAS) Command"
 parent: "SQL Commands"
 ---
 You can create tables in Drill by using the CTAS command:

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/sql-reference/sql-commands/050-create-view-command.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/050-create-view-command.md b/_docs/sql-reference/sql-commands/050-create-view-command.md
index d21ea12..53cf3b8 100644
--- a/_docs/sql-reference/sql-commands/050-create-view-command.md
+++ b/_docs/sql-reference/sql-commands/050-create-view-command.md
@@ -1,5 +1,5 @@
 ---
-title: "CREATE VIEW command"
+title: "CREATE VIEW Command"
 parent: "SQL Commands"
 ---
 The CREATE VIEW command creates a virtual structure for the result set of a

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/sql-reference/sql-commands/070-explain-commands.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/070-explain-commands.md b/_docs/sql-reference/sql-commands/070-explain-commands.md
index 5aab0e9..acf0825 100644
--- a/_docs/sql-reference/sql-commands/070-explain-commands.md
+++ b/_docs/sql-reference/sql-commands/070-explain-commands.md
@@ -1,5 +1,5 @@
 ---
-title: "EXPLAIN commands"
+title: "EXPLAIN Commands"
 parent: "SQL Commands"
 ---
 EXPLAIN is a useful tool for examining the steps that a query goes through

http://git-wip-us.apache.org/repos/asf/drill/blob/80bbe062/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md b/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md
index c000f32..0f227ae 100644
--- a/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md
+++ b/_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md
@@ -1,5 +1,5 @@
 ---
-title: "SHOW DATABASES AND SHOW SCHEMAS Command"
+title: "SHOW DATABASES and SHOW SCHEMAS Command"
 parent: "SQL Commands"
 ---
 The SHOW DATABASES and SHOW SCHEMAS commands generate a list of available Drill schemas that you can query.


Mime
View raw message