You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@doris.apache.org by Joice Jacob <jo...@gmail.com> on 2023/09/06 06:48:42 UTC
Doris Workload group
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 ' 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 & Regards,
Joice Jacob
Re:Doris Workload group
Posted by 李乾丰 <li...@flywheels.com>.
You can bind a user to a workload group through: set property 'user1' = 'workload_group1';
external programs can access doris through this user.
Can it solve your problem?
李乾丰
liqianfeng@selectdb.com
签名由 网易灵犀办公 定制
Original:
From:Joice Jacob <jo...@gmail.com>Date:2023-09-06 14:48:42(中国 (GMT+08:00))To:dev<de...@doris.apache.org>Cc:Subject:Doris Workload group 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 ' 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 & Regards,
Joice Jacob
回复:Doris Workload group
Posted by 王博 <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>;
发送时间: 2023年9月6日(星期三) 下午3:18
收件人: "dev"<dev@doris.apache.org>;
主题: Doris Workload group
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 ' 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 & Regards,
Joice Jacob