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 <[email protected]> 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 <[email protected]> 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 <[email protected]> > > 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 > > >
