Jackie-Jiang opened a new pull request, #15027:
URL: https://github.com/apache/pinot/pull/15027
An attempt to fix #13617
The idea is to:
1. Do not convert IN/NOT_IN to OR lists when converting Sql to Rel. Calcite
will make it a JOIN query.
2. Convert the JOIN query back to IN/NOT_IN using a rule
It works for simple cases, but starts failing when there is another
condition joined with OR (e.g. `WHERE col1 IN ('a', 'b') OR col2 > 0`). Calcite
is rewriting it into a very complex expression within
`SqlToRelConverter.translateIn()`, and I'm not able to find a workaround to
turn it off.
--
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: commits-unsubscr...@pinot.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org
