You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@druid.apache.org by GitBox <gi...@apache.org> on 2020/03/11 08:41:06 UTC
[GitHub] [druid] BeanNan opened a new issue #9505: druid query Inconsistent
results returned after adjusting indicator order
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:
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
[GitHub] [druid] BeanNan commented on issue #9505: druid query Inconsistent
results returned after adjusting indicator order
Posted by GitBox <gi...@apache.org>.
BeanNan commented on issue #9505: druid query Inconsistent results returned after adjusting indicator order
URL: https://github.com/apache/druid/issues/9505#issuecomment-597512339
In addition to the basic default configuration, I also turned on druid.generic.useDefaultValueForNull=false, Other than that, it's no different
----------------------------------------------------------------
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
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org