Trying to run an Druid SQL query which only return rows where either the columnA value is in a list of values from a sub query, OR columnB is in a list of different (but potentially) overlapping values. They don’t both have to be in their respective list, but at least one needs to be.
SELECT * FROM foo
WHERE colA IN (SELECT colX From XX where colY = 1)
OR colB IN (SELECT colX FROM XX where colY = 2)
I get the error
Unknown Exception / Detected duplicate prefix in join clauses
I have no idea what this error is trying to tell me. It works fine with the AND operator, just has issues with the OR... any help appreciated!