[GitHub] awelsh93 opened a new issue #6447: Bug: Zero filling time buckets below the queryGranularity

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

awelsh93 opened a new issue #6447: Bug: Zero filling time buckets below the queryGranularity
URL: https://github.com/apache/incubator-druid/issues/6447
 
 
   I think I've come across an issue where a query with a granularity less than the queryGranularity of the datasource results in empty time buckets. For example this query:
   
   ```
   {
       "queryType": "topN",
       "threshold": 3,
       "dimension": "dimension",
       "metric": "metric",
       "dataSource": "datasource",
       "granularity": "second",
       "aggregations": [
           {
               "type": "longSum",
               "fieldName": "fieldName",
               "name": "name"
           }
       ],
       "postAggregations": [],
       "intervals": "2018-10-10T00:00:00/2018-10-10T00:00:03"
   }
   ```
   where the datasource has minute granularity. The results of the query:
   
   ```
   [
       {
           "timestamp": "2018-10-10T00:00:00.000Z",
           "result": [
               {
                   "dimension": "12891",
                   "metric": 6795
               },
               {
                   "dimension": "7145",
                   "metric": 6595
               },
               {
                   "dimension": "8429",
                   "metric": 5991
               }
           ]
       },
       {
           "timestamp": "2018-10-10T00:00:01.000Z",
           "result": []
       },
       {
           "timestamp": "2018-10-10T00:00:02.000Z",
           "result": []
       }
   ]
   ```
   
   The first object is what I expected and matches what is returned when the granularity is set to minute in the query. This issue only seems to affect this datasource in our cluster (running 0.12.0) and gets ingested by the kafka indexing service. Is anyone able to reproduce or explain this issue?

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on 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


With regards,
Apache Git Services

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