Slackbot
04/27/2023, 6:50 AMImran Imran
04/27/2023, 7:16 AMdruid.processing.buffer.sizeBytes is the size of the in-memory buffer Druid uses for storing intermediate query results (that it then performs operations on).
GroupBy queries with large intermediate result sets can require more than this buffer. We only support a size of up to 2GB for this buffer; the default size is 1 GB.
For larger buffers, you can spill these results out of memory and onto disk. That is what druid.query.groupBy.maxOnDiskStorage does.
You could first try increasing druid.processing.buffer.sizeBytes to 2G in Broker runtime properties and check