Details
Description
We've observed that large queries, doing order/group by leading to issues on the regionserver (crashes/long gc pauses/file handler exhaustion etc.). We should make spilling to disk configurable and in case its disabled, fail the query once it hits the spilling limit on any of the region servers. Also make spooling threshold server-side property only to prevent clients from controlling memory allocation on the rs side.