drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [06/12] drill git commit: fix links in gh-pages-master
Date Tue, 17 Mar 2015 21:02:47 GMT
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 &lt;query&gt;;</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&gt;;</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 &lt;query&gt;;</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 &lt;query&gt;;</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 &lt;query&gt;;</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&gt;;</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 &lt;query&gt;;</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 &lt;query&gt;;</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


Mime
View raw message