Slide 42
Slide 42 text
2013
{
"queryType" : "groupBy", "dataSource" : "wikipedia",
"granularity": "all",
"dimensions" : ["page"],
"orderBy" : { "type": "default",
"columns": [{"dimension": "edit_count", "direction": "DESCENDING"}],
"limit" : 10 },
"aggregations": [{"type": "longSum", "fieldName": "count", "name": "edit_count"}],
"filter" : {"type": "selector", "dimension": "country", "value": "United States"},
"intervals": ["2012-10-01T00:00/2020-01-01T00"]
}
curl -X POST 'http://localhost:8083/druid/v2/?pretty' -H 'content-type: application/
json' -d @group_by_query.body
QUERYING
GroupBy Queries
Monday, September 9, 13