回复：Doris Workload group

[王博 <50...@qq.com.INVALID>]

A user can have access to multiple workload groups.
You can specify which group to use when query in two places;
1, user default property; exec 'SHOW PROPERTY for root like '%default_workload_group%';' you can see user's property default_workload_group, if you don't exec 'set workload_group=xxx', then default_workload_group could be used.
2, session variables; a username may be used in many jdbc  connection, every jdbc connection can set its owned workload_group variables. for example, a username is 'jack', it can visit workload group 'g1,g2', then
jdbc connection 1, exec 'set workload_group=g1'
jdbc connection 2, exec  'set workload_group=g2'

then workload group is choosed.





王博
506340561@qq.com



 




------------------ 原始邮件 ------------------
发件人:                                                                                                                        "dev"                                                                                    <joicejacob1910@gmail.com&gt;;
发送时间:&nbsp;2023年9月6日(星期三) 下午3:18
收件人:&nbsp;"dev"<dev@doris.apache.org&gt;;

主题:&nbsp;Doris Workload group



&nbsp; Hello team,

I've been exploring worker groups within Apache Doris. I've successfully
configured a worker group in the command line using the property ' set
workload_group&nbsp; ' and tested it, and it's functioning as expected.

I have a concern regarding how to choose a particular worker group when
using Apache Doris from an external application.

Thanks &amp; Regards,
Joice Jacob