walterddr opened a new issue, #9963:
URL: https://github.com/apache/pinot/issues/9963
using SSB as example, the following produce in consistent results (num of
rows)
```
select
P_MFGR,
D_YEAR,
LO_REVENUE
from lineorder
JOIN dates ON LO_ORDERDATE = D_DATEKEY
JOIN part ON LO_PARTKEY = P_PARTKEY
where 1=1
and (D_YEAR = 1997 or D_YEAR = 1998)
and P_CATEGORY = 'MFGR#14'
```
where as
```
select
P_MFGR,
LO_REVENUE
from lineorder
JOIN part ON LO_PARTKEY = P_PARTKEY
where 1=1
and P_CATEGORY = 'MFGR#14'
```
```
select
D_YEAR,
LO_REVENUE
from lineorder
JOIN dates ON LO_ORDERDATE = D_DATEKEY
where 1=1
and (D_YEAR = 1997 or D_YEAR = 1998)
```
produce correct number of rows consistently.
--
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]