Repository: drill Updated Branches: refs/heads/gh-pages-master 0119fdde5 -> e73f2ec17
http://git-wip-us.apache.org/repos/asf/drill/blob/e73f2ec1/_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 8082f88..0a08af6 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></div> +<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></div> http://git-wip-us.apache.org/repos/asf/drill/blob/e73f2ec1/_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/e73f2ec1/_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/e73f2ec1/_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/e73f2ec1/_docs/tutorial/002-get2kno-sb.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/002-get2kno-sb.md b/_docs/tutorial/002-get2kno-sb.md index 3ed1929..3850daf 100644 --- a/_docs/tutorial/002-get2kno-sb.md +++ b/_docs/tutorial/002-get2kno-sb.md @@ -139,5 +139,5 @@ You have a number of data sources to explore. For example, analyzing customer r # 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/e73f2ec1/_docs/tutorial/003-lesson1.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/003-lesson1.md b/_docs/tutorial/003-lesson1.md index 577ede3..d92a8be 100644 --- a/_docs/tutorial/003-lesson1.md +++ b/_docs/tutorial/003-lesson1.md @@ -380,7 +380,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/e73f2ec1/_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/e73f2ec1/_docs/tutorial/005-lesson3.md ---------------------------------------------------------------------- diff --git a/_docs/tutorial/005-lesson3.md b/_docs/tutorial/005-lesson3.md index b3bb83d..e913952 100644 --- a/_docs/tutorial/005-lesson3.md +++ b/_docs/tutorial/005-lesson3.md @@ -369,7 +369,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/e73f2ec1/_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/e73f2ec1/_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 da8ddd9..73daa6d 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/e73f2ec1/_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 9d4fb3b..e72abf9 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
