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 use of PutSQL processor

Nifi use of PutSQL processor

New Contributor

Hi,

 

I'm stucked with ConvertJSONtoSQL and PutSQL

I'm tryng to push a csv into a table 

So I'm using this design

 

FetchFile -> validateCsv (schema avro) -> ConvertRecord -> ReplaceText  (change date format from french to american)-> ConvertJsonToSQL -> PutSql

 

ConvertJsonToSQL has one flow containing one line per Json

It generate an insert statement like that kind:  

 

insert into calendrier (a,b,c) values (?,?,?)

 

and sends it to PutSQL

PutSQL inserts nothing

 

Any idea ?

regards

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