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.

how to load multiple columns at ones from nifi to dynamodb

how to load multiple columns at ones from nifi to dynamodb

New Contributor

hello,

we are trying to develop a flow in nifi that loads jsons to dynamodb.

our json looks like this:

	{
	"hash_field": "hash_value",
	"field2": "value2",
	"field3": "value3"
	}
</p><p>
	We are using putDynamDB processor. </p><p>
	Field one is the hash key. We tried to specify a json path to the hash key('$.field1') at the putDynamDB's attribute '<strong style="background-color: initial;">Hash Key Value' </strong>but it failed, so we add an attribute that contains the hash key value and removed the hash key from the original json, so now it looks like this:</p><pre>	{
	"field2": "value2",
	"field3": "value3"
	}

We understood that in the putDynamDB's attribute 'Json Document attribute' we need to specify the json path we want to load, which means that if we want to load the whole json we need to insert '$'. But somehow $ loads the data like this:

{ "field2" : { "S" : "value2" }, "field3" : { "S" : "value3" } }

we tried changing it to '$.', '$.*','.' and nothing loads the data right.

What are we doing wrong?

Thanks for the help

@gal626262