Aggregators filtered by bound not working (Druid 0.9.0)

Hello,

I want to apply a bound filter to an aggregator such as the following:

{

“context”:{“queryId”:“38184d28-0bdd-4380-9faf-fd41fbb31d47”},

“queryType”:“topN”,

“intervals”:[“2016-06-01/2016-06-07”],

“dataSource”:“ip_queries_daily_v2”,

“granularity”:“all”,

“filter”: {

“dimension”:“key”,

“type”:“selector”,

“value”:“69ebb01236ad838fa07cce7ab97dd9a3”

},

“aggregations” : [

{

“type” : “filtered”,

“filter” : {

“type”: “bound”,

“dimension”: “date”,

“upper”: “2016-06-01”,

“alphaNumeric”: true

},

“aggregator” : {

“type” : “longSum”,

“name” : “filtered_count”,

“fieldName” : “count”

}

},

{

“type” : “longSum”,

“name” : “total_count”,

“fieldName” : “count”

}

],

“threshold”: 10,

“dimension”: “sid”,

“metric”: “filtered_count”

}

``

I get the following:

{

“error” : “Unknown exception”

}

``

If I replace the “bound” filter in the aggregator with an “in” filter mapping all dates in the interval of concern, then it works, but I assume this is slower than a bound filter.

Are bound filters not supported in filtered aggregators?

Hey Carlos,

Until 0.9.1.1, not all filters worked with filtered aggregators. This should work if you update to 0.9.1.1.

Awesome, thank you Gian. I will update once I get a chance.