TimeStamp Converter for column with NULL values

[dwija]

I am running a Kafka connect source connector (Oracle) with transformation of human readable Date field[dd-MMM-yyyy HH:mm:ss] to Timestamp format[Long].

...
...
"transforms": "ConvertStartDate",
"transforms.ConvertStartDate.type": "org.apache.kafka.connect.transforms.TimestampConverter$Value",
"transforms.ConvertStartDate.target.type": "Timestamp",
"transforms.ConvertStartDate.field": "START_DATE",
"transforms.ConvertStartDate.format": "dd-MMM-yyyy HH:mm:ss"
...
...

This works fine except when the column [START_DATE] contains null value and the message does not get into the topic.

The issue is discussed in details here.

What is the fix for the issue?

Thanks

[danicafine]

Two things to check:

1. Are you using one of the versions that has the NULL fix in it?

• Fix Version/s: 1.0.3, 1.1.2, 2.0.2, 2.1.2, 2.2.2, 2.4.0, 2.3.1

2. Can you check the schema of the target topic, please? Specifically confirm that START_DATE allows for a NULL value.

[dwija]

Hi
I am using Confluent CCS 6.1.0 which has Kafka version 2.7

It looks like the fix has not been applied to Kafka version 2.7 still now.

The schema has been designed to allow for NULL value.

Thanks