Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

phoenix exception

There is hadoop job which drops an old phoenix table and recreates it again and populate it with some records (no issue till here). There is another task which tries to update a value in the newly inserted record and we do see this exception org.apache.phoenix.exception.PhoenixIOException: java.lang.IndexOutOfBoundsException: index ( 6 ) must be less than size (5) This is only in one environment, whereas the same query runs fine in other environments.

1 REPLY 1

Double-check the schema of your table and your use of any PreparedStatements. A common one-off is if you're binding too many values into a statement, e.g. You set 4 values but your SQL only expects 3

UPSERT INTO my_table VALUES(?,?,?);

Please update your question with the full stacktrace for that Exception to help elicit a better answer.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.