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 <[email protected]>
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: [email protected]
For additional commands, e-mail: [email protected]
