Hi Josh, It might take some time, but thanks for the tip!
-Jaime On Wed, Aug 26, 2015 at 3:54 PM, Josh Mahonin <[email protected]> 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 those same queries? > > Josh > > On Wed, Aug 26, 2015 at 3:30 PM, Jaime Solano <[email protected]> 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 <[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 >>>> >>> >>> >> >
