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:05:52 UTC
[incubator-druid] branch master updated: fix SQL doc comment (#7981)
This is an automated email from the ASF dual-hosted git repository.
jihoonson pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/incubator-druid.git
The following commit(s) were added to refs/heads/master by this push:
new ad45ef1 fix SQL doc comment (#7981)
ad45ef1 is described below
commit ad45ef12ed62bcf0b92b47bd06dcc5b1ac7dc573
Author: Vadim Ogievetsky <va...@gmail.com>
AuthorDate: Thu Jun 27 15:05:45 2019 -0700
fix SQL doc comment (#7981)
---
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 8921fe0..89a48c7 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
@@ -676,22 +676,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