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: [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]
