Apache Pinot

image.png

Hi Team

Can anyone assist on this??
We are not able to consume messages from kafka from last day.

When I check Debug information for table. Not sure. how to procced with that can anyone assist??

did the format of the data in the timestamp field change in the last day?

&gt; which version of Pinot?
Pinot Version : 0.7.1
Pinot Chart Version: 0.2.5-SNAPSHOT

&gt; did the format of the data in the timestamp field change in the last day?
No

can you share the schema config for the timestamp field and an example of the data for that field?

Thanks for reply <@U01DS9A0DS4>
Hers's schema config:
```"dateTimeFieldSpecs": [
		{
			"name": "timestamp",
			"dataType": "STRING",
			"format": "1:HOURS:SIMPLE_DATE_FORMAT:yyyy/MM/dd HH:mm:ss'Z'",
			"granularity": "1:SECONDS"
		}
	]```


`"timestamp":"2022-04-11T05:13:27Z"`
Here's  example of the data for that field

in the format it seems like it's missing the `T` - I would expect it to be:

```"format": "1:HOURS:SIMPLE_DATE_FORMAT:yyyy/MM/dd''T''HH:mm:ss'Z'",```

although I'm not sure how it would have been working before 1 day ago as that issue would have still existed

Format does not match data is using “yyyy-MM-dd’’T’‘HH:mm:ss’Z’” and schema is declared at  “yyyy/MM/dd HH:mm:ss’Z’”

Thanks Let me update the schema and check. Hope updating will not cause any prob. to data inside table.