davidagee commented on a change in pull request #7863: Added the web console to
the quickstart tutorials and docs
URL: https://github.com/apache/incubator-druid/pull/7863#discussion_r293053053
##########
File path: docs/content/tutorials/tutorial-query.md
##########
@@ -33,91 +33,80 @@ The tutorial assumes that you've already completed one of
the 4 ingestion tutori
* [Tutorial: Loading a file using
Hadoop](../tutorials/tutorial-batch-hadoop.html)
* [Tutorial: Loading stream data using
Tranquility](../tutorials/tutorial-tranquility.html)
-## Native JSON queries
+Druid queries are sent over HTTP.
+The Druid console includes a view to issue queries to Druid and nicely format
the results.
-Druid's native query format is expressed in JSON. We have included a sample
native TopN query under `quickstart/tutorial/wikipedia-top-pages.json`:
+## Druid SQL queries
-```json
-{
- "queryType" : "topN",
- "dataSource" : "wikipedia",
- "intervals" : ["2015-09-12/2015-09-13"],
- "granularity" : "all",
- "dimension" : "page",
- "metric" : "count",
- "threshold" : 10,
- "aggregations" : [
- {
- "type" : "count",
- "name" : "count"
- }
- ]
-}
-```
+Druid supports a dialect of SQL for querying.
This query retrieves the 10 Wikipedia pages with the most page edits on
2015-09-12.
-Let's submit this query to the Druid Broker:
-
-```bash
-curl -X 'POST' -H 'Content-Type:application/json' -d
@quickstart/tutorial/wikipedia-top-pages.json
http://localhost:8082/druid/v2?pretty
+```
+SELECT page, COUNT(*) AS Edits
+FROM wikipedia
+WHERE "__time" BETWEEN TIMESTAMP '2015-09-12 00:00:00' AND TIMESTAMP
'2015-09-13 00:00:00'
+GROUP BY page ORDER BY Edits DESC
+LIMIT 10
```
-You should see the following query results:
+Let's look at the different ways to issue this query.
-```json
-[ {
- "timestamp" : "2015-09-12T00:46:58.771Z",
- "result" : [ {
- "count" : 33,
- "page" : "Wikipedia:Vandalismusmeldung"
- }, {
- "count" : 28,
- "page" : "User:Cyde/List of candidates for speedy deletion/Subpage"
- }, {
- "count" : 27,
- "page" : "Jeremy Corbyn"
- }, {
- "count" : 21,
- "page" : "Wikipedia:Administrators' noticeboard/Incidents"
- }, {
- "count" : 20,
- "page" : "Flavia Pennetta"
- }, {
- "count" : 18,
- "page" : "Total Drama Presents: The Ridonculous Race"
- }, {
- "count" : 18,
- "page" : "User talk:Dudeperson176123"
- }, {
- "count" : 18,
- "page" : "Wikipédia:Le Bistro/12 septembre 2015"
- }, {
- "count" : 17,
- "page" : "Wikipedia:In the news/Candidates"
- }, {
- "count" : 17,
- "page" : "Wikipedia:Requests for page protection"
- } ]
-} ]
-```
+### Query SQL via the console
-## Druid SQL queries
+You can issue the above query from the console.
+
+
+
+The console query view provides autocomplete together with inline function
documentation.
+You can also configure extra context flags get sent with the query from the
more options menu.
Review comment:
"You can also configure extra content flags to be sent with.." or "...
**to** get sent with"?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
