sundeepks opened a new issue, #13677: URL: https://github.com/apache/druid/issues/13677
I am performing single aggregation using theta sketches while doing so facing the below error org.apache.druid.query.QueryException: Not enough merge buffer memory to execute this query. Try enabling disk spilling by setting druid.query.groupBy.maxOnDiskStorage to an amount of bytes available on your machine for on-disk scratch files. Or, if you have additional off-heap memory available, consider increasing druid.processing.buffer.sizeBytes. See https://druid.apache.org/docs/latest/querying/groupbyquery.html#memory-tuning-and-resource-limits for details. Even after increasing the value of maxOnDiskStorage as indicated below.. facing still an issue Broker druid.query.groupBy.maxOnDiskStorage=10000000000 druid.processing.buffer.sizeBytes=2000MiB druid.processing.numMergeBuffers=16 Historical druid.processing.buffer.sizeBytes=2000MiB druid.processing.numMergeBuffers=8 druid.processing.numThreads=31 Using the version apache-druid-25.0.0 on ec2 ubuntu machine with 32 vcpu & 256 ram & 400G ssd (3% used) Although same query is running fine via multi-stage-query -- 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]
