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. Thank you all for your help. On Thu, Apr 7, 2016 at 3:48 AM, Josh Elser <josh.el...@gmail.com> wrote: > (-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 would be best to try to upgrade to a recent > release of HBase-0.98.x if at all possible (the last 0.94 release was over > a year ago). > > Also, please remember that the people helping here are volunteering their > time. Requesting preferential help is generally frowned upon. > > - Josh > > Deepak Gopalakrishnan wrote: > >> 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 <dgk...@gmail.com >> <mailto:dgk...@gmail.com>> wrote: >> >> Adding Dev group >> >> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan >> <dgk...@gmail.com <mailto:dgk...@gmail.com>> 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 >> <dgk...@gmail.com <mailto:dgk...@gmail.com>> 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 >> <jamestay...@apache.org <mailto:jamestay...@apache.org>> >> 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 >> <dgk...@gmail.com <mailto:dgk...@gmail.com>> 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 <http://a.name>=b.name <http://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 <tel:%2B918891509774> >> *Skype* : deepakgk87 >> http://myexps.blogspot.com >> >> >> >> >> -- >> Regards, >> *Deepak Gopalakrishnan* >> *Mobile*:+918891509774 <tel:%2B918891509774> >> *Skype* : deepakgk87 >> http://myexps.blogspot.com >> >> >> >> >> -- >> Regards, >> *Deepak Gopalakrishnan* >> *Mobile*:+918891509774 <tel:%2B918891509774> >> *Skype* : deepakgk87 >> http://myexps.blogspot.com >> >> >> >> >> -- >> Regards, >> *Deepak Gopalakrishnan* >> *Mobile*:+918891509774 <tel:%2B918891509774> >> *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