ayush-san opened a new issue, #11267:
URL: https://github.com/apache/pinot/issues/11267
I sometimes get the wrong result from Pinot. Please find the query on which
I was able to reproduce the issue
```sql
SELECT CASE
WHEN ist_day_of_quarter <= 100 THEN 92
ELSE 0
END AS no_of_days, count(*)
FROM stats_OFFLINE
WHERE "timestamp" BETWEEN 1672511400000 AND 1690741800000
AND id IN (.....)
and no_of_days = 92
group by 1
```
I am able to reproduce it on other pinot tables as well
I am using **Pinot 0.11** and the table has the following index config
- `ist_day_of_quarter` -> sortedColumn, bloomFilterColumns, rangeIndexColumns
- `id` -> invertedIndexColumns, sortedColumn, bloomFilterColumns
- `timestamp` -> rangeIndexColumns
--
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]
