AnalyticDB for MySQL Data Warehouse Edition (V3.0) allows you to specify a resource group to execute queries by adding a hint to SQL statements or associating the resource group with a database account. If you do not specify a resource group to execute queries, the USER_DEFAULT resource group is used. This topic describes how to specify a resource group when you submit SQL queries.
Use JDBC to submit SQL queries
You can use one of the following methods to specify a resource group to execute queries:
Add a hint to SQL statements. Syntax:
/*+resource_group=resourceGroupName*/.Associate a resource group with a database account. For more information, see Associate with or disassociate from a database account.
If you do not specify a resource group, the USER_DEFAULT resource group is used.
If you specify multiple resource groups by using the preceding methods, the resource groups take effect in the following order based on priority: hint-based resource group, associated resource group, and default resource group.