Hi,

I hope we can solve this issues with the new type system. The core problem is the old planner uses java.sql.Timestamp which depends on the timezone of the current machine. I would recommend to set everything to UTC if possible for now.

Regards,
Timo


On 03.12.19 18:49, Lasse Nedergaard wrote:
Hi.

We have the same Challenges. I asked on Flink forward and it’s a known problem. We input in utc but Flink output in local machine time. We have created a function that converts it back to utc before collecting to down stream.

Med venlig hilsen / Best regards
Lasse Nedergaard


Den 3. dec. 2019 kl. 15.16 skrev Wojciech Indyk <wojciechin...@gmail.com <mailto:wojciechin...@gmail.com>>:

Hi!
I use Flink 1.8 with Scala. I think I've found a problem with event timestamps in TableAPI. When I mark my timestamp: Long as .rowtime and then save it back to stream as sql.Timestamp I will get wrong .getTime result. The gist for reproduction is here: https://gist.github.com/woj-i/b1dfbb71590b7f1c0c58be1f9e41c610
When I change my timezome from GMT+1 to GMT everything works ok.
I've found this post from March http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/event-time-timezone-is-not-correct-tt26457.html but it's not resolved. The most relevant ticket I've found https://issues.apache.org/jira/browse/FLINK-8353 seems to not include the problem I described.

1. Can you confirm it's a bug?
2. Should I post this bug somewhere to be at least planned to solve?
3. Can you recommend me a workaround for the described problem?

--
Kind regards/ Pozdrawiam,
Wojciech Indyk

Reply via email to