Re: Getting InsufficientMemoryException

2014-09-25 Thread G.S.Vijay Raajaa
Hi Xue, Thanks for replying. I did modify the hbase-site.xml by increasing the default value of phoenix.query.maxGlobalMemoryPercentage . Also increased the Region server heap space memory . The change didn't get reflected and I still get the error with an indication that global pool of

Re: Recursive queries?

2014-09-25 Thread Jean-Marc Spaggiari
Hi James, Thanks for the feedback. My knowledge of Phoenix and SQL is not good enough for now to jump on such a big patch. Regarding your suggesting with UPSERT SELECT and temp table, the question is when do we know we should stop. I upsert select from the first level, then do that again with

Re: Subqueries: Missing LPAREN

2014-09-25 Thread Maryann Xue
Hi JM, Sorry that I made a mistake earlier. Your query should be covered by https://issues.apache.org/jira/browse/PHOENIX-945. Will keep you updated on the progress of that issue. Thanks, Maryann On Wed, Sep 24, 2014 at 3:41 PM, Jean-Marc Spaggiari jean-m...@spaggiari.org wrote: Hi