[GitHub] samsai commented on issue #7180: [FLINK-11010] [TABLE] Flink SQL timestamp is inconsistent with currentProcessingTime()

2018-12-11 Thread GitBox 
samsai commented on issue #7180: [FLINK-11010] [TABLE] Flink SQL timestamp is 
inconsistent with currentProcessingTime()
URL: https://github.com/apache/flink/pull/7180#issuecomment-446445016
 
 
   @walterddr could you please check the timezone problem when dealing with 
eventtime?  
   it seems that lamber-ken's commit only fixed proc time.  
   Would you please refer to my previous comment to take a look at my eventtime 
usecase. thanks a lot!
   


This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

[GitHub] samsai commented on issue #7180: [FLINK-11010] [TABLE] Flink SQL timestamp is inconsistent with currentProcessingTime()

2018-12-10 Thread GitBox 
samsai commented on issue #7180: [FLINK-11010] [TABLE] Flink SQL timestamp is 
inconsistent with currentProcessingTime()
URL: https://github.com/apache/flink/pull/7180#issuecomment-446041717
 
 
   i got the same problem too:
   val format = new SimpleDateFormat("-MM-dd HH:mm:ssZ")
   val origin: DataStream[TransactionEvent] = env.fromCollection(List(
 TransactionEvent("u1", format.parse("2018-01-02 01:13:30+0800"), 10)
   ))
   val source2 = origin
 .assignTimestampsAndWatermarks(new 
BoundedOutOfOrdernessTimestampExtractor[TransactionEvent](Time.minutes(1)){
   override def extractTimestamp(element: TransactionEvent): Long = {
 val timestamp = element.time.getTime
 println(s"extractTimestamp:$timestamp")
 timestamp
   }
 })
   tEnv.fromDataStream(source2, 'user,'eventTime.rowtime)
 .toAppendStream[Row].print()
   
   I got eventTime as 2018-01-01 17:13:30.0, which is 8hours delayed


This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services