Dear All,

I would like to upload a JSON file in Event Collection which contains key:value pairs that are filled with dates. I have a "CancelDate" key, which sometimes contain null value (Date is not null here in the data if some conditions are met).

E.g. {"CancelDate":null},{"CancelDate":"2020-11-10"}]

The datatype is set to DATETIME.

After clicking the Finish button, i get the error code: „Processing Errorjava.lang.RuntimeException: java.lang.NullPointerException caused by null” .

If i set CancelDate to DATE, i get: Data type conversion error for column "CancelDate", value "2020-11-10". Cause: Can not cast value "2020-11-10" to type DATE in column "CancelDate".

I also tried DATETIME, as yyyy-MM-dd format, but the error code is the same.

The only way i don't get an error code is if i set the datatype to STRING or if all the json objects keys contain values that are not null.

Is there anything i can do so that the date column is accepted from the JSON file as DATE datatype (accepting null or empty as well) - without fiddling in SQL?

Thank you,

Zsolt