Hi Siddharth,
Thank you for attaching the log file! I didn't find any insufficient memory error, so my previous guess should be wrong. But unfortunately I couldn't seem to find any other useful information from the log regarding the exception you got. So the best way to identify the problem is to get full stack trace of your exception. Maybe you can try running the query in your JDBC environment instead of in sqlline. As to the configuration file, you just need to make sure that the "hbase-site.xml" file is included in your CLASSPATH both for the server side and the client side, and you can just put all your needed attributes into that file. Thanks, Maryann On Wed, Dec 10, 2014 at 9:35 AM, Siddharth Ubale < [email protected]> wrote: > Hi , > > > > I am adding the log file(the exception log captured at 19:45) for the > case where I have received the exception. Also I am sending my > hbase-site.xml . > > Do let me know if any inputs from your side. > > > > Thanks, > > Siddharth > > > > *From:* Siddharth Ubale > *Sent:* Wednesday, December 10, 2014 7:43 PM > *To:* '[email protected]' > *Subject:* Exception in sub plan[0] exception - multi inner join > > > > Hi , > > > > We have been trying to run a multi table inner join query .However very > often we get a error message :”.Encountered exception in sub plan [0] > execution.”. > > Since we had posted this message earlier to this forum, we had received a > response saying that there are three parameters which have to be added , > which are : > > > > *1. **<property>* > > *<name>phoenix.query.maxServerCacheBytes</name>* > > *<value>409,715,200</value>* > > *</property>* > > > > *2. * > > *<property>* > > *<name>phoenix.query.maxGlobalMemoryPercentage</name>* > > *<value>39</value>* > > *</property>* > > > > *3. **<property>* > > *<name>phoenix.coprocessor.maxServerCacheTimeToLiveMs</name>* > > *<value>60000</value>* > > *</property>* > > > > > > > > Along with this we have also gone through the Phoenix tuning parameters on > phoenix tuning page as well as Hbase configuration settings and added the > recommended ones. > > > > But still we are getting the above mentioned error. Also, we are seeing a > lag of 120 – 200 secs on the query which is : > > > > select /*+ NO_STAR_JOIN */ * from "Address_1" as a > > inner join "Customers_1" as c on c."C_Id" = a."A_C_Id" > > inner join "Orders_1" as o on o."O_C_Id" = a."A_C_Id" > > inner join "Order_Details_1" as od on od."O_Id" = o."O_Id" > > inner join "Payterms" as p on p."Payt_Id" = o."O_Pay_Terms" > > inner join "Shipterms" as s on s."Shipt_Id" = > o."O_Ship_Terms" > > where c."C_Id" = '69088'; > > > > all the above tables have more than 2million + records. > > > > Also, if somebody could let us know whether hbase-site.xml in phoenix > installation folder also needs to be updated with the following changes?? > Or it should contain only the one property mentioned there?? > > > > > > > > Thanks, > > Siddharth Ubale, > > *Synchronized Communications * > > *#43, Velankani Tech Park, Block No. II, * > > *3rd Floor, Electronic City Phase I,* > > *Bangalore – 560 100* > > *Tel : +91 80 3202 4060 <%2B91%2080%203202%204060>* > > *Web:* *www.syncoms.com* <http://www.syncoms.com/> > > *[image: LogoNEWmohLARGE]* > > *London*|*Bangalore*|*Orlando* > > > > *we innovate, plan, execute, and transform the business* > > > -- Thanks, Maryann
