Type: New Feature
Fix Version/s: Exasol 7.1.0
The Consumer Groups allow defining properties on a role basis.
They allow fine-grained control of the resource-utilization among users and roles.
In the past, the query timeout could only be set on session and system level.
This new feature allows specifying query timeout within the consumer group.
The query timeout is integrated in the consumer groups (QUERY_TIMEOUT attribute)
- Attribute type is decimal(6,0), defined for values in the interval <1 , 999999>, in seconds or 0 representing UNLIMITED
- Attribute value can be set independent of system and session parameters QUERY_TIMEOUT.
- When a query is executed the minimum value between session QUERY_TIMEOUT and the user consumer group QUERY_TIMEOUT is considered, to terminate the query if this value is reached.