Hi there, anyone know what should be the schema fo...
# troubleshootingn
Neil Teng
05/26/2021, 7:16 PMHi there, anyone know what should be the schema for such time format?
2021-05-19T180823.583Z
Had tried but no luck
Copy code
{
"name": "date",
"dataType": "STRING",
"format": "1:SIMPLE_DATE_FORMAT:yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",
"granularity": "1:MILLISECONDS"
},m
Mayank
05/26/2021, 7:27 PM
@Neha Pawar ^^
n
Neha Pawar
05/26/2021, 8:01 PM
looks right. I’ve used this in the past successfully
Copy code
"format": "1:HOURS:SIMPLE_DATE_FORMAT:yyyy-MM-dd'T'HH:mm:ss.SSS'Z'",Neha Pawar
05/26/2021, 8:01 PM
what fails?
j
Jackie
05/26/2021, 8:04 PMI think @Neil Teng missed the unit part
👍 1
Jackie
05/26/2021, 8:04 PMWe should remove the unit part for
SIMPLE_DATE_FORMATn
Neil Teng
05/26/2021, 8:08 PMthis is the error msg
Neil Teng
05/26/2021, 8:08 PM"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
05/26/2021, 8:08 PMOK, let me try add the unit part first
Neil Teng
05/26/2021, 8:12 PMadded the unit solved the problem, thanks. it is a bug of my code.