fjy commented on a change in pull request #6955: update sys table docs URL: https://github.com/apache/incubator-druid/pull/6955#discussion_r252380579
########## File path: docs/content/querying/sql.md ########## @@ -587,6 +583,26 @@ Segments table provides details on all Druid segments, whether they are publishe |is_realtime|Boolean is represented as long type where 1 = true, 0 = false. 1 if this segment is being served on any type of realtime tasks| |payload|JSON-serialized data segment payload| +For example to retrieve all segments for datasource "wikipedia", use the query: + +```sql +SELECT * FROM sys.segments WHERE datasource = 'wikipedia' +``` + +Another example to retrieve segments total_size, avg_size, avg_num_rows and num_segments per datasource: + +```sql +select Review comment: can we capitalize the SQL syntax? ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org
