I'm using nifi to transfer data from one database to another. Both database is psql.
The template is like: ExecuteSQL -> ConvertAvrotoJson -> ConvertJsontoSQL -> PutSQL.
One of the columns's datatype is date and if the processor include this colums the PutSQL will return an error:
"ProcessException: The value of the sql.args.2.value is '2017-01-10', which cannot be converted into the necessary data type; routing to failure: org.apache.nifi.processor.exception.ProcessException: The value of the sql.args.2.value is '2017-01-10', which cannot be converted into the necessary data type"
If I remove this column(not select this column in ExecuteSQL) and then Nifi will work fine. Anyone has idea about this?
Dates are always tricky. You need to make sure that the conversion to JSON and to SQL is getting the correct date format.
You are getting a number format exception
Either the table has the wrong type or it's converting it to a number. Check the logs and data provenance.
can you please provide, what exactly needs to done( process) even I'm getting same issue
problem with date, datetime, varbinary datatypes.
please help me\