Re: Error while attempting join query

2016-04-07 Thread James Heather
I'm also interested to hear about this! Please do give more info! On 7 Apr 2016 7:00 p.m., "James Taylor" wrote: > I'm interested in the "how". Thanks for sharing this info, Steve. > > James > > On Thu, Apr 7, 2016 at 8:30 AM, Steve Terrell > wrote: > >> I've been successful at running HBase

Re: Error while attempting join query

2016-04-07 Thread Steve Terrell
OK, check out http://stackoverflow.com/questions/32208549/how-to-use-newer-versions-of-hbase-on-amazon-elastic-mapreduce . Worked for me! I'm using EMR AMI.3.10.0 . On Thu, Apr 7, 2016 at 1:00 PM, James Taylor wrote: > I'm interested in the "how". Thanks for sharing this info, Steve. > > J

Re: Error while attempting join query

2016-04-07 Thread James Taylor
I'm interested in the "how". Thanks for sharing this info, Steve. James On Thu, Apr 7, 2016 at 8:30 AM, Steve Terrell wrote: > I've been successful at running HBase 0.98.15 and Phoenix 4.6.0 on EMR. > Found someone else's solution for this on the internet. Been working fine > for months.

Re: Error while attempting join query

2016-04-07 Thread Steve Terrell
I've been successful at running HBase 0.98.15 and Phoenix 4.6.0 on EMR. Found someone else's solution for this on the internet. Been working fine for months. Downside is loss of some Amazon EMR tools like HBase backups to S3. If anyone else is interested in the "how", post a new email to this ma

Re: Error while attempting join query

2016-04-06 Thread Deepak Gopalakrishnan
Hello All, I apologise if I sounded persistent. It was not my intention at all, was just adding more detail to the thread in hope of getting a solution. I completely understand the issue, but Amazon EMR does not support anything > 0.94.18. But, we've decided to move away from EMR and embrace HDP.

Re: Error while attempting join query

2016-04-06 Thread Josh Elser
(-cc dev@phoenix) Deepak, As the name suggests, that release is targeted for HBase-0.98.x release lines. Any compatibility of an older release of HBase than 0.98 is likely circumstantial. I can't speak on behalf of the HBase community, but I feel relatively confident in suggesting that it w

Re: Error while attempting join query

2016-04-06 Thread Deepak Gopalakrishnan
Hello All, Does the package available here : http://a.mbbsindia.com/phoenix/phoenix-4.6.0-HBase-0.98/bin/ support HBase-0.94.18 ? If not, is there a version that is supported for HBase-0.94.18 ? Please help! On Wed, Apr 6, 2016 at 10:42 AM, Deepak Gopalakrishnan wrote: > Adding Dev group > >

Re: Error while attempting join query

2016-04-05 Thread Deepak Gopalakrishnan
Adding Dev group On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan wrote: > Hello All, > > I did move on to 4.7 and my HBase version is 0.98+. Below is the script I > execute in order to get it installed before HBase is started. > > > > After doing this on all nodes ( including master ), wh

Re: Error while attempting join query

2016-04-05 Thread Deepak Gopalakrishnan
Hello All, I did move on to 4.7 and my HBase version is 0.98+. Below is the script I execute in order to get it installed before HBase is started. After doing this on all nodes ( including master ), when I try a ./sqline.py localhost, it just freezes and doesnt proceed. Can someone please help

Re: Error while attempting join query

2016-04-05 Thread Deepak Gopalakrishnan
Hello James, Sure I understand. But any idea why JOIN fails on the server ? Is it not supported on 2.1.2 ? Thanks Deepak On Tue, Apr 5, 2016 at 9:48 PM, James Taylor wrote: > Support for the 2.x line was dropped over a year ago. I'd recommend > encouraging the EMR folks to upgrade to the lates

Re: Error while attempting join query

2016-04-05 Thread James Taylor
Support for the 2.x line was dropped over a year ago. I'd recommend encouraging the EMR folks to upgrade to the latest version of Phoenix and HBase. On Tuesday, April 5, 2016, Deepak Gopalakrishnan wrote: > Hello, > > I'm trying to join two tables that I created using Phoenix. My tables are > A

Error while attempting join query

2016-04-05 Thread Deepak Gopalakrishnan
Hello, I'm trying to join two tables that I created using Phoenix. My tables are A and B. I've setup phoenix on EMR using https://phoenix.apache.org/phoenix_on_emr.html. I've used the phoenix-2.1.2 version and I can do basic queries like SELECT. But when I try a join, I get an error. It looks like