You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Eric Fukuda <e....@gmail.com> on 2016/05/20 03:49:17 UTC

Configuring the number of threads

Hi,

I'm trying to configure the number of threads that run on each drill node
in a cluster, but haven't succeeded. I tried:

$ bin/drillbit.sh start -Dplanner.width.max_per_node=1

but the value remained 3 (the default value). I also tried adding the
following line in conf/drill_override.conf:

planner.width.max_per_node: 1

but got the same result. Does anyone know how to change this value?

Thanks,
Eric

Re: Configuring the number of threads

Posted by Eric Fukuda <e....@gmail.com>.

Thanks Aman, ALTER command worked. I must have overlooked the link to the
"Planning and Execution Options".
- Eric


On Fri, May 20, 2016 at 1:08 AM, Aman Sinha <am...@apache.org> wrote:

> From inside a sqlline session you can do:
>    ALTER SYSTEM SET `planner.width.max_per_node` = 1 ;   // if you want it
> system-wide, otherwise use SESSION instead of SYSTEM
>
> Another way is to go to the web UI and select the 'Options' tab on the
> upper right and set the corresponding system option from there.
>
> On Thu, May 19, 2016 at 8:49 PM, Eric Fukuda <e....@gmail.com> wrote:
>
> > Hi,
> >
> > I'm trying to configure the number of threads that run on each drill node
> > in a cluster, but haven't succeeded. I tried:
> >
> > $ bin/drillbit.sh start -Dplanner.width.max_per_node=1
> >
> > but the value remained 3 (the default value). I also tried adding the
> > following line in conf/drill_override.conf:
> >
> > planner.width.max_per_node: 1
> >
> > but got the same result. Does anyone know how to change this value?
> >
> > Thanks,
> > Eric
> >
>

Re: Configuring the number of threads

Posted by Aman Sinha <am...@apache.org>.

From inside a sqlline session you can do:
   ALTER SYSTEM SET `planner.width.max_per_node` = 1 ;   // if you want it
system-wide, otherwise use SESSION instead of SYSTEM

Another way is to go to the web UI and select the 'Options' tab on the
upper right and set the corresponding system option from there.

On Thu, May 19, 2016 at 8:49 PM, Eric Fukuda <e....@gmail.com> wrote:

> Hi,
>
> I'm trying to configure the number of threads that run on each drill node
> in a cluster, but haven't succeeded. I tried:
>
> $ bin/drillbit.sh start -Dplanner.width.max_per_node=1
>
> but the value remained 3 (the default value). I also tried adding the
> following line in conf/drill_override.conf:
>
> planner.width.max_per_node: 1
>
> but got the same result. Does anyone know how to change this value?
>
> Thanks,
> Eric
>