https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-csv-file-into-mySql-DB-using-nifi/m-p/173626#M46013 <P>Dear Forum, </P><P>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 </P><P>am new to nifi, I need guidance how to start and which processor should I use ? </P><P>Thanks</P> Sat, 12 Nov 2016 19:20:10 GMT yahya_najjar 2016-11-12T19:20:10Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-csv-file-into-mySql-DB-using-nifi/m-p/173626#M46013 <P>Dear Forum, </P><P>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 </P><P>am new to nifi, I need guidance how to start and which processor should I use ? </P><P>Thanks</P> Sat, 12 Nov 2016 19:20:10 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-csv-file-into-mySql-DB-using-nifi/m-p/173626#M46013 yahya_najjar 2016-11-12T19:20:10Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-csv-file-into-mySql-DB-using-nifi/m-p/173627#M46014 <P>Hi,</P><P>Please refer this link. Hope it will be useful.</P><P><A href="http://stackoverflow.com/questions/38402140/how-to-import-data-from-mysql-into-hive-using-apache-nifi" target="_blank">http://stackoverflow.com/questions/38402140/how-to-import-data-from-mysql-into-hive-using-apache-nifi</A></P> Sun, 13 Nov 2016 23:58:21 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Load-csv-file-into-mySql-DB-using-nifi/m-p/173627#M46014 maheshmsh88 2016-11-13T23:58:21Z