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 ? #!/bin/sh mkdir /home/hadoop/phoenix/ wget http://mirror.fibergrid.in/apache/phoenix/phoenix-4.7.0-HBase-0.98/bin/phoenix-4.7.0-HBase-0.98-bin.tar.gz -P /home/hadoop/phoenix/ cd /home/hadoop/phoenix/ tar -xvf phoenix-4.7.0-HBase-0.98-bin.tar.gz cp -r phoenix-4.7.0-HBase-0.98-bin/phoenix-*.jar /home/hadoop/hbase/lib/ On Tue, Apr 5, 2016 at 10:39 PM, Deepak Gopalakrishnan <[email protected]> wrote: > 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 <[email protected]> > wrote: > >> 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 <[email protected]> >> wrote: >> >>> 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 the SQL query is not even being >>> parsed. I'm not sure what I'm doing here. I'm using the sqline client on >>> the server itself. >>> >>> select A.name,B.dname from A as a inner join B as b on a.name=b.name; >>> >>> Error: ERROR 602 (42P00): Syntax error. Missing "EOF" at line 1, column >>> 35. (state=42P00,code=602) >>> Please let me know if you guys can help ? >>> >>> -- >>> Regards, >>> *Deepak Gopalakrishnan* >>> *Mobile*:+918891509774 >>> *Skype* : deepakgk87 >>> http://myexps.blogspot.com >>> >>> > > > -- > Regards, > *Deepak Gopalakrishnan* > *Mobile*:+918891509774 > *Skype* : deepakgk87 > http://myexps.blogspot.com > > -- Regards, *Deepak Gopalakrishnan* *Mobile*:+918891509774 *Skype* : deepakgk87 http://myexps.blogspot.com
