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.

How I can bulk insert my csv file into mysql database table

How I can bulk insert my csv file into mysql database table

Explorer

Hi,

I am trying to bulk insert my csv file to mysql table using PutDatabaseRecord.

My CSV file contains all the column values except for the last column as it is auto incremented in table in case of insertion.

 

Can you help me with the attribute setting or processor setting in that case?

1 REPLY 1

Re: How I can bulk insert my csv file into mysql database table

Explorer

Hi,

I am trying to insert my CSV file into mysql table using PutDatabaseRecord processor.

My CSV containr records for all columns except for one as it is auto incremented on insertion.

 

Can you help me with the processors or attribute settings that I can use in such situation?

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