phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <josh.el...@gmail.com>
Subject Re: Error while attempting join query
Date Wed, 06 Apr 2016 22:18:00 GMT
(-cc dev@phoenix)

Deepak,

As the name suggests, that release is targeted for HBase-0.98.x release 
lines. Any compatibility of an older release of HBase than 0.98 is 
likely circumstantial.

I can't speak on behalf of the HBase community, but I feel relatively 
confident in suggesting that it would be best to try to upgrade to a 
recent release of HBase-0.98.x if at all possible (the last 0.94 release 
was over a year ago).

Also, please remember that the people helping here are volunteering 
their time. Requesting preferential help is generally frowned upon.

- Josh

Deepak Gopalakrishnan wrote:
> 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
> <mailto:dgkris@gmail.com>> wrote:
>
>     Adding Dev group
>
>     On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan
>     <dgkris@gmail.com <mailto: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 <mailto: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 <mailto: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 <mailto: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 <http://a.name>=b.name <http://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 <tel:%2B918891509774>
>                     *Skype* : deepakgk87
>                     http://myexps.blogspot.com
>
>
>
>
>             --
>             Regards,
>             *Deepak Gopalakrishnan*
>             *Mobile*:+918891509774 <tel:%2B918891509774>
>             *Skype* : deepakgk87
>             http://myexps.blogspot.com
>
>
>
>
>         --
>         Regards,
>         *Deepak Gopalakrishnan*
>         *Mobile*:+918891509774 <tel:%2B918891509774>
>         *Skype* : deepakgk87
>         http://myexps.blogspot.com
>
>
>
>
>     --
>     Regards,
>     *Deepak Gopalakrishnan*
>     *Mobile*:+918891509774 <tel:%2B918891509774>
>     *Skype* : deepakgk87
>     http://myexps.blogspot.com
>
>
>
>
> --
> Regards,
> *Deepak Gopalakrishnan*
> *Mobile*:+918891509774
> *Skype* : deepakgk87
> http://myexps.blogspot.com
>

Mime
View raw message