question Re: Nested field as Hbase row identifier in Support Questions

Nested field as Hbase row identifier

sheep — Tue, 29 Mar 2022 20:22:32 GMT

I have a JSON document that I want to index into Hbase.

{ "field1" : { "nestedfield" : "value1" } "field2" : "value2" }

In this case I want `nestedfield` to be the one used as a row identifier field, but I can't figure out how to specify this to the `PutHBaseJson` processor. I have tried multiple ways :

- field1/nestedfiled

- field1['nestedfiled']

- field1.nestedfield

- $.filed1.nestedfiled

None of them are working, the processor is saying that "the Row ID was null".

Using `field2` for this purpose is working fwiw.

Re: Nested field as Hbase row identifier

araujo — Tue, 29 Mar 2022 23:44:38 GMT

@sheep ,

You need to add an EvaluateJsonPath processor before your PutHBaseJson to extract the value that you need and save it as an attribute in the flowfile. For example, you could get the value from $.field1.nestedfield and save that as the attribute mynestedfieldvalue. You can then refer to that attribute in your PutHBaseJson processor as ${mynestedfieldvalue}.

Please check out this other answer to a similar question: https://community.cloudera.com/t5/Support-Questions/Hash-key-value-missing-putdynamodb-nifi/m-p/339622/highlight/true#M233139

Cheers,

André