Query with where clause fieldA != fieldB


I looked around and did not find anything related to my question.

Is it possible in Druid to query for example TopN where the fieldA of an entry is ‘not equal’ to fieldB?

I am tracking pageViews and store those events in Druid. But i want to exclude “self views”.

This means fieldA would be the id of the user this page belongs to. fieldB would be the id of the user who views the page.

I was also thinking about resolving this before inserting the data, but maybe it is also possible via runtime.

Cheers Armin

Hey Armin,

This isn’t currently possible at runtime but is slated to be possible in 0.10.1. You can follow the related patch here: https://github.com/druid-io/druid/pull/3928