Can anyone please guide me on how to perform filter on metrics in druid.
With Druid SQL (http://druid.io/docs/latest/querying/sql), if you mean filtering on numeric columns, that can be done in the WHERE clause. If you mean filtering on aggregator values, that can be done with the HAVING clause.
With imply version 1.2.1, I was trying the WHERE clause on metrics and this is the error I received.
There was an error getting the data: can not convert $plr:NUMBER = 0 to filter because it references an un-filterable metric ‘plr’ which is most likely rolled up.
Is this feature available on the latest version of imply ?