question Re: PutSql With Date as argument in Archives of Support Questions (Read Only)

PutSql With Date as argument

srikanth_gunupu — Wed, 22 Feb 2017 01:51:10 GMT

Hi ,

I'm trying some examples with PutSQL processor. While doing trying the examples, gone through the PutSql.java code. When i checked the PutSql.java file , found that Date and Time data types always expects only Long.

Why is this restriction? Is it possible to make it to accept String also?

Re: PutSql With Date as argument

mburgess — Wed, 22 Feb 2017 02:00:40 GMT

It seems feasible to remove this restriction from Date and Time data types, as was done for Timestamps in NIFI-3430. Please feel free to write up a Jira case for this improvement.

In the meantime, if you are trying to do something like use the value '2017-02-21' in a field specified as Date/Time type, you could first change the value (possibly in an UpdateAttribute processor) using NiFi Expression Language's toDate() function. So if you have an attribute such as 'my.date.string' set to '2017-02-21' you could set an attribute 'my.date' equal to the following:

${my.date.string:format('yyyy-MM-dd')}

Re: PutSql With Date as argument

devopsteja — Wed, 22 Feb 2017 02:59:52 GMT

I tried putting attribute " ${my.date.string:format('yyyy-MM-dd')} " in update attribute got some error in PUTSQL, its not updating the value into database.

please find the image of my dataflow in the attachment

Thanks

nifidatepng.png

Re: PutSql With Date as argument

srikanth_gunupu — Wed, 22 Feb 2017 21:36:18 GMT

Hi Matt,

Thanks for suggestion and it worked 🙂 Tried like this:- ${my.date:toDate("yyyy-MM-dd"):toNumber()}

Thanks alot.

--Srikanth.