Support Questions
Find answers, ask questions, and share your expertise
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



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 ?


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