dianaarnos commented on issue #7758: URL: https://github.com/apache/pinot/issues/7758#issuecomment-968915918
I made `dateTimeConvert()` run successfully by changing bucketing from `30:DAYS` to `15:DAYS` ```sql DATETIMECONVERT(operationDate, '1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM-dd''T''HH:mm:ss.SSSZ', '1:MILLISECONDS:SIMPLE_DATE_FORMAT:yyyy-MM', '15:DAYS') ``` Other than that, I noticed a couple of messages had a malformed RFC3339. After fixing those everything worked fine. In case anyone had to deal with a similar problem: Original RFC3339 format looks like the following: `yyyy-MM-ddTHH:mm:ss.SSSZ`. So a correct dateTime would be something like: `2021-05-20T12:55:54.000+00:00` Some of my messages had values like: ``2021-05-20T12:55:54.000+0000` -> there is a colon missing on `+0000`. It should be `+00:00` instead. I'm closing this and thanks for the help :) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
