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.

loading data from csv file to dynamodb using NIfi

loading data from csv file to dynamodb using NIfi

New Contributor

How can i load data from CSV file to dynmaodb using putdynamodb in nifi..?

2 REPLIES 2

Re: loading data from csv file to dynamodb using NIfi

What does your CSV file look like? Does it have 3 columns corresponding to the hash key, range key, and an attribute value?

Re: loading data from csv file to dynamodb using NIfi

New Contributor

Hi @Matt Burgess, i am having some multiple csv files with different schema,just one column is common(lets say id) and they may or may not have matching values. I want to merge them all before sending it to dynamo db and and dont know how can i put them in dynamodb. for example

InputFile 1

deptidfirstnamelastname
1AmanSharma
2RamanVerma

InputFile 2

deptidsalaryemail
120000abc@gmail.com
230000bgf@gmail.com

OutputFile(By merging file1 and file2):-

deptidfirstnamelastnamesalaryemail
1AmanSharma20000abc@gmail.com
2RamanVerma30000bgf@gmail.com