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:30:29 GMT
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