You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@pinot.apache.org by GitBox <gi...@apache.org> on 2020/11/05 19:27:26 UTC

[GitHub] [incubator-pinot] fx19880617 commented on issue #6243: Support more than 1 condition in CASE WHEN statement

fx19880617 commented on issue #6243:
URL: https://github.com/apache/incubator-pinot/issues/6243#issuecomment-722591145


   This query can be written as:
   
   ```
   SELECT
       CASE
           WHEN 'timestamp' >= 1587077057690 THEN 0
           WHEN 'timestamp' >= 1587073457690 THEN 1
           ELSE 0
       END AS columnA,
       SUM(someId)
   FROM testTable
   GROUP BY columnA
   ```


----------------------------------------------------------------
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.

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



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