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 Wed, 06 Apr 2016 05:12:35 GMT
Adding Dev group

On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan <dgkris@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 <dgkris@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 <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
>>
>>
>
>
> --
> 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