AnalyticDB for MySQL Data Lakehouse Edition (V3.0) allows you to specify a resource group to execute queries. If you do not specify a resource group to execute queries, the user_default resource group is used. The method that is used to specify a resource group varies based on whether you submit SQL queries or Spark applications. For example, if you use Java Database Connectivity (JDBC) to submit a XIHE SQL query, you can specify a resource group by adding a hint to SQL statements or associating the resource group with a database account. If you use the Job Development page in the AnalyticDB for MySQL console to submit a Spark SQL query or a Spark application, you can select a resource group on the Job Development page. This topic describes how to specify a resource group when you submit XIHE SQL queries, Spark SQL queries, or Spark applications.
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.
Use the Job Development page to submit Spark SQL queries or Spark applications
You can select a resource group on the Job Development page in the AnalyticDB for MySQL console. In this case, you cannot specify a resource group by adding a hint to SQL statements or associating the resource group with a database account.
Use API operations to submit Spark applications
You can call the SumbitSparkApp operation and use the ResourceGroupName parameter to specify a resource group. For more information, see SubmitSparkApp.
Use other methods to submit Spark applications
For information about how to specify a resource group when you use AnalyticDB for MySQL spark-submit to submit Spark applications, see Use spark-submit to develop Spark applications.
For information about how to specify a resource group when you use AnalyticDB for MySQL SDK for Python to submit Spark applications, see Use AnalyticDB for MySQL SDK for Python to develop Spark applications.