Adding Dev group On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan <[email protected]> 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 ), 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 > > -- Regards, *Deepak Gopalakrishnan* *Mobile*:+918891509774 *Skype* : deepakgk87 http://myexps.blogspot.com
