Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Nifi - PutSQL Row length exception for Phoenix Upsert

avatar
Rising Star

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

avatar
Super Guru

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

avatar
Super Mentor

avatar
Rising Star

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

avatar
Rising Star

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

avatar
Super Guru

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

avatar
Rising Star

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 ?

avatar
Super Guru

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