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.

nifi -Ingesting a file from SFTP and insert into MYSQL using nifi

Solved Go to solution

Re: nifi -Ingesting a file from SFTP and insert into MYSQL using nifi

I am experiencing the same issue with the PutSQL processor, regardless of how many properly formatted SQL Insert statements I pass to the processor, it fails say that the entire batch failed because it was expecting N statements, where N = the number of SQL statements I have passed in, e.g. 30, 50, 100. It never seems to get past this point.

Highlighted

Re: nifi -Ingesting a file from SFTP and insert into MYSQL using nifi

Expert Contributor

@David Kjerrumgaard Did you manage to get past this challenge? In my case, i get an error "invalid number" after i changed the Obtain Generated Keys property to true.

Highlighted

Re: nifi -Ingesting a file from SFTP and insert into MYSQL using nifi

Expert Contributor

@David Kjerrumgaard I found out the issue was with my csv file. It had to do with the column names i was ingesting in the csv file. Also, the turning the Obtain Generated Keys property to false worked as well in my case.

Don't have an account?
Coming from Hortonworks? Activate your account here