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.
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.