Re: Join create OOM with java heap space on phoenix client

2015-06-30 Thread Maryann Xue
issue? Thanks, Krunal. From: Maryann Xue maryann@gmail.com Date: Tuesday, June 16, 2015 at 3:20 PM To: Krunal krunal.varaj...@ask.com Cc: user@phoenix.apache.org user@phoenix.apache.org Subject: Re: Join create OOM with java heap space on phoenix client Hi Krunal, Can you try

Re: Join create OOM with java heap space on phoenix client

2015-06-30 Thread Krunal Varajiya
@gmail.com Date: Tuesday, June 30, 2015 at 6:17 AM To: Krunal krunal.varaj...@ask.commailto:krunal.varaj...@ask.com Cc: user@phoenix.apache.orgmailto:user@phoenix.apache.org user@phoenix.apache.orgmailto:user@phoenix.apache.org Subject: Re: Join create OOM with java heap space on phoenix client Yes

Re: Join create OOM with java heap space on phoenix client

2015-06-29 Thread Krunal Varajiya
krunal.varaj...@ask.commailto:krunal.varaj...@ask.com Cc: user@phoenix.apache.orgmailto:user@phoenix.apache.org user@phoenix.apache.orgmailto:user@phoenix.apache.org Subject: Re: Join create OOM with java heap space on phoenix client Hi Krunal, Can you try with merge join by specifying the hint

Re: Join create OOM with java heap space on phoenix client

2015-06-16 Thread Krunal Varajiya
@phoenix.apache.org Subject: Re: Join create OOM with java heap space on phoenix client Hi Krunal, Thanks for the explanation! I am back to work now. Could you please also post the table definition? I have some guess here, but need more information to confirm. And which version of Phoenix are you using

Re: Join create OOM with java heap space on phoenix client

2015-06-10 Thread Krunal Varajiya
@phoenix.apache.orgmailto:user@phoenix.apache.org user@phoenix.apache.orgmailto:user@phoenix.apache.org Subject: Re: Join create OOM with java heap space on phoenix client Hi Krunal, Sorry for the late reply. I have been on vacation. 1. Can you make sure that the connection/statement is closed after each run

Re: Join create OOM with java heap space on phoenix client

2015-06-01 Thread Maryann Xue
From: Maryann Xue maryann@gmail.com Reply-To: user@phoenix.apache.org user@phoenix.apache.org Date: Tuesday, May 26, 2015 at 5:45 PM To: user@phoenix.apache.org user@phoenix.apache.org Subject: Re: Join create OOM with java heap space on phoenix client Hi Krunal, Sorry for the late

Re: Join create OOM with java heap space on phoenix client

2015-05-27 Thread Krunal Varajiya
@phoenix.apache.org Subject: Re: Join create OOM with java heap space on phoenix client Hi Krunal, Sorry for the late reply. I have been on vacation. 1. Can you make sure that the connection/statement is closed after each run of your query (even with exception)? I think this is related to second issue

Re: Join create OOM with java heap space on phoenix client

2015-05-26 Thread Maryann Xue
Hi Krunal, Sorry for the late reply. I have been on vacation. 1. Can you make sure that the connection/statement is closed after each run of your query (even with exception)? 2. You might want to try switching the join tables in your query first by putting the larger table as LHS, and if it

Join create OOM with java heap space on phoenix client

2015-05-20 Thread Krunal Varajiya
Hi I have 2 issues with phoenix client: 1. Heap memory is not cleanup after each query is finished. So, it keeps increasing every time when we submit new query. 2. I am try to do a normal join operation on two tables but getting exception. Below is the details: These are some sample