You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@pinot.apache.org by "Jackie-Jiang (via GitHub)" <gi...@apache.org> on 2024/07/12 22:12:08 UTC
[I] Multi-stage engine might break MV filter semantic [pinot]
Jackie-Jiang opened a new issue, #13595:
URL: https://github.com/apache/pinot/issues/13595
With the dataset in the integration test:
V1 query returns 129:
```
SELECT COUNT(*) FROM mytable WHERE DivWheelsOffs < 1416 AND DivWheelsOffs >= 2344
```
V2 query returns 0:
```
SELECT COUNT(*) FROM mytable WHERE ARRAY_TO_MV(DivWheelsOffs) < 1416 AND ARRAY_TO_MV(DivWheelsOffs) >= 2344
```
The reason is that V2 planner directly detect `ARRAY_TO_MV(DivWheelsOffs) < 1416 AND ARRAY_TO_MV(DivWheelsOffs) >= 2344` as `false`, but it might not be `false` with MV semantic. If one value matches `< 1416` and another value matches `>= 2344` we count it as match.
--
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.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
Re: [I] Multi-stage engine might break MV filter semantic [pinot]
Posted by "Jackie-Jiang (via GitHub)" <gi...@apache.org>.
Jackie-Jiang closed issue #13595: Multi-stage engine might break MV filter semantic
URL: https://github.com/apache/pinot/issues/13595
--
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
Re: [I] Multi-stage engine might break MV filter semantic [pinot]
Posted by "gortiz (via GitHub)" <gi...@apache.org>.
gortiz commented on issue #13595:
URL: https://github.com/apache/pinot/issues/13595#issuecomment-2230225704
Can we mark somehow `ARRAY_TO_MV` as a not pure function? Meaning that the returned value is not determined by the input? Something like `random()`.
--
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