You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/05/22 23:20:57 UTC
drill git commit: bridget's doc changes - select page and
troubleshooting page
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 <bb...@maprtech.com>
Authored: Fri May 22 14:20:25 2015 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
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.