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?