Support Questions
Find answers, ask questions, and share your expertise

Nifi - PutSQL Row length exception for Phoenix Upsert

phoenix-upsert-error.pngNifi putsql is working fine ,suddenly i am getting Row length exception for Phoenix Upsert . There is no junk data , there is no syntax error also .

ERROR : PUTSQL failed to process due to java.lang.illegalArgumentException; Row length 43125 > 32767 .

i observed that leftside(32767) values is constant .

PFA

1 ACCEPTED SOLUTION

Accepted Solutions

It appears that this is a hard-coded check in the client side HBase Mutation class. I would recommend that you consider why you are creating such a large rowKey in the first place. There is some reading you could also do on the subject: http://hbase.apache.org/book.html#keysize

View solution in original post

6 REPLIES 6

Master Guru

The same upsert command I am executing in phoenix console , its working . but from putSql, it is throwing above error. Thanks

Is MAX_ROW_LENGTH belong to to only key or whole row which consists of all columns ??

Just the row component of the Key: http://hbase.apache.org/book.html#_row

Thank you . I am refering this link https://hbase.apache.org/apidocs/org/apache/hadoop/hbase/HConstants.html#MAX_ROW_LENGTH

what i understood is MAX_ROW_LENGTH is about whole row not only key . Here is my confusion , how can i take this property is only belongs to key ?

It appears that this is a hard-coded check in the client side HBase Mutation class. I would recommend that you consider why you are creating such a large rowKey in the first place. There is some reading you could also do on the subject: http://hbase.apache.org/book.html#keysize

View solution in original post