Hello All,
Will appreciate any insight of what i'm missing in my configuration to get
the impala submission control working as expected ....
a- Here is my placement Placement Rule:
1- Use the pool Specified at run time., only if the pool exists.
2- Use the pool root.[secondary group].
3- Use the pool root.default.
b- Here is the impala resource pools
Name Max Memory Max Running Queries Max Queued Queries Queue
Timeout Default Query Memory Limit Access Control
root.impiaas Unlimited Unlimited
200 1 minute(s) No
Default Custom
root.impreports Unlimited Unlimited
200 1 minute(s) No Default
Custom
C- Here is my Access control for root.impiaas pool:
Allow these users and groups to submit to this pool
Users: fawzea
The same for impreports the allowed user and groups to submit to pool is
only nira.
LDAP groups for fawzea user:
Member in groups:
- dba
- impiaas
- mysql
LDAP group for nira user
Member in groups:
- dba
- impreports
- mysql
Impala Queries UI shows:
1- select count(*) from dv_entersiteevent_prq_remote where year=2017
User: fawzea
Pool: root.impiaas
2- select count(*) from dv_entersiteevent_prq_remote where year=2017 and
month=10
User: nira
Pool: root.impreports
As shown above that the queries submitted based on the secondary group rule.
When i'm running the following with fawzea user:
set request_pool=impreports;
select count(*) from dv_entersiteevent_prq_remote where year=2017 and
month=10;
I can see that the query is running with impreports pool.
What i'm missing here in my configuration to get this works as expected.
