mysql - Nifi PutSQL Timestamp/Datetime error cannot be converted error -
i tried solution suggested remove timestamp format conversion error using "updateattribute" processor i.e. convertjsontosql-> updateattribute--> putsql
in updateattribute used
property value --------------- ------------------------ sql.args.4.value -> ${sql.args.4.original:format("yyyy-mm-dd hh:mm:ss")}
log:
the value of sql.args.4.value '', cannot converted timestamp @ org.apache.nifi.processors.standard.putsql.setparameters(putsql.java:690) at
without use of updateattribute tried direct convertjsontosql-> putsql . log showed same error datetime value in quote 'aug 14 2017 10:17:00 edt' i.e. when use updateattribute, removes value , put empty quotes error not resolved.
note: mysql table has datetime datatype columns not sure why errors out trying convert timestamp. tried timestamp datatype in source , target table on localhost, no luck!
funny enough! found answer question . please use sql.args.n.value -> ${sql.args.n.value:format("yyyy-mm-dd hh:mm:ss.sss")}. worked me!
Comments
Post a Comment