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.

Is it possible to create a table direct in mysql using the csv file by nifi?

Is it possible to create a table direct in mysql using the csv file by nifi?

New Contributor

Dear Forum,

 

I have a CSV file that is generated in a Azure Blob container, i have to record the data from CSV file in table MySQL;

I i got it a solution using this processors:

 

1 - Use processor ListAzureBlob for list the file in my container;

2 - Fetch file with processo FetchAzureBlob;

3 - Replace the Header and prepare the file for the next step;

4 - input the data into MySQL table;

 

But I think to have better way to do this. Is it possible to create a table direct in mysql using the csv file by nifi?

Spoiler
solution.JPG
1 REPLY 1

Re: Is it possible to create a table direct in mysql using the csv file by nifi?

Rising Star

This flow seems quite compact already, so I think you are scoring well regarding best practices.

 

Conceptually, the only step you could eliminate is the transformation, but of course this would require the file to 'fit' as-is into mysql.

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