Filter by Lookup Value when Lookup Key is not known

Apache Druid Q&A Google Groups
#1

I have a use case, where multiple IDs map to the same value in a lookup, e.g. multiple app-ids belong to a single account manager.

In my Druid Query, I would like to filter by the lookup Value (account manager) directly and not by the Key(app-ids). Is this possible with Lookup feature? if not possible is there any alternate way?

#2

yes you can use a selector filter and pass to it your lookup spec

http://druid.io/docs/latest/querying/filters.html#filtering-with-extraction-functions

#3

The example was helpful. Thank you.