[GitHub] [druid] JackDavidson commented on issue #10011: Druid SQL Differing Results When Grouping By 1 Column vs 1 Col With Dummy Column

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

JackDavidson commented on issue #10011:
URL: https://github.com/apache/druid/issues/10011#issuecomment-641508073


   Should I expect the first query,
   
   ```
   SELECT col1, count(*) from inline_data where col1='a' GROUP BY col1
   ```
   
   to return just one row for a?
   
   If so, the generated dimension spec probably should have been along the lines of:
   ```
       {
         "type": "listFiltered",
         "delegate": "col1",
         "values": ["a"],
         "outputType": "STRING"
       }
   ```
   
   instead of what was generated:
   ```
       {
         "type": "default",
         "dimension": "col1",
         "outputName": "d0",
         "outputType": "STRING"
       }
   ```
   
   Based on the docs for topN usage.


----------------------------------------------------------------
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@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org