Apache Pinot

image.png

I am getting date in this format, used the following schema configuration:  "name": "dispatch_date",
      "dataType": "STRING" With timestamp, it doesn't work.

What does the date time field spec look like?

```"dimensionFieldSpecs": [
    {
      "name": "dispatch_date",
      "dataType": "STRING"
    }```

please specify the format: <https://docs.pinot.apache.org/configuration-reference/schema#datetimefieldspec>

The job isn't triggered if I change format.

Seems like you specified it as dimension and not time?

So type will be datetime and fieldtype will be?

Is logging enabled in pinot? How can I debug and check errors?

do you intend to make it a dimension field or date time field?

I want date, in my file the format is yyyy-MM-dd so I want date will late use it in join.

could you try to follow the link to make it a dateTimeField?

I tried, even used this, still didn't work
```{
  "schemaName": "metrics",
  "dateTimeFieldSpecs": [
    {
      "name": "dispatch_date",
      "dataType": "LONG",
      "format": "1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd",
      "granularity": "1:DAYS"
    }
  ]
}```

I guess your value does not follow the format       "format": "1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd",

I see your value is 19125 but not yyyy-MM-dd

No it's coming but original date is in this format in file. When I do it as string, it comes this way.

could you please try
```{
  "schemaName": "metrics",
  "dateTimeFieldSpecs": [
    {
      "name": "dispatch_date",
      "dataType": "STRING",
      "format": "1:DAYS:SIMPLE_DATE_FORMAT:yyyy-MM-dd",
      "granularity": "1:DAYS"
    }
  ]
}```


I guess maybe I have some misunderstanding here. Could you please share one example date value in your source file?