[HAWQ-47] Make user able to set statement level resource usage.

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0.0-incubating
• Component/s: Resource Manager
• Assignee: Yi Jin
• Reporter: Yi Jin
• Created: 13/Oct/15 01:53
• Updated: 21/Nov/15 02:59
• Resolved: 21/Nov/15 02:58

Description

SET STATEMENT_VSEG_MEM=memory_units
SET STATEMENT_NVSEG=<integer>
memory_units ::= 128mb|256mb|512mb|1024mb|1gb|2gb|4gb|8gb|16gb

Resource manager will try to reserve expected resource for current statement execution. The default value of STATEMENT_NVSEG is 0, which means the statement level setting is not activated, when STATEMENT_NVSEG is greater than zero, STATEMENT_MEM overrides the resource queue virtual segment resource quota. Memory core ratio derived by resource queue hierarchy and cluster capacity.

If the expected resource specified by STATEMENT_MEM and STATEMENT_NVSEG can not be satisfied due to various reason, the session is timed out.

Yi Jin <[e-mail]>
Oct 8 (5 days ago)

to Lei, Jiali, Amy
1) If the expected resource specified by STATEMENT_MEM and STATEMENT_NVSEG can not be satisfied due to queue capacity limits, the error is reported at once, the session is aborted;

2) The setting of statement level resource may cause different query plan generated; (Change code for passing this into optimizer??)

3) If the expected resource can not be satisfied by the other various reasons, the session is timed out.