drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [26/31] drill git commit: fix links
Date Mon, 18 May 2015 23:36:49 GMT
fix links


Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/97016752
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/97016752
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/97016752

Branch: refs/heads/gh-pages
Commit: 97016752fabe792acb57375538f356983d007e2c
Parents: 9700ff6
Author: Kristine Hahn <khahn@maprtech.com>
Authored: Mon May 18 13:51:54 2015 -0700
Committer: Kristine Hahn <khahn@maprtech.com>
Committed: Mon May 18 13:51:54 2015 -0700

----------------------------------------------------------------------
 _docs/sql-reference/sql-commands/005-supported-sql-commands.md | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill/blob/97016752/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
----------------------------------------------------------------------
diff --git a/_docs/sql-reference/sql-commands/005-supported-sql-commands.md b/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
index 37a08eb..df604cb 100644
--- a/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
+++ b/_docs/sql-reference/sql-commands/005-supported-sql-commands.md
@@ -6,4 +6,4 @@ The following table provides a list of the SQL commands that Drill supports,
 with their descriptions and example syntax:
 
 <table style='table-layout:fixed;width:100%'>
-    <tr><th >Command</th><th >Description</th><th >Syntax</th></tr><tr><td
valign="top" width="15%"><a href="/docs/alter-session">ALTER SESSION</a></td><td
valign="top" width="60%">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">Planning and Execution Options</a>.</td><td
valign="top"><pre>ALTER SESSION SET `&lt;option_name&gt;`=&lt;value&gt;;</pre></td></tr><tr><td
valign="top" ><a href="/docs/alter-system">ALTER SYSTEM</a></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">Planning
and Execution Options</a>.</td><td valign="top" ><pre>ALTER SYSTEM
SET `&lt;option_name&gt;`=&lt;value&gt;;</pre></td></tr><tr><td
valign="top" ><p><a href="/docs/create-table-as--cta
 s">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.<br />You can specify which writer you want Drill to
use when creating a table: parquet, CSV, or JSON (as specified with the <code>store.format</code>
option).</td><td valign="top" ><pre class="programlisting">CREATE TABLE
new_table_name AS &lt;query&gt;;</pre></td></tr><tr><td
- valign="top" ><a href="/docs/create-view">CREATE VIEW </a></td><td
- valign="top" >Creates a virtual structure for the result set of a stored query.-</td><td
-valign="top" ><pre>CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name
[, ...]) ] AS &lt;query&gt;;</pre></td></tr><tr><td  valign="top"
><a href="/docs/describe">DESCRIBE</a></td><td 
  valign="top" >Returns information about columns in a table or view.</td><td
valign="top" ><pre>DESCRIBE [workspace.]table_name|view_name</pre></td></tr><tr><td
valign="top" ><a href="/docs/drop-view-command">DROP VIEW</a></td><td
valign="top" >Removes a view.</td><td valign="top" ><pre>DROP VIEW [workspace.]view_name
;</pre></td></tr><tr><td  valign="top" ><a href="/docs/explain">EXPLAIN
PLAN FOR</a></td><td valign="top" >Returns the physical plan for a particular
query.</td><td valign="top" ><pre>EXPLAIN PLAN FOR &lt;query&gt;;</pre></td></tr><tr><td
valign="top" ><a href="/docs/explain">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td><td
valign="top" >Returns the logical plan for a particular query.</td><td  valign="top"
><pre>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR &lt;query&gt;;</pre></td></tr><tr><td
colspan="1" valign="top" ><a href="/docs/select" rel="nofollow">SELECT</a></td><td
valign="top" >Retrieves data from tables and files.</td><td  valign="top" ><pre>[WITH
subquery]<
 br />SELECT column_list FROM table_name <br />[WHERE clause]<br />[GROUP BY
clause]<br />[HAVING clause]<br />[ORDER BY clause];</pre></td></tr><tr><td
 valign="top" ><a href="/docs/show-databases-and-show-schemas">SHOW DATABASES </a></td><td
valign="top" >Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td><td
valign="top" ><pre>SHOW DATABASES;</pre></td></tr><tr><td
valign="top" ><a href="/docs/show-files" >SHOW FILES</a></td><td valign="top"
>Returns a list of files in a file system schema.</td><td valign="top" ><pre>SHOW
FILES IN filesystem.`schema_name`;<br />SHOW FILES FROM filesystem.`schema_name`;</pre></td></tr><tr><td
valign="top" ><a href="/docs/show-databases-and-show-schemas">SHOW SCHEMAS</a></td><td
- valign="top" >Returns a list of available schemas. Equivalent to SHOW DATABASES.</td><td
valign="top" ><pre>SHOW SCHEMAS;</pre></td></tr><tr><td
valign="top" ><a href="/docs/show-tables">SHOW TABLES</a></td><td
valign="top" >Returns a list of tables and v
 iews.</td><td valign="top" ><pre>SHOW TABLES;</pre></td></tr><tr><td
valign="top" ><a href="/docs/use">USE</a></td><td valign="top" >Change
to a particular schema. When you opt to use a particular schema, Drill issues queries on that
schema only.</td><td valign="top" ><pre>USE schema_name;</pre></td></tr></table>
+    <tr><th >Command</th><th >Description</th><th >Syntax</th></tr><tr><td
valign="top" width="15%"><a href="/docs/alter-session">ALTER SESSION</a></td><td
valign="top" width="60%">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">Planning and Execution Options</a>.</td><td
valign="top"><pre>ALTER SESSION SET `&lt;option_name&gt;`=&lt;value&gt;;</pre></td></tr><tr><td
valign="top" ><a href="/docs/alter-system">ALTER SYSTEM</a></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">Planning
and Execution Options</a>.</td><td valign="top" ><pre>ALTER SYSTEM
SET `&lt;option_name&gt;`=&lt;value&gt;;</pre></td></tr><tr><td
valign="top" ><p><a href="/docs/create-table-as--cta
 s">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.<br />You can specify which writer you want Drill to
use when creating a table: parquet, CSV, or JSON (as specified with the <code>store.format</code>
option).</td><td valign="top" ><pre class="programlisting">CREATE TABLE
new_table_name AS &lt;query&gt;;</pre></td></tr><tr><td
- valign="top" ><a href="/docs/create-view">CREATE VIEW </a></td><td
- valign="top" >Creates a virtual structure for the result set of a stored query.-</td><td
-valign="top" ><pre>CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name
[, ...]) ] AS &lt;query&gt;;</pre></td></tr><tr><td  valign="top"
><a href="/docs/describe">DESCRIBE</a></td><td 
  valign="top" >Returns information about columns in a table or view.</td><td
valign="top" ><pre>DESCRIBE [workspace.]table_name|view_name</pre></td></tr><tr><td
valign="top" ><a href="/docs/drop-view">DROP VIEW</a></td><td valign="top"
>Removes a view.</td><td valign="top" ><pre>DROP VIEW [workspace.]view_name
;</pre></td></tr><tr><td  valign="top" ><a href="/docs/explain">EXPLAIN
PLAN FOR</a></td><td valign="top" >Returns the physical plan for a particular
query.</td><td valign="top" ><pre>EXPLAIN PLAN FOR &lt;query&gt;;</pre></td></tr><tr><td
valign="top" ><a href="/docs/explain">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td><td
valign="top" >Returns the logical plan for a particular query.</td><td  valign="top"
><pre>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR &lt;query&gt;;</pre></td></tr><tr><td
colspan="1" valign="top" ><a href="/docs/select" rel="nofollow">SELECT</a></td><td
valign="top" >Retrieves data from tables and files.</td><td  valign="top" ><pre>[WITH
subquery]<br />SEL
 ECT column_list FROM table_name <br />[WHERE clause]<br />[GROUP BY clause]<br
/>[HAVING clause]<br />[ORDER BY clause];</pre></td></tr><tr><td
 valign="top" ><a href="/docs/show-databases-and-show-schemas">SHOW DATABASES </a></td><td
valign="top" >Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td><td
valign="top" ><pre>SHOW DATABASES;</pre></td></tr><tr><td
valign="top" ><a href="/docs/show-files" >SHOW FILES</a></td><td valign="top"
>Returns a list of files in a file system schema.</td><td valign="top" ><pre>SHOW
FILES IN filesystem.`schema_name`;<br />SHOW FILES FROM filesystem.`schema_name`;</pre></td></tr><tr><td
valign="top" ><a href="/docs/show-databases-and-show-schemas">SHOW SCHEMAS</a></td><td
- valign="top" >Returns a list of available schemas. Equivalent to SHOW DATABASES.</td><td
valign="top" ><pre>SHOW SCHEMAS;</pre></td></tr><tr><td
valign="top" ><a href="/docs/show-tables">SHOW TABLES</a></td><td
valign="top" >Returns a list of tables and views.</t
 d><td valign="top" ><pre>SHOW TABLES;</pre></td></tr><tr><td
valign="top" ><a href="/docs/use">USE</a></td><td valign="top" >Change
to a particular schema. When you opt to use a particular schema, Drill issues queries on that
schema only.</td><td valign="top" ><pre>USE schema_name;</pre></td></tr></table>


Mime
View raw message