You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Kun Liu (Jira)" <ji...@apache.org> on 2021/02/05 06:35:00 UTC
[jira] [Updated] (KYLIN-4900) The result of derived time columns
are error, when timezone is GMT-1 or GMT-N
[ https://issues.apache.org/jira/browse/KYLIN-4900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kun Liu updated KYLIN-4900:
---------------------------
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 6:32:28 GMT+0
was:When set the configuration of `kylin.stream.event.timezone` to GMT-1 or GMT-N, the result of DAY_START is error.
> The result of derived time columns are error, when timezone is GMT-1 or GMT-N
> -----------------------------------------------------------------------------
>
> Key: KYLIN-4900
> URL: https://issues.apache.org/jira/browse/KYLIN-4900
> Project: Kylin
> Issue Type: Bug
> Components: Real-time Streaming
> Reporter: Kun Liu
> Priority: Blocker
>
> 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 6:32:28 GMT+0
--
This message was sent by Atlassian Jira
(v8.3.4#803005)