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:
us...@infra.apache.org



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

Reply via email to