Nifi - PutSQL Row length exception for Phoenix Upsert

[#1]

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

[#2]

@srinivas padala

hbase has a MAX_ROW_LENGTH value of 32767

https://hbase.apache.org/apidocs/constant-values.html

[#3]

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

[#4]

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

[#5]

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

[#6]

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 ?

[#7 · Accepted solution]

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