[GitHub] [pinot] Jackie-Jiang commented on issue #10383: filter clause with where = or = fail or are slow

["Jackie-Jiang (via GitHub)" <gi...@apache.org>]

Jackie-Jiang commented on issue #10383:
URL: https://github.com/apache/pinot/issues/10383#issuecomment-1459088565

   The reason why `where colA = colA` is slow is because it will be converted to `where colA - colA = 0`, which involves transform.
   One solution is to remove the equality predicate when the LHS and RHS are the same.


-- 
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-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org