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 07:27:56 GMT
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 <dgkris@gmail.com>
wrote:

> 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
>
>


-- 
Regards,
*Deepak Gopalakrishnan*
*Mobile*:+918891509774
*Skype* : deepakgk87
http://myexps.blogspot.com

Mime
View raw message