Support Questions

Find answers, ask questions, and share your expertise

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

2 REPLIES 2

Were you able to solve this?

Community Manager

@jacektrocinski, as this is an older post, you would have a better chance of receiving a resolution by starting a new thread. This will also be an opportunity to provide details specific to your environment that could aid others in assisting you with a more accurate answer to your question. You can link this thread as a reference in your new post.



Regards,

Vidya Sargur,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: