rohangarg commented on issue #12311:
URL: https://github.com/apache/druid/issues/12311#issuecomment-1059704043
@cheezman34 : Thanks for reporting the issue! I think the issue is because
of a filter explosion that happens in one of the join optimizations if the
number of OR filters in the query is big-ish (as you observed). The filter you
have in the query : `("field1", "field2") IN (('a1, 'a2'), ('b1, 'b2'),
{more_values})` gets rewritten as `(("field1" = 'a1' AND 'field2' = 'a2') OR
("field1" = 'b1' AND 'field2' = 'b2') ...)`
Can you try your query with disabling `enableJoinFilterPushDown` and
`useFilterCNF` query context flags? I believe that should fix the OOM in
historical. I'm working on a fix which avoid this filter explosion and will put
it up very soon
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
