question Re: Nifi - PutSQL Row length exception for Phoenix Upsert in Archives of Support Questions (Read Only)

Nifi - PutSQL Row length exception for Phoenix Upsert

srinivaspadala_ — Wed, 19 Oct 2016 04:41:45 GMT

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

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

MattWho — Wed, 19 Oct 2016 05:19:15 GMT

@srinivas padala

hbase has a MAX_ROW_LENGTH value of 32767

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

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

srinivaspadala_ — Wed, 19 Oct 2016 05:33:23 GMT

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

elserj — Thu, 20 Oct 2016 00:59:04 GMT

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

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

srinivaspadala_ — Mon, 31 Oct 2016 21:41:58 GMT

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

elserj — Mon, 31 Oct 2016 22:01:19 GMT

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

Re: Nifi - PutSQL Row length exception for Phoenix Upsert

srinivaspadala_ — Mon, 31 Oct 2016 22:29:29 GMT

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 ?