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]

Reply via email to