You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Alberto Gonzalez Mesas <ag...@hotmail.com> on 2015/09/11 13:04:48 UTC

Error: Encountered exception in sub plan [0] execution.

Hi!

I create two tables:

CREATE TABLE "Customers2" ("CustomerID" VARCHAR NOT NULL PRIMARY KEY,
    "C"."CustomerName" VARCHAR,
    "C"."Country" VARCHAR
)

and

CREATE TABLE "Orders2" ("OrderID" VARCHAR NOT NULL PRIMARY KEY,
    "O"."CustomerID" VARCHAR,
    "O"."Date" VARCHAR,
    "O"."ItemID" VARCHAR,
    "O"."Quantity" VARCHAR
)

When i have a join, i recived this msg:

"Error: Encountered exception in sub plan [0] execution.
SQLState:  null
ErrorCode: 0"

My phoenix version is 4.5.0

Thanks!

Re: Error: Encountered exception in sub plan [0] execution.

Posted by Maryann Xue <ma...@gmail.com>.
Hi Alberto,

Please make sure you have setup your environment correctly according to
https://phoenix.apache.org/installation.html.


Thanks,
Maryann

On Mon, Sep 21, 2015 at 12:46 PM, Alberto Gonzalez Mesas <
agmesas@hotmail.com> wrote:

> cause: not found the phoenix client library in HBASE_HOME/lib
>
> thx!!
>
> ------------------------------
> Date: Fri, 11 Sep 2015 09:10:06 -0400
> Subject: Re: Error: Encountered exception in sub plan [0] execution.
> From: maryann.xue@gmail.com
> To: user@phoenix.apache.org
>
>
> Hi Alberto,
>
> Could you please check in your server log if there's an ERROR, probably
> something like InsufficientMemoryException?
>
>
> Thanks,
> Maryann
>
> On Fri, Sep 11, 2015 at 7:04 AM, Alberto Gonzalez Mesas <
> agmesas@hotmail.com> wrote:
>
> Hi!
>
> I create two tables:
>
> CREATE TABLE "Customers2" ("CustomerID" VARCHAR NOT NULL PRIMARY KEY,
>     "C"."CustomerName" VARCHAR,
>     "C"."Country" VARCHAR
> )
>
> and
>
> CREATE TABLE "Orders2" ("OrderID" VARCHAR NOT NULL PRIMARY KEY,
>     "O"."CustomerID" VARCHAR,
>     "O"."Date" VARCHAR,
>     "O"."ItemID" VARCHAR,
>     "O"."Quantity" VARCHAR
> )
>
> When i have a join, i recived this msg:
>
> "Error: Encountered exception in sub plan [0] execution.
> SQLState:  null
> ErrorCode: 0"
>
> My phoenix version is 4.5.0
>
> Thanks!
>
>
>

RE: Error: Encountered exception in sub plan [0] execution.

Posted by Alberto Gonzalez Mesas <ag...@hotmail.com>.
cause: not found the phoenix client library in HBASE_HOME/lib 

thx!!

Date: Fri, 11 Sep 2015 09:10:06 -0400
Subject: Re: Error: Encountered exception in sub plan [0] execution.
From: maryann.xue@gmail.com
To: user@phoenix.apache.org

Hi Alberto,
Could you please check in your server log if there's an ERROR, probably something like InsufficientMemoryException?

Thanks,Maryann
On Fri, Sep 11, 2015 at 7:04 AM, Alberto Gonzalez Mesas <ag...@hotmail.com> wrote:



Hi!

I create two tables:

CREATE TABLE "Customers2" ("CustomerID" VARCHAR NOT NULL PRIMARY KEY,
    "C"."CustomerName" VARCHAR,
    "C"."Country" VARCHAR
)

and

CREATE TABLE "Orders2" ("OrderID" VARCHAR NOT NULL PRIMARY KEY,
    "O"."CustomerID" VARCHAR,
    "O"."Date" VARCHAR,
    "O"."ItemID" VARCHAR,
    "O"."Quantity" VARCHAR
)

When i have a join, i recived this msg:

"Error: Encountered exception in sub plan [0] execution.
SQLState:  null
ErrorCode: 0"

My phoenix version is 4.5.0

Thanks!

Re: Error: Encountered exception in sub plan [0] execution.

Posted by Maryann Xue <ma...@gmail.com>.
Hi Alberto,

Could you please check in your server log if there's an ERROR, probably
something like InsufficientMemoryException?


Thanks,
Maryann

On Fri, Sep 11, 2015 at 7:04 AM, Alberto Gonzalez Mesas <agmesas@hotmail.com
> wrote:

> Hi!
>
> I create two tables:
>
> CREATE TABLE "Customers2" ("CustomerID" VARCHAR NOT NULL PRIMARY KEY,
>     "C"."CustomerName" VARCHAR,
>     "C"."Country" VARCHAR
> )
>
> and
>
> CREATE TABLE "Orders2" ("OrderID" VARCHAR NOT NULL PRIMARY KEY,
>     "O"."CustomerID" VARCHAR,
>     "O"."Date" VARCHAR,
>     "O"."ItemID" VARCHAR,
>     "O"."Quantity" VARCHAR
> )
>
> When i have a join, i recived this msg:
>
> "Error: Encountered exception in sub plan [0] execution.
> SQLState:  null
> ErrorCode: 0"
>
> My phoenix version is 4.5.0
>
> Thanks!
>