[KYLIN-4900] The result of derived time columns are error, when timezone is GMT-1 or GMT-N

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Fix Version/s: v3.1.2
• Component/s: Real-time Streaming
• Assignee: Kun Liu
• Reporter: Kun Liu
• Created: 05/Feb/21 01:55
• Updated: 27/Apr/21 02:33
• Resolved: 05/Mar/21 09:09

Description

When set the configuration of `kylin.stream.event.timezone` to GMT-1 or GMT-N, the result of DAY_START is error.

 

The data produced by use `$KYLIN_HOME/bin/kylin.sh org.apache.kylin.source.kafka.util.KafkaSampleProducer --topic kylin_streaming_topic --broker localhost:9092 --interval 10000`

 

message template is ：

2021-02-05 06:32:28,720 INFO [main] util.KafkaSampleProducer:136 : Sending 1 message: {"country":"US","amount":65.78351439157635,"qty":9,"currency":"USD","order_time":1612506748660,"category":"ELECTRONIC","device":"Windows","user":{"gender":"Male","id":"e1f07f05-9eff-46fa-d401-180d0441df13","first_name":"unknown","age":22}}

 

The order_time of first message is 1612506748660 which is 2021-02-05 14:32:28 GMT+8 or 2021-02-05 5:32:28 GMT-0

 

The query result is in the attachments.