nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Pablo Gardella <gardellajuanpa...@gmail.com>
Subject Re: Cannot convert to timestamp error using putsql processor NiFi 1.3.0
Date Fri, 13 Oct 2017 12:10:46 GMT
It is solved in Nifi 1.4.0, but you can use toDate().toNumber() and the
timestamp will work.



On Fri, 13 Oct 2017 at 08:57 rakesh <rakesh999.alla@gmail.com> wrote:

> Greetings Community,
>
>
> 1.I'm developing a nifi flow which reads mysql bin_log(Capture Change
> Mysql)
> form source db and executing the queries in destination db using PutSql
> processor. In my source db tables some columns have datatype datetime(like
> *2017-10-09 18:08:55*). Capture Chnage Mysql is giving me data in json
> format in that columns with datetime are converted to "*Mon Sep 11 19:56:13
> IST 2017*".
>
> 2.After that I'm using JoltTransformJson Processor to convert flat Json.
> 3.Next Converting to sql statement using ConvertJsonToSql Processor after
> converting the format is like "*Mon Sep 11 19:56:13*" chopping to 19 char.
> 4.With this flowfile I'm trying to execute sql statement using PutSql
> Processor.
> 5.PutSql Processor is giving "*flow file attribute value of
> sql.args.27.type
> is 93 and sql.args.27.value is Mon Oct 09 23:38:55.*".
> <http://apache-nifi-users-list.2361937.n4.nabble.com/file/t310/Capture.png
> >
>
>
> 6.I tried Update attribute Processor with Property:"sql.args.4.value"
> Value:${sql.args.4.original:format("yyyy-MM-dd HH:mm:ss")} but no luck.
>
> Any suggestions are welcome and appreciated.
> Thanks
> Rakesh
>
>
>
> --
> Sent from: http://apache-nifi-users-list.2361937.n4.nabble.com/
>

Mime
View raw message