[GitHub] [druid] sirianni commented on issue #5566: Applying doubleSum over doubleFirst aggregations in nested groupBy fails

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

sirianni commented on issue #5566:
URL: https://github.com/apache/druid/issues/5566#issuecomment-1245513163

   @jihoonson is it safe to explicitly set `"finalized": true` in the inner query `context` as an alternative to using an `expression` `postAggregator`?
   
   I assume the broker will reset `finalized` to `false` so that it gets the unfinalized results from the historicals.  I've tested in a single machine setup, but wanted to confirm that this is expected to work properly in a fully distributed environment with multiple historicals.
   
   ```json
   {
     "queryType": "groupBy",
     "dataSource": {
       "type": "query",
       "query": {
         "queryType": "groupBy",
         "dataSource": "twitter",
         "aggregations": [
           {
             "type": "doubleFirst",
             "name": "tweets",
             "fieldName": "tweets"
           }
         ],
         "context": {
           "finalize": true
         }
         "dimensions": [
           "lang"
         ],
         "intervals": "2018-07-27/2018-07-28",
         "granularity": "hour"
       }
     },
     "intervals": "2018-07-27/2018-07-28",
     "granularity": "hour",
     "aggregations": [
       {
         "type": "doubleSum",
         "name": "value_num",
         "fieldName": "tweets"
       }
     ],
     "dimensions": []
   }
   ```


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