[
https://issues.apache.org/jira/browse/KYLIN-2264?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15735521#comment-15735521
]
Shaofeng SHI commented on KYLIN-2264:
-------------------------------------
I think this is expected. The property "kylin.rest.timezone" will be used to
display the operation times on Web GUI, like last build time, etc. But it is
just for Kylin's Web GUI, not affect the query result.
In Cube, all the times has no timezone (it equals to GMT0); GMT0 time is also
called UTC or Epoch time; Java's System.currentTimeMillis() value is UTC, which
is used in streaming scenarios very often.
You mentioned that the result is 8 hours earlier than your expectation, because
you're comparing it with your local time which is GMT+8. If you adding the
timezone diff, they're matched.
In this post Julian has a good sharing about timestamp in Calciate and JDBC,
suggest to check if you haven't:
http://apache-kylin.74782.x6.nabble.com/JDBC-query-result-Date-column-get-wrong-value-td5370.html
> Date error when use new streaming cube in Kylin1.6.0
> ----------------------------------------------------
>
> Key: KYLIN-2264
> URL: https://issues.apache.org/jira/browse/KYLIN-2264
> Project: Kylin
> Issue Type: Bug
> Components: streaming, Web
> Affects Versions: v1.6.0
> Environment: Debian 3.2.54-2 x86_64 GNU/Linux
> Reporter: WangSheng
> Assignee: Shaofeng SHI
>
> I installed Kylin1.6.0 and built streaming cube successgfully.But I found two
> problems which I didn't met in Kylin1.5.*.
> First, segments' start/end time displayed on Kylin Web are earlier 8 hours
> than my PC date, but streaming cube's Last Build Time and Create Time
> displayed on Kylin Web are same with my PC date. Maybe something wrong when
> Kylin Web transform the segments' start/end timestamp into date, but I'm not
> sure.
> Second, I did sql query from streaming cube, but the records' time related
> columns like "HOUR_START" and "MINUTE_START" are all earlier 8 hours than my
> PC time. I found that these time related columns' timestamp from HBase are
> correct by remote debug, so I guess something wrong when Kylin server
> transform these timestamp into date.
> By the way, I only changed the "kylin.rest.timezone=GM+8" in file
> "kylin.properties", and my PC date is same with my server date.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
