Hello James,Sure I understand. But any idea why JOIN fails on the server ? Is it not supported on 2.1.2 ?ThanksDeepakOn Tue, Apr 5, 2016 at 9:48 PM, James Taylor <email@example.com> 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 <firstname.lastname@example.org> 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.
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 ?----