Member since
02-02-2017
1
Post
2
Kudos Received
0
Solutions
02-02-2017
05:15 AM
2 Kudos
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!
... View more
Labels:
- Labels:
-
Apache NiFi