Repository: drill Updated Branches: refs/heads/gh-pages 64a7d5f8e -> 2856ae488
DRILL-2324 Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/2856ae48 Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/2856ae48 Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/2856ae48 Branch: refs/heads/gh-pages Commit: 2856ae488e691478b944c8b4a5e89c2e948d7727 Parents: 64a7d5f Author: Kristine Hahn <kh...@maprtech.com> Authored: Thu Feb 26 17:19:12 2015 -0800 Committer: Bridget Bevens <bbev...@maprtech.com> Committed: Thu Feb 26 17:52:37 2015 -0800 ---------------------------------------------------------------------- _docs/001-arch.md | 6 +++--- _docs/002-tutorial.md | 16 ++++++++-------- _docs/003-yelp.md | 10 +++++----- _docs/006-interfaces.md | 12 ++++++------ _docs/012-rn.md | 2 +- _docs/013-contribute.md | 4 ++-- _docs/014-sample-ds.md | 6 +++--- _docs/015-design.md | 10 +++++----- _docs/016-progress.md | 2 +- _docs/arch/arch-hilite/001-flexibility.md | 2 +- _docs/connect/005-reg-hive.md | 2 +- _docs/connect/006-default-frmt.md | 2 +- _docs/connect/007-mongo-plugin.md | 6 +++--- _docs/contribute/001-guidelines.md | 2 +- _docs/dev-custom-fcn/001-dev-simple.md | 2 +- _docs/dev-custom-fcn/002-dev-aggregate.md | 2 +- _docs/develop/001-compile.md | 6 +++--- _docs/develop/003-patch-tool.md | 4 ++-- _docs/install/001-drill-in-10.md | 20 ++++++++++---------- _docs/install/002-deploy.md | 4 ++-- _docs/install/004-install-distributed.md | 2 +- .../install-embedded/001-install-linux.md | 2 +- .../install/install-embedded/002-install-mac.md | 2 +- .../install/install-embedded/003-install-win.md | 2 +- _docs/interfaces/001-odbc-win.md | 8 ++++---- _docs/interfaces/003-jdbc-squirrel.md | 2 +- .../odbc-linux/001-install-odbc-linux.md | 4 ++-- .../odbc-linux/002-install-odbc-mac.md | 4 ++-- .../odbc-linux/003-odbc-connections-linux.md | 6 +++--- .../odbc-linux/005-odbc-connect-str.md | 2 +- .../interfaces/odbc-win/001-install-odbc-win.md | 2 +- _docs/interfaces/odbc-win/002-conf-odbc-win.md | 8 ++++---- .../interfaces/odbc-win/003-connect-odbc-win.md | 4 ++-- .../interfaces/odbc-win/004-tableau-examples.md | 4 ++-- _docs/manage/conf/001-mem-alloc.md | 2 +- _docs/manage/conf/002-startup-opt.md | 2 +- _docs/manage/conf/004-persist-conf.md | 2 +- _docs/query/001-query-fs.md | 2 +- _docs/query/002-query-hbase.md | 2 +- _docs/query/004-query-hive.md | 2 +- _docs/query/006-query-sys-tbl.md | 4 ++-- _docs/query/query-fs/002-query-parquet.md | 2 +- _docs/rn/004-0.6.0-rn.md | 2 +- _docs/sql-ref/001-data-types.md | 2 +- _docs/sql-ref/002-operators.md | 2 +- _docs/sql-ref/003-functions.md | 6 +++--- _docs/sql-ref/004-nest-functions.md | 6 +++--- _docs/sql-ref/005-cmd-summary.md | 2 +- _docs/sql-ref/nested/001-flatten.md | 2 +- _docs/sql-ref/nested/002-kvgen.md | 6 +++--- _docs/sql-ref/nested/003-repeated-cnt.md | 2 +- _docs/tutorial/002-get2kno-sb.md | 8 ++++---- _docs/tutorial/003-lesson1.md | 2 +- _docs/tutorial/004-lesson2.md | 2 +- _docs/tutorial/005-lesson3.md | 2 +- _docs/tutorial/006-summary.md | 2 +- .../install-sandbox/001-install-mapr-vm.md | 2 +- .../install-sandbox/002-install-mapr-vb.md | 2 +- 58 files changed, 120 insertions(+), 120 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/001-arch.md ---------------------------------------------------------------------- diff --git a/_docs/001-arch.md b/_docs/001-arch.md index 0905ad3..8779a11 100644 --- a/_docs/001-arch.md +++ b/_docs/001-arch.md @@ -43,7 +43,7 @@ The flow of a Drill query typically involves the following steps: You can access Drill through the following interfaces: - * [Drill shell (SQLLine)](/drill/docs/starting-stopping-drill) - * [Drill Web UI](/drill/docs/monitoring-and-canceling-queries-in-the-drill-web-ui) - * [ODBC/JDBC](/drill/docs/odbc-jdbc-interfaces/#using-odbc-to-access-apache-drill-from-bi-tools) + * [Drill shell (SQLLine)](/docs/starting-stopping-drill) + * [Drill Web UI](/docs/monitoring-and-canceling-queries-in-the-drill-web-ui) + * [ODBC/JDBC](/docs/odbc-jdbc-interfaces/#using-odbc-to-access-apache-drill-from-bi-tools) * C++ API \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/002-tutorial.md ---------------------------------------------------------------------- diff --git a/_docs/002-tutorial.md b/_docs/002-tutorial.md index 14cae80..9f69b71 100644 --- a/_docs/002-tutorial.md +++ b/_docs/002-tutorial.md @@ -7,12 +7,12 @@ configured with Apache Drill. To complete the tutorial on the MapR Sandbox with Apache Drill, work through the following pages in order: - * [Installing the Apache Drill Sandbox](/drill/docs/installing-the-apache-drill-sandbox) - * [Getting to Know the Drill Setup](/drill/docs/getting-to-know-the-drill-sandbox) - * [Lesson 1: Learn About the Data Set](/drill/docs/lession-1-learn-about-the-data-set) - * [Lesson 2: Run Queries with ANSI SQL](/drill/docs/lession-2-run-queries-with-ansi-sql) - * [Lesson 3: Run Queries on Complex Data Types](/drill/docs/lession-3-run-queries-on-complex-data-types) - * [Summary](/drill/docs/summary) + * [Installing the Apache Drill Sandbox](/docs/installing-the-apache-drill-sandbox) + * [Getting to Know the Drill Setup](/docs/getting-to-know-the-drill-sandbox) + * [Lesson 1: Learn About the Data Set](/docs/lession-1-learn-about-the-data-set) + * [Lesson 2: Run Queries with ANSI SQL](/docs/lession-2-run-queries-with-ansi-sql) + * [Lesson 3: Run Queries on Complex Data Types](/docs/lession-3-run-queries-on-complex-data-types) + * [Summary](/docs/summary) ## About Apache Drill @@ -41,11 +41,11 @@ environment to get a feel for the power and capabilities of Apache Drill by performing various types of queries. Once you get a flavor for the technology, refer to the [Apache Drill web site](http://incubator.apache.org/drill/) and [Apache Drill documentation -](/drill/docs)for more +](/docs)for more details. Note that Hadoop is not a prerequisite for Drill and users can start ramping up with Drill by running SQL queries directly on the local file system. Refer -to [Apache Drill in 10 minutes](/drill/docs/apache-drill-in-10-minutes) for an introduction to using Drill in local +to [Apache Drill in 10 minutes](/docs/apache-drill-in-10-minutes) for an introduction to using Drill in local (embedded) mode. http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/003-yelp.md ---------------------------------------------------------------------- diff --git a/_docs/003-yelp.md b/_docs/003-yelp.md index b65359e..874f780 100644 --- a/_docs/003-yelp.md +++ b/_docs/003-yelp.md @@ -25,7 +25,7 @@ example is downloadable from [Yelp](http://www.yelp.com/dataset_challenge) [http://incubator.apache.org/drill/download/](http://incubator.apache.org/drill/download/) -You can also [deploy Drill in clustered mode](/drill/docs/deploying-apache-drill-in-a-clustered-environment) if you +You can also [deploy Drill in clustered mode](/docs/deploying-apache-drill-in-a-clustered-environment) if you want to scale your environment. ### Step 2 : Open the Drill tar file @@ -337,10 +337,10 @@ Letâs get the total number of records from the view. +------------+ In addition to these queries, you can get many more deeper insights using -Drillâs [SQL functionality](/drill/docs/sql-reference). If you are not comfortable with writing queries manually, you +Drillâs [SQL functionality](/docs/sql-reference). If you are not comfortable with writing queries manually, you can use a BI/Analytics tools such as Tableau/MicroStrategy to query raw files/Hive/HBase data or Drill-created views directly using Drill [ODBC/JDBC -drivers](/drill/docs/odbc-jdbc-interfaces). +drivers](/docs/odbc-jdbc-interfaces). The goal of Apache Drill is to provide the freedom and flexibility in exploring data in ways we have never seen before with SQL technologies. The @@ -407,6 +407,6 @@ To learn more about Drill, please refer to the following resources: * Download Drill here:<http://incubator.apache.org/drill/download/> * 10 reasons we think Drill is cool:<http://incubator.apache.org/drill/why-drill/> - * [A simple 10-minute tutorial](/drill/docs/apache-drill-in-10-minutes>) - * [A more comprehensive tutorial](/drill/docs/apache-drill-tutorial) + * [A simple 10-minute tutorial](/docs/apache-drill-in-10-minutes>) + * [A more comprehensive tutorial](/docs/apache-drill-tutorial) http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/006-interfaces.md ---------------------------------------------------------------------- diff --git a/_docs/006-interfaces.md b/_docs/006-interfaces.md index ce068a6..f971e63 100644 --- a/_docs/006-interfaces.md +++ b/_docs/006-interfaces.md @@ -5,8 +5,8 @@ You can connect to Apache Drill through the following interfaces: * Drill shell (SQLLine) * Drill Web UI - * [ODBC](/drill/docs/odbc-jdbc-interfaces#using-odbc-to-access-apache-drill-from-bi-tools)* - * [JDBC](/drill/docs/odbc-jdbc-interfaces#using-jdbc-to-access-apache-drill-from-squirrel) + * [ODBC](/docs/odbc-jdbc-interfaces#using-odbc-to-access-apache-drill-from-bi-tools)* + * [JDBC](/docs/odbc-jdbc-interfaces#using-jdbc-to-access-apache-drill-from-squirrel) * C++ API *Apache Drill does not have an open source ODBC driver. However, MapR provides an ODBC driver that you can use to connect to Apache Drill from BI tools. @@ -39,10 +39,10 @@ SQuirreL on Windows. To use the Drill JDBC driver with SQuirreL on Windows, complete the following steps: - * [Step 1: Getting the Drill JDBC Driver](/drill/docs/using-the-jdbc-driver#step-1-getting-the-drill-jdbc-driver) - * [Step 2: Installing and Starting SQuirreL](/drill/docs/using-the-jdbc-driver#step-2-installing-and-starting-squirrel) - * [Step 3: Adding the Drill JDBC Driver to SQuirreL](/drill/docs/using-the-jdbc-driver#step-3-adding-the-drill-jdbc-driver-to-squirrel) - * [Step 4: Running a Drill Query from SQuirreL](/drill/docs/using-the-jdbc-driver#step-4-running-a-drill-query-from-squirrel) + * [Step 1: Getting the Drill JDBC Driver](/docs/using-the-jdbc-driver#step-1-getting-the-drill-jdbc-driver) + * [Step 2: Installing and Starting SQuirreL](/docs/using-the-jdbc-driver#step-2-installing-and-starting-squirrel) + * [Step 3: Adding the Drill JDBC Driver to SQuirreL](/docs/using-the-jdbc-driver#step-3-adding-the-drill-jdbc-driver-to-squirrel) + * [Step 4: Running a Drill Query from SQuirreL](/docs/using-the-jdbc-driver#step-4-running-a-drill-query-from-squirrel) For information about how to use SQuirreL, refer to the [SQuirreL Quick Start](http://squirrel-sql.sourceforge.net/user-manual/quick_start.html) http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/012-rn.md ---------------------------------------------------------------------- diff --git a/_docs/012-rn.md b/_docs/012-rn.md index f369335..25ec29e 100644 --- a/_docs/012-rn.md +++ b/_docs/012-rn.md @@ -75,7 +75,7 @@ This release is primarily a bug fix release, with [more than 30 JIRAs closed]( https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&vers ion=12327472), but there are some notable features: - * Direct ANSI SQL access to MongoDB, using the latest [MongoDB Plugin for Apache Drill](/drill/docs/mongodb-plugin-for-apache-drill) + * Direct ANSI SQL access to MongoDB, using the latest [MongoDB Plugin for Apache Drill](/docs/mongodb-plugin-for-apache-drill) * Filesystem query performance improvements with partition pruning * Ability to use the file system as a persistent store for query profiles and diagnostic information * Window function support (alpha) http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/013-contribute.md ---------------------------------------------------------------------- diff --git a/_docs/013-contribute.md b/_docs/013-contribute.md index 33db231..42108b9 100644 --- a/_docs/013-contribute.md +++ b/_docs/013-contribute.md @@ -2,8 +2,8 @@ title: "Contribute to Drill" --- The Apache Drill community welcomes your support. Please read [Apache Drill -Contribution Guidelines](/drill/docs/apache-drill-contribution-guidelines) for information about how to contribute to +Contribution Guidelines](/docs/apache-drill-contribution-guidelines) for information about how to contribute to the project. If you would like to contribute to the project and need some ideas for what to do, please read [Apache Drill Contribution -Ideas](/drill/docs/apache-drill-contribution-ideas). +Ideas](/docs/apache-drill-contribution-ideas). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/014-sample-ds.md ---------------------------------------------------------------------- diff --git a/_docs/014-sample-ds.md b/_docs/014-sample-ds.md index 7212ea0..c6f51e1 100644 --- a/_docs/014-sample-ds.md +++ b/_docs/014-sample-ds.md @@ -3,8 +3,8 @@ title: "Sample Datasets" --- Use any of the following sample datasets provided to test Drill: - * [AOL Search](/drill/docs/aol-search) - * [Enron Emails](/drill/docs/enron-emails) - * [Wikipedia Edit History](/drill/docs/wikipedia-edit-history) + * [AOL Search](/docs/aol-search) + * [Enron Emails](/docs/enron-emails) + * [Wikipedia Edit History](/docs/wikipedia-edit-history) http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/015-design.md ---------------------------------------------------------------------- diff --git a/_docs/015-design.md b/_docs/015-design.md index 00b17e5..474052e 100644 --- a/_docs/015-design.md +++ b/_docs/015-design.md @@ -5,9 +5,9 @@ Review the Apache Drill design docs for early descriptions of Apache Drill functionality, terms, and goals, and reference the research articles to learn about Apache Drill's history: - * [Drill Plan Syntax](/drill/docs/drill-plan-syntax) - * [RPC Overview](/drill/docs/rpc-overview) - * [Query Stages](/drill/docs/query-stages) - * [Useful Research](/drill/docs/useful-research) - * [Value Vectors](/drill/docs/value-vectors) + * [Drill Plan Syntax](/docs/drill-plan-syntax) + * [RPC Overview](/docs/rpc-overview) + * [Query Stages](/docs/query-stages) + * [Useful Research](/docs/useful-research) + * [Value Vectors](/docs/value-vectors) http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/016-progress.md ---------------------------------------------------------------------- diff --git a/_docs/016-progress.md b/_docs/016-progress.md index bf19a29..680290e 100644 --- a/_docs/016-progress.md +++ b/_docs/016-progress.md @@ -4,5 +4,5 @@ title: "Progress Reports" Review the following Apache Drill progress reports for a summary of issues, progression of the project, summary of mailing list discussions, and events: - * [2014 Q1 Drill Report](/drill/docs/2014-q1-drill-report) + * [2014 Q1 Drill Report](/docs/2014-q1-drill-report) http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/arch/arch-hilite/001-flexibility.md ---------------------------------------------------------------------- diff --git a/_docs/arch/arch-hilite/001-flexibility.md b/_docs/arch/arch-hilite/001-flexibility.md index 0b5c5e3..8c0ae3a 100644 --- a/_docs/arch/arch-hilite/001-flexibility.md +++ b/_docs/arch/arch-hilite/001-flexibility.md @@ -56,7 +56,7 @@ traditional DB (Databases->Tables/Views->Columns). The metadata is accessible through the ANSI standard INFORMATION_SCHEMA database For more information on how to configure and work various data sources with -Drill, refer to [Connect Apache Drill to Data Sources](/drill/docs/connect-to-data-sources). +Drill, refer to [Connect Apache Drill to Data Sources](/docs/connect-to-data-sources). **_Extensibility_** http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/connect/005-reg-hive.md ---------------------------------------------------------------------- diff --git a/_docs/connect/005-reg-hive.md b/_docs/connect/005-reg-hive.md index 564bebc..8ea607d 100644 --- a/_docs/connect/005-reg-hive.md +++ b/_docs/connect/005-reg-hive.md @@ -46,7 +46,7 @@ To register a remote Hive metastore with Drill, complete the following steps: 6. Verify that `HADOOP_CLASSPATH` is set in `drill-env.sh`. If you need to set the classpath, add the following line to `drill-env.sh`. Once you have configured a storage plugin instance for a Hive data source, you -can [query Hive tables](/drill/docs/querying-hive/). +can [query Hive tables](/docs/querying-hive/). ## Hive Embedded Metastore http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/connect/006-default-frmt.md ---------------------------------------------------------------------- diff --git a/_docs/connect/006-default-frmt.md b/_docs/connect/006-default-frmt.md index 7dc55d5..b14fc1a 100644 --- a/_docs/connect/006-default-frmt.md +++ b/_docs/connect/006-default-frmt.md @@ -30,7 +30,7 @@ Drill supports. Currently, Drill supports the following types: ## Defining a Default Input Format You define the default input format for a file system workspace through the -Drill Web UI. You must have a [defined workspace](/drill/docs/workspaces) before you can define a +Drill Web UI. You must have a [defined workspace](/docs/workspaces) before you can define a default input format. To define a default input format for a workspace, complete the following http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/connect/007-mongo-plugin.md ---------------------------------------------------------------------- diff --git a/_docs/connect/007-mongo-plugin.md b/_docs/connect/007-mongo-plugin.md index fd5dba8..b872e7a 100644 --- a/_docs/connect/007-mongo-plugin.md +++ b/_docs/connect/007-mongo-plugin.md @@ -26,7 +26,7 @@ Before you can query MongoDB with Drill, you must have Drill and MongoDB installed on your machine. You may also want to import the MongoDB zip code data to run the example queries on your machine. - 1. [Install Drill](/drill/docs/installing-drill-in-embedded-mode), if you do not already have it installed on your machine. + 1. [Install Drill](/docs/installing-drill-in-embedded-mode), if you do not already have it installed on your machine. 2. [Install MongoDB](http://docs.mongodb.org/manual/installation), if you do not already have it installed on your machine. 3. [Import the MongoDB zip code sample data set](http://docs.mongodb.org/manual/tutorial/aggregation-zip-code-data-set). You can use Mongo Import to get the data. @@ -88,7 +88,7 @@ the `USE` command to change schema. The following example queries are included for reference. However, you can use the SQL power of Apache Drill directly on MongoDB. For more information about, refer to the [SQL -Reference](/drill/docs/sql-reference). +Reference](/docs/sql-reference). **Example 1: View mongo.zipdb Dataset** @@ -164,4 +164,4 @@ Reference](/drill/docs/sql-reference). You can leverage the power of Apache Drill to query MongoDB through standard BI tools, such as Tableau and SQuirreL. -For information about Drill ODBC and JDBC drivers, refer to [Drill Interfaces](/drill/docs/odbc-jdbc-interfaces). +For information about Drill ODBC and JDBC drivers, refer to [Drill Interfaces](/docs/odbc-jdbc-interfaces). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/contribute/001-guidelines.md ---------------------------------------------------------------------- diff --git a/_docs/contribute/001-guidelines.md b/_docs/contribute/001-guidelines.md index 686d972..feacb10 100644 --- a/_docs/contribute/001-guidelines.md +++ b/_docs/contribute/001-guidelines.md @@ -167,7 +167,7 @@ functions which need to be implemented can be found [here](https://docs.google.com/spreadsheet/ccc?key=0AgAGbQ6asvQ- dDRrUUxVSVlMVXRtanRoWk9JcHgteUE&usp=sharing#gid=0) (WIP). -More contribution ideas are located on the [Contribution Ideas](/drill/docs/apache-drill-contribution-ideas) page. +More contribution ideas are located on the [Contribution Ideas](/docs/apache-drill-contribution-ideas) page. ### Contributing your work http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/dev-custom-fcn/001-dev-simple.md ---------------------------------------------------------------------- diff --git a/_docs/dev-custom-fcn/001-dev-simple.md b/_docs/dev-custom-fcn/001-dev-simple.md index ebf3831..1528bd9 100644 --- a/_docs/dev-custom-fcn/001-dev-simple.md +++ b/_docs/dev-custom-fcn/001-dev-simple.md @@ -5,7 +5,7 @@ parent: "Develop Custom Functions" Create a class within a Java package that implements Drillâs simple interface into the program, and include the required information for the function type. Your function must include data types that Drill supports, such as int or -BigInt. For a list of supported data types, refer to the [SQL Reference](/drill/docs/sql-reference). +BigInt. For a list of supported data types, refer to the [SQL Reference](/docs/sql-reference). Complete the following steps to develop a simple function using Drillâs simple function interface: http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/dev-custom-fcn/002-dev-aggregate.md ---------------------------------------------------------------------- diff --git a/_docs/dev-custom-fcn/002-dev-aggregate.md b/_docs/dev-custom-fcn/002-dev-aggregate.md index d1a3cfb..149be8c 100644 --- a/_docs/dev-custom-fcn/002-dev-aggregate.md +++ b/_docs/dev-custom-fcn/002-dev-aggregate.md @@ -5,7 +5,7 @@ parent: "Develop Custom Functions" Create a class within a Java package that implements Drillâs aggregate interface into the program. Include the required information for the function. Your function must include data types that Drill supports, such as int or -BigInt. For a list of supported data types, refer to the [SQL Reference](/drill/docs/sql-reference). +BigInt. For a list of supported data types, refer to the [SQL Reference](/docs/sql-reference). Complete the following steps to create an aggregate function: http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/develop/001-compile.md ---------------------------------------------------------------------- diff --git a/_docs/develop/001-compile.md b/_docs/develop/001-compile.md index 2cf6ac9..dea42e9 100644 --- a/_docs/develop/001-compile.md +++ b/_docs/develop/001-compile.md @@ -30,8 +30,8 @@ Maven and JDK installed: Now that you have Drill installed, you can connect to Drill and query sample data or you can connect Drill to your data sources. - * To connect Drill to your data sources, refer to [Connect to Data Sources](/drill/docs/connect-to-data-sources) for instructions. + * To connect Drill to your data sources, refer to [Connect to Data Sources](/docs/connect-to-data-sources) for instructions. * To connect to Drill and query sample data, refer to the following topics: - * [Start Drill ](/drill/docs/starting-stopping-drill)(For Drill installed in embedded mode) - * [Query Data ](/drill/docs/query-data) + * [Start Drill ](/docs/starting-stopping-drill)(For Drill installed in embedded mode) + * [Query Data ](/docs/query-data) http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/develop/003-patch-tool.md ---------------------------------------------------------------------- diff --git a/_docs/develop/003-patch-tool.md b/_docs/develop/003-patch-tool.md index 3ef3fe5..28c8a54 100644 --- a/_docs/develop/003-patch-tool.md +++ b/_docs/develop/003-patch-tool.md @@ -21,8 +21,8 @@ parent: "Develop Drill" #### 1\. Setup - 1. Follow instructions [here](/drill/docs/drill-patch-review-tool#jira-command-line-tool) to setup the jira-python package - 2. Follow instructions [here](/drill/docs/drill-patch-review-tool#reviewboard) to setup the reviewboard python tools + 1. Follow instructions [here](/docs/drill-patch-review-tool#jira-command-line-tool) to setup the jira-python package + 2. Follow instructions [here](/docs/drill-patch-review-tool#reviewboard) to setup the reviewboard python tools 3. Install the argparse module On Linux -> sudo yum install python-argparse http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/install/001-drill-in-10.md ---------------------------------------------------------------------- diff --git a/_docs/install/001-drill-in-10.md b/_docs/install/001-drill-in-10.md index 13d2410..df507ca 100644 --- a/_docs/install/001-drill-in-10.md +++ b/_docs/install/001-drill-in-10.md @@ -120,7 +120,7 @@ Complete the following steps to install Drill: cd /opt/drill/apache-drill-<version> -At this point, you can [start Drill](/drill/docs/apache-drill-in-10-minutes#start-drill). +At this point, you can [start Drill](/docs/apache-drill-in-10-minutes#start-drill). ### Installing Drill on Mac OS X @@ -144,7 +144,7 @@ Complete the following steps to install Drill: cd /Users/max/drill/apache-drill-<version> -At this point, you can [start Drill](/drill/docs/apache-drill-in-10-minutes/#start-drill). +At this point, you can [start Drill](/docs/apache-drill-in-10-minutes/#start-drill). ### Installing Drill on Windows @@ -193,7 +193,7 @@ directory path, Drill fails to run. 2. When prompted, enter the password `admin` and then press Enter. The cursor blinks for a few seconds and then `0: jdbc:drill:zk=local>` displays in the prompt. At this point, you can submit queries to Drill. Refer to the [Query Sample Dat -a](/drill/docs/apache-drill-in-10-minutes#query-sample-data) section of this document. +a](/docs/apache-drill-in-10-minutes#query-sample-data) section of this document. ## Start Drill @@ -215,7 +215,7 @@ Example: `~/apache-drill-<version>` also starts a local Drillbit. If you are connecting to an Apache Drill cluster, the value of `zk=` would be a list of Zookeeper quorum nodes. For more information about how to run Drill in clustered mode, go to [Deploying -Apache Drill in a Clustered Environment](/drill/docs/deploying-apache-drill-in-a-clustered-environment). +Apache Drill in a Clustered Environment](/docs/deploying-apache-drill-in-a-clustered-environment). When SQLLine starts, the system displays the following prompt: `0: jdbc:drill:zk=local>` @@ -231,7 +231,7 @@ Your Drill installation includes a `sample-date` directory with JSON and Parquet files that you can query. The local file system on your machine is configured as the `dfs` storage plugin instance by default when you install Drill in embedded mode. For more information about storage plugin -configuration, refer to [Storage Plugin Registration](/drill/docs/connect-to-data-sources). +configuration, refer to [Storage Plugin Registration](/docs/connect-to-data-sources). Use SQL syntax to query the sample `JSON` and `Parquet` files in the `sample- data` directory on your local file system. @@ -353,11 +353,11 @@ following tasks: Now that you have an idea about what Drill can do, you might want to: - * [Deploy Drill in a clustered environment.](/drill/docs/deploying-apache-drill-in-a-clustered-environment) - * [Configure storage plugins to connect Drill to your data sources](/drill/docs/connect-to-data-sources). - * Query [Hive](/drill/docs/querying-hive) and [HBase](/drill/docs/registering-hbase) data. - * [Query Complex Data](/drill/docs/querying-complex-data) - * [Query Plain Text Files](/drill/docs/querying-plain-text-files) + * [Deploy Drill in a clustered environment.](/docs/deploying-apache-drill-in-a-clustered-environment) + * [Configure storage plugins to connect Drill to your data sources](/docs/connect-to-data-sources). + * Query [Hive](/docs/querying-hive) and [HBase](/docs/registering-hbase) data. + * [Query Complex Data](/docs/querying-complex-data) + * [Query Plain Text Files](/docs/querying-plain-text-files) ## More Information http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/install/002-deploy.md ---------------------------------------------------------------------- diff --git a/_docs/install/002-deploy.md b/_docs/install/002-deploy.md index eecd3bc..399414e 100644 --- a/_docs/install/002-deploy.md +++ b/_docs/install/002-deploy.md @@ -52,7 +52,7 @@ Complete the following steps to install Drill on designated nodes: ### Connecting Drill to Data Sources You can connect Drill to various types of data sources. Refer to [Connect -Apache Drill to Data Sources](/drill/docs/connect-to-data-sources) to get configuration instructions for the +Apache Drill to Data Sources](/docs/connect-to-data-sources) to get configuration instructions for the particular type of data source that you want to connect to Drill. ### Starting Drill @@ -86,4 +86,4 @@ Drill provides a list of Drillbits that have joined. **Example** Now you can query data with Drill. The Drill installation includes sample data -that you can query. Refer to [Query Sample Data](/drill/docs/sample-datasets). \ No newline at end of file +that you can query. Refer to [Query Sample Data](/docs/sample-datasets). \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/install/004-install-distributed.md ---------------------------------------------------------------------- diff --git a/_docs/install/004-install-distributed.md b/_docs/install/004-install-distributed.md index d0f07aa..a47176f 100644 --- a/_docs/install/004-install-distributed.md +++ b/_docs/install/004-install-distributed.md @@ -51,5 +51,5 @@ Complete the following steps to install Drill on designated nodes: } You can connect Drill to various types of data sources. Refer to [Connect -Apache Drill to Data Sources](/drill/docs/connect-to-data-sources) to get configuration instructions for the +Apache Drill to Data Sources](/docs/connect-to-data-sources) to get configuration instructions for the particular type of data source that you want to connect to Drill. \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/install/install-embedded/001-install-linux.md ---------------------------------------------------------------------- diff --git a/_docs/install/install-embedded/001-install-linux.md b/_docs/install/install-embedded/001-install-linux.md index b7a0c85..589fa0f 100644 --- a/_docs/install/install-embedded/001-install-linux.md +++ b/_docs/install/install-embedded/001-install-linux.md @@ -19,4 +19,4 @@ Linux: cd /opt/drill/apache-drill-<version> At this point, you can [invoke -SQLLine](/drill/docs/starting-stopping-drill) to run Drill. \ No newline at end of file +SQLLine](/docs/starting-stopping-drill) to run Drill. \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/install/install-embedded/002-install-mac.md ---------------------------------------------------------------------- diff --git a/_docs/install/install-embedded/002-install-mac.md b/_docs/install/install-embedded/002-install-mac.md index a288b94..97ae775 100644 --- a/_docs/install/install-embedded/002-install-mac.md +++ b/_docs/install/install-embedded/002-install-mac.md @@ -23,7 +23,7 @@ OS X: cd /Users/max/drill/apache-drill-<version> -At this point, you can [invoke SQLLine](/drill/docs/starting-stopping-drill) to +At this point, you can [invoke SQLLine](/docs/starting-stopping-drill) to run Drill. <!--The title is too complicated for me to figure out how to create a link to it.--> \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/install/install-embedded/003-install-win.md ---------------------------------------------------------------------- diff --git a/_docs/install/install-embedded/003-install-win.md b/_docs/install/install-embedded/003-install-win.md index 6680019..6c8272b 100644 --- a/_docs/install/install-embedded/003-install-win.md +++ b/_docs/install/install-embedded/003-install-win.md @@ -48,4 +48,4 @@ directory path, Drill fails to run. 2. When prompted, enter the password `admin` and then press Enter. The cursor blinks for a few seconds and then `0: jdbc:drill:zk=local>` displays in the prompt. At this point, you can submit queries to Drill. Refer to the [Query Sample Dat -a](/drill/docs/apache-drill-in-10-minutes#query-sampledata) section of this document. \ No newline at end of file +a](/docs/apache-drill-in-10-minutes#query-sampledata) section of this document. \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/001-odbc-win.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/001-odbc-win.md b/_docs/interfaces/001-odbc-win.md index 2f08af2..1cd5f4e 100644 --- a/_docs/interfaces/001-odbc-win.md +++ b/_docs/interfaces/001-odbc-win.md @@ -17,13 +17,13 @@ that is self-describing, such as HBase, Parquet, JSON, CSV, and TSV. Complete the following steps to connect to a Drill data source from a BI tool using ODBC: - * [Step 1. Install the MapR Drill ODBC Driver](/drill/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows) - * [Step 2. Configure ODBC Connections to Drill Data Sources](/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources) - * [Step 3. Connect to Drill Data Sources from a BI Tool](/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool) + * [Step 1. Install the MapR Drill ODBC Driver](/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows) + * [Step 2. Configure ODBC Connections to Drill Data Sources](/docs/step-2-configure-odbc-connections-to-drill-data-sources) + * [Step 3. Connect to Drill Data Sources from a BI Tool](/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool) For examples of how you can use the MapR Drill ODBC Driver to connect to Drill Data Sources from BI tools, see [Step 3. Connect to Drill Data Sources from a -BI Tool](/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool). While the documentation includes examples for Tableau, you can use +BI Tool](/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool). While the documentation includes examples for Tableau, you can use this driver with any BI tool that works with ODBC, such as Excel, MicroStrategy, and Toad. http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/003-jdbc-squirrel.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/003-jdbc-squirrel.md b/_docs/interfaces/003-jdbc-squirrel.md index 99eba80..0fd14c0 100644 --- a/_docs/interfaces/003-jdbc-squirrel.md +++ b/_docs/interfaces/003-jdbc-squirrel.md @@ -6,7 +6,7 @@ To use the JDBC Driver to access Drill through Squirrel, ensure that you meet th ### Prerequisites * SQuirreL requires JRE 7 - * Drill installed in distributed mode on one or multiple nodes in a cluster. Refer to the [Install Drill](/drill/docs/install-drill/) documentation for more information. + * Drill installed in distributed mode on one or multiple nodes in a cluster. Refer to the [Install Drill](/docs/install-drill/) documentation for more information. * The client must be able to resolve the actual hostname of the Drill node(s) with the IP(s). Verify that a DNS entry was created on the client machine for the Drill node(s). If a DNS entry does not exist, create the entry for the Drill node(s). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/odbc-linux/001-install-odbc-linux.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/odbc-linux/001-install-odbc-linux.md b/_docs/interfaces/odbc-linux/001-install-odbc-linux.md index 3ae1930..61644d8 100644 --- a/_docs/interfaces/odbc-linux/001-install-odbc-linux.md +++ b/_docs/interfaces/odbc-linux/001-install-odbc-linux.md @@ -15,7 +15,7 @@ To install the MapR Drill ODBC Driver, complete the following steps: * Step 3: Setting the LD_LIBRARY_PATH Environment Variable After you complete the installation steps, complete the steps listed in -[Configuring ODBC Connections for Linux and Mac OS X](/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x). +[Configuring ODBC Connections for Linux and Mac OS X](/docs/configuring-odbc-connections-for-linux-and-mac-os-x). Verify that your system meets the system requirements before you start. @@ -101,5 +101,5 @@ variables permanently. #### Next Step Complete the steps listed in [Configuring ODBC Connections for Linux and Mac -OS X](/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x). +OS X](/docs/configuring-odbc-connections-for-linux-and-mac-os-x). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/odbc-linux/002-install-odbc-mac.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/odbc-linux/002-install-odbc-mac.md b/_docs/interfaces/odbc-linux/002-install-odbc-mac.md index 65a35f3..77b8e1b 100644 --- a/_docs/interfaces/odbc-linux/002-install-odbc-mac.md +++ b/_docs/interfaces/odbc-linux/002-install-odbc-mac.md @@ -12,7 +12,7 @@ To install the MapR Drill ODBC Driver, complete the following steps: * Step 3: Updating the DYLD_LIBRARY_PATH Environment Variable After you complete the installation steps, complete the steps listed in -[Configuring ODBC Connections for Linux and Mac OS X](/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x) +[Configuring ODBC Connections for Linux and Mac OS X](/docs/configuring-odbc-connections-for-linux-and-mac-os-x) . Verify that your system meets the following prerequisites before you start. @@ -67,4 +67,4 @@ c/lib/universal` #### Next Step Complete the steps listed in [Configuring ODBC Connections for Linux and Mac -OS X](/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x). +OS X](/docs/configuring-odbc-connections-for-linux-and-mac-os-x). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/odbc-linux/003-odbc-connections-linux.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/odbc-linux/003-odbc-connections-linux.md b/_docs/interfaces/odbc-linux/003-odbc-connections-linux.md index 11b660d..f6f276e 100644 --- a/_docs/interfaces/odbc-linux/003-odbc-connections-linux.md +++ b/_docs/interfaces/odbc-linux/003-odbc-connections-linux.md @@ -27,7 +27,7 @@ steps: * Step 4: Configure the MapR Drill ODBC Driver Once you have completed the required steps, refer to [Testing the ODBC -Connection on Linux and Mac OS X](/drill/docs/testing-the-odbc-connection-on-linux-and-mac-os-x). +Connection on Linux and Mac OS X](/docs/testing-the-odbc-connection-on-linux-and-mac-os-x). #### Sample Configuration Files @@ -114,7 +114,7 @@ following steps: For details on the configuration options available for controlling the behavior of DSNs using Simba ODBC Driver for Apache Drill, see [Driver Configuration -Options](/drill/docs/driver-configuration-options). +Options](/docs/driver-configuration-options). ## Step 3: (Optional) Define the ODBC Driver in `odbcinst.ini` @@ -174,5 +174,5 @@ named `DYLD_LIBRARY_PATH`. ### Next Step -Refer to [Testing the ODBC Connection on Linux and Mac OS X](/drill/docs/testing-the-odbc-connection-on-linux-and-mac-os-x). +Refer to [Testing the ODBC Connection on Linux and Mac OS X](/docs/testing-the-odbc-connection-on-linux-and-mac-os-x). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/odbc-linux/005-odbc-connect-str.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/odbc-linux/005-odbc-connect-str.md b/_docs/interfaces/odbc-linux/005-odbc-connect-str.md index 595432b..70f3858 100644 --- a/_docs/interfaces/odbc-linux/005-odbc-connect-str.md +++ b/_docs/interfaces/odbc-linux/005-odbc-connect-str.md @@ -5,7 +5,7 @@ parent: "Using the MapR ODBC Driver on Linux and Mac OS X" You can use a connection string to connect to your data source. For a list of all the properties that you can use in connection strings, see [Driver Configuration -Options](/drill/docs/driver-configuration-options). +Options](/docs/driver-configuration-options). The following example shows a connection string for connecting directly to a Drillbit: http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/odbc-win/001-install-odbc-win.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/odbc-win/001-install-odbc-win.md b/_docs/interfaces/odbc-win/001-install-odbc-win.md index 5bb6c8d..7ff770d 100644 --- a/_docs/interfaces/odbc-win/001-install-odbc-win.md +++ b/_docs/interfaces/odbc-win/001-install-odbc-win.md @@ -54,5 +54,5 @@ driver. 2. When the installation completes, press any key to continue. For example, you can press the SPACEBAR key. -#### What's Next? Go to [Step 2. Configure ODBC Connections to Drill Data Sources](/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources). +#### What's Next? Go to [Step 2. Configure ODBC Connections to Drill Data Sources](/docs/step-2-configure-odbc-connections-to-drill-data-sources). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/odbc-win/002-conf-odbc-win.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/odbc-win/002-conf-odbc-win.md b/_docs/interfaces/odbc-win/002-conf-odbc-win.md index 636bd9f..5fe40b2 100644 --- a/_docs/interfaces/odbc-win/002-conf-odbc-win.md +++ b/_docs/interfaces/odbc-win/002-conf-odbc-win.md @@ -8,7 +8,7 @@ sources: * Create a Data Source Name * Create an ODBC Connection String -**Prerequisite:** An Apache Drill installation must be available that is configured to access the data sources that you want to connect to. For information about how to install Apache Drill, see [Install Drill](/drill/docs/install-drill). For information about configuring data sources, see the [Apache Drill documentation](/drill/docs). +**Prerequisite:** An Apache Drill installation must be available that is configured to access the data sources that you want to connect to. For information about how to install Apache Drill, see [Install Drill](/docs/install-drill). For information about configuring data sources, see the [Apache Drill documentation](/docs). ## Create a Data Source Name (DSN) @@ -31,12 +31,12 @@ The ODBC Data Source Administrator window appears. <table style='table-layout:fixed;width:100%'><tbody><tr><th>Connection Type</th><th >Properties</th><th >Descriptions</th></tr><tr><td rowspan="2" valign="top" width="10%">Zookeeper Quorum</td><td valign="top" style='width: 100px;'>Quorum</td><td valign="top" style='width: 400px;'>A comma-separated list of servers in a Zookeeper cluster.For example, <ip_zookeepernode1>:5181,<ip_zookeepernode21>:5181,â¦</td></tr><tr><td valign="top">ClusterID</td><td valign="top">Name of the drillbit cluster. The default is drillbits1. You may need to specify a different value if the cluster ID was changed in the drill-override.conf file.</td></tr><tr><td colspan="1" valign="top">Direct to Drillbit</td><td colspan="1" valign="top"> </td><td colspan="1" valign="top">Provide the IP address or host name of the Drill server and the port number that that the Drill server is listening on. The port number defaults to 31010. You may need to specify a different value if the port number was changed in the drill-override.conf file.</td></tr></tbody></table> For information on selecting the appropriate connection type, see [Connection -Types](/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources#connection-type). +Types](/docs/step-2-configure-odbc-connections-to-drill-data-sources#connection-type). 8. In the **Default Schema** field, select the default schema that you want to connect to. For more information about the schemas that appear in this list, see Schemas. 9. Optionally, perform one of the following operations: - <table ><tbody><tr><th >Option</th><th >Action</th></tr><tr><td valign="top">Update the configuration of the advanced properties.</td><td valign="top">Edit the default values in the <strong>Advanced Properties</strong> section. <br />For more information, see <a href="/drill/docs/advanced-properties/">Advanced Properties</a>.</td></tr><tr><td valign="top">Configure the types of events that you want the driver to log.</td><td valign="top">Click <strong>Logging Options</strong>. <br />For more information, see <a href="/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources#logging-options">Logging Options</a>.</td></tr><tr><td valign="top">Create views or explore Drill sources.</td><td valign="top">Click <strong>Drill Explorer</strong>. <br />For more information, see <a href="/drill/docs/using-drill-explorer-to-browse-data-and-create-views">Using Drill Explorer to Browse Data and Create Views</a>.</td></tr></tbody></table> + <table ><tbody><tr><th >Option</th><th >Action</th></tr><tr><td valign="top">Update the configuration of the advanced properties.</td><td valign="top">Edit the default values in the <strong>Advanced Properties</strong> section. <br />For more information, see <a href="/docs/advanced-properties/">Advanced Properties</a>.</td></tr><tr><td valign="top">Configure the types of events that you want the driver to log.</td><td valign="top">Click <strong>Logging Options</strong>. <br />For more information, see <a href="/docs/step-2-configure-odbc-connections-to-drill-data-sources#logging-options">Logging Options</a>.</td></tr><tr><td valign="top">Create views or explore Drill sources.</td><td valign="top">Click <strong>Drill Explorer</strong>. <br />For more information, see <a href="/docs/using-drill-explorer-to-browse-data-and-create-views">Using Drill Explorer to Browse Data and Create Views</a>.</td></tr></tbody></table> 10. Click **OK** to save the DSN. ## Configuration Options @@ -139,5 +139,5 @@ type: DRIVER=MapR Drill ODBC Driver;AdvancedProperties={HandshakeTimeout=0;QueryTimeout=0;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys, INFORMATION_SCHEMA;};Catalog=DRILL;Schema=;ConnectionType=ZooKeeper;ZKQuorum=192.168.39.43:5181;ZKClusterID=drillbits1 -#### What's Next? Go to [Step 3. Connect to Drill Data Sources from a BI Tool](/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool). +#### What's Next? Go to [Step 3. Connect to Drill Data Sources from a BI Tool](/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/odbc-win/003-connect-odbc-win.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/odbc-win/003-connect-odbc-win.md b/_docs/interfaces/odbc-win/003-connect-odbc-win.md index 0d4cb8a..cf031b0 100644 --- a/_docs/interfaces/odbc-win/003-connect-odbc-win.md +++ b/_docs/interfaces/odbc-win/003-connect-odbc-win.md @@ -9,7 +9,7 @@ Examples of self-describing data include HBase, Parquet, JSON, CSV,and TSV. In some cases, you may want to use Drill Explorer to explore that data or to create a view before you connect to the data from a BI tool. For more information about Drill Explorer, see [Using Drill Explorer to Browse Data and -Create Views](/drill/docs/using-drill-explorer-to-browse-data-and-create-views). +Create Views](/docs/using-drill-explorer-to-browse-data-and-create-views). In an ODBC-compliant BI tool, use the ODBC DSN to create an ODBC connection with one of the methods applicable to the data source type: @@ -17,7 +17,7 @@ with one of the methods applicable to the data source type: <table ><tbody><tr><th >Data Source Type</th><th>ODBC Connection Method</th></tr><tr><td valign="top">Hive</td><td valign="top">Connect to a table.<br />Connect to the table using custom SQL.<br />Use Drill Explorer to create a view. Then use ODBC to connect to the view as if it were a table.</td></tr><tr><td valign="top">HBase<br /><span style="line-height: 1.4285715;background-color: transparent;">Parquet<br /></span><span style="line-height: 1.4285715;background-color: transparent;">JSON<br /></span><span style="line-height: 1.4285715;background-color: transparent;">CSV<br /></span><span style="line-height: 1.4285715;background-color: transparent;">TSV</span></td><td valign="top">Use Drill Explorer to create a view. Then use ODBC to connect to the view as if it were a table.<br />Connect to the data using custom SQL.</td></tr></tbody></table> For examples of how to connect to Drill data sources from a BI tool, see the -[Step 3. Connect to Drill Data Sources from a BI Tool](/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool). +[Step 3. Connect to Drill Data Sources from a BI Tool](/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool). **Note:** The default schema that you configure in the DSN may or may not carry over to an applicationâs data source connections. You may need to re-select the schema. http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/interfaces/odbc-win/004-tableau-examples.md ---------------------------------------------------------------------- diff --git a/_docs/interfaces/odbc-win/004-tableau-examples.md b/_docs/interfaces/odbc-win/004-tableau-examples.md index d45f3f3..c169aab 100644 --- a/_docs/interfaces/odbc-win/004-tableau-examples.md +++ b/_docs/interfaces/odbc-win/004-tableau-examples.md @@ -12,7 +12,7 @@ This section includes the following examples: * Using custom SQL to connect to data in a Parquet file The steps and results of these examples assume pre-configured schemas and source data. You configure schemas as storage plugin instances on the Storage -tab of the [Drill Web UI](/drill/docs/getting-to-know-the-drill-sandbox#storage-plugins-overview). +tab of the [Drill Web UI](/docs/getting-to-know-the-drill-sandbox#storage-plugins-overview). ## Example: Connect to a Hive Table in Tableau @@ -125,7 +125,7 @@ HBase table. HBase does not contain type information, so you need to cast the data in Drill Explorer. For information about SQL query support, see the [SQL -Reference] (/drill/docs/sql-reference). +Reference] (/docs/sql-reference). 9. To save the view, click **Create As**. 10. Specify the schema where you want to save the view, enter a name for the view, and click **Save**. http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/manage/conf/001-mem-alloc.md ---------------------------------------------------------------------- diff --git a/_docs/manage/conf/001-mem-alloc.md b/_docs/manage/conf/001-mem-alloc.md index 8f98cfc..4caf563 100644 --- a/_docs/manage/conf/001-mem-alloc.md +++ b/_docs/manage/conf/001-mem-alloc.md @@ -27,5 +27,5 @@ env.sh`. After you edit `<drill_installation_directory>/conf/drill-env.sh`, [restart the Drillbit -](/drill/docs/starting-stopping-drill#starting-a-drillbit)on +](/docs/starting-stopping-drill#starting-a-drillbit)on the node. \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/manage/conf/002-startup-opt.md ---------------------------------------------------------------------- diff --git a/_docs/manage/conf/002-startup-opt.md b/_docs/manage/conf/002-startup-opt.md index 3434401..898a7ba 100644 --- a/_docs/manage/conf/002-startup-opt.md +++ b/_docs/manage/conf/002-startup-opt.md @@ -46,5 +46,5 @@ override.conf` file located in Drillâs` /conf` directory. You may want to configure the following start-up options that control certain behaviors in Drill: -<table ><tbody><tr><th >Option</th><th >Default Value</th><th >Description</th></tr><tr><td valign="top" >drill.exec.sys.store.provider</td><td valign="top" >ZooKeeper</td><td valign="top" >Defines the persistent storage (PStore) provider. The PStore holds configuration and profile data. For more information about PStores, see <a href="/drill/docs/persistent-configuration-storage" rel="nofollow">Persistent Configuration Storage</a>.</td></tr><tr><td valign="top" >drill.exec.buffer.size</td><td valign="top" > </td><td valign="top" >Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quickly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this optio n increases the speed at which Drill completes a query.</td></tr><tr><td valign="top" >drill.exec.sort.external.directoriesdrill.exec.sort.external.fs</td><td valign="top" > </td><td valign="top" >These options control spooling. The drill.exec.sort.external.directories option tells Drill which directory to use when spooling. The drill.exec.sort.external.fs option tells Drill which file system to use when spooling beyond memory files. <span style="line-height: 1.4285715;background-color: transparent;"> </span>Drill uses a spool and sort operation for beyond memory operations. The sorting operation is designed to spool to a Hadoop file system. The default Hadoop file system is a local file system in the /tmp directory. Spooling performance (both writing and reading back from it) is constrained by the file system. <span style="line-height: 1.4285715;background-color: transparent;"> </span>For MapR clusters, use MapReduce volumes or set up local volumes to use for spooling purposes. Vol umes improve performance and stripe data across as many disks as possible.</td></tr><tr><td valign="top" colspan="1" >drill.exec.debug.error_on_leak</td><td valign="top" colspan="1" >True</td><td valign="top" colspan="1" >Determines how Drill behaves when memory leaks occur during a query. By default, this option is enabled so that queries fail when memory leaks occur. If you disable the option, Drill issues a warning when a memory leak occurs and completes the query.</td></tr><tr><td valign="top" colspan="1" >drill.exec.zk.connect</td><td valign="top" colspan="1" >localhost:2181</td><td valign="top" colspan="1" >Provides Drill with the ZooKeeper quorum to use to connect to data sources. Change this setting to point to the ZooKeeper quorum that you want Drill to use. You must configure this option on each Drillbit node.</td></tr><tr><td valign="top" colspan="1" >drill.exec.cluster-id</td><td valign="top" colspan="1" >my_drillbit_cluster</td><td valign="top" colspan="1" >Identifies t he cluster that corresponds with the ZooKeeper quorum indicated. It also provides Drill with the name of the cluster used during UDP multicast. You must change the default cluster-id if there are multiple clusters on the same subnet. If you do not change the ID, the clusters will try to connect to each other to create one cluster.</td></tr></tbody></table> +<table ><tbody><tr><th >Option</th><th >Default Value</th><th >Description</th></tr><tr><td valign="top" >drill.exec.sys.store.provider</td><td valign="top" >ZooKeeper</td><td valign="top" >Defines the persistent storage (PStore) provider. The PStore holds configuration and profile data. For more information about PStores, see <a href="/docs/persistent-configuration-storage" rel="nofollow">Persistent Configuration Storage</a>.</td></tr><tr><td valign="top" >drill.exec.buffer.size</td><td valign="top" > </td><td valign="top" >Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quickly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this option incr eases the speed at which Drill completes a query.</td></tr><tr><td valign="top" >drill.exec.sort.external.directoriesdrill.exec.sort.external.fs</td><td valign="top" > </td><td valign="top" >These options control spooling. The drill.exec.sort.external.directories option tells Drill which directory to use when spooling. The drill.exec.sort.external.fs option tells Drill which file system to use when spooling beyond memory files. <span style="line-height: 1.4285715;background-color: transparent;"> </span>Drill uses a spool and sort operation for beyond memory operations. The sorting operation is designed to spool to a Hadoop file system. The default Hadoop file system is a local file system in the /tmp directory. Spooling performance (both writing and reading back from it) is constrained by the file system. <span style="line-height: 1.4285715;background-color: transparent;"> </span>For MapR clusters, use MapReduce volumes or set up local volumes to use for spooling purposes. Volumes i mprove performance and stripe data across as many disks as possible.</td></tr><tr><td valign="top" colspan="1" >drill.exec.debug.error_on_leak</td><td valign="top" colspan="1" >True</td><td valign="top" colspan="1" >Determines how Drill behaves when memory leaks occur during a query. By default, this option is enabled so that queries fail when memory leaks occur. If you disable the option, Drill issues a warning when a memory leak occurs and completes the query.</td></tr><tr><td valign="top" colspan="1" >drill.exec.zk.connect</td><td valign="top" colspan="1" >localhost:2181</td><td valign="top" colspan="1" >Provides Drill with the ZooKeeper quorum to use to connect to data sources. Change this setting to point to the ZooKeeper quorum that you want Drill to use. You must configure this option on each Drillbit node.</td></tr><tr><td valign="top" colspan="1" >drill.exec.cluster-id</td><td valign="top" colspan="1" >my_drillbit_cluster</td><td valign="top" colspan="1" >Identifies the clu ster that corresponds with the ZooKeeper quorum indicated. It also provides Drill with the name of the cluster used during UDP multicast. You must change the default cluster-id if there are multiple clusters on the same subnet. If you do not change the ID, the clusters will try to connect to each other to create one cluster.</td></tr></tbody></table> http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/manage/conf/004-persist-conf.md ---------------------------------------------------------------------- diff --git a/_docs/manage/conf/004-persist-conf.md b/_docs/manage/conf/004-persist-conf.md index b1deefa..cb54a51 100644 --- a/_docs/manage/conf/004-persist-conf.md +++ b/_docs/manage/conf/004-persist-conf.md @@ -67,7 +67,7 @@ override.conf.` ## MapR-DB for Persistent Configuration Storage The MapR-DB plugin will be released soon. You can [compile Drill from -source](/drill/docs/compiling-drill-from-source) to try out this +source](/docs/compiling-drill-from-source) to try out this new feature. If you have MapR-DB in your cluster, you can use MapR-DB for persistent http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/query/001-query-fs.md ---------------------------------------------------------------------- diff --git a/_docs/query/001-query-fs.md b/_docs/query/001-query-fs.md index ca488fb..c5d27f6 100644 --- a/_docs/query/001-query-fs.md +++ b/_docs/query/001-query-fs.md @@ -16,7 +16,7 @@ distributed file system: The default `dfs` storage plugin instance registered with Drill has a `default` workspace. If you query data in the `default` workspace, you do not need to include the workspace in the query. Refer to -[Workspaces](/drill/docs/workspaces) for +[Workspaces](/docs/workspaces) for more information. Drill supports the following file types: http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/query/002-query-hbase.md ---------------------------------------------------------------------- diff --git a/_docs/query/002-query-hbase.md b/_docs/query/002-query-hbase.md index d2a33d5..e6e70fa 100644 --- a/_docs/query/002-query-hbase.md +++ b/_docs/query/002-query-hbase.md @@ -88,7 +88,7 @@ steps: cat testdata.txt | hbase shell 5. Issue `exit` to leave the `hbase shell`. - 6. Start Drill. Refer to [Starting/Stopping Drill](/drill/docs/starting-stopping-drill) for instructions. + 6. Start Drill. Refer to [Starting/Stopping Drill](/docs/starting-stopping-drill) for instructions. 7. Use Drill to issue the following SQL queries on the âstudentsâ and âclicksâ tables: 1. Issue the following query to see the data in the âstudentsâ table: http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/query/004-query-hive.md ---------------------------------------------------------------------- diff --git a/_docs/query/004-query-hive.md b/_docs/query/004-query-hive.md index 903c7c6..c19c1b7 100644 --- a/_docs/query/004-query-hive.md +++ b/_docs/query/004-query-hive.md @@ -19,7 +19,7 @@ To create a Hive table and query it with Drill, complete the following steps: hive> load data local inpath '/<directory path>/customers.csv' overwrite into table customers;` 4. Issue `quit` or `exit` to leave the Hive shell. - 5. Start Drill. Refer to [Starting/Stopping Drill](/drill/docs/starting-stopping-drill) for instructions. + 5. Start Drill. Refer to [Starting/Stopping Drill](/docs/starting-stopping-drill) for instructions. 6. Issue the following query to Drill to get the first and last names of the first ten customers in the Hive table: 0: jdbc:drill:schema=hiveremote> SELECT firstname,lastname FROM hiveremote.`customers` limit 10;` http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/query/006-query-sys-tbl.md ---------------------------------------------------------------------- diff --git a/_docs/query/006-query-sys-tbl.md b/_docs/query/006-query-sys-tbl.md index 9b853ec..42975d9 100644 --- a/_docs/query/006-query-sys-tbl.md +++ b/_docs/query/006-query-sys-tbl.md @@ -152,8 +152,8 @@ The default value, which is of the double, float, or long double data type; otherwise, null. For information about how to configure Drill system and session options, see[ -Planning and Execution Options](/drill/docs/planning-and-execution-options). +Planning and Execution Options](/docs/planning-and-execution-options). For information about how to configure Drill start-up options, see[ Start-Up -Options](/drill/docs/start-up-options). +Options](/docs/start-up-options). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/query/query-fs/002-query-parquet.md ---------------------------------------------------------------------- diff --git a/_docs/query/query-fs/002-query-parquet.md b/_docs/query/query-fs/002-query-parquet.md index cf19fcf..390dac4 100644 --- a/_docs/query/query-fs/002-query-parquet.md +++ b/_docs/query/query-fs/002-query-parquet.md @@ -6,7 +6,7 @@ Your Drill installation includes a `sample-data` directory with Parquet files that you can query. Use SQL syntax to query the `region.parquet` and `nation.parquet` files in the `sample-data` directory. -**Note:** Your Drill installation location may differ from the examples used here. The examples assume that Drill was installed in embedded mode on your machine following the [Apache Drill in 10 Minutes ](/drill/docs/apache-drill-in-10-minutes/)tutorial. If you installed Drill in distributed mode, or your `sample-data` directory differs from the location used in the examples, make sure to change the `sample-data` directory to the correct location before you run the queries. +**Note:** Your Drill installation location may differ from the examples used here. The examples assume that Drill was installed in embedded mode on your machine following the [Apache Drill in 10 Minutes ](/docs/apache-drill-in-10-minutes/)tutorial. If you installed Drill in distributed mode, or your `sample-data` directory differs from the location used in the examples, make sure to change the `sample-data` directory to the correct location before you run the queries. ## Region File http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/rn/004-0.6.0-rn.md ---------------------------------------------------------------------- diff --git a/_docs/rn/004-0.6.0-rn.md b/_docs/rn/004-0.6.0-rn.md index f121ebe..28111f0 100644 --- a/_docs/rn/004-0.6.0-rn.md +++ b/_docs/rn/004-0.6.0-rn.md @@ -20,7 +20,7 @@ This release is primarily a bug fix release, with [more than 30 JIRAs closed]( https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&vers ion=12327472), but there are some notable features: - * Direct ANSI SQL access to MongoDB, using the latest [MongoDB Plugin for Apache Drill](/drill/docs/mongodb-plugin-for-apache-drill) + * Direct ANSI SQL access to MongoDB, using the latest [MongoDB Plugin for Apache Drill](/docs/mongodb-plugin-for-apache-drill) * Filesystem query performance improvements with partition pruning * Ability to use the file system as a persistent store for query profiles and diagnostic information * Window function support (alpha) http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/sql-ref/001-data-types.md ---------------------------------------------------------------------- diff --git a/_docs/sql-ref/001-data-types.md b/_docs/sql-ref/001-data-types.md index e425033..491898a 100644 --- a/_docs/sql-ref/001-data-types.md +++ b/_docs/sql-ref/001-data-types.md @@ -18,7 +18,7 @@ You can use the following SQL data types in your Drill queries: * TIME * TIMESTAMP -Refer to [Supported Date/Time Data Type formats](/drill/docs/supported-date-time-data-type-formats/). +Refer to [Supported Date/Time Data Type formats](/docs/supported-date-time-data-type-formats/). #### Integer http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/sql-ref/002-operators.md ---------------------------------------------------------------------- diff --git a/_docs/sql-ref/002-operators.md b/_docs/sql-ref/002-operators.md index 79afc7d..074375a 100644 --- a/_docs/sql-ref/002-operators.md +++ b/_docs/sql-ref/002-operators.md @@ -60,7 +60,7 @@ You can use the following subquery operators in your Drill queries: * EXISTS * IN -See [SELECT Statements](/drill/docs/select-statements). +See [SELECT Statements](/docs/select-statements). ## String Operators http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/sql-ref/003-functions.md ---------------------------------------------------------------------- diff --git a/_docs/sql-ref/003-functions.md b/_docs/sql-ref/003-functions.md index 4769257..dc78569 100644 --- a/_docs/sql-ref/003-functions.md +++ b/_docs/sql-ref/003-functions.md @@ -180,6 +180,6 @@ embedded JSON data: This section contains descriptions of SQL functions that you can use to analyze nested data: - * [FLATTEN Function](/drill/docs/flatten-function) - * [KVGEN Function](/drill/docs/kvgen-function) - * [REPEATED_COUNT Function](/drill/docs/repeated-count-function) \ No newline at end of file + * [FLATTEN Function](/docs/flatten-function) + * [KVGEN Function](/docs/kvgen-function) + * [REPEATED_COUNT Function](/docs/repeated-count-function) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/sql-ref/004-nest-functions.md ---------------------------------------------------------------------- diff --git a/_docs/sql-ref/004-nest-functions.md b/_docs/sql-ref/004-nest-functions.md index 09fe91e..c6e7ff2 100644 --- a/_docs/sql-ref/004-nest-functions.md +++ b/_docs/sql-ref/004-nest-functions.md @@ -5,6 +5,6 @@ parent: "SQL Reference" This section contains descriptions of SQL functions that you can use to analyze nested data: - * [FLATTEN Function](/drill/docs/flatten-function) - * [KVGEN Function](/drill/docs/kvgen-function) - * [REPEATED_COUNT Function](/drill/docs/repeated-count-function) \ No newline at end of file + * [FLATTEN Function](/docs/flatten-function) + * [KVGEN Function](/docs/kvgen-function) + * [REPEATED_COUNT Function](/docs/repeated-count-function) \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/sql-ref/005-cmd-summary.md ---------------------------------------------------------------------- diff --git a/_docs/sql-ref/005-cmd-summary.md b/_docs/sql-ref/005-cmd-summary.md index 13d9515..3733e79 100644 --- a/_docs/sql-ref/005-cmd-summary.md +++ b/_docs/sql-ref/005-cmd-summary.md @@ -5,5 +5,5 @@ parent: "SQL Reference" The following table provides a list of the SQL commands that Drill supports, with their descriptions and example syntax: -<table ><tbody><tr><th >Command</th><th >Description</th><th >Syntax</th></tr><tr><td valign="top" >ALTER SESSION</td><td valign="top" >Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, refer to <a href="/drill/docs/planning-and-execution-options" rel="nofollow">Planning and Execution Options</a>.</td><td valign="top" ><code>ALTER SESSION SET `option_name`='string';<br />ALTER SESSION SET `option_name`=TRUE | FALSE;</code></td></tr><tr><td valign="top" >ALTER SYSTEM</td><td valign="top" >Permanently changes a system setting. The new settings persist across all sessions. For a list of Drill options and their descriptions, refer to <a href="/drill/docs/planning-and-execution-options/" rel="nofollow">Planning and Execution Options</a>.</td><td valign="top" ><code>ALTER SYSTEM `option_name`='string'<br />ALTER SYSTEM `option_name`=TRUE | FALSE;</code></td></tr><tr><td valign="top" ><a href="/drill/docs/create-table-as-ctas-command">CREATE TABLE AS<br />(CTAS)</a></p></td><td valign="top" >Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO. When you issue the CTAS command, you create a directory that contains parquet or CSV files. Each workspace in a file system has a default file type.<p>You can specify which writer you want Drill to use when creating a table: parquet, CSV, or JSON (as specified with <span style="line-height: 1.4285715;">the </span><code>store.format</code><span style="line-height: 1.4285715;"> option<span><span>).</span></span></span></p></td><td valign="top" ><code>CREATE TABLE new_table_name AS <query>;</code></td></tr><tr><td valign="top" colspan="1" >CREATE VIEW</td><td valign="top" colspan="1" >Creates a new view based on the results of a SELECT query.</td><td valign="top" colspan="1" ><code>CREATE VIEW view_name [(column_list)] AS & lt;query>;</code></td></tr><tr><td valign="top" colspan="1" >DROP VIEW</td><td valign="top" colspan="1" >Removes one or more views.</td><td valign="top" colspan="1" ><code>DROP VIEW view_name [, <em class="replaceable">view_name</em>] ...; </code></td></tr><tr><td valign="top" colspan="1" ><a href="/drill/docs/explain-commands" rel="nofollow">EXPLAIN PLAN FOR</a></td><td valign="top" colspan="1" >Returns the physical plan for a particular query.</td><td valign="top" colspan="1" ><code>EXPLAIN PLAN FOR <query>;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/drill/docs/explain-commands/" rel="nofollow">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td><td valign="top" colspan="1" >Returns the logical plan for a particular query.</td><td valign="top" colspan="1" ><code>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR <query>;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/drill/docs/select-statements" rel="nofollow">SELECT</a></td><td valign="top" cols pan="1" >Retrieves data from tables and files.</td><td valign="top" colspan="1" ><code>[WITH subquery]<br />SELECT column_list FROM table_name <br />[WHERE clause]<br />[GROUP BY clause]<br />[HAVING clause]<br />[ORDER BY clause];</code></td></tr><tr><td valign="top" colspan="1" >SHOW DATABASES</td><td valign="top" colspan="1" >Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td><td valign="top" colspan="1" ><code>SHOW DATABASES;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/drill/docs/show-files-command/" rel="nofollow">SHOW FILES</a></td><td valign="top" colspan="1" >Returns a list of files in a file system schema.</td><td valign="top" colspan="1" ><code>SHOW FILES IN filesystem.`schema_name`;<br />SHOW FILES FROM filesystem.`schema_name`;</code></td></tr><tr><td valign="top" colspan="1" >SHOW SCHEMAS</td><td valign="top" colspan="1" >Returns a list of available schemas. Equivalent to SHOW DATABASES.</td><td valign="top" colspan="1" ><code>SHOW SCHE MAS;</code></td></tr><tr><td valign="top" colspan="1" >SHOW TABLES</td><td valign="top" colspan="1" >Returns a list of tables for all schemas. Optionally, you can first issue the <code>USE </code>command to identify the schema for which you want to view tables.<br />For example, the following <code>USE</code> statement tells Drill that you only want information from the <code>hive.default</code> schema:<br /><code>USE hive.`default`;</code></td><td valign="top" colspan="1" ><code>SHOW TABLES;</code></td></tr><tr><td valign="top" colspan="1" >USE</td><td valign="top" colspan="1" >Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only.</td><td valign="top" colspan="1" ><code>USE schema_name;</code></td></tr></tbody></table> +<table ><tbody><tr><th >Command</th><th >Description</th><th >Syntax</th></tr><tr><td valign="top" >ALTER SESSION</td><td valign="top" >Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, refer to <a href="/docs/planning-and-execution-options" rel="nofollow">Planning and Execution Options</a>.</td><td valign="top" ><code>ALTER SESSION SET `option_name`='string';<br />ALTER SESSION SET `option_name`=TRUE | FALSE;</code></td></tr><tr><td valign="top" >ALTER SYSTEM</td><td valign="top" >Permanently changes a system setting. The new settings persist across all sessions. For a list of Drill options and their descriptions, refer to <a href="/docs/planning-and-execution-options/" rel="nofollow">Planning and Execution Options</a>.</td><td valign="top" ><code>ALTER SYSTEM `option_name`='string'<br />ALTER SYSTEM `option_name`=TRUE | FALSE;</code></td></tr><tr><td valign="top" ><a href="/docs /create-table-as-ctas-command">CREATE TABLE AS<br />(CTAS)</a></p></td><td valign="top" >Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO. When you issue the CTAS command, you create a directory that contains parquet or CSV files. Each workspace in a file system has a default file type.<p>You can specify which writer you want Drill to use when creating a table: parquet, CSV, or JSON (as specified with <span style="line-height: 1.4285715;">the </span><code>store.format</code><span style="line-height: 1.4285715;"> option<span><span>).</span></span></span></p></td><td valign="top" ><code>CREATE TABLE new_table_name AS <query>;</code></td></tr><tr><td valign="top" colspan="1" >CREATE VIEW</td><td valign="top" colspan="1" >Creates a new view based on the results of a SELECT query.</td><td valign="top" colspan="1" ><code>CREATE VIEW view_name [(column_list)] AS <query>;</cod e></td></tr><tr><td valign="top" colspan="1" >DROP VIEW</td><td valign="top" colspan="1" >Removes one or more views.</td><td valign="top" colspan="1" ><code>DROP VIEW view_name [, <em class="replaceable">view_name</em>] ...; </code></td></tr><tr><td valign="top" colspan="1" ><a href="/docs/explain-commands" rel="nofollow">EXPLAIN PLAN FOR</a></td><td valign="top" colspan="1" >Returns the physical plan for a particular query.</td><td valign="top" colspan="1" ><code>EXPLAIN PLAN FOR <query>;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/docs/explain-commands/" rel="nofollow">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td><td valign="top" colspan="1" >Returns the logical plan for a particular query.</td><td valign="top" colspan="1" ><code>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR <query>;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/docs/select-statements" rel="nofollow">SELECT</a></td><td valign="top" colspan="1" >Retrieves data from tables and files.</td><td valign="top" colspan="1" ><code>[WITH subquery]<br />SELECT column_list FROM table_name <br />[WHERE clause]<br />[GROUP BY clause]<br />[HAVING clause]<br />[ORDER BY clause];</code></td></tr><tr><td valign="top" colspan="1" >SHOW DATABASES</td><td valign="top" colspan="1" >Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td><td valign="top" colspan="1" ><code>SHOW DATABASES;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/docs/show-files-command/" rel="nofollow">SHOW FILES</a></td><td valign="top" colspan="1" >Returns a list of files in a file system schema.</td><td valign="top" colspan="1" ><code>SHOW FILES IN filesystem.`schema_name`;<br />SHOW FILES FROM filesystem.`schema_name`;</code></td></tr><tr><td valign="top" colspan="1" >SHOW SCHEMAS</td><td valign="top" colspan="1" >Returns a list of available schemas. Equivalent to SHOW DATABASES.</td><td valign="top" colspan="1" ><code>SHOW SCHEMAS;</code></td></tr><tr><td valign="top" colspan="1" >SHOW TABLES</td><td valign="top" colspan="1" >Returns a list of tables for all schemas. Optionally, you can first issue the <code>USE </code>command to identify the schema for which you want to view tables.<br />For example, the following <code>USE</code> statement tells Drill that you only want information from the <code>hive.default</code> schema:<br /><code>USE hive.`default`;</code></td><td valign="top" colspan="1" ><code>SHOW TABLES;</code></td></tr><tr><td valign="top" colspan="1" >USE</td><td valign="top" colspan="1" >Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only.</td><td valign="top" colspan="1" ><code>USE schema_name;</code></td></tr></tbody></table> http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/sql-ref/nested/001-flatten.md ---------------------------------------------------------------------- diff --git a/_docs/sql-ref/nested/001-flatten.md b/_docs/sql-ref/nested/001-flatten.md index 2769000..fdebbf4 100644 --- a/_docs/sql-ref/nested/001-flatten.md +++ b/_docs/sql-ref/nested/001-flatten.md @@ -85,5 +85,5 @@ the categories array, then run a COUNT function on the flattened result: +---------------|------------+ A common use case for FLATTEN is its use in conjunction with the -[KVGEN](/drill/docs/flatten-function) function. +[KVGEN](/docs/flatten-function) function. http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/sql-ref/nested/002-kvgen.md ---------------------------------------------------------------------- diff --git a/_docs/sql-ref/nested/002-kvgen.md b/_docs/sql-ref/nested/002-kvgen.md index f619864..dd4edd3 100644 --- a/_docs/sql-ref/nested/002-kvgen.md +++ b/_docs/sql-ref/nested/002-kvgen.md @@ -10,7 +10,7 @@ a map with a wide set of columns into an array of key-value pairs. In turn, you can write analytic queries that return a subset of the generated keys or constrain the keys in some way. For example, you can use the -[FLATTEN](/drill/docs/flatten-function) function to break the +[FLATTEN](/docs/flatten-function) function to break the array down into multiple distinct rows and further query those rows. @@ -26,7 +26,7 @@ KVGEN would operate on this data to generate: [{"key": "a", "value": "valA"}, {"key": "b", "value": "valB"}] [{"key": "c", "value": "valC"}, {"key": "d", "value": "valD"}] -Applying the [FLATTEN](/drill/docs/flatten-function) function to +Applying the [FLATTEN](/docs/flatten-function) function to this data would return: {"key": "a", "value": "valA"} @@ -146,5 +146,5 @@ distinct rows: +------------+ 9 rows selected (0.151 seconds) -See the description of [FLATTEN](/drill/docs/flatten-function) +See the description of [FLATTEN](/docs/flatten-function) for an example of a query against the flattened data. \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/sql-ref/nested/003-repeated-cnt.md ---------------------------------------------------------------------- diff --git a/_docs/sql-ref/nested/003-repeated-cnt.md b/_docs/sql-ref/nested/003-repeated-cnt.md index 2b332b3..f15eeda 100644 --- a/_docs/sql-ref/nested/003-repeated-cnt.md +++ b/_docs/sql-ref/nested/003-repeated-cnt.md @@ -30,4 +30,4 @@ the count to be grouped by other columns in the select list (such as `name` in this example). For another example of this function, see the following lesson in the Apache -Drill Tutorial for Hadoop: [Lesson 3: Run Queries on Complex Data Types](/drill/docs/lession-3-run-queries-on-complex-data-types/). \ No newline at end of file +Drill Tutorial for Hadoop: [Lesson 3: Run Queries on Complex Data Types](/docs/lession-3-run-queries-on-complex-data-types/). \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/tutorial/002-get2kno-sb.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/002-get2kno-sb.md b/_docs/tutorial/002-get2kno-sb.md index 9b11b9d..3ed4a01 100644 --- a/_docs/tutorial/002-get2kno-sb.md +++ b/_docs/tutorial/002-get2kno-sb.md @@ -19,7 +19,7 @@ Take a look at the pre-configured storage plugins by opening the Drill Web UI. Feel free to skip this section and jump directly to the queries: [Lesson 1: Learn About the Data -Set](/drill/docs/lession-1-learn-about-the-data-set) +Set](/docs/lession-1-learn-about-the-data-set) * Launch a web browser and go to: `http://<IP address of the sandbox>:8047` * Go to the Storage tab @@ -30,7 +30,7 @@ Set](/drill/docs/lession-1-learn-about-the-data-set) A storage plugin configuration for MapR-DB in the sandbox. Drill uses a single storage plugin for connecting to HBase as well as MapR-DB, which is an -enterprise grade in-Hadoop NoSQL database. In addition to the following brief example, see the [Registering HBase](/drill/docs/registering-hbase) for more +enterprise grade in-Hadoop NoSQL database. In addition to the following brief example, see the [Registering HBase](/docs/registering-hbase) for more information on how to configure Drill to query HBase. { @@ -150,7 +150,7 @@ connect and access from Drill. The interfaces include the following. Drill provides ODBC/JDBC drivers to connect from BI tools such as Tableau, MicroStrategy, SQUirrel, and Jaspersoft; refer to [Using ODBC to Access Apache -Drill from BI Tools](/drill/docs/odbc-jdbc-interfaces/using-odbc-to- access-apache-drill-from-bi-tools) and [Using JDBC to Access Apache Drill](/drill/docs/odbc-jdbc-interfaces#using-jdbc-to-access-apache-drill-from-squirrel) to learn +Drill from BI Tools](/docs/odbc-jdbc-interfaces/using-odbc-to- access-apache-drill-from-bi-tools) and [Using JDBC to Access Apache Drill](/docs/odbc-jdbc-interfaces#using-jdbc-to-access-apache-drill-from-squirrel) to learn more. ### SQLLine @@ -228,5 +228,5 @@ Apache Drill as you work through the tutorial. # What's Next Start running queries by going to [Lesson 1: Learn About the Data -Set](/drill/docs/lession-1-learn-about-the-data-set). +Set](/docs/lession-1-learn-about-the-data-set). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/tutorial/003-lesson1.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/003-lesson1.md b/_docs/tutorial/003-lesson1.md index 119d67f..7291965 100644 --- a/_docs/tutorial/003-lesson1.md +++ b/_docs/tutorial/003-lesson1.md @@ -390,7 +390,7 @@ subdirectories to return the total number of rows in those files. # What's Next Go to [Lesson 2: Run Queries with ANSI -SQL](/drill/docs/lession-2-run-queries-with-ansi-sql). +SQL](/docs/lession-2-run-queries-with-ansi-sql). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/tutorial/004-lesson2.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/004-lesson2.md b/_docs/tutorial/004-lesson2.md index 73c4329..0cc25ee 100644 --- a/_docs/tutorial/004-lesson2.md +++ b/_docs/tutorial/004-lesson2.md @@ -382,7 +382,7 @@ workspace, so the query specifies the full path to the file: ## What's Next -Go to [Lesson 3: Run Queries on Complex Data Types](/drill/docs/lession-3-run-queries-on-complex-data-types). +Go to [Lesson 3: Run Queries on Complex Data Types](/docs/lession-3-run-queries-on-complex-data-types). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/tutorial/005-lesson3.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/005-lesson3.md b/_docs/tutorial/005-lesson3.md index f6c7ae4..a3fe2f3 100644 --- a/_docs/tutorial/005-lesson3.md +++ b/_docs/tutorial/005-lesson3.md @@ -373,7 +373,7 @@ with a subdirectory that has the same name as the table you created. ## What's Next -Complete the tutorial with the [Summary](/drill/docs/summary). +Complete the tutorial with the [Summary](/docs/summary). http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/tutorial/006-summary.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/006-summary.md b/_docs/tutorial/006-summary.md index 552d72f..6ebae37 100644 --- a/_docs/tutorial/006-summary.md +++ b/_docs/tutorial/006-summary.md @@ -10,4 +10,4 @@ systems. Now that you are familiar with different ways to access the sample data with Drill, you can try writing your own queries against your own data sources. -Refer to the [Apache Drill documentation](/drill/docs) for more information. \ No newline at end of file +Refer to the [Apache Drill documentation](/docs) for more information. \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/tutorial/install-sandbox/001-install-mapr-vm.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/install-sandbox/001-install-mapr-vm.md b/_docs/tutorial/install-sandbox/001-install-mapr-vm.md index 9c0e19e..3fbc0f4 100644 --- a/_docs/tutorial/install-sandbox/001-install-mapr-vm.md +++ b/_docs/tutorial/install-sandbox/001-install-mapr-vm.md @@ -46,4 +46,4 @@ Drill. After downloading and installing the sandbox, continue with the tutorial by [Getting to Know the Drill -Setup](/drill/docs/getting-to-know-the-drill-sandbox). \ No newline at end of file +Setup](/docs/getting-to-know-the-drill-sandbox). \ No newline at end of file http://git-wip-us.apache.org/repos/asf/drill/blob/2856ae48/_docs/tutorial/install-sandbox/002-install-mapr-vb.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/install-sandbox/002-install-mapr-vb.md b/_docs/tutorial/install-sandbox/002-install-mapr-vb.md index 36b10c0..1f377d7 100644 --- a/_docs/tutorial/install-sandbox/002-install-mapr-vb.md +++ b/_docs/tutorial/install-sandbox/002-install-mapr-vb.md @@ -61,4 +61,4 @@ VirtualBox adapter. After downloading and installing the sandbox, continue with the tutorial by [Getting to Know the Drill -Setup](/drill/docs/getting-to-know-the-drill-sandbox). \ No newline at end of file +Setup](/docs/getting-to-know-the-drill-sandbox). \ No newline at end of file
