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

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 wrote: > Hello, > > I'm g

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

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 Pho