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/09/16 01:24:22 UTC
[5/5] drill git commit: Daniel's changes
Daniel's changes
remove Step 1, there is no other step
minor edit
minor edits
DRILL-2354
DRILL-2757
typo
web UI security
web ui security updates
format bullets
remove impersonation
web ui security
fix link
obsolete stuff
obsolete
fix per Daniel
web ui security update
typo
Bridget's 1.2 window func updates
Bridget's fixes
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/43d6dd1d
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/43d6dd1d
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/43d6dd1d
Branch: refs/heads/gh-pages
Commit: 43d6dd1d9a29f5f81cba79f0f34bb082d21d4a16
Parents: 26e9af6
Author: Kristine Hahn <kh...@maprtech.com>
Authored: Thu Sep 10 17:42:28 2015 -0700
Committer: Kristine Hahn <kh...@maprtech.com>
Committed: Tue Sep 15 16:19:29 2015 -0700
----------------------------------------------------------------------
_data/docs.json | 687 ++++++++++---------
_docs/150-archived-pages.md | 3 -
_docs/160-progress-reports.md | 4 -
.../010-how-to-run-the-drill-demo.md | 308 ---------
.../archived-pages/020-what-is-apache-drill.md | 41 --
...-configuring-web-ui-and-rest-api-security.md | 121 ++++
.../020-storage-plugin-registration.md | 16 +-
.../035-plugin-configuration-basics.md | 6 +-
.../025-tutorial-develop-a-simple-function.md | 6 +-
.../050-use-custom-functions-in-queries.md | 2 +-
.../010-apache-drill-contribution-guidelines.md | 2 +-
_docs/img/plugin-default.png | Bin 56412 -> 70859 bytes
_docs/img/web-ui-admin-view.png | Bin 0 -> 45701 bytes
_docs/img/web-ui-login.png | Bin 0 -> 45535 bytes
_docs/img/web-ui-user-view.png | Bin 0 -> 47799 bytes
_docs/img/web-ui.png | Bin 0 -> 43194 bytes
.../045-distributed-mode-prerequisites.md | 21 +-
.../047-installing-drill-on-the-cluster.md | 18 +-
.../050-starting-drill-in-distributed-mode.md | 90 ++-
_docs/install/060-starting-the-web-ui.md | 24 +
...20-installing-drill-on-linux-and-mac-os-x.md | 8 +-
.../030-starting-drill-on-linux-and-mac-os-x.md | 35 +-
.../040-installing-drill-on-windows.md | 5 +-
.../050-starting-drill-on-windows.md | 17 +-
.../015-using-jdbc-driver.md | 132 ++--
_docs/progress-reports/001-2014-q1.md | 174 -----
_docs/query-data/030-querying-hbase.md | 2 +-
...and-canceling-queries-in-the-Drill-Web-UI.md | 2 +-
.../010-querying-json-files.md | 27 +-
.../020-querying-parquet-files.md | 16 +-
_docs/sql-reference/040-operators.md | 5 +-
.../sql-reference/sql-commands/053-describe.md | 99 +++
.../sql-commands/055-drop-table.md | 270 ++++++++
.../sql-reference/sql-commands/055-drop-view.md | 47 --
.../sql-reference/sql-commands/056-drop-view.md | 47 ++
.../sql-reference/sql-commands/060-describe.md | 99 ---
.../010-case-expression.md | 4 +-
.../sql-functions/020-data-type-conversion.md | 9 +-
.../030-date-time-functions-and-arithmetic.md | 39 +-
.../050-aggregate-and-aggregate-statistical.md | 12 +-
.../010-sql-window-functions-introduction.md | 6 +-
.../030-ranking-window-functions.md | 54 +-
.../035-value-window-functions.md | 131 ++++
_docs/tutorials/020-drill-in-10-minutes.md | 60 +-
.../030-analyzing-the-yelp-academic-dataset.md | 2 +-
45 files changed, 1369 insertions(+), 1282 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/43d6dd1d/_data/docs.json
----------------------------------------------------------------------
diff --git a/_data/docs.json b/_data/docs.json
index c6af217..6ecd0a5 100644
--- a/_data/docs.json
+++ b/_data/docs.json
@@ -1,22 +1,5 @@
{
"by_title": {
- "2014 Q1 Drill Report": {
- "breadcrumbs": [
- {
- "title": "Progress Reports",
- "url": "/docs/progress-reports/"
- }
- ],
- "children": [],
- "next_title": "Project Bylaws",
- "next_url": "/docs/project-bylaws/",
- "parent": "Progress Reports",
- "previous_title": "Progress Reports",
- "previous_url": "/docs/progress-reports/",
- "relative_path": "_docs/progress-reports/001-2014-q1.md",
- "title": "2014 Q1 Drill Report",
- "url": "/docs/2014-q1-drill-report/"
- },
"ALTER SESSION": {
"breadcrumbs": [
{
@@ -521,53 +504,6 @@
"title": "Architecture Introduction",
"url": "/docs/architecture-introduction/"
},
- "Archived Pages": {
- "breadcrumbs": [],
- "children": [
- {
- "breadcrumbs": [
- {
- "title": "Archived Pages",
- "url": "/docs/archived-pages/"
- }
- ],
- "children": [],
- "next_title": "What is Apache Drill",
- "next_url": "/docs/what-is-apache-drill/",
- "parent": "Archived Pages",
- "previous_title": "Archived Pages",
- "previous_url": "/docs/archived-pages/",
- "relative_path": "_docs/archived-pages/010-how-to-run-the-drill-demo.md",
- "title": "How to Run the Drill Demo",
- "url": "/docs/how-to-run-the-drill-demo/"
- },
- {
- "breadcrumbs": [
- {
- "title": "Archived Pages",
- "url": "/docs/archived-pages/"
- }
- ],
- "children": [],
- "next_title": "Progress Reports",
- "next_url": "/docs/progress-reports/",
- "parent": "Archived Pages",
- "previous_title": "How to Run the Drill Demo",
- "previous_url": "/docs/how-to-run-the-drill-demo/",
- "relative_path": "_docs/archived-pages/020-what-is-apache-drill.md",
- "title": "What is Apache Drill",
- "url": "/docs/what-is-apache-drill/"
- }
- ],
- "next_title": "How to Run the Drill Demo",
- "next_url": "/docs/how-to-run-the-drill-demo/",
- "parent": "",
- "previous_title": "Wikipedia Edit History",
- "previous_url": "/docs/wikipedia-edit-history/",
- "relative_path": "_docs/150-archived-pages.md",
- "title": "Archived Pages",
- "url": "/docs/archived-pages/"
- },
"Browsing Data and Defining Views": {
"breadcrumbs": [
{
@@ -643,8 +579,8 @@
}
],
"children": [],
- "next_title": "DROP VIEW",
- "next_url": "/docs/drop-view/",
+ "next_title": "DESCRIBE",
+ "next_url": "/docs/describe/",
"parent": "SQL Commands",
"previous_title": "PARTITION BY Clause",
"previous_url": "/docs/partition-by-clause/",
@@ -786,8 +722,8 @@
"next_title": "Configuration Options Introduction",
"next_url": "/docs/configuration-options-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring User Impersonation with Hive Authorization",
- "previous_url": "/docs/configuring-user-impersonation-with-hive-authorization/",
+ "previous_title": "Configuring Web UI and REST API Security",
+ "previous_url": "/docs/configuring-web-ui-and-rest-api-security/",
"relative_path": "_docs/configure-drill/080-configuration-options.md",
"title": "Configuration Options",
"url": "/docs/configuration-options/"
@@ -973,8 +909,8 @@
}
],
"children": [],
- "next_title": "Configuration Options",
- "next_url": "/docs/configuration-options/",
+ "next_title": "Configuring Web UI and REST API Security",
+ "next_url": "/docs/configuring-web-ui-and-rest-api-security/",
"parent": "Configure Drill",
"previous_title": "Configuring User Authentication",
"previous_url": "/docs/configuring-user-authentication/",
@@ -989,6 +925,23 @@
"url": "/docs/configure-drill/"
}
],
+ "children": [],
+ "next_title": "Configuration Options",
+ "next_url": "/docs/configuration-options/",
+ "parent": "Configure Drill",
+ "previous_title": "Configuring User Impersonation with Hive Authorization",
+ "previous_url": "/docs/configuring-user-impersonation-with-hive-authorization/",
+ "relative_path": "_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md",
+ "title": "Configuring Web UI and REST API Security",
+ "url": "/docs/configuring-web-ui-and-rest-api-security/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Configure Drill",
+ "url": "/docs/configure-drill/"
+ }
+ ],
"children": [
{
"breadcrumbs": [
@@ -1078,8 +1031,8 @@
"next_title": "Configuration Options Introduction",
"next_url": "/docs/configuration-options-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring User Impersonation with Hive Authorization",
- "previous_url": "/docs/configuring-user-impersonation-with-hive-authorization/",
+ "previous_title": "Configuring Web UI and REST API Security",
+ "previous_url": "/docs/configuring-web-ui-and-rest-api-security/",
"relative_path": "_docs/configure-drill/080-configuration-options.md",
"title": "Configuration Options",
"url": "/docs/configuration-options/"
@@ -1122,8 +1075,8 @@
"next_title": "Configure Drill Introduction",
"next_url": "/docs/configure-drill-introduction/",
"parent": "",
- "previous_title": "Starting Drill in Distributed Mode",
- "previous_url": "/docs/starting-drill-in-distributed-mode/",
+ "previous_title": "Starting the Web UI",
+ "previous_url": "/docs/starting-the-web-ui/",
"relative_path": "_docs/045-configure-drill.md",
"title": "Configure Drill",
"url": "/docs/configure-drill/"
@@ -1474,8 +1427,8 @@
}
],
"children": [],
- "next_title": "Configuration Options",
- "next_url": "/docs/configuration-options/",
+ "next_title": "Configuring Web UI and REST API Security",
+ "next_url": "/docs/configuring-web-ui-and-rest-api-security/",
"parent": "Configure Drill",
"previous_title": "Configuring User Authentication",
"previous_url": "/docs/configuring-user-authentication/",
@@ -1483,6 +1436,23 @@
"title": "Configuring User Impersonation with Hive Authorization",
"url": "/docs/configuring-user-impersonation-with-hive-authorization/"
},
+ "Configuring Web UI and REST API Security": {
+ "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 Impersonation with Hive Authorization",
+ "previous_url": "/docs/configuring-user-impersonation-with-hive-authorization/",
+ "relative_path": "_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md",
+ "title": "Configuring Web UI and REST API Security",
+ "url": "/docs/configuring-web-ui-and-rest-api-security/"
+ },
"Configuring a Multitenant Cluster": {
"breadcrumbs": [
{
@@ -1992,15 +1962,36 @@
}
],
"children": [],
- "next_title": "EXPLAIN",
- "next_url": "/docs/explain/",
+ "next_title": "DROP TABLE",
+ "next_url": "/docs/drop-table/",
"parent": "SQL Commands",
- "previous_title": "DROP VIEW",
- "previous_url": "/docs/drop-view/",
- "relative_path": "_docs/sql-reference/sql-commands/060-describe.md",
+ "previous_title": "CREATE VIEW",
+ "previous_url": "/docs/create-view/",
+ "relative_path": "_docs/sql-reference/sql-commands/053-describe.md",
"title": "DESCRIBE",
"url": "/docs/describe/"
},
+ "DROP TABLE": {
+ "breadcrumbs": [
+ {
+ "title": "SQL Commands",
+ "url": "/docs/sql-commands/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "DROP VIEW",
+ "next_url": "/docs/drop-view/",
+ "parent": "SQL Commands",
+ "previous_title": "DESCRIBE",
+ "previous_url": "/docs/describe/",
+ "relative_path": "_docs/sql-reference/sql-commands/055-drop-table.md",
+ "title": "DROP TABLE",
+ "url": "/docs/drop-table/"
+ },
"DROP VIEW": {
"breadcrumbs": [
{
@@ -2013,12 +2004,12 @@
}
],
"children": [],
- "next_title": "DESCRIBE",
- "next_url": "/docs/describe/",
+ "next_title": "EXPLAIN",
+ "next_url": "/docs/explain/",
"parent": "SQL Commands",
- "previous_title": "CREATE VIEW",
- "previous_url": "/docs/create-view/",
- "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md",
+ "previous_title": "DROP TABLE",
+ "previous_url": "/docs/drop-table/",
+ "relative_path": "_docs/sql-reference/sql-commands/056-drop-view.md",
"title": "DROP VIEW",
"url": "/docs/drop-view/"
},
@@ -3108,8 +3099,8 @@
"next_title": "SELECT",
"next_url": "/docs/select/",
"parent": "SQL Commands",
- "previous_title": "DESCRIBE",
- "previous_url": "/docs/describe/",
+ "previous_title": "DROP VIEW",
+ "previous_url": "/docs/drop-view/",
"relative_path": "_docs/sql-reference/sql-commands/070-explain.md",
"title": "EXPLAIN",
"url": "/docs/explain/"
@@ -3485,23 +3476,6 @@
"title": "Hive-to-Drill Data Type Mapping",
"url": "/docs/hive-to-drill-data-type-mapping/"
},
- "How to Run the Drill Demo": {
- "breadcrumbs": [
- {
- "title": "Archived Pages",
- "url": "/docs/archived-pages/"
- }
- ],
- "children": [],
- "next_title": "What is Apache Drill",
- "next_url": "/docs/what-is-apache-drill/",
- "parent": "Archived Pages",
- "previous_title": "Archived Pages",
- "previous_url": "/docs/archived-pages/",
- "relative_path": "_docs/archived-pages/010-how-to-run-the-drill-demo.md",
- "title": "How to Run the Drill Demo",
- "url": "/docs/how-to-run-the-drill-demo/"
- },
"Identifying Performance Issues": {
"breadcrumbs": [
{
@@ -3767,8 +3741,8 @@
}
],
"children": [],
- "next_title": "Configure Drill",
- "next_url": "/docs/configure-drill/",
+ "next_title": "Starting the Web UI",
+ "next_url": "/docs/starting-the-web-ui/",
"parent": "Installing Drill in Distributed Mode",
"previous_title": "Installing Drill on the Cluster",
"previous_url": "/docs/installing-drill-on-the-cluster/",
@@ -3785,6 +3759,23 @@
"relative_path": "_docs/install/040-installing-drill-in-distributed-mode.md",
"title": "Installing Drill in Distributed Mode",
"url": "/docs/installing-drill-in-distributed-mode/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Install Drill",
+ "url": "/docs/install-drill/"
+ }
+ ],
+ "children": [],
+ "next_title": "Configure Drill",
+ "next_url": "/docs/configure-drill/",
+ "parent": "Install Drill",
+ "previous_title": "Starting Drill in Distributed Mode",
+ "previous_url": "/docs/starting-drill-in-distributed-mode/",
+ "relative_path": "_docs/install/060-starting-the-web-ui.md",
+ "title": "Starting the Web UI",
+ "url": "/docs/starting-the-web-ui/"
}
],
"next_title": "Install Drill Introduction",
@@ -3875,8 +3866,8 @@
}
],
"children": [],
- "next_title": "Configure Drill",
- "next_url": "/docs/configure-drill/",
+ "next_title": "Starting the Web UI",
+ "next_url": "/docs/starting-the-web-ui/",
"parent": "Installing Drill in Distributed Mode",
"previous_title": "Installing Drill on the Cluster",
"previous_url": "/docs/installing-drill-on-the-cluster/",
@@ -6233,44 +6224,14 @@
"title": "Ports Used by Drill",
"url": "/docs/ports-used-by-drill/"
},
- "Progress Reports": {
- "breadcrumbs": [],
- "children": [
- {
- "breadcrumbs": [
- {
- "title": "Progress Reports",
- "url": "/docs/progress-reports/"
- }
- ],
- "children": [],
- "next_title": "Project Bylaws",
- "next_url": "/docs/project-bylaws/",
- "parent": "Progress Reports",
- "previous_title": "Progress Reports",
- "previous_url": "/docs/progress-reports/",
- "relative_path": "_docs/progress-reports/001-2014-q1.md",
- "title": "2014 Q1 Drill Report",
- "url": "/docs/2014-q1-drill-report/"
- }
- ],
- "next_title": "2014 Q1 Drill Report",
- "next_url": "/docs/2014-q1-drill-report/",
- "parent": "",
- "previous_title": "What is Apache Drill",
- "previous_url": "/docs/what-is-apache-drill/",
- "relative_path": "_docs/160-progress-reports.md",
- "title": "Progress Reports",
- "url": "/docs/progress-reports/"
- },
"Project Bylaws": {
"breadcrumbs": [],
"children": [],
"next_title": "",
"next_url": "",
"parent": "",
- "previous_title": "2014 Q1 Drill Report",
- "previous_url": "/docs/2014-q1-drill-report/",
+ "previous_title": "Wikipedia Edit History",
+ "previous_url": "/docs/wikipedia-edit-history/",
"relative_path": "_docs/170-bylaws.md",
"title": "Project Bylaws",
"url": "/docs/project-bylaws/"
@@ -7514,8 +7475,8 @@
}
],
"children": [],
- "next_title": "SQL Window Functions Examples",
- "next_url": "/docs/sql-window-functions-examples/",
+ "next_title": "Value Window Functions",
+ "next_url": "/docs/value-window-functions/",
"parent": "SQL Window Functions",
"previous_title": "Aggregate Window Functions",
"previous_url": "/docs/aggregate-window-functions/",
@@ -7970,8 +7931,8 @@
}
],
"children": [],
- "next_title": "DROP VIEW",
- "next_url": "/docs/drop-view/",
+ "next_title": "DESCRIBE",
+ "next_url": "/docs/describe/",
"parent": "SQL Commands",
"previous_title": "PARTITION BY Clause",
"previous_url": "/docs/partition-by-clause/",
@@ -7991,14 +7952,35 @@
}
],
"children": [],
- "next_title": "DESCRIBE",
- "next_url": "/docs/describe/",
+ "next_title": "DROP TABLE",
+ "next_url": "/docs/drop-table/",
"parent": "SQL Commands",
"previous_title": "CREATE VIEW",
"previous_url": "/docs/create-view/",
- "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md",
- "title": "DROP VIEW",
- "url": "/docs/drop-view/"
+ "relative_path": "_docs/sql-reference/sql-commands/053-describe.md",
+ "title": "DESCRIBE",
+ "url": "/docs/describe/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "SQL Commands",
+ "url": "/docs/sql-commands/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "DROP VIEW",
+ "next_url": "/docs/drop-view/",
+ "parent": "SQL Commands",
+ "previous_title": "DESCRIBE",
+ "previous_url": "/docs/describe/",
+ "relative_path": "_docs/sql-reference/sql-commands/055-drop-table.md",
+ "title": "DROP TABLE",
+ "url": "/docs/drop-table/"
},
{
"breadcrumbs": [
@@ -8015,11 +7997,11 @@
"next_title": "EXPLAIN",
"next_url": "/docs/explain/",
"parent": "SQL Commands",
- "previous_title": "DROP VIEW",
- "previous_url": "/docs/drop-view/",
- "relative_path": "_docs/sql-reference/sql-commands/060-describe.md",
- "title": "DESCRIBE",
- "url": "/docs/describe/"
+ "previous_title": "DROP TABLE",
+ "previous_url": "/docs/drop-table/",
+ "relative_path": "_docs/sql-reference/sql-commands/056-drop-view.md",
+ "title": "DROP VIEW",
+ "url": "/docs/drop-view/"
},
{
"breadcrumbs": [
@@ -8036,8 +8018,8 @@
"next_title": "SELECT",
"next_url": "/docs/select/",
"parent": "SQL Commands",
- "previous_title": "DESCRIBE",
- "previous_url": "/docs/describe/",
+ "previous_title": "DROP VIEW",
+ "previous_url": "/docs/drop-view/",
"relative_path": "_docs/sql-reference/sql-commands/070-explain.md",
"title": "EXPLAIN",
"url": "/docs/explain/"
@@ -8950,8 +8932,8 @@
}
],
"children": [],
- "next_title": "SQL Window Functions Examples",
- "next_url": "/docs/sql-window-functions-examples/",
+ "next_title": "Value Window Functions",
+ "next_url": "/docs/value-window-functions/",
"parent": "SQL Window Functions",
"previous_title": "Aggregate Window Functions",
"previous_url": "/docs/aggregate-window-functions/",
@@ -8971,11 +8953,32 @@
}
],
"children": [],
- "next_title": "Nested Data Functions",
- "next_url": "/docs/nested-data-functions/",
+ "next_title": "SQL Window Functions Examples",
+ "next_url": "/docs/sql-window-functions-examples/",
"parent": "SQL Window Functions",
"previous_title": "Ranking Window Functions",
"previous_url": "/docs/ranking-window-functions/",
+ "relative_path": "_docs/sql-reference/sql-window-functions/035-value-window-functions.md",
+ "title": "Value Window Functions",
+ "url": "/docs/value-window-functions/"
+ },
+ {
+ "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": "Value Window Functions",
+ "previous_url": "/docs/value-window-functions/",
"relative_path": "_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md",
"title": "SQL Window Functions Examples",
"url": "/docs/sql-window-functions-examples/"
@@ -9255,8 +9258,8 @@
}
],
"children": [],
- "next_title": "DROP VIEW",
- "next_url": "/docs/drop-view/",
+ "next_title": "DESCRIBE",
+ "next_url": "/docs/describe/",
"parent": "SQL Commands",
"previous_title": "PARTITION BY Clause",
"previous_url": "/docs/partition-by-clause/",
@@ -9276,14 +9279,35 @@
}
],
"children": [],
- "next_title": "DESCRIBE",
- "next_url": "/docs/describe/",
+ "next_title": "DROP TABLE",
+ "next_url": "/docs/drop-table/",
"parent": "SQL Commands",
"previous_title": "CREATE VIEW",
"previous_url": "/docs/create-view/",
- "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md",
- "title": "DROP VIEW",
- "url": "/docs/drop-view/"
+ "relative_path": "_docs/sql-reference/sql-commands/053-describe.md",
+ "title": "DESCRIBE",
+ "url": "/docs/describe/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "SQL Commands",
+ "url": "/docs/sql-commands/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "DROP VIEW",
+ "next_url": "/docs/drop-view/",
+ "parent": "SQL Commands",
+ "previous_title": "DESCRIBE",
+ "previous_url": "/docs/describe/",
+ "relative_path": "_docs/sql-reference/sql-commands/055-drop-table.md",
+ "title": "DROP TABLE",
+ "url": "/docs/drop-table/"
},
{
"breadcrumbs": [
@@ -9300,11 +9324,11 @@
"next_title": "EXPLAIN",
"next_url": "/docs/explain/",
"parent": "SQL Commands",
- "previous_title": "DROP VIEW",
- "previous_url": "/docs/drop-view/",
- "relative_path": "_docs/sql-reference/sql-commands/060-describe.md",
- "title": "DESCRIBE",
- "url": "/docs/describe/"
+ "previous_title": "DROP TABLE",
+ "previous_url": "/docs/drop-table/",
+ "relative_path": "_docs/sql-reference/sql-commands/056-drop-view.md",
+ "title": "DROP VIEW",
+ "url": "/docs/drop-view/"
},
{
"breadcrumbs": [
@@ -9321,8 +9345,8 @@
"next_title": "SELECT",
"next_url": "/docs/select/",
"parent": "SQL Commands",
- "previous_title": "DESCRIBE",
- "previous_url": "/docs/describe/",
+ "previous_title": "DROP VIEW",
+ "previous_url": "/docs/drop-view/",
"relative_path": "_docs/sql-reference/sql-commands/070-explain.md",
"title": "EXPLAIN",
"url": "/docs/explain/"
@@ -9814,8 +9838,8 @@
}
],
"children": [],
- "next_title": "SQL Window Functions Examples",
- "next_url": "/docs/sql-window-functions-examples/",
+ "next_title": "Value Window Functions",
+ "next_url": "/docs/value-window-functions/",
"parent": "SQL Window Functions",
"previous_title": "Aggregate Window Functions",
"previous_url": "/docs/aggregate-window-functions/",
@@ -9835,11 +9859,32 @@
}
],
"children": [],
- "next_title": "Nested Data Functions",
- "next_url": "/docs/nested-data-functions/",
+ "next_title": "SQL Window Functions Examples",
+ "next_url": "/docs/sql-window-functions-examples/",
"parent": "SQL Window Functions",
"previous_title": "Ranking Window Functions",
"previous_url": "/docs/ranking-window-functions/",
+ "relative_path": "_docs/sql-reference/sql-window-functions/035-value-window-functions.md",
+ "title": "Value Window Functions",
+ "url": "/docs/value-window-functions/"
+ },
+ {
+ "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": "Value Window Functions",
+ "previous_url": "/docs/value-window-functions/",
"relative_path": "_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md",
"title": "SQL Window Functions Examples",
"url": "/docs/sql-window-functions-examples/"
@@ -9869,8 +9914,8 @@
"next_title": "Nested Data Functions",
"next_url": "/docs/nested-data-functions/",
"parent": "SQL Window Functions",
- "previous_title": "Ranking Window Functions",
- "previous_url": "/docs/ranking-window-functions/",
+ "previous_title": "Value Window Functions",
+ "previous_url": "/docs/value-window-functions/",
"relative_path": "_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md",
"title": "SQL Window Functions Examples",
"url": "/docs/sql-window-functions-examples/"
@@ -9962,8 +10007,8 @@
}
],
"children": [],
- "next_title": "Archived Pages",
- "next_url": "/docs/archived-pages/",
+ "next_title": "Project Bylaws",
+ "next_url": "/docs/project-bylaws/",
"parent": "Sample Datasets",
"previous_title": "Enron Emails",
"previous_url": "/docs/enron-emails/",
@@ -10098,8 +10143,8 @@
}
],
"children": [],
- "next_title": "Configure Drill",
- "next_url": "/docs/configure-drill/",
+ "next_title": "Starting the Web UI",
+ "next_url": "/docs/starting-the-web-ui/",
"parent": "Installing Drill in Distributed Mode",
"previous_title": "Installing Drill on the Cluster",
"previous_url": "/docs/installing-drill-on-the-cluster/",
@@ -10149,6 +10194,23 @@
"title": "Starting Drill on Windows",
"url": "/docs/starting-drill-on-windows/"
},
+ "Starting the Web UI": {
+ "breadcrumbs": [
+ {
+ "title": "Install Drill",
+ "url": "/docs/install-drill/"
+ }
+ ],
+ "children": [],
+ "next_title": "Configure Drill",
+ "next_url": "/docs/configure-drill/",
+ "parent": "Install Drill",
+ "previous_title": "Starting Drill in Distributed Mode",
+ "previous_url": "/docs/starting-drill-in-distributed-mode/",
+ "relative_path": "_docs/install/060-starting-the-web-ui.md",
+ "title": "Starting the Web UI",
+ "url": "/docs/starting-the-web-ui/"
+ },
"Storage Plugin Configuration": {
"breadcrumbs": [
{
@@ -11290,6 +11352,27 @@
"title": "Value Vectors",
"url": "/docs/value-vectors/"
},
+ "Value Window Functions": {
+ "breadcrumbs": [
+ {
+ "title": "SQL Window Functions",
+ "url": "/docs/sql-window-functions/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "SQL Window Functions Examples",
+ "next_url": "/docs/sql-window-functions-examples/",
+ "parent": "SQL Window Functions",
+ "previous_title": "Ranking Window Functions",
+ "previous_url": "/docs/ranking-window-functions/",
+ "relative_path": "_docs/sql-reference/sql-window-functions/035-value-window-functions.md",
+ "title": "Value Window Functions",
+ "url": "/docs/value-window-functions/"
+ },
"WHERE Clause": {
"breadcrumbs": [
{
@@ -11332,23 +11415,6 @@
"title": "WITH Clause",
"url": "/docs/with-clause/"
},
- "What is Apache Drill": {
- "breadcrumbs": [
- {
- "title": "Archived Pages",
- "url": "/docs/archived-pages/"
- }
- ],
- "children": [],
- "next_title": "Progress Reports",
- "next_url": "/docs/progress-reports/",
- "parent": "Archived Pages",
- "previous_title": "How to Run the Drill Demo",
- "previous_url": "/docs/how-to-run-the-drill-demo/",
- "relative_path": "_docs/archived-pages/020-what-is-apache-drill.md",
- "title": "What is Apache Drill",
- "url": "/docs/what-is-apache-drill/"
- },
"Why Drill": {
"breadcrumbs": [
{
@@ -11374,8 +11440,8 @@
}
],
"children": [],
- "next_title": "Archived Pages",
- "next_url": "/docs/archived-pages/",
+ "next_title": "Project Bylaws",
+ "next_url": "/docs/project-bylaws/",
"parent": "Sample Datasets",
"previous_title": "Enron Emails",
"previous_url": "/docs/enron-emails/",
@@ -12002,8 +12068,8 @@
}
],
"children": [],
- "next_title": "Configure Drill",
- "next_url": "/docs/configure-drill/",
+ "next_title": "Starting the Web UI",
+ "next_url": "/docs/starting-the-web-ui/",
"parent": "Installing Drill in Distributed Mode",
"previous_title": "Installing Drill on the Cluster",
"previous_url": "/docs/installing-drill-on-the-cluster/",
@@ -12020,6 +12086,23 @@
"relative_path": "_docs/install/040-installing-drill-in-distributed-mode.md",
"title": "Installing Drill in Distributed Mode",
"url": "/docs/installing-drill-in-distributed-mode/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Install Drill",
+ "url": "/docs/install-drill/"
+ }
+ ],
+ "children": [],
+ "next_title": "Configure Drill",
+ "next_url": "/docs/configure-drill/",
+ "parent": "Install Drill",
+ "previous_title": "Starting Drill in Distributed Mode",
+ "previous_url": "/docs/starting-drill-in-distributed-mode/",
+ "relative_path": "_docs/install/060-starting-the-web-ui.md",
+ "title": "Starting the Web UI",
+ "url": "/docs/starting-the-web-ui/"
}
],
"next_title": "Install Drill Introduction",
@@ -12191,8 +12274,8 @@
}
],
"children": [],
- "next_title": "Configuration Options",
- "next_url": "/docs/configuration-options/",
+ "next_title": "Configuring Web UI and REST API Security",
+ "next_url": "/docs/configuring-web-ui-and-rest-api-security/",
"parent": "Configure Drill",
"previous_title": "Configuring User Authentication",
"previous_url": "/docs/configuring-user-authentication/",
@@ -12207,6 +12290,23 @@
"url": "/docs/configure-drill/"
}
],
+ "children": [],
+ "next_title": "Configuration Options",
+ "next_url": "/docs/configuration-options/",
+ "parent": "Configure Drill",
+ "previous_title": "Configuring User Impersonation with Hive Authorization",
+ "previous_url": "/docs/configuring-user-impersonation-with-hive-authorization/",
+ "relative_path": "_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md",
+ "title": "Configuring Web UI and REST API Security",
+ "url": "/docs/configuring-web-ui-and-rest-api-security/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "Configure Drill",
+ "url": "/docs/configure-drill/"
+ }
+ ],
"children": [
{
"breadcrumbs": [
@@ -12296,8 +12396,8 @@
"next_title": "Configuration Options Introduction",
"next_url": "/docs/configuration-options-introduction/",
"parent": "Configure Drill",
- "previous_title": "Configuring User Impersonation with Hive Authorization",
- "previous_url": "/docs/configuring-user-impersonation-with-hive-authorization/",
+ "previous_title": "Configuring Web UI and REST API Security",
+ "previous_url": "/docs/configuring-web-ui-and-rest-api-security/",
"relative_path": "_docs/configure-drill/080-configuration-options.md",
"title": "Configuration Options",
"url": "/docs/configuration-options/"
@@ -12340,8 +12440,8 @@
"next_title": "Configure Drill Introduction",
"next_url": "/docs/configure-drill-introduction/",
"parent": "",
- "previous_title": "Starting Drill in Distributed Mode",
- "previous_url": "/docs/starting-drill-in-distributed-mode/",
+ "previous_title": "Starting the Web UI",
+ "previous_url": "/docs/starting-the-web-ui/",
"relative_path": "_docs/045-configure-drill.md",
"title": "Configure Drill",
"url": "/docs/configure-drill/"
@@ -14318,8 +14418,8 @@
}
],
"children": [],
- "next_title": "SQL Window Functions Examples",
- "next_url": "/docs/sql-window-functions-examples/",
+ "next_title": "Value Window Functions",
+ "next_url": "/docs/value-window-functions/",
"parent": "SQL Window Functions",
"previous_title": "Aggregate Window Functions",
"previous_url": "/docs/aggregate-window-functions/",
@@ -14339,11 +14439,32 @@
}
],
"children": [],
- "next_title": "Nested Data Functions",
- "next_url": "/docs/nested-data-functions/",
+ "next_title": "SQL Window Functions Examples",
+ "next_url": "/docs/sql-window-functions-examples/",
"parent": "SQL Window Functions",
"previous_title": "Ranking Window Functions",
"previous_url": "/docs/ranking-window-functions/",
+ "relative_path": "_docs/sql-reference/sql-window-functions/035-value-window-functions.md",
+ "title": "Value Window Functions",
+ "url": "/docs/value-window-functions/"
+ },
+ {
+ "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": "Value Window Functions",
+ "previous_url": "/docs/value-window-functions/",
"relative_path": "_docs/sql-reference/sql-window-functions/040-sql-window-functions-examples.md",
"title": "SQL Window Functions Examples",
"url": "/docs/sql-window-functions-examples/"
@@ -14623,8 +14744,8 @@
}
],
"children": [],
- "next_title": "DROP VIEW",
- "next_url": "/docs/drop-view/",
+ "next_title": "DESCRIBE",
+ "next_url": "/docs/describe/",
"parent": "SQL Commands",
"previous_title": "PARTITION BY Clause",
"previous_url": "/docs/partition-by-clause/",
@@ -14644,14 +14765,35 @@
}
],
"children": [],
- "next_title": "DESCRIBE",
- "next_url": "/docs/describe/",
+ "next_title": "DROP TABLE",
+ "next_url": "/docs/drop-table/",
"parent": "SQL Commands",
"previous_title": "CREATE VIEW",
"previous_url": "/docs/create-view/",
- "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md",
- "title": "DROP VIEW",
- "url": "/docs/drop-view/"
+ "relative_path": "_docs/sql-reference/sql-commands/053-describe.md",
+ "title": "DESCRIBE",
+ "url": "/docs/describe/"
+ },
+ {
+ "breadcrumbs": [
+ {
+ "title": "SQL Commands",
+ "url": "/docs/sql-commands/"
+ },
+ {
+ "title": "SQL Reference",
+ "url": "/docs/sql-reference/"
+ }
+ ],
+ "children": [],
+ "next_title": "DROP VIEW",
+ "next_url": "/docs/drop-view/",
+ "parent": "SQL Commands",
+ "previous_title": "DESCRIBE",
+ "previous_url": "/docs/describe/",
+ "relative_path": "_docs/sql-reference/sql-commands/055-drop-table.md",
+ "title": "DROP TABLE",
+ "url": "/docs/drop-table/"
},
{
"breadcrumbs": [
@@ -14668,11 +14810,11 @@
"next_title": "EXPLAIN",
"next_url": "/docs/explain/",
"parent": "SQL Commands",
- "previous_title": "DROP VIEW",
- "previous_url": "/docs/drop-view/",
- "relative_path": "_docs/sql-reference/sql-commands/060-describe.md",
- "title": "DESCRIBE",
- "url": "/docs/describe/"
+ "previous_title": "DROP TABLE",
+ "previous_url": "/docs/drop-table/",
+ "relative_path": "_docs/sql-reference/sql-commands/056-drop-view.md",
+ "title": "DROP VIEW",
+ "url": "/docs/drop-view/"
},
{
"breadcrumbs": [
@@ -14689,8 +14831,8 @@
"next_title": "SELECT",
"next_url": "/docs/select/",
"parent": "SQL Commands",
- "previous_title": "DESCRIBE",
- "previous_url": "/docs/describe/",
+ "previous_title": "DROP VIEW",
+ "previous_url": "/docs/drop-view/",
"relative_path": "_docs/sql-reference/sql-commands/070-explain.md",
"title": "EXPLAIN",
"url": "/docs/explain/"
@@ -15846,8 +15988,8 @@
}
],
"children": [],
- "next_title": "Archived Pages",
- "next_url": "/docs/archived-pages/",
+ "next_title": "Project Bylaws",
+ "next_url": "/docs/project-bylaws/",
"parent": "Sample Datasets",
"previous_title": "Enron Emails",
"previous_url": "/docs/enron-emails/",
@@ -15867,89 +16009,12 @@
},
{
"breadcrumbs": [],
- "children": [
- {
- "breadcrumbs": [
- {
- "title": "Archived Pages",
- "url": "/docs/archived-pages/"
- }
- ],
- "children": [],
- "next_title": "What is Apache Drill",
- "next_url": "/docs/what-is-apache-drill/",
- "parent": "Archived Pages",
- "previous_title": "Archived Pages",
- "previous_url": "/docs/archived-pages/",
- "relative_path": "_docs/archived-pages/010-how-to-run-the-drill-demo.md",
- "title": "How to Run the Drill Demo",
- "url": "/docs/how-to-run-the-drill-demo/"
- },
- {
- "breadcrumbs": [
- {
- "title": "Archived Pages",
- "url": "/docs/archived-pages/"
- }
- ],
- "children": [],
- "next_title": "Progress Reports",
- "next_url": "/docs/progress-reports/",
- "parent": "Archived Pages",
- "previous_title": "How to Run the Drill Demo",
- "previous_url": "/docs/how-to-run-the-drill-demo/",
- "relative_path": "_docs/archived-pages/020-what-is-apache-drill.md",
- "title": "What is Apache Drill",
- "url": "/docs/what-is-apache-drill/"
- }
- ],
- "next_title": "How to Run the Drill Demo",
- "next_url": "/docs/how-to-run-the-drill-demo/",
- "parent": "",
- "previous_title": "Wikipedia Edit History",
- "previous_url": "/docs/wikipedia-edit-history/",
- "relative_path": "_docs/150-archived-pages.md",
- "title": "Archived Pages",
- "url": "/docs/archived-pages/"
- },
- {
- "breadcrumbs": [],
- "children": [
- {
- "breadcrumbs": [
- {
- "title": "Progress Reports",
- "url": "/docs/progress-reports/"
- }
- ],
- "children": [],
- "next_title": "Project Bylaws",
- "next_url": "/docs/project-bylaws/",
- "parent": "Progress Reports",
- "previous_title": "Progress Reports",
- "previous_url": "/docs/progress-reports/",
- "relative_path": "_docs/progress-reports/001-2014-q1.md",
- "title": "2014 Q1 Drill Report",
- "url": "/docs/2014-q1-drill-report/"
- }
- ],
- "next_title": "2014 Q1 Drill Report",
- "next_url": "/docs/2014-q1-drill-report/",
- "parent": "",
- "previous_title": "What is Apache Drill",
- "previous_url": "/docs/what-is-apache-drill/",
- "relative_path": "_docs/160-progress-reports.md",
- "title": "Progress Reports",
- "url": "/docs/progress-reports/"
- },
- {
- "breadcrumbs": [],
"children": [],
"next_title": "",
"next_url": "",
"parent": "",
- "previous_title": "2014 Q1 Drill Report",
- "previous_url": "/docs/2014-q1-drill-report/",
+ "previous_title": "Wikipedia Edit History",
+ "previous_url": "/docs/wikipedia-edit-history/",
"relative_path": "_docs/170-bylaws.md",
"title": "Project Bylaws",
"url": "/docs/project-bylaws/"
http://git-wip-us.apache.org/repos/asf/drill/blob/43d6dd1d/_docs/150-archived-pages.md
----------------------------------------------------------------------
diff --git a/_docs/150-archived-pages.md b/_docs/150-archived-pages.md
deleted file mode 100644
index aa61eeb..0000000
--- a/_docs/150-archived-pages.md
+++ /dev/null
@@ -1,3 +0,0 @@
----
-title: "Archived Pages"
----
http://git-wip-us.apache.org/repos/asf/drill/blob/43d6dd1d/_docs/160-progress-reports.md
----------------------------------------------------------------------
diff --git a/_docs/160-progress-reports.md b/_docs/160-progress-reports.md
deleted file mode 100644
index 0aee81a..0000000
--- a/_docs/160-progress-reports.md
+++ /dev/null
@@ -1,4 +0,0 @@
----
-title: "Progress Reports"
----
-
http://git-wip-us.apache.org/repos/asf/drill/blob/43d6dd1d/_docs/archived-pages/010-how-to-run-the-drill-demo.md
----------------------------------------------------------------------
diff --git a/_docs/archived-pages/010-how-to-run-the-drill-demo.md b/_docs/archived-pages/010-how-to-run-the-drill-demo.md
deleted file mode 100644
index d24e86a..0000000
--- a/_docs/archived-pages/010-how-to-run-the-drill-demo.md
+++ /dev/null
@@ -1,308 +0,0 @@
----
-title: "How to Run the Drill Demo"
-parent: "Archived Pages"
----
-This section describes how to get started by running the Drill demo.
-
-## Pre-requisites
-
- * Maven 2 or higher
-
- On Ubuntu, you can do this as root:
-
- apt-get install maven2
-
- On the Mac, maven is pre-installed.
-
- Note that installing maven can result in installing java 1.6 and setting that
-to your default version. Make sure you check java version before compiling or
-running.
-
- * Java 1.7
-
- You will need java 1.7 to compile and run the Drill demo.
-
- On Ubuntu you can get the right version of Java by doing this as root:
-
- apt-get install openjdk-7-jdk
- sudo update-alternatives --set java $(update-alternatives --list java | grep 7 | head -1)
-
- On a Mac, go to [Oracle's web-
-site](http://www.oracle.com/technetwork/java/javase/downloads/java-se-
-jdk-7-download-432154.html) to download and install java 7. You will also need
-to set JAVA_HOME in order to use the right version of java.
-
- Drill will not compile correctly using java 6. There is also a subtle problem
-that can occur if you have both
-java 6 and java 7 with the default version set to 6. In that case, you may be
-able to compile, but execution may not work correctly.
-
- Send email to the dev list if this is a problem for you.
-
- * Protobuf
-
- Drill requires Protobuf 2.5. Install this on Ubuntu using:
-
- apt-get install protobuf-compiler
-
- On Centos 6.4, OEL or RHEL you will need to compile protobuf-compiler:
-
- wget http://protobuf.googlecode.com/files/protobuf-2.5.0.tar.bz2
- tar xfj protobuf-2.5.0.tar.bz2
- pushd protobuf-2.5.0
- ./configure
- make
- sudo make install
-
- * git
-
- On Ubuntu you can install git by doing this as root:
-
- apt-get install git-all
-
-On the Mac or Windows, go to [this site](http://git-scm.com/downloads) to
-download and install git.
-
-## Check your installation versions
-
-Run
-
- java -version
- mvn -version
-
-Verify that your default java and maven versions are correct, and that maven
-runs the right version of java. On my Mac, you see something like this:
-
- ted:apache-drill-1.0.0-m1$ java -version
- java version "1.7.0_11"
- Java(TM) SE Runtime Environment (build 1.7.0_11-b21)
- Java HotSpot(TM) 64-Bit Server VM (build 23.6-b04, mixed mode)
- ted:apache-drill-1.0.0-m1$ mvn -version
- Apache Maven 3.0.3 (r1075438; 2011-02-28 09:31:09-0800)
- Maven home: /usr/share/maven
- Java version: 1.7.0_11, vendor: Oracle Corporation
- Java home: /Library/Java/JavaVirtualMachines/jdk1.7.0_11.jdk/Contents/Home/jre
- Default locale: en_US, platform encoding: UTF-8
- OS name: "mac os x", version: "10.7.5", arch: "x86_64", family: "mac"
- ted:apache-drill-1.0.0-m1$
-
-## Get the Source
-
- git clone https://git-wip-us.apache.org/repos/asf/incubator-drill.git
-
-## Compile the Code
-
- cd incubator-drill/sandbox/prototype
- mvn clean install -DskipTests
- rm .classpath
-
-This takes about a minute on a not-terribly-current MacBook.
-
-## Run the interactive Drill shell
-
- ./sqlline -u jdbc:drill:schema=parquet-local -n admin -p admin
-
-The first time you run this program, you will get reams of output. What is
-happening is that the program is running maven in order to build a
-(voluminous) class path for the actual program and stores this classpath into
-the file called `.classpath`. When you run this program again, it will note
-that this file already exists and avoid re-creating it. You should delete this
-file every time the dependencies of Drill are changed. If you start getting
-"class not found" errors, that is a good hint that `.classpath` is out of date
-and needs to be deleted and recreated.
-
-The `-u` argument to [sqlline](https://github.com/julianhyde/sqlline) is a
-JDBC connection string that directs sqlline to connect to drill. The Drill
-JDBC driver currently includes enough smarts to run Drill in embedded mode so
-this command also effectively starts a local drill bit. The `schema=` part of
-the JDBC connection string causes Drill to consider the "parquet-local"
-storage engine to be default. Other storage engines can be specified. The list
-of supported storage engines can be found in the file
-`./sqlparser/src/main/resources/storage-engines.json`. Each storage engine
-specifies the format of the data and how to get the data. See the section
-below on "Storage Engines" for more detail.
-
-When you run sqlline, you should see something like this after quite a lot of
-log messages:
-
- Connected to: Drill (version 1.0)
- Driver: Apache Drill JDBC Driver (version 1.0)
- Autocommit status: true
- Transaction isolation: TRANSACTION_REPEATABLE_READ
- sqlline version ??? by Marc Prud'hommeaux
- 0: jdbc:drill:schema=parquet-local>
-
-**Tip:** To quit sqlline at any time, type "!quit" at the prompt.
-
- 0: jdbc:drill:schema=parquet-local> !quit
-
-## Run a Query
-
-Once you have sqlline running you can now try out some queries:
-
- select * from "sample-data/region.parquet";
-
-You should see a number of debug messages and then something like this:
-
- +--------------------------------------------------------------------------------------------------------------------------------------------+
- | _MAP |
- +--------------------------------------------------------------------------------------------------------------------------------------------+
- | {"R_REGIONKEY":0,"R_NAME":"AFRICA","R_COMMENT":"lar deposits. blithely final packages cajole. regular waters are final requests. regular a |
- | {"R_REGIONKEY":1,"R_NAME":"AMERICA","R_COMMENT":"hs use ironic, even requests. s"} |
- | {"R_REGIONKEY":2,"R_NAME":"ASIA","R_COMMENT":"ges. thinly even pinto beans ca"} |
- | {"R_REGIONKEY":3,"R_NAME":"EUROPE","R_COMMENT":"ly final courts cajole furiously final excuse"} |
- | {"R_REGIONKEY":4,"R_NAME":"MIDDLE EAST","R_COMMENT":"uickly special accounts cajole carefully blithely close requests. carefully final asy |
- +--------------------------------------------------------------------------------------------------------------------------------------------+
- 5 rows selected (1.103 seconds)
-
-Drill has no idea what the structure of this
-file is in terms of what fields exist, but Drill does know that every record
-has a pseudo-field called `_MAP`. This field contains a map of all of the
-actual fields to values. When returned via JDBC, this fields is rendered as
-JSON since JDBC doesn't really understand maps.
-
-This can be made more readable by using a query like this:
-
- select _MAP['R_REGIONKEY'] as region_key, _MAP['R_NAME'] as name, _MAP['R_COMMENT'] as comment
- from "sample-data/region.parquet";
-
-The output will look something like this:
-
- +-------------+--------------+---------------------------------------------------------------------------------------------------------------+
- | REGION_KEY | NAME | COMMENT |
- +-------------+--------------+---------------------------------------------------------------------------------------------------------------+
- | 0 | AFRICA | lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are accordi |
- | 1 | AMERICA | hs use ironic, even requests. s |
- | 2 | ASIA | ges. thinly even pinto beans ca |
- | 3 | EUROPE | ly final courts cajole furiously final excuse |
- | 4 | MIDDLE EAST | uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl |
- +-------------+--------------+---------------------------------------------------------------------------------------------------------------+
-
-In upcoming versions, Drill will insert the `_MAP[ ... ]` goo and will also
-unwrap the contents of `_MAP` in results so that things seem much more like
-ordinary SQL. The reason that things work this way now is that SQL itself
-requires considerable type information for queries to be parsed and that
-information doesn't necessarily exist for all kinds of files, especially those
-with very flexible schemas. To avoid all these problems, Drill adopts the
-convention of the _MAP fields for all kinds of input.
-
-## A Note Before You Continue
-
-Drill currently supports a wide variety of queries. It currently also has a
-fair number of deficiencies in terms of the number of operators that are
-actually supported and exactly which expressions are passed through to the
-execution engine in the correct form for execution.
-
-These problems fall into roughly three categories,
-
- * missing operators. Many operators have been implemented for only a subset of the types available in Drill. This will cause queries to work for some types of data, but not for others. This is particularly true for operators with many possible type signatures such as comparisons. This lack is being remedied at a fast pace so check back in frequently if you suspect this might be a problem.
-
- Missing operators will result in error messages like this:
-
- `UnsupportedOperationException:[ Missing function implementation: compare_to
-(BIT-OPTIONAL, BIT-OPTIONAL) ]`
-
- * missing casts. The SQL parser currently has trouble producing a valid logical plan without sufficient type information. Ironically, this type information is often not necessary to the execution engine because Drill generates the code on the fly based on the types of the data it encounters as data are processed. Currently, the work-around is to cast fields in certain situations to give the parser enough information to proceed. This problem will be remedied soon, but probably not quite as quickly as the missing operators.
-
- The typical error message that indicates you need an additional cast looks
-like
-
- `Cannot apply '>' to arguments of type '<ANY> > <CHAR(1)>'. Supported
-form(s): '<COMPARABLE_TYPE> > <COMPARABLE_TYPE>'`
-
- * weak optimizer. The current optimizer that transforms the logical plan into a physical plan is not the fully-featured cost based optimizer that Optiq normally uses. This is because some of the transformations that are needed for Drill are not yet fully supported by Optiq. In order to allow end-to-end execution of queries, a deterministic peep-hole optimizer has been used instead. This optimizer cannot handle large plan transformations and so some queries cannot be transformed correctly from logical to physical plan. We expect that the necessary changes to the cost-based optimizer will allow it to be used in an upcoming release, but didn't want to delay the current release waiting for that to happen.
-
-## Try Fancier Queries
-
-This query does a join between two files:
-
- SELECT nations.name, regions.name FROM (
- SELECT _MAP['N_REGIONKEY'] as regionKey, _MAP['N_NAME'] as name
- FROM "sample-data/nation.parquet") nations
- join (
- SELECT _MAP['R_REGIONKEY'] as regionKey, _MAP['R_NAME'] as name
- FROM "sample-data/region.parquet") regions
- on nations.regionKey = regions.regionKey
- order by nations.name;
-
-Notice the use of sub-queries to avoid the spread of the `_MAP` idiom.
-
-This query illustrates how a cast is currently necessary to make the parser
-happy:
-
- SELECT
- _MAP['N_REGIONKEY'] as regionKey,
- _MAP['N_NAME'] as name
- FROM
- "sample-data/nation.parquet"
- WHERE
- cast(_MAP['N_NAME'] as varchar) IN ('MOROCCO', 'MOZAMBIQUE');
-
-Here are more queries that you can try.
-
- // count distinct
- SELECT count(distinct _MAP['N_REGIONKEY']) FROM "sample-data/nation.parquet";
-
- // aliases
- SELECT
- _MAP['N_REGIONKEY'] as regionKey,
- _MAP['N_NAME'] as name
- FROM "sample-data/nation.parquet";
-
- // order by
- SELECT
- _MAP['N_REGIONKEY'] as regionKey,
- _MAP['N_NAME'] as name
- FROM
- "sample-data/nation.parquet"
- ORDER BY
- _MAP['N_NAME'] DESC;
-
- // subquery order by
- select * from (
- SELECT
- _MAP['N_REGIONKEY'] as regionKey,
- _MAP['N_NAME'] as name
- FROM
- "sample-data/nation.parquet"
- ) as x
- ORDER BY
- name DESC;
-
- // String where
- SELECT
- _MAP['N_REGIONKEY'] as regionKey,
- _MAP['N_NAME'] as name
- FROM
- "sample-data/nation.parquet"
- WHERE
- cast(_MAP['N_NAME'] as varchar) > 'M';
-
- // INNER Join + Order (parquet)
- SELECT n.name, r.name FROM
- (SELECT _MAP['N_REGIONKEY'] as regionKey, _MAP['N_NAME'] as name FROM "sample-data/nation.parquet")n
- join (SELECT _MAP['R_REGIONKEY'] as regionKey, _MAP['R_NAME'] as name FROM "sample-data/region.parquet")r
- using (regionKey);
-
- // INNER Join + Order (parquet)
- SELECT n.name, r.name FROM
- (SELECT _MAP['N_REGIONKEY'] as regionKey, _MAP['N_NAME'] as name FROM "sample-data/nation.parquet")n
- join (SELECT _MAP['R_REGIONKEY'] as regionKey, _MAP['R_NAME'] as name FROM "sample-data/region.parquet")r
- on n.regionKey = r.regionKey
- order by n.name;
-
-## Analyze the Execution of Queries
-
-Drill sends log events to a logback socket appender. This makes it easy to
-catch and filter these log events using a tool called Lilith. You can download
-[Lilith](http://www.huxhorn.de/) and install it easily. A tutorial can be
-[found here](http://ekkescorner.wordpress.com/2009/09/05/osgi-logging-part-8
--viewing-log-events-lilith/). This is especially important if you find errors
-that you want to report back to the mailing list since Lilith will help you
-isolate the stack trace of interest.
-
-By default, Lilith uses a slightly lurid splash page based on a pre-Raphaelite
-image of the mythical Lilith. This is easily disabled if the image is not to
-your taste (or if your work-mates are not well-versed in Victorian views of
-Sumerian mythology).
-
http://git-wip-us.apache.org/repos/asf/drill/blob/43d6dd1d/_docs/archived-pages/020-what-is-apache-drill.md
----------------------------------------------------------------------
diff --git a/_docs/archived-pages/020-what-is-apache-drill.md b/_docs/archived-pages/020-what-is-apache-drill.md
deleted file mode 100644
index aa9556b..0000000
--- a/_docs/archived-pages/020-what-is-apache-drill.md
+++ /dev/null
@@ -1,41 +0,0 @@
----
-title: "What is Apache Drill"
-parent: "Archived Pages"
----
-## What is Apache Drill
-
-Apache Drill by Apache Foundation is the first open source implementation of
-the Google's Dremel paper for interactive query processing. Apache Drill
-provides low latency ad-hoc queries to many different data sources & nested
-data. Drill is designed to scale to 10,000 servers and query petabytes of data
-in seconds.
-
-
-
-In a nutshell, Few key points about Apache Drill are:
-
- * Inspired by Google's Dremel
- * Supports standard SQL 2003
- * Supports plug-able data sources (HBase, Mongo, HDFS etc)
- * Supports nested data (JSON, ProtoBufs, Parquet etc)
- * Supports optional schema
- * Community driven
-
-## Where Apache Drill fits in
-
-Apache Drill is designed as an answer to the Interactive queries problems that
-we face while dealing with huge data. A standard Drill Query might take 100ms
-- 3 minutes for its execution as compared to Apache Hadoop or HIVE/PIG. Below
-is a diagram to help you relate in terms of the execution times:
-
-
-
-## Drill is powerful
-
-Below are few things that make Apache Drill really powerful:
-
- * **Speed**: Apache Drill uses an efficient columnar storage format, an optimistic execution engine and a cache-conscious memory layout. Coordination, query planning, optimization, scheduling, and execution are all distributed throughout nodes in a system to maximize parallelization. Apache Drill is blazing fast. Period.
- * **Plug-able data sources**: Apache drill brings in the support of pluggable data sources like HBase, Mongo, HDFS etc. It means that Drill will still work comfortably while your data is exploring new data stores.
- * **Nested data**: With the support for data sources like HBase, Cassandra, MongoDB etc, Drill allows interactive analysis on all of your data, including nested and schema-less forms. Drill also supports querying against nested data formats like JSON and Parquet.
- * **Flexibility**: Apache Dril strongly defined tiers and APIs for straightforward integration with a wide array of technologies.
-