How, more specifically, are you configuring these pools? Can you share the configuration files?
On Wed, Feb 7, 2018 at 11:42 AM, Fawze Abujaber <[email protected]> wrote: > 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. >
