I have a question about the groupBy.result and the groupBy.intermediateRows … if I think fine … The historical, the broker and the realtime tasks have this properties:
The first is used to compute the groupBy queries but this size is not the result is only the number of rows that the the nodes use to compute the result.
The second value is the maximum number of the rows that the node can compute to make a result and return back to the broker.
When the historical and realtime tasks get back the result to the broker. The broker merges this results and does something similar. If the rows increase more that the number of the second properties the node throws a exception like: " Limit number of rows." or something similar, isn’t??
I also know that the groupBy queries are processing using the HEAP memory so:
I think that I should configure these properties based on my heap memory… Is this correct? How can I calculate the correct values to this properties??
I think that the broker need higher values than historical or realtime tasks because the broker need to merge these values to get a big value … isn’t ??
Regards and thanks,