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 < [email protected]> 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: [email protected] > To: [email protected] > > > 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 < > [email protected]> 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! > > >
