phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jaime Solano <jdjsol...@gmail.com>
Subject Re: Getting ArrayIndexOutOfBoundsException in UPSERT SELECT
Date Wed, 26 Aug 2015 19:56:38 GMT
Hi Josh,

It might take some time, but thanks for the tip!

-Jaime

On Wed, Aug 26, 2015 at 3:54 PM, Josh Mahonin <jmahonin@interset.com> 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 <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