BeanNan opened a new issue #9505: druid query Inconsistent results returned after adjusting indicator order URL: https://github.com/apache/druid/issues/9505 ### Affected Version 0.17.0 ### Description The same query statement, after adjusting the order of the indicators, the number of data returned is inconsistent ### Configurations in use single server, medium config ### code ``` select name, avg(pbmrq), sum(pbmrq), std-dev(pbmrq) from "datasource" group by name response data count:10288 ``` change metric order ``` select name, avg(pbmrq), std-dev(pbmrq), sum(pbmrq) from "datasource" group by name response data count: 100 ``` 10288 vs 100? The same query, but the order is different, the returned data entries should be consistent, but now the data is obviously lost I don't know if anyone has the same problem, I tried to close the *query context cache*. After closing, the two returned the same amount., 10288=10288 I ’m not sure if it ’s a *cache* issue, I ’ll keep watching to see if it will happen again, cache type is the default type : *caffeine*
---------------------------------------------------------------- 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: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
