Hi Matt, I created the pools manually and it’s completely nfigurations as shown in b.
On Wed, 7 Feb 2018 at 23:17 Matthew Jacobs <[email protected]> wrote: > 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. > > >
