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