abhioncbr commented on issue #10513:
URL: https://github.com/apache/pinot/issues/10513#issuecomment-1491179833
It's not specific to the above query. It's happening for all queries without
the `ELSE` clause. Here are more examples
```
SELECT intCol, CASE WHEN intCol % 2 = 0 THEN intCol END AS intVal, strCol
FROM {tbl1}
SELECT intCol, CASE WHEN floatCol > 4.0 THEN floatCol END AS floatVal,
strCol FROM {tbl1}
SELECT intCol, CASE WHEN doubleCol > 6.0 THEN doubleCol END AS doubleVal,
strCol FROM {tbl1}
SELECT intCol, CASE WHEN longCol > 10 THEN longCol * 4 END AS longVal,
strCol FROM {tbl1}
```
--
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]