hqx871 edited a comment on issue #11591:
URL: https://github.com/apache/druid/issues/11591#issuecomment-899384859
Thanks @abhishekagarwal87 and @FrankChen021. I have successfully reproduce
the Results of the PR #3820 [groupBy v2: Results not fully merged when caching
is enabled on the broker] by following steps:
1. make GroupByStrategyV2#isQueryCacheable to return true.
2. ingestion the wikiticker-2015-09-12-sampled.json.gz by dynamic partition
it into 20 segments with nearly no more than 2000 rows.
3. then take a sql as follow, and I finally got the partialy merged row as
{channel = '#es.wikipedia' and namespace in('Main')}
```
select TIME_FLOOR(__time,'PT1H') "time",
channel,
namespace,
sum(added) sum_added
from wikipedia_dynamic
where __time >='2015-09-12T00:00:00.000Z'
and __time <'2015-09-13T00:00:00.000Z'
GROUP BY TIME_FLOOR(__time,'PT1H'),channel,namespace
limit 10000
```
Finally, as @abhishekagarwal87 said, the result-level cache can be enabled.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
