Interesting, but how do we manage this on a cluster? Do we have to maintain the same copy on each node? (just curious, I will use the _*MD*_.default method)
Eric *From:* Suresh Subbiah [mailto:suresh.subbia...@gmail.com] *Sent:* Tuesday, February 2, 2016 2:29 PM *To:* user@trafodion.incubator.apache.org *Subject:* Re: How to change default CQD? Hi, One can also create (or add to the file it already exists) a text file called SQSystemDefaults.conf in the directory $MY_SQROOT/etc and add attribute name and the value it should be set to in the file. I think each attribute should in a separate line and the attribute value should NOT be surrounded by single quotes as we would do from sqlci/trafci. This file is also created by install_local_hadoop. if this script was used, you may see an empty file with a few comments in your instance. Thanks Suresh On Tue, Feb 2, 2016 at 12:34 PM, Eric Owhadi <eric.owh...@esgyn.com> wrote: Thanks Anoop, So I will use the following insert statement: insert into "_MD_".defaults values ('MY_CQD', 'value of CQD', 'comment why it is inserted'); Eric *From:* Anoop Sharma [mailto:anoop.sha...@esgyn.com] *Sent:* Tuesday, February 2, 2016 12:29 PM *To:* user@trafodion.incubator.apache.org *Subject:* RE: How to change default CQD? You can change it in code by modifying the defaults array in sqlcomp/nadefaults.cpp or you can insert the default value in system defaults table trafodion.“_MD_”.defaults. If you do the insert, you will need to restart dcs servers to pick up the new value. anoop *From:* Eric Owhadi [mailto:eric.owh...@esgyn.com] *Sent:* Tuesday, February 2, 2016 10:26 AM *To:* user@trafodion.incubator.apache.org *Subject:* How to change default CQD? Hello Trafodioneers, I have seen in the code that there is a way to globally change the default Control Query Default values. But I can’t find it in the docs. Can someone help me on this? Regards, Eric
