Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Cannot convert to timestamp error using putsql processor NiFi 1.3.0

Highlighted

Cannot convert to timestamp error using putsql processor NiFi 1.3.0

New Contributor

Hello,

I'm working for a data flow POC form one mysql database to other for that i'm using ConvertJsonToSql(Relationships sql and original)------>UpdateAttribute(Property:sql.args.n.value and value:${sql.args.n.value:format("yyyy-MM-dd HH:mm:ss.SSS")}This answer)-------->PutSQL. But still i'm facing the same issue any suggestions are welcome and appreciated.

Thanks

Rakesh.

2 REPLIES 2

Re: Cannot convert to timestamp error using putsql processor NiFi 1.3.0

New Contributor

I got answer for this In updateattribute processor property: sql.args.27.value and value :${sql.args.27.value:toDate("EEE MMM dd HH:mm:ss z yyyy"):toNumber():format("yyyy-MM-dd HH:mm:ss.SSS")}

Re: Cannot convert to timestamp error using putsql processor NiFi 1.3.0

Rising Star

@rakesh chow

Thank you for sharing your solution. I was facing the same problem and solved it with your information! Great!

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