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
>

Reply via email to