Nifi is appending additional character while reading from oracle database

Asked Jul 27 '21 at 11:04

Active Jul 27 '21 at 11:47

Viewed 107 times

I am novice to nifi.

I want to read an Oracle database table "ST_MATIC" which has the below records using "QueryDatabaseTable".

KEY,START_TIME,MATIC1 1,2021-07-27 01:07:28,M1

I need to load this to Kudu table. START_TIME is a TIMESTAMP column in kudu. I am using "PutKudu" processor for that.

But I see in the queue that The START_TIME is getting appended an additional value ".0". The value that I get in queue is ""2021-07-27 01:07:28.0". Hence it is not getting inserted to kudu.

Could you please let me know how to resolve this issue

edited Jul 27 '21 at 11:47

asked Jul 27 '21 at 11:04

stacktesting

What processor is reading from Oracle? – Sdairs Jul 27 '21 at 11:15
QueryDatabaseTable – stacktesting Jul 27 '21 at 11:16
What is Database Type and Use Avro Logical Types set to? – Sdairs Jul 27 '21 at 12:02
DataType is TIMESTAMP. Avro schema is type="long", logical type="timestamp-millis". While reading from the database, I am formatting to "'YYYY-MM-DD HH24:MI:SS'" – stacktesting Jul 27 '21 at 12:14

Nifi is appending additional character while reading from oracle database

0 Answers0