You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by ji...@apache.org on 2019/06/27 22:08:25 UTC
[incubator-druid] branch 0.15.0-incubating updated: fix SQL doc
comment (#7981) (#7982)
This is an automated email from the ASF dual-hosted git repository.
jihoonson pushed a commit to branch 0.15.0-incubating
in repository https://gitbox.apache.org/repos/asf/incubator-druid.git
The following commit(s) were added to refs/heads/0.15.0-incubating by this push:
new bedd9b0 fix SQL doc comment (#7981) (#7982)
bedd9b0 is described below
commit bedd9b0e050550e5e67051856657dc7ac9b5f0cd
Author: Jihoon Son <ji...@apache.org>
AuthorDate: Thu Jun 27 15:08:20 2019 -0700
fix SQL doc comment (#7981) (#7982)
---
docs/content/querying/sql.md | 26 +++++++++++++-------------
1 file changed, 13 insertions(+), 13 deletions(-)
diff --git a/docs/content/querying/sql.md b/docs/content/querying/sql.md
index bf7fb04..6c68a5f 100644
--- a/docs/content/querying/sql.md
+++ b/docs/content/querying/sql.md
@@ -22,12 +22,12 @@ title: "SQL"
~ under the License.
-->
- <!--
- The format of the tables that describe the functions and operators
- should not be changed without updating the script create-sql-function-doc
- in web-console/script/create-sql-function-doc, because the script detects
- patterns in this markdown file and parse it to TypeScript file for web console
- -->
+<!--
+ The format of the tables that describe the functions and operators
+ should not be changed without updating the script create-sql-function-doc
+ in web-console/script/create-sql-function-doc, because the script detects
+ patterns in this markdown file and parse it to TypeScript file for web console
+-->
# SQL
@@ -666,22 +666,22 @@ SERVER_SEGMENTS is used to join servers with segments table
|server|STRING|Server name in format host:port (Primary key of [servers table](#SERVERS-table))|
|segment_id|STRING|Segment identifier (Primary key of [segments table](#SEGMENTS-table))|
-JOIN between "servers" and "segments" can be used to query the number of segments for a specific datasource,
+JOIN between "servers" and "segments" can be used to query the number of segments for a specific datasource,
grouped by server, example query:
```sql
-SELECT count(segments.segment_id) as num_segments from sys.segments as segments
-INNER JOIN sys.server_segments as server_segments
-ON segments.segment_id = server_segments.segment_id
-INNER JOIN sys.servers as servers
+SELECT count(segments.segment_id) as num_segments from sys.segments as segments
+INNER JOIN sys.server_segments as server_segments
+ON segments.segment_id = server_segments.segment_id
+INNER JOIN sys.servers as servers
ON servers.server = server_segments.server
-WHERE segments.datasource = 'wikipedia'
+WHERE segments.datasource = 'wikipedia'
GROUP BY servers.server;
```
### TASKS table
-The tasks table provides information about active and recently-completed indexing tasks. For more information
+The tasks table provides information about active and recently-completed indexing tasks. For more information
check out [ingestion tasks](#../ingestion/tasks.html)
|Column|Type|Notes|
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org