Repository: drill Updated Branches: refs/heads/gh-pages 45c29be75 -> 497e61ef2
bridget's doc changes - select page and troubleshooting page Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/497e61ef Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/497e61ef Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/497e61ef Branch: refs/heads/gh-pages Commit: 497e61ef2186eb4cc20a9789ed776dce3002f51d Parents: 45c29be Author: Bridget Bevens <[email protected]> Authored: Fri May 22 14:20:25 2015 -0700 Committer: Bridget Bevens <[email protected]> Committed: Fri May 22 14:20:25 2015 -0700 ---------------------------------------------------------------------- _docs/110-troubleshooting.md | 5 +++-- _docs/sql-reference/sql-commands/080-select.md | 19 +++++-------------- 2 files changed, 8 insertions(+), 16 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/497e61ef/_docs/110-troubleshooting.md ---------------------------------------------------------------------- diff --git a/_docs/110-troubleshooting.md b/_docs/110-troubleshooting.md index eb6f98b..b3e20ea 100644 --- a/_docs/110-troubleshooting.md +++ b/_docs/110-troubleshooting.md @@ -10,8 +10,9 @@ Before you begin troubleshooting issues that you encounter in Drill, make sure y You should also know the version of Drill running in the cluster. You can search JIRA for issues related to the version to see if a patch or workaround exists for the issue that you encountered. ### Identify the Foreman -Issue the following query to identify the node running as the Foreman: -SELECT host FROM sys.drillbits WHERE `current` = true; +Issue the following query to identify the node running as the Foreman: + + SELECT host FROM sys.drillbits WHERE `current` = true; ### Identify the Drill Version Issue the following query to identify the version of Drill running in your cluster: http://git-wip-us.apache.org/repos/asf/drill/blob/497e61ef/_docs/sql-reference/sql-commands/080-select.md ---------------------------------------------------------------------- diff --git a/_docs/sql-reference/sql-commands/080-select.md b/_docs/sql-reference/sql-commands/080-select.md index 5ee5e25..edce91c 100644 --- a/_docs/sql-reference/sql-commands/080-select.md +++ b/_docs/sql-reference/sql-commands/080-select.md @@ -35,14 +35,6 @@ Because Drill works with schema-less data sources, you cannot use positional aliases (1, 2, etc.) to refer to SELECT list columns, except in the ORDER BY clause. -## UNION ALL Set Operator - -Drill supports the UNION ALL set operator to combine two result sets. The -distinct UNION operator is not yet supported. - -The EXCEPT, EXCEPT ALL, INTERSECT, and INTERSECT ALL operators are not yet -supported. - ## Joins Drill supports ANSI standard joins in the FROM and WHERE clauses: @@ -52,12 +44,11 @@ Drill supports ANSI standard joins in the FROM and WHERE clauses: The following types of join syntax are supported: -Join type| Syntax ----|--- -Join condition in WHERE clause|FROM table1, table 2 WHERE table1.col1=table2.col1 -USING join in FROM clause|FROM table1 JOIN table2 USING(col1, ...) -ON join in FROM clause|FROM table1 JOIN table2 ON table1.col1=table2.col1 -NATURAL JOIN in FROM clause|FROM table 1 NATURAL JOIN table 2 +| Join type | Syntax | +|--------------------------------|----------------------------------------------------| +| Join condition in WHERE clause | FROM table1, table 2 WHERE table1.col1=table2.col1 | +| ON join in FROM clause | FROM table1 JOIN table2 ON table1.col1=table2.col1 | + Cross-joins are not yet supported. You must specify a join condition when more than one table is listed in the FROM clause.
