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.

Flatfile to mysql table not loading the data

Highlighted

Flatfile to mysql table not loading the data

Rising Star

75381-nifi-error1.png

I'm trying to insert data to mysql from flat(.txt) file and i am using the processors list as (Getfile->ReplaceText->PutSQL).

I can see the data from my flat file till Getfile processor but as soon it reaches Replacetext the values for the columns shows as ? .

I'm using the below Replacement Value in replace text:

insert into flowfiles(id,name) values('${id}', '${name}')

Data provinence in replace text:

insert into flowfiles(id,name) values('', '')

Any help on this would be appreciated

1 REPLY 1
Highlighted

Re: Flatfile to mysql table not loading the data

Rising Star

@Shu any comment on this?

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