phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Mahonin <jmaho...@interset.com>
Subject Re: Getting ArrayIndexOutOfBoundsException in UPSERT SELECT
Date Wed, 26 Aug 2015 19:54:51 GMT
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 <jdjsolano@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 <johngouf85@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 <jdjsolano@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
>>>
>>
>>
>

Mime
View raw message