Created 02-02-2017 05:15 AM
Hi,
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?
Thanks!
Created 02-02-2017 02:44 PM
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.
See:
https://nifi.apache.org/docs/nifi-docs/html/user-guide.html#data-provenance
Created 02-21-2017 05:40 PM
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\
Thanks
Ravi