You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by Deepak Gopalakrishnan <dg...@gmail.com> on 2016/04/06 07:12:35 UTC
Re: Error while attempting join query
Adding Dev group
On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan <dg...@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 <dg...@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 <ja...@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 <dg...@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
Re: Error while attempting join query
Posted by James Heather <ja...@mendeley.com>.
I'm also interested to hear about this! Please do give more info!
On 7 Apr 2016 7:00 p.m., "James Taylor" <ja...@apache.org> wrote:
> I'm interested in the "how". Thanks for sharing this info, Steve.
>
> James
>
> On Thu, Apr 7, 2016 at 8:30 AM, Steve Terrell <st...@oculus360.us>
> wrote:
>
>> I've been successful at running HBase 0.98.15 and Phoenix 4.6.0 on EMR.
>> Found someone else's solution for this on the internet. Been working fine
>> for months. Downside is loss of some Amazon EMR tools like HBase backups
>> to S3. If anyone else is interested in the "how", post a new email to this
>> mailing list with a new subject heading.
>>
>> Thanks,
>> Steve
>>
>> On Wed, Apr 6, 2016 at 9:22 PM, Deepak Gopalakrishnan <dg...@gmail.com>
>> wrote:
>>
>>> Hello All,
>>>
>>> I apologise if I sounded persistent. It was not my intention at all, was
>>> just adding more detail to the thread in hope of getting a solution.
>>>
>>> I completely understand the issue, but Amazon EMR does not support
>>> anything > 0.94.18. But, we've decided to move away from EMR and embrace
>>> HDP.
>>>
>>> Thank you all for your help.
>>>
>>> On Thu, Apr 7, 2016 at 3:48 AM, Josh Elser <jo...@gmail.com> wrote:
>>>
>>>> (-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
>>>>> <ma...@gmail.com>> wrote:
>>>>>
>>>>> Adding Dev group
>>>>>
>>>>> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan
>>>>> <dgkris@gmail.com <ma...@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 <ma...@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 <ma...@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 <ma...@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
>>>>>
>>>>>
>>>
>>>
>>> --
>>> Regards,
>>> *Deepak Gopalakrishnan*
>>> *Mobile*:+918891509774
>>> *Skype* : deepakgk87
>>> http://myexps.blogspot.com
>>>
>>>
>>
>
Re: Error while attempting join query
Posted by Steve Terrell <st...@oculus360.us>.
OK, check out
http://stackoverflow.com/questions/32208549/how-to-use-newer-versions-of-hbase-on-amazon-elastic-mapreduce
. Worked for me!
I'm using EMR AMI.3.10.0 .
On Thu, Apr 7, 2016 at 1:00 PM, James Taylor <ja...@apache.org> wrote:
> I'm interested in the "how". Thanks for sharing this info, Steve.
>
> James
>
> On Thu, Apr 7, 2016 at 8:30 AM, Steve Terrell <st...@oculus360.us>
> wrote:
>
>> I've been successful at running HBase 0.98.15 and Phoenix 4.6.0 on EMR.
>> Found someone else's solution for this on the internet. Been working fine
>> for months. Downside is loss of some Amazon EMR tools like HBase backups
>> to S3. If anyone else is interested in the "how", post a new email to this
>> mailing list with a new subject heading.
>>
>> Thanks,
>> Steve
>>
>> On Wed, Apr 6, 2016 at 9:22 PM, Deepak Gopalakrishnan <dg...@gmail.com>
>> wrote:
>>
>>> Hello All,
>>>
>>> I apologise if I sounded persistent. It was not my intention at all, was
>>> just adding more detail to the thread in hope of getting a solution.
>>>
>>> I completely understand the issue, but Amazon EMR does not support
>>> anything > 0.94.18. But, we've decided to move away from EMR and embrace
>>> HDP.
>>>
>>> Thank you all for your help.
>>>
>>> On Thu, Apr 7, 2016 at 3:48 AM, Josh Elser <jo...@gmail.com> wrote:
>>>
>>>> (-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
>>>>> <ma...@gmail.com>> wrote:
>>>>>
>>>>> Adding Dev group
>>>>>
>>>>> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan
>>>>> <dgkris@gmail.com <ma...@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 <ma...@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 <ma...@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 <ma...@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
>>>>>
>>>>>
>>>
>>>
>>> --
>>> Regards,
>>> *Deepak Gopalakrishnan*
>>> *Mobile*:+918891509774
>>> *Skype* : deepakgk87
>>> http://myexps.blogspot.com
>>>
>>>
>>
>
Re: Error while attempting join query
Posted by James Taylor <ja...@apache.org>.
I'm interested in the "how". Thanks for sharing this info, Steve.
James
On Thu, Apr 7, 2016 at 8:30 AM, Steve Terrell <st...@oculus360.us> wrote:
> I've been successful at running HBase 0.98.15 and Phoenix 4.6.0 on EMR.
> Found someone else's solution for this on the internet. Been working fine
> for months. Downside is loss of some Amazon EMR tools like HBase backups
> to S3. If anyone else is interested in the "how", post a new email to this
> mailing list with a new subject heading.
>
> Thanks,
> Steve
>
> On Wed, Apr 6, 2016 at 9:22 PM, Deepak Gopalakrishnan <dg...@gmail.com>
> wrote:
>
>> Hello All,
>>
>> I apologise if I sounded persistent. It was not my intention at all, was
>> just adding more detail to the thread in hope of getting a solution.
>>
>> I completely understand the issue, but Amazon EMR does not support
>> anything > 0.94.18. But, we've decided to move away from EMR and embrace
>> HDP.
>>
>> Thank you all for your help.
>>
>> On Thu, Apr 7, 2016 at 3:48 AM, Josh Elser <jo...@gmail.com> wrote:
>>
>>> (-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
>>>> <ma...@gmail.com>> wrote:
>>>>
>>>> Adding Dev group
>>>>
>>>> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan
>>>> <dgkris@gmail.com <ma...@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 <ma...@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 <ma...@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 <ma...@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
>>>>
>>>>
>>
>>
>> --
>> Regards,
>> *Deepak Gopalakrishnan*
>> *Mobile*:+918891509774
>> *Skype* : deepakgk87
>> http://myexps.blogspot.com
>>
>>
>
Re: Error while attempting join query
Posted by Steve Terrell <st...@oculus360.us>.
I've been successful at running HBase 0.98.15 and Phoenix 4.6.0 on EMR.
Found someone else's solution for this on the internet. Been working fine
for months. Downside is loss of some Amazon EMR tools like HBase backups
to S3. If anyone else is interested in the "how", post a new email to this
mailing list with a new subject heading.
Thanks,
Steve
On Wed, Apr 6, 2016 at 9:22 PM, Deepak Gopalakrishnan <dg...@gmail.com>
wrote:
> Hello All,
>
> I apologise if I sounded persistent. It was not my intention at all, was
> just adding more detail to the thread in hope of getting a solution.
>
> I completely understand the issue, but Amazon EMR does not support
> anything > 0.94.18. But, we've decided to move away from EMR and embrace
> HDP.
>
> Thank you all for your help.
>
> On Thu, Apr 7, 2016 at 3:48 AM, Josh Elser <jo...@gmail.com> wrote:
>
>> (-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
>>> <ma...@gmail.com>> wrote:
>>>
>>> Adding Dev group
>>>
>>> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan
>>> <dgkris@gmail.com <ma...@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 <ma...@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 <ma...@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 <ma...@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
>>>
>>>
>
>
> --
> Regards,
> *Deepak Gopalakrishnan*
> *Mobile*:+918891509774
> *Skype* : deepakgk87
> http://myexps.blogspot.com
>
>
Re: Error while attempting join query
Posted by Deepak Gopalakrishnan <dg...@gmail.com>.
Hello All,
I apologise if I sounded persistent. It was not my intention at all, was
just adding more detail to the thread in hope of getting a solution.
I completely understand the issue, but Amazon EMR does not support anything
> 0.94.18. But, we've decided to move away from EMR and embrace HDP.
Thank you all for your help.
On Thu, Apr 7, 2016 at 3:48 AM, Josh Elser <jo...@gmail.com> wrote:
> (-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
>> <ma...@gmail.com>> wrote:
>>
>> Adding Dev group
>>
>> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan
>> <dgkris@gmail.com <ma...@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 <ma...@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 <ma...@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 <ma...@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
>>
>>
--
Regards,
*Deepak Gopalakrishnan*
*Mobile*:+918891509774
*Skype* : deepakgk87
http://myexps.blogspot.com
Re: Error while attempting join query
Posted by Josh Elser <jo...@gmail.com>.
(-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
> <ma...@gmail.com>> wrote:
>
> Adding Dev group
>
> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan
> <dgkris@gmail.com <ma...@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 <ma...@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 <ma...@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 <ma...@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
>
Re: Error while attempting join query
Posted by Deepak Gopalakrishnan <dg...@gmail.com>.
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 <dg...@gmail.com>
wrote:
> Adding Dev group
>
> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan <dg...@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 <dg...@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 <ja...@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 <dg...@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
Re: Error while attempting join query
Posted by Deepak Gopalakrishnan <dg...@gmail.com>.
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 <dg...@gmail.com>
wrote:
> Adding Dev group
>
> On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan <dg...@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 <dg...@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 <ja...@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 <dg...@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