Hi there anyone know what should be the schema for such time

Question

Hi there anyone know what should be the schema for such time format 2021 05 19T18 08 23 583Z Had tried but no luck ``` name date dataType STRING format 1 SIMPLE DATE FORMAT yyyy MM dd T HH mm ss SSS Z granularity 1 MILLISECONDS ```

Mayank · Answer

< Neha Pawar> ^^

Neha Pawar · Answer

looks right I ve used this in the past successfully ``` format 1 HOURS SIMPLE DATE FORMAT yyyy MM dd T HH mm ss SSS Z ```

Neha Pawar · Answer

what fails

Jackie · Answer

I think < Neil Teng> missed the unit part

Jackie · Answer

We should remove the unit part for `SIMPLE DATE FORMAT` because it is ignored anyway

Neil Teng · Answer

this is the error msg

Neil Teng · Answer

Cannot add invalid schema promises Reason Unit SIMPLE DATE FORMAT must belong to enum TimeUnit or DateTimeTransformUnit while sending request <http pinot controller 9000 schemas> to controller 9c91ad50509f version Unkno

Neil Teng · Answer

OK let me try add the unit part first

Neil Teng · Answer

added the unit solved the problem thanks it is a bug of my code