Support circuit breaking in SQL planning phase

[zhaohehuhu]

Enhancement

Query circuit breaking is an effective way to prevent resource abuse in a database system. When a query requires significantly more resources than the configured limits, it is terminated by the circuit breaker.

Currently, StarRocks only supports runtime circuit breaking through resource groups. It would be ideal if StarRocks could also support planning-time circuit breaking, so that expensive or unreasonable queries can be stopped before reaching execution.

I’m interested in contributing code for this feature or enhancement. My idea is to introduce new parameters in the resource group to enable planning-time circuit breaking.

Does this approach make sense?

[murphyatwork]

How does planning-time circuit breaking work? Could you outline some general concepts here?

[zhaohehuhu]

OK. Please see below:

1. Limit the number of partitions accessed during the planning phase.

2. Limit the estimated number of rows scanned during the planning phase.

@murphyatwork