Re: event time timezone is not correct

2019-03-05 Thread Piotr Nowojski
Hi, Yes, unfortunately this is still not resolved issue :( Piotrek > On 5 Mar 2019, at 04:34, 孙森 wrote: > > Thanks Piotrek. > > It seems the question has not been solved. I will try to use the > TIMESTAMPADD(timeUnit, integer, datetime) instead . > > Best > Sen > >> 在

Re: event time timezone is not correct

2019-03-04 Thread 孙森
Thanks Piotrek. It seems the question has not been solved. I will try to use the TIMESTAMPADD(timeUnit, integer, datetime) instead . Best Sen > 在 2019年3月4日,下午11:29,Piotr Nowojski 写道: > > Hi, > > I think that Flink SQL works currently only in UTC, so the 8 hours difference > is a result of

Re: event time timezone is not correct

2019-03-04 Thread Piotr Nowojski
Hi, I think that Flink SQL works currently only in UTC, so the 8 hours difference is a result of you using GMT+8 time stamps somewhere. Please take a look at this thread: http://mail-archives.apache.org/mod_mbox/flink-user/201711.mbox/%3c2e1eb190-26a0-b288-39a4-683b463f4...@apache.org%3E I

event time timezone is not correct

2019-03-03 Thread 孙森
Hi all: I am using flink sql with event time, but the field which acts as the routine is not correct in the output. There’s an eight-hour time difference. Any suggestion? My input is (ums_ts_ acts as the rowtime):