Re: Getting ArrayIndexOutOfBoundsException in UPSERT SELECT

2015-08-26 Thread Jaime Solano
Hi Josh, It might take some time, but thanks for the tip! -Jaime On Wed, Aug 26, 2015 at 3:54 PM, Josh Mahonin wrote: > Hi Jaime, > > I've run into similar issues with Phoenix 4.2.x. They seem to have gone > away for me as of 4.3.1. Are you able to upgrade to that version or higher > and try t

Re: Getting ArrayIndexOutOfBoundsException in UPSERT SELECT

2015-08-26 Thread Josh Mahonin
Hi Jaime, I've run into similar issues with Phoenix 4.2.x. They seem to have gone away for me as of 4.3.1. Are you able to upgrade to that version or higher and try those same queries? Josh On Wed, Aug 26, 2015 at 3:30 PM, Jaime Solano wrote: > Hi Yiannis, > > Not quite, but it's similar. For

Re: Getting ArrayIndexOutOfBoundsException in UPSERT SELECT

2015-08-26 Thread Jaime Solano
Hi Yiannis, Not quite, but it's similar. For instance, in my case the tables are not salted. I forgot to add, I'm using Phoenix 4.2.0. Thanks for your reply! -Jaime On Wed, Aug 26, 2015 at 3:20 PM, Yiannis Gkoufas wrote: > Hi Jaime, > > is this https://issues.apache.org/jira/browse/PHOENIX-21

Re: Getting ArrayIndexOutOfBoundsException in UPSERT SELECT

2015-08-26 Thread Yiannis Gkoufas
Hi Jaime, is this https://issues.apache.org/jira/browse/PHOENIX-2169 the error you are getting? Thanks On 26 August 2015 at 19:52, Jaime Solano wrote: > Hi guys, > > I'm getting *Error: java.lang.ArrayIndexOutOfBoundsException > (state=08000, code=101)*, while doing a query like the following:

Getting ArrayIndexOutOfBoundsException in UPSERT SELECT

2015-08-26 Thread Jaime Solano
Hi guys, I'm getting *Error: java.lang.ArrayIndexOutOfBoundsException (state=08000, code=101)*, while doing a query like the following: UPSERT INTO A (PK, COL2) SELECT A.PK, A.COL1 * B.COL1 FROM A LEFT JOIN B ON A.COL3=B.COL2; Some additional info: - Table A has around 140k records, while table