Load csv file into mySql DB using nifi

[#1]

Dear Forum,

I have CSV file that is generated in /home/input/ , what am trying to do is to read this CSV file line by line, modify the first field in each of the CSV file (if field1 starts with 06, replace 0 with 00962, else leave as is), then load the file into mysql DB

am new to nifi, I need guidance how to start and which processor should I use ?

Thanks

[#2 · Accepted solution]

Hi,

Please refer this link. Hope it will be useful.

http://stackoverflow.com/questions/38402140/how-to-import-data-from-mysql-into-hive-using-apache-nif...