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]

Reply via email to