Stupid question: do you have transforms=DateConvert as well?
On Fri, Nov 9, 2018, 9:00 PM sanjeev0915 <sanjeev0...@gmail.com> wrote:
> Hi
>
> Please help for the below issue
>
> i am using Kafka connect JDBC Connector and trying to pull the data from
> Oracle Database table. I am using Apache Kafka (not the confluent). But
> using JDBC connector from Confluent 5.0.0.
>
> i have a field of number(19) with auto-increment as a primary key. the data
> published from this field in the topic is in bytes/binary format. examples
> below
>
> {"Identifier":*"UQ=="*
>
> ,"User":"fdd","MODIFIED":1541798490000,"XYZ":40,"NEWDATE":17844,"NUM1":30,"extra":"test-file"}
>
> Also having the issues with timestamp field for which I am using Timestamp
> converter using SMT.
> I have wo date fields in the table. Data coming out as
> "MODIFIED":1541798490000
> and "NEWDATE":17844
> Transform configurations are as follows
>
> transforms.DateConvert.type=org.apache.kafka.connect.transforms.TimestampConverter$Value
> transforms.DateConvert.target.type=Date
> transforms.DateConvert.field=NEWDATE
> transforms.DateConvert.format=yyyy-MM-dd
>
> I am also using numeric.mapping=best_fit
>
> cansome one help please
>
>
> --
> Regards
> Sanjeev Jain
>
