[GitHub] [pinot] abhioncbr opened a new issue, #11691: [multistage] IS NULL/ IS NOT NULL getting skipped from the queries using multistage

[via GitHub]

abhioncbr opened a new issue, #11691:
URL: https://github.com/apache/pinot/issues/11691

   Explain query results for the case/when transformation function based on 
NULL value comparison shows skipping of the transformation function. For example
   
   ```bash
   EXPLAIN PLAN FOR SELECT CASE WHEN ArrTimeBlk IS NOT NULL THEN 'null11' ELSE 
ArrTimeBlk END AS val FROM airlineStats 
   
   Execution Plan
   LogicalProject(val=['null11':VARCHAR])
     LogicalTableScan(table=[[airlineStats]])
   ```
   
   another example
   
   ```bash
   EXPLAIN PLAN FOR SELECT CASE WHEN ArrTimeBlk IS NULL THEN 'null11' ELSE 
ArrTimeBlk END AS val FROM airlineStats 
   
   Execution Plan
   LogicalProject(val=[$10])
     LogicalTableScan(table=[[airlineStats]])
   
   ```
   
   `Where` clause based query
   
   ```bash
   EXPLAIN PLAN FOR SELECT ArrTimeBlk FROM airlineStats where ArrTimeBlk is not 
null
   Execution Plan
   LogicalProject(ArrTimeBlk=[$10])
     LogicalTableScan(table=[[airlineStats]])
   
   EXPLAIN PLAN FOR SELECT ArrTimeBlk FROM airlineStats where ArrTimeBlk is null
   Execution Plan
   LogicalValues(tuples=[[]])
   ```
   
   Using docker pinot:1.0.0 release image


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

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


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