[GitHub] [druid] zemin-piao commented on issue #11909: Druid SQL cannot do aggregation on metric column with name "count"

[GitBox <gi...@apache.org>]

zemin-piao commented on issue #11909:
URL: https://github.com/apache/druid/issues/11909#issuecomment-973187200


   > Using `count` as is would not work as it is a keyword/function name. Try using it within quotes, like `"count"`
   > 
   > So the query would be something like `SELECT SUM("count") ...`
   
   Thanks a lot for your reply, that indeed works when the query itself is not in part of a json.
   
   The only edge case I've found is when we specify the query as part of json e.g. 
   ```{
   "query": "select sum(count) ..."
   }```
   
   Tried to use slash + quote, it does not work as well. Do we also have workaround for this scenario? 


-- 
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: commits-unsubscribe@druid.apache.org

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



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