impala-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matthew Jacobs <jacobs...@gmail.com>
Subject Re: impala submission control
Date Wed, 07 Feb 2018 21:17:53 GMT
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 <fawzeaj@gmail.com> 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.
>

Mime
View raw message