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 <jdjsol...@gmail.com> wrote: > 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 <johngou...@gmail.com> > wrote: > >> 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 <jdjsol...@gmail.com> wrote: >> >>> 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 B only has around 100. >>> - In reality, Table A has around 140 columns, but they're not part of >>> the UPSERT in any way. >>> - A.COL2 is DECIMAL. >>> - A.COL1 is FLOAT >>> - B.COL1 is DECIMAL. >>> *- Running only the SELECT statement, successfully prints the results on >>> the screen.* >>> >>> To be honest, I have no idea what to look for or where. Any ideas? >>> >>> Thanks, >>> -Jaime >>> >> >> >
