Getting errors in Phoenix queries with JOIN clause[Phoenix version 3.2.2]

[Sumanta Gh <su...@tcs.com>]

Hello,

I'm getting an error (Error: Encountered exception in sub plan [0] execution. (state=,code=0)) with Apache Phoenix version 3.2.2 while I'm trying to execute a query with INNER JOIN or LEFT OUTER JOIN or with sub-query.I'm using sqlline.py client from hadoop1/bin directory found under Phoenix 3.2.2 distribution.In my case only simple queries(without JOIN and sub-query) are executing successfully.

Please find my environment details as below:

Operating System: Ubuntu 14.04
HBase version: 0.94.18  (on Amazon EMR)
Hadoop version: 1.0.4
Apache Phoenix version: Phoenix 3.2.2
Java: Oracle JDK 7

I have also tried Phoenix 3.3.1 but I'm getting the same error.Could you please help me in this regard to resolve this issue.If I'm missing anything related the version compatibility or something else please also let me know.

Regards
Sumanta 
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

Re: Getting errors in Phoenix queries with JOIN clause[Phoenix version 3.2.2]

["rajeshbabu@apache.org" <ch...@gmail.com>]

Hi Samantha,

You are facing this issue https://issues.apache.org/jira/browse/PHOENIX-2007
got fixed in latest code.
You get the error when there is no data in the table so you can load some
data and try.


Thanks,
Rajeshbabu.

On Mon, Jul 27, 2015 at 5:50 PM, Sumanta Gh <su...@tcs.com> wrote:

> Hello,
>
> I'm getting an error (Error: Encountered exception in sub plan [0]
> execution. (state=,code=0)) with Apache Phoenix version 3.2.2 while I'm
> trying to execute a query with INNER JOIN or LEFT OUTER JOIN or with
> sub-query.I'm using sqlline.py client from hadoop1/bin directory found
> under Phoenix 3.2.2 distribution.In my case only simple queries(without
> JOIN and sub-query) are executing successfully.
>
> Please find my environment details as below:
>
> Operating System: Ubuntu 14.04
> HBase version: 0.94.18  (on Amazon EMR)
> Hadoop version: 1.0.4
> Apache Phoenix version: Phoenix 3.2.2
> Java: Oracle JDK 7
>
> I have also tried Phoenix 3.3.1 but I'm getting the same error.Could you
> please help me in this regard to resolve this issue.If I'm missing anything
> related the version compatibility or something else please also let me know.
>
> Regards
> Sumanta
>
> =====-----=====-----=====
> Notice: The information contained in this e-mail
> message and/or attachments to it may contain
> confidential or privileged information. If you are
> not the intended recipient, any dissemination, use,
> review, distribution, printing or copying of the
> information contained in this e-mail message
> and/or attachments to it are strictly prohibited. If
> you have received this communication in error,
> please notify us by reply e-mail or telephone and
> immediately and permanently delete the message
> and any attachments. Thank you
>
>