phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deepak Gopalakrishnan <dgk...@gmail.com>
Subject Re: Error while attempting join query
Date Tue, 05 Apr 2016 17:09:30 GMT
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 <jamestaylor@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 <dgkris@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=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

Mime
View raw message