Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Nifi - PutSQL Row length exception for Phoenix Upsert

Solved Go to solution
Highlighted

Nifi - PutSQL Row length exception for Phoenix Upsert

New Contributor

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

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

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

6 REPLIES 6

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

Master Guru

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

New Contributor

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

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

New Contributor

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

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

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

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

New Contributor

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 ?

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

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

Don't have an account?
Coming from Hortonworks? Activate your account here