场景:通过jdbc连接到phoenix执行 upsert into table select 操作报一下异常:
phoenix upsert ERROR:MutationState size is bigger than maximum allowed number of bytes
网上的解决方法:
https://blog.csdn.net/u012551524/article/details/81773851
试了一下还是解决不了问题,可能是问题出现的一种原因,后来仔细看了一下以下官网说明如下:
When using UPSERT SELECT to write many rows in a single statement, turn on autocommit and the rows will be automatically batched according to the phoenix.mutate.batchSize. This will minimize the amount of data returned back to the client and is the most efficient means of updating many rows.
简单地说就是打开自动提交
conn.setAutoCommit(true)
问题成功解决!