hqx871 edited a comment on issue #11591:
URL: https://github.com/apache/druid/issues/11591#issuecomment-899384859
Thanks @abhishekagarwal87 and @FrankChen021. I have successfully reproduced
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 each no more than 2000 rows.
3. set druid.broker.cache.useCache=true and
druid.broker.cache.populateCache=true for broker
4. then take a sql as follow, and I finally got the partialy merged row as
{time='2015-09-12T02:00:00.000Z', channel = '#es.wikipedia', namespace =
'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, I think we can enable result-level
caching on broker for groupBy v2.
--
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]
