phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jaime Solano <jdjsol...@gmail.com>
Subject Getting ArrayIndexOutOfBoundsException in UPSERT SELECT
Date Wed, 26 Aug 2015 18:52:39 GMT
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