[jira] [Commented] (KYLIN-4901) Query result use diff timezone in real-time stream

["Kun Liu (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-4901?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17279392#comment-17279392 ] 

Kun Liu commented on KYLIN-4901:
--------------------------------

[~xxyu] PTAL and assign this issue to me.

> 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
>            Priority: Major
>         Attachments: Different timezones for displaying results.png
>
>
> When i test the real-time stream with timezone configuration, i can that the query result use diff timezone format.
>  For example, I set the `kylin.stream.event.timezone` to GMT+8, 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
>  
> 1. 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)