Ignore calculations if some row has certain value in some dimension.


Is it posible in the filter, instead of decide “which rows of data should be included in the computation for a query according with a dimension’s value”, decide to ignore all rows if any has a certain value on dimension?

For example, if some of the rows ingested aggregated by dimension1, have dimension2 = error discard all name A and don’t calculate the metrics:

timestamp | dimension1 | dimension2 | metric 1

Hi Juan, you can use the NOT filter (http://druid.io/docs/latest/querying/filters.html) to filter on all values in a dimension except a certain value, and combine the NOT filter with boolean logic with other filters.