We have count type as aggregator over table name playerevent, and have action, publisherID, campaignID as dimensions in it.
Query is as below have checked in logs, query is same just update in time interval (toTime increases in the following cycle of job)
[queryType:groupBy, dataSource:playerevent, granularity:all, dimensions:[action], aggregations:[[type:longSum, name:count, fieldName:count]], intervals:[2015-07-29T00:00:00.000Z/2015-07-29T11:46:41.000Z], filter:[type:and, fields:[[type:selector, dimension:publisherID, value:8a80813a468241a701468245fab80000], [type:selector, dimension:campaignID, value:ff8080814e95e49d014e95e909b00000], [type:or, fields:[[type:selector, dimension:action, value:Load], [type:selector, dimension:action, value:CountsAsView]]]]]]
Querying on first node of druid cluster on broker.
Attaching the cluster config files
druid.tar.gz (912 Bytes)