From user-return-10205-apmail-drill-user-archive=drill.apache.org@drill.apache.org Tue Mar 12 18:31:58 2019 Return-Path: X-Original-To: apmail-drill-user-archive@www.apache.org Delivered-To: apmail-drill-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 506161904A for ; Tue, 12 Mar 2019 18:31:58 +0000 (UTC) Received: (qmail 27908 invoked by uid 500); 12 Mar 2019 18:31:53 -0000 Delivered-To: apmail-drill-user-archive@drill.apache.org Received: (qmail 27801 invoked by uid 500); 12 Mar 2019 18:31:53 -0000 Mailing-List: contact user-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@drill.apache.org Delivered-To: mailing list user@drill.apache.org Received: (qmail 27789 invoked by uid 99); 12 Mar 2019 18:31:53 -0000 Received: from mail-relay.apache.org (HELO mailrelay2-lw-us.apache.org) (207.244.88.137) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 12 Mar 2019 18:31:53 +0000 Received: from mail-qk1-f170.google.com (mail-qk1-f170.google.com [209.85.222.170]) by mailrelay2-lw-us.apache.org (ASF Mail Server at mailrelay2-lw-us.apache.org) with ESMTPSA id 39EF13593 for ; Tue, 12 Mar 2019 18:31:52 +0000 (UTC) Received: by mail-qk1-f170.google.com with SMTP id k130so2004904qke.3 for ; Tue, 12 Mar 2019 11:31:52 -0700 (PDT) X-Gm-Message-State: APjAAAWOYfY5gnpvkxHX1e2ZT965AfHMsbG83m4QpzyGXJtS529UK5bd eLHdvbZCk7EuVpTFqxpTFngP98hLY/1WKlcLYIY= X-Google-Smtp-Source: APXvYqzpRfnC5RZLpT0QdzEdlM0qsy8zLQ5j4+rDX/0EjgQwNEE6wG4tgtaE1gOmQRd/flkED4cOJdhhfD9kmK8DpnQ= X-Received: by 2002:a37:aec5:: with SMTP id x188mr29236154qke.320.1552415512004; Tue, 12 Mar 2019 11:31:52 -0700 (PDT) MIME-Version: 1.0 References: <7ccf3433-4603-4fe8-a947-1558f925b110@getmailbird.com> In-Reply-To: From: Kunal Khatua Date: Tue, 12 Mar 2019 11:31:48 -0700 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: Update planner/configuration keys To: user@drill.apache.org Content-Type: multipart/alternative; boundary="0000000000002311960583e9e769" --0000000000002311960583e9e769 Content-Type: text/plain; charset="UTF-8" That is correct... you'll need to run these on the command prompt for the very first time. Like profiles, I believe, the ALTER SYSTEM commands also have a permanent effect. I'm not sure if there is a way for a user to provide a pre-configured set of parameters to use during startup. You could see if setting these values in DRILL_HOME/conf/drill-override.conf helps. A lot of the values you want are originally set as defaults from an embedded file "drill-module.conf" , and drill-override.conf , well... overrides some of those values. If this doesn't work, you can file an improvement/newFeature JIRA for this, considering this is a nice feature to have. ~ Kunal On Tue, Mar 12, 2019 at 3:18 AM PRAVEEN DEVERACHETTY wrote: > Hi Kunal, But where should i keep those statements? is there any drill > startup script that i can run these alter staements? i think these scripts > only on the drill command prompt right? > > Thanks, > Praveen > > On Tue, Mar 12, 2019 at 1:02 PM Kunal Khatua wrote: > > > Executing an "alter system set param=value" usually persists the value. > > Not sure if that works for an embedded mode. > > Could you try and let us know if that works? > > On 3/11/2019 11:19:13 AM, PRAVEEN DEVERACHETTY > > wrote: > > I am using apache drill on windows platform. My requirement is to udpate > > the following parameters during apache drill startup. These parameter > > vaules may differ in each apache drill nodes. can you share me an example > > of how to update these in windows. I know another option is to run on > webUI > > or postman? i dont want to do it post installation of apache drill. i > want > > these changes to be reflected during apache drill startup. > > > > *planner.cpu_load_average - 0.7* > > *exec.queue.enable - true* > > *exec.queue.large - 2* > > *exec.queue.memory_ratio - 10.0* > > *exec.queue.memory_reserve_ratio - 0.2* > > *exec.queue.small - 4* > > > > Thanks, > > praveen > > > --0000000000002311960583e9e769--