You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/07/01 03:33:24 UTC
[2/5] drill git commit: autoCommit doc per Parth
autoCommit doc per Parth
refinements
placeholders
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/59391722
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/59391722
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/59391722
Branch: refs/heads/gh-pages
Commit: 593917227062414940bf1789c766c6e374e0c104
Parents: 9784cfc
Author: Kristine Hahn <kh...@maprtech.com>
Authored: Tue Jun 30 13:55:41 2015 -0700
Committer: Kristine Hahn <kh...@maprtech.com>
Committed: Tue Jun 30 13:57:41 2015 -0700
----------------------------------------------------------------------
_data/docs.json | 322 +++++++++++++------
...er-impersonation-with-hive-authentication.md | 15 +
.../120-configuring-the-drill-shell.md | 8 +-
_docs/sql-reference/055-sql-window-functions.md | 4 +
.../sql-commands/035-partition-by-clause.md | 10 +-
.../010-sql-window-functions-introduction.md | 4 +
6 files changed, 258 insertions(+), 105 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/59391722/_data/docs.json
----------------------------------------------------------------------
diff --git a/_data/docs.json b/_data/docs.json
index 62ce47d..8a05186 100644
--- a/_data/docs.json
+++ b/_data/docs.json
@@ -748,8 +748,8 @@
"next_title": "Configuration Options Introduction",
"next_url": "/docs/configuration-options-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring User Authentication",
- "previous_url": "/docs/configuring-user-authentication/",
+ "previous_title": "Configuring User Impersonation with Hive Authentication",
+ "previous_url": "/docs/configuring-user-impersonation-with-hive-authentication/",
"relative_path": "_docs/configure-drill/080-configuration-options.md",
"title": "Configuration Options",
"url": "/docs/configuration-options/"
@@ -918,8 +918,8 @@
}
],
"children": [],
- "next_title": "Configuration Options",
- "next_url": "/docs/configuration-options/",
+ "next_title": "Configuring User Impersonation with Hive Authentication",
+ "next_url": "/docs/configuring-user-impersonation-with-hive-authentication/",
"parent": "Configure Drill",
"previous_title": "Configuring User Impersonation",
"previous_url": "/docs/configuring-user-impersonation/",
@@ -934,6 +934,23 @@
"url": "/docs/configure-drill/"
}
],
+ "children": [],
+ "next_title": "Configuration Options",
+ "next_url": "/docs/configuration-options/",
+ "parent": "Configure Drill",
+ "previous_title": "Configuring User Authentication",
+ "previous_url": "/docs/configuring-user-authentication/",
+ "relative_path": "_docs/configure-drill/077-configuring-user-impersonation-with-hive-authentication.md",
+ "title": "Configuring User Impersonation with Hive Authentication",
+ "url": "/docs/configuring-user-impersonation-with-hive-authentication/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Configure Drill",
+ "url": "/docs/configure-drill/"
+ }
+ ],
"children": [
{
"breadcrumbs": [
@@ -1023,8 +1040,8 @@
"next_title": "Configuration Options Introduction",
"next_url": "/docs/configuration-options-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring User Authentication",
- "previous_url": "/docs/configuring-user-authentication/",
+ "previous_title": "Configuring User Impersonation with Hive Authentication",
+ "previous_url": "/docs/configuring-user-impersonation-with-hive-authentication/",
"relative_path": "_docs/configure-drill/080-configuration-options.md",
"title": "Configuration Options",
"url": "/docs/configuration-options/"
@@ -1385,8 +1402,8 @@
}
],
"children": [],
- "next_title": "Configuration Options",
- "next_url": "/docs/configuration-options/",
+ "next_title": "Configuring User Impersonation with Hive Authentication",
+ "next_url": "/docs/configuring-user-impersonation-with-hive-authentication/",
"parent": "Configure Drill",
"previous_title": "Configuring User Impersonation",
"previous_url": "/docs/configuring-user-impersonation/",
@@ -1411,6 +1428,23 @@
"title": "Configuring User Impersonation",
"url": "/docs/configuring-user-impersonation/"
},
+ "Configuring User Impersonation with Hive Authentication": {
+ "breadcrumbs": [
+ {
+ "title": "Configure Drill",
+ "url": "/docs/configure-drill/"
+ }
+ ],
+ "children": [],
+ "next_title": "Configuration Options",
+ "next_url": "/docs/configuration-options/",
+ "parent": "Configure Drill",
+ "previous_title": "Configuring User Authentication",
+ "previous_url": "/docs/configuring-user-authentication/",
+ "relative_path": "_docs/configure-drill/077-configuring-user-impersonation-with-hive-authentication.md",
+ "title": "Configuring User Impersonation with Hive Authentication",
+ "url": "/docs/configuring-user-impersonation-with-hive-authentication/"
+ },
"Configuring a Multitenant Cluster": {
"breadcrumbs": [
{
@@ -3159,8 +3193,8 @@
}
],
"children": [],
- "next_title": "Nested Data Functions",
- "next_url": "/docs/nested-data-functions/",
+ "next_title": "SQL Window Functions",
+ "next_url": "/docs/sql-window-functions/",
"parent": "SQL Functions",
"previous_title": "Aggregate and Aggregate Statistical",
"previous_url": "/docs/aggregate-and-aggregate-statistical/",
@@ -4865,8 +4899,8 @@
"next_title": "Nested Data Limitations",
"next_url": "/docs/nested-data-limitations/",
"parent": "SQL Reference",
- "previous_title": "Functions for Handling Nulls",
- "previous_url": "/docs/functions-for-handling-nulls/",
+ "previous_title": "SQL Window Functions Introduction",
+ "previous_url": "/docs/sql-window-functions-introduction/",
"relative_path": "_docs/sql-reference/060-nested-data-functions.md",
"title": "Nested Data Functions",
"url": "/docs/nested-data-functions/"
@@ -5356,8 +5390,8 @@
}
],
"children": [],
- "next_title": "Using Tibco Spotfire Desktop with Drill",
- "next_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
+ "next_title": "Configuring Tibco Spotfire Server with Drill",
+ "next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
"parent": "Using Drill with BI Tools",
"previous_title": "Using MicroStrategy Analytics with Apache Drill",
"previous_url": "/docs/using-microstrategy-analytics-with-apache-drill/",
@@ -5377,27 +5411,6 @@
}
],
"children": [],
- "next_title": "Configuring Tibco Spotfire Server with Drill",
- "next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
- "parent": "Using Drill with BI Tools",
- "previous_title": "Using Tibco Spotfire Desktop with Drill",
- "previous_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
- "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-with-drill.md",
- "title": "Using Tibco Spotfire Desktop with Drill",
- "url": "/docs/using-tibco-spotfire-desktop-with-drill/"
- },
- {
- "breadcrumbs": [
- {
- "title": "Using Drill with BI Tools",
- "url": "/docs/using-drill-with-bi-tools/"
- },
- {
- "title": "ODBC/JDBC Interfaces",
- "url": "/docs/odbc-jdbc-interfaces/"
- }
- ],
- "children": [],
"next_title": "Using Apache Drill with Tableau 9 Desktop",
"next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
"parent": "Using Drill with BI Tools",
@@ -8446,8 +8459,8 @@
}
],
"children": [],
- "next_title": "Nested Data Functions",
- "next_url": "/docs/nested-data-functions/",
+ "next_title": "SQL Window Functions",
+ "next_url": "/docs/sql-window-functions/",
"parent": "SQL Functions",
"previous_title": "Aggregate and Aggregate Statistical",
"previous_url": "/docs/aggregate-and-aggregate-statistical/",
@@ -8746,8 +8759,8 @@
}
],
"children": [],
- "next_title": "Nested Data Functions",
- "next_url": "/docs/nested-data-functions/",
+ "next_title": "SQL Window Functions",
+ "next_url": "/docs/sql-window-functions/",
"parent": "SQL Functions",
"previous_title": "Aggregate and Aggregate Statistical",
"previous_url": "/docs/aggregate-and-aggregate-statistical/",
@@ -8776,6 +8789,45 @@
{
"breadcrumbs": [
{
+ "title": "SQL Window Functions",
+ "url": "/docs/sql-window-functions/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "Nested Data Functions",
+ "next_url": "/docs/nested-data-functions/",
+ "parent": "SQL Window Functions",
+ "previous_title": "SQL Window Functions",
+ "previous_url": "/docs/sql-window-functions/",
+ "relative_path": "_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md",
+ "title": "SQL Window Functions Introduction",
+ "url": "/docs/sql-window-functions-introduction/"
+ }
+ ],
+ "next_title": "SQL Window Functions Introduction",
+ "next_url": "/docs/sql-window-functions-introduction/",
+ "parent": "SQL Reference",
+ "previous_title": "Functions for Handling Nulls",
+ "previous_url": "/docs/functions-for-handling-nulls/",
+ "relative_path": "_docs/sql-reference/055-sql-window-functions.md",
+ "title": "SQL Window Functions",
+ "url": "/docs/sql-window-functions/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [
+ {
+ "breadcrumbs": [
+ {
"title": "Nested Data Functions",
"url": "/docs/nested-data-functions/"
},
@@ -8882,8 +8934,8 @@
"next_title": "Nested Data Limitations",
"next_url": "/docs/nested-data-limitations/",
"parent": "SQL Reference",
- "previous_title": "Functions for Handling Nulls",
- "previous_url": "/docs/functions-for-handling-nulls/",
+ "previous_title": "SQL Window Functions Introduction",
+ "previous_url": "/docs/sql-window-functions-introduction/",
"relative_path": "_docs/sql-reference/060-nested-data-functions.md",
"title": "Nested Data Functions",
"url": "/docs/nested-data-functions/"
@@ -9527,6 +9579,66 @@
"title": "SQL Reference Introduction",
"url": "/docs/sql-reference-introduction/"
},
+ "SQL Window Functions": {
+ "breadcrumbs": [
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [
+ {
+ "breadcrumbs": [
+ {
+ "title": "SQL Window Functions",
+ "url": "/docs/sql-window-functions/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "Nested Data Functions",
+ "next_url": "/docs/nested-data-functions/",
+ "parent": "SQL Window Functions",
+ "previous_title": "SQL Window Functions",
+ "previous_url": "/docs/sql-window-functions/",
+ "relative_path": "_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md",
+ "title": "SQL Window Functions Introduction",
+ "url": "/docs/sql-window-functions-introduction/"
+ }
+ ],
+ "next_title": "SQL Window Functions Introduction",
+ "next_url": "/docs/sql-window-functions-introduction/",
+ "parent": "SQL Reference",
+ "previous_title": "Functions for Handling Nulls",
+ "previous_url": "/docs/functions-for-handling-nulls/",
+ "relative_path": "_docs/sql-reference/055-sql-window-functions.md",
+ "title": "SQL Window Functions",
+ "url": "/docs/sql-window-functions/"
+ },
+ "SQL Window Functions Introduction": {
+ "breadcrumbs": [
+ {
+ "title": "SQL Window Functions",
+ "url": "/docs/sql-window-functions/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "Nested Data Functions",
+ "next_url": "/docs/nested-data-functions/",
+ "parent": "SQL Window Functions",
+ "previous_title": "SQL Window Functions",
+ "previous_url": "/docs/sql-window-functions/",
+ "relative_path": "_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md",
+ "title": "SQL Window Functions Introduction",
+ "url": "/docs/sql-window-functions-introduction/"
+ },
"Sample Data: Donuts": {
"breadcrumbs": [
{
@@ -10645,8 +10757,8 @@
}
],
"children": [],
- "next_title": "Using Tibco Spotfire Desktop with Drill",
- "next_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
+ "next_title": "Configuring Tibco Spotfire Server with Drill",
+ "next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
"parent": "Using Drill with BI Tools",
"previous_title": "Using MicroStrategy Analytics with Apache Drill",
"previous_url": "/docs/using-microstrategy-analytics-with-apache-drill/",
@@ -10666,27 +10778,6 @@
}
],
"children": [],
- "next_title": "Configuring Tibco Spotfire Server with Drill",
- "next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
- "parent": "Using Drill with BI Tools",
- "previous_title": "Using Tibco Spotfire Desktop with Drill",
- "previous_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
- "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-with-drill.md",
- "title": "Using Tibco Spotfire Desktop with Drill",
- "url": "/docs/using-tibco-spotfire-desktop-with-drill/"
- },
- {
- "breadcrumbs": [
- {
- "title": "Using Drill with BI Tools",
- "url": "/docs/using-drill-with-bi-tools/"
- },
- {
- "title": "ODBC/JDBC Interfaces",
- "url": "/docs/odbc-jdbc-interfaces/"
- }
- ],
- "children": [],
"next_title": "Using Apache Drill with Tableau 9 Desktop",
"next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
"parent": "Using Drill with BI Tools",
@@ -10864,9 +10955,9 @@
"next_title": "Configuring Tibco Spotfire Server with Drill",
"next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
"parent": "Using Drill with BI Tools",
- "previous_title": "Using Tibco Spotfire Desktop with Drill",
- "previous_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
- "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-with-drill.md",
+ "previous_title": "Using MicroStrategy Analytics with Apache Drill",
+ "previous_url": "/docs/using-microstrategy-analytics-with-apache-drill/",
+ "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-desktop-with-drill.md",
"title": "Using Tibco Spotfire Desktop with Drill",
"url": "/docs/using-tibco-spotfire-desktop-with-drill/"
},
@@ -11792,8 +11883,8 @@
}
],
"children": [],
- "next_title": "Configuration Options",
- "next_url": "/docs/configuration-options/",
+ "next_title": "Configuring User Impersonation with Hive Authentication",
+ "next_url": "/docs/configuring-user-impersonation-with-hive-authentication/",
"parent": "Configure Drill",
"previous_title": "Configuring User Impersonation",
"previous_url": "/docs/configuring-user-impersonation/",
@@ -11808,6 +11899,23 @@
"url": "/docs/configure-drill/"
}
],
+ "children": [],
+ "next_title": "Configuration Options",
+ "next_url": "/docs/configuration-options/",
+ "parent": "Configure Drill",
+ "previous_title": "Configuring User Authentication",
+ "previous_url": "/docs/configuring-user-authentication/",
+ "relative_path": "_docs/configure-drill/077-configuring-user-impersonation-with-hive-authentication.md",
+ "title": "Configuring User Impersonation with Hive Authentication",
+ "url": "/docs/configuring-user-impersonation-with-hive-authentication/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Configure Drill",
+ "url": "/docs/configure-drill/"
+ }
+ ],
"children": [
{
"breadcrumbs": [
@@ -11897,8 +12005,8 @@
"next_title": "Configuration Options Introduction",
"next_url": "/docs/configuration-options-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring User Authentication",
- "previous_url": "/docs/configuring-user-authentication/",
+ "previous_title": "Configuring User Impersonation with Hive Authentication",
+ "previous_url": "/docs/configuring-user-impersonation-with-hive-authentication/",
"relative_path": "_docs/configure-drill/080-configuration-options.md",
"title": "Configuration Options",
"url": "/docs/configuration-options/"
@@ -12615,8 +12723,8 @@
}
],
"children": [],
- "next_title": "Using Tibco Spotfire Desktop with Drill",
- "next_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
+ "next_title": "Configuring Tibco Spotfire Server with Drill",
+ "next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
"parent": "Using Drill with BI Tools",
"previous_title": "Using MicroStrategy Analytics with Apache Drill",
"previous_url": "/docs/using-microstrategy-analytics-with-apache-drill/",
@@ -12636,27 +12744,6 @@
}
],
"children": [],
- "next_title": "Configuring Tibco Spotfire Server with Drill",
- "next_url": "/docs/configuring-tibco-spotfire-server-with-drill/",
- "parent": "Using Drill with BI Tools",
- "previous_title": "Using Tibco Spotfire Desktop with Drill",
- "previous_url": "/docs/using-tibco-spotfire-desktop-with-drill/",
- "relative_path": "_docs/odbc-jdbc-interfaces/using-drill-with-bi-tools/040-using-tibco-spotfire-with-drill.md",
- "title": "Using Tibco Spotfire Desktop with Drill",
- "url": "/docs/using-tibco-spotfire-desktop-with-drill/"
- },
- {
- "breadcrumbs": [
- {
- "title": "Using Drill with BI Tools",
- "url": "/docs/using-drill-with-bi-tools/"
- },
- {
- "title": "ODBC/JDBC Interfaces",
- "url": "/docs/odbc-jdbc-interfaces/"
- }
- ],
- "children": [],
"next_title": "Using Apache Drill with Tableau 9 Desktop",
"next_url": "/docs/using-apache-drill-with-tableau-9-desktop/",
"parent": "Using Drill with BI Tools",
@@ -13859,8 +13946,8 @@
}
],
"children": [],
- "next_title": "Nested Data Functions",
- "next_url": "/docs/nested-data-functions/",
+ "next_title": "SQL Window Functions",
+ "next_url": "/docs/sql-window-functions/",
"parent": "SQL Functions",
"previous_title": "Aggregate and Aggregate Statistical",
"previous_url": "/docs/aggregate-and-aggregate-statistical/",
@@ -13889,6 +13976,45 @@
{
"breadcrumbs": [
{
+ "title": "SQL Window Functions",
+ "url": "/docs/sql-window-functions/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "Nested Data Functions",
+ "next_url": "/docs/nested-data-functions/",
+ "parent": "SQL Window Functions",
+ "previous_title": "SQL Window Functions",
+ "previous_url": "/docs/sql-window-functions/",
+ "relative_path": "_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md",
+ "title": "SQL Window Functions Introduction",
+ "url": "/docs/sql-window-functions-introduction/"
+ }
+ ],
+ "next_title": "SQL Window Functions Introduction",
+ "next_url": "/docs/sql-window-functions-introduction/",
+ "parent": "SQL Reference",
+ "previous_title": "Functions for Handling Nulls",
+ "previous_url": "/docs/functions-for-handling-nulls/",
+ "relative_path": "_docs/sql-reference/055-sql-window-functions.md",
+ "title": "SQL Window Functions",
+ "url": "/docs/sql-window-functions/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [
+ {
+ "breadcrumbs": [
+ {
"title": "Nested Data Functions",
"url": "/docs/nested-data-functions/"
},
@@ -13995,8 +14121,8 @@
"next_title": "Nested Data Limitations",
"next_url": "/docs/nested-data-limitations/",
"parent": "SQL Reference",
- "previous_title": "Functions for Handling Nulls",
- "previous_url": "/docs/functions-for-handling-nulls/",
+ "previous_title": "SQL Window Functions Introduction",
+ "previous_url": "/docs/sql-window-functions-introduction/",
"relative_path": "_docs/sql-reference/060-nested-data-functions.md",
"title": "Nested Data Functions",
"url": "/docs/nested-data-functions/"
http://git-wip-us.apache.org/repos/asf/drill/blob/59391722/_docs/configure-drill/077-configuring-user-impersonation-with-hive-authentication.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/077-configuring-user-impersonation-with-hive-authentication.md b/_docs/configure-drill/077-configuring-user-impersonation-with-hive-authentication.md
new file mode 100755
index 0000000..aa3c7d5
--- /dev/null
+++ b/_docs/configure-drill/077-configuring-user-impersonation-with-hive-authentication.md
@@ -0,0 +1,15 @@
+---
+title: "Configuring User Impersonation with Hive Authentication"
+parent: "Configure Drill"
+---
+
+
+
+
+
+
+
+
+
+
+
http://git-wip-us.apache.org/repos/asf/drill/blob/59391722/_docs/configure-drill/120-configuring-the-drill-shell.md
----------------------------------------------------------------------
diff --git a/_docs/configure-drill/120-configuring-the-drill-shell.md b/_docs/configure-drill/120-configuring-the-drill-shell.md
index 383bc1b..1597fa0 100644
--- a/_docs/configure-drill/120-configuring-the-drill-shell.md
+++ b/_docs/configure-drill/120-configuring-the-drill-shell.md
@@ -56,7 +56,7 @@ Set the output format to CSV to improve performance of a huge query.
| Variable Name | Valid Variable Values | Description |
|-----------------|------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
-| autoCommit | true/false | Enable/disable automatic transaction commit. |
+| autoCommit | true/false | Enable/disable automatic transaction commit. Should remain enabled (true). |
| autoSave | true/false | Automatically save preferences. |
| color | true/false | Control whether color is used for display. |
| fastConnect | true/false | Skip building table/column list for tab-completion. |
@@ -79,4 +79,8 @@ Set the output format to CSV to improve performance of a huge query.
| silent | true/false | Disable or enable showing information specified by show commands. |
| timeout | \<integer\> | Query timeout in seconds; less than zero means no timeout. |
| trimScripts | true/false | Remove trailing spaces from lines read from script files. |
-| verbose | true/false | Show unabbreviated error messages and debug info. |
\ No newline at end of file
+| verbose | true/false | Show unabbreviated error messages and debug info. |
+
+### autoCommit
+
+Drill performs read-only operations primarily, and autocommits writes. Drill JDBC throws an exception if autoCommit is disabled.
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/drill/blob/59391722/_docs/sql-reference/055-sql-window-functions.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/055-sql-window-functions.md b/_docs/sql-reference/055-sql-window-functions.md
new file mode 100644
index 0000000..5dc1075
--- /dev/null
+++ b/_docs/sql-reference/055-sql-window-functions.md
@@ -0,0 +1,4 @@
+---
+title: "SQL Window Functions"
+parent: "SQL Reference"
+---
http://git-wip-us.apache.org/repos/asf/drill/blob/59391722/_docs/sql-reference/sql-commands/035-partition-by-clause.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/035-partition-by-clause.md b/_docs/sql-reference/sql-commands/035-partition-by-clause.md
index 3214c05..c57fa7a 100644
--- a/_docs/sql-reference/sql-commands/035-partition-by-clause.md
+++ b/_docs/sql-reference/sql-commands/035-partition-by-clause.md
@@ -2,11 +2,11 @@
title: "PARTITION BY Clause"
parent: "SQL Commands"
---
-In Drill 1.1, using the PARTITION BY clause in the CTAS command, automatically partitions data, which Drill [prunes]({{site.baseurl}}/docs/partition-pruning/) when you query the data to improve performance.
+The PARTITION BY clause in the CTAS command, automatically partitions data, which Drill [prunes]({{site.baseurl}}/docs/partition-pruning/) when you query the data to improve performance. (Drill 1.1.0)
## Syntax
- [ PARTITION_BY ( column_name[, . . .] ) ]
+ [ PARTITION_BY ( column_name[, . . .] ) ]
The PARTITION BY clause partitions the data by the first column_name, and then subpartitions the data by the next column_name, and so on.
@@ -76,7 +76,7 @@ a file to have this extension.
Distributed mode: This example assumes that the default `dfs` either works with your distributed file system out-of-the-box, or that you have adapted the storage plugin to your environment.
`USE dfs.tmp`;
5. Set the `store.format` property to the default parquet if you changed the default.
- `ALTER SESSION SET `store.format` = 'parquet';`
+ ``ALTER SESSION SET `store.format` = 'parquet';``
6. Partition Google Ngram data by year in a directory named `by_yr`.
Embedded mode:
@@ -109,7 +109,7 @@ a file to have this extension.
0_0_12.parquet 0_0_30.parquet 0_0_49.parquet 0_0_67.parquet
. . .
7. Query the `by_yr` directory to check to see how the data appears.
- `SELECT * FROM by_yr LIMIT 100`;
+ `SELECT * FROM by_yr LIMIT 100;`
The output looks something like this:
+-------+------------------------------------------------------------+--------------+
@@ -153,7 +153,7 @@ a file to have this extension.
+-------------------------------------------------------------------------------+
31,100 rows selected (8.389 seconds)
- The more data you query, the greater the performance benefit is from partition pruning.
+ The larger the data set you query, the greater the performance benefit from partition pruning.
## Other Examples
http://git-wip-us.apache.org/repos/asf/drill/blob/59391722/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md b/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md
new file mode 100644
index 0000000..cd2426a
--- /dev/null
+++ b/_docs/sql-reference/sql-window-functions/010-sql-window-functions-introduction.md
@@ -0,0 +1,4 @@
+---
+title: "SQL Window Functions Introduction"
+parent: "SQL Window Functions"
+---