Hi there, we’ve got a field MSGDATETIME, with valu...
# troubleshooting
m
Hi there, we’ve got a field MSGDATETIME, with values like “2022-05-13T182125.444Z”. Trying to write the schema for it in Pinot as a time colume. However, with the following configuration:
"dateTimeFieldSpecs": [
{
"name": "MSGDATETIME",
"dataType": "STRING",
"format": "1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd'T'HH:mm:ss.fff'Z'",
"granularity": "1:MILLISECONDS"
}
],
Pinot reports that
invalid datetime format: 1MILLISECONDSSIMPLE_DATE_FORMATyyyy MM dd’T’HHmm:ss.fff’Z’”
What would be the right way to write this schema?
nvm. I figured why. Was mixing the ‘f’ notation with the “S” notation
m
@Fizza Abid