amrishlal opened a new issue, #9820: URL: https://github.com/apache/pinot/issues/9820
Pinot currently supports numerical type conversion of literal values in WHERE clause as shown in the examples below: ``` select runs from baseballStats WHERE runs = 10.0 select runs from baseballStats WHERE runs = 10.3 select runs from baseballStats WHERE runs != 10.3 select runs from baseballStats WHERE runs > 6.5 AND runs < 10.23 ``` This support was added through PR https://github.com/apache/pinot/pull/6811 and https://github.com/apache/pinot/pull/6927. However, Pinot still doesn't support type conversion of literal values that may appear in the IN clause. For example, the queries shown below will throw exceptions: ``` select runs from baseballStats WHERE runs IN (5.0, 6, 7.2) select runs from baseballStats WHERE runs NOT IN (5.0, 6, 7.2) ``` We would like to extend the type conversion mechanism in `NumericalFilterOptimizer` to cover IN and NOT_IN clauses as well. One side effect of this change would be that we would need to make another pass over all the literal values specified in IN or NOT_IN clause when these clauses are present in the query. -- 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.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
