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
