mihai-cazacu-adswizz opened a new issue #6969: The materialized view returns different results than the base data source URL: https://github.com/apache/incubator-druid/issues/6969 The query that is using the base data source: ``` { "query": { "context": { "useCache": false, "populateCache": false, "timeout": 3600000 }, "dataSource": "the-kafka-data-source", "queryType": "groupBy", "aggregations": [ { "fieldName": "metricASum", "name": "metricASum", "type": "longSum" } ], "dimensions": [ "dimA" ], "granularity": "all", "intervals": [ "2019-01-30T00:01Z/2019-01-31T23:59Z" ], "limitSpec": { "limit": 1, "type": "default" } }, "queryType": "view" } ``` and its result: ``` [ { "version": "v1", "timestamp": "2019-01-30T00:01:00.000Z", "event": { "client": "dimA", "metricASum": 4342 } } ] ``` And the one that uses the view (the same query, only the `dataSource` is changed): ``` { "query": { "context": { "useCache": false, "populateCache": false, "timeout": 3600000 }, "dataSource": "the-kafka-data-view-source", "queryType": "groupBy", "aggregations": [ { "fieldName": "metricASum", "name": "metricASum", "type": "longSum" } ], "dimensions": [ "dimA" ], "granularity": "all", "intervals": [ "2019-01-30T00:01Z/2019-01-31T23:59Z" ], "limitSpec": { "limit": 1, "type": "default" } }, "queryType": "view" } ``` and its result: ``` [ { "version": "v1", "timestamp": "2019-01-30T00:01:00.000Z", "event": { "client": "dimA", "metricASum": 291 } } ] ``` The spec and the payloads can be found [here](https://github.com/apache/incubator-druid/issues/6945).
---------------------------------------------------------------- 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: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@druid.apache.org For additional commands, e-mail: commits-h...@druid.apache.org