New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
TIMESTAMP_FORMAT does not respect '' escaping #1439
Comments
Try to use double quotes, like so |
Is that not the same as what he posted? |
Not sure of the formatting, but it looks like there are two single quotes |
Oh. The docs definitely have two
|
I am hitting this error too, on 5.0.0.
|
It would be nice to be able to use the pre-defined formatters? e.g.
|
Seems CSAS handles the datetime parsing differently from simply
|
Hit the same problem here. Still no solutions? |
@apurvam I tried two single quotes and one double quotes. Neither works. All my kafka topics have timestamps like |
I've marked this as a bug. |
Appreciated the help. Meanwhile, I will use unix timestamp for all my kafka topics. |
As a temporary work-around, you can do the following: Given a timestamp such as
|
CREATE STREAM foo (thing_id BIGINT, event_timestamp VARCHAR) WITH (VALUE_FORMAT='JSON', KAFKA_TOPIC='triggers', TIMESTAMP='event_timestamp', TIMESTAMP_FORMAT='yyyy-MM-dd''T''HH:mm:ssX');
The above appears to work. But trying to select from the streams results in the following:
Caused by: Invalid value java.lang.IllegalArgumentException: Unknown pattern letter: T for configuration Invalid date format: yyyy-MM-dd''T''HH:mm:ssX Unknown pattern letter: T
Version: 5.0.0-beta30
The text was updated successfully, but these errors were encountered: