[ https://issues.apache.org/jira/browse/KYLIN-4901?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xiaoxiang Yu closed KYLIN-4901. ------------------------------- Released at kylin 3.1.2 > Query result use diff timezone in real-time stream > -------------------------------------------------- > > Key: KYLIN-4901 > URL: https://issues.apache.org/jira/browse/KYLIN-4901 > Project: Kylin > Issue Type: Bug > Components: Real-time Streaming > Reporter: Kun Liu > Assignee: Kun Liu > Priority: Major > Fix For: v3.1.2 > > Attachments: Different timezones for displaying results.png, other > non-derived time columns.png > > > When i test the real-time stream with timezone configuration, I find that the > query result use diff timezone format. > For example, I set the `kylin.stream.event.timezone` to GMT-1 (after i fix > the issue > [kylin-4900|https://issues.apache.org/jira/projects/KYLIN/issues/KYLIN-4900?filter=allopenissues]), > and push some data to kafka. > > The result of derived time column is GMT-8 format, but other time/date > columns are displayed using GMT+0 format. > > This result make me confused. > > How to reproduce > > 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 05:32:28 > GMT-1 or 2021-02-05 06:32:28 GMT-0 -- This message was sent by Atlassian Jira (v8.3.4#803005)