kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Billy Liu <billy...@apache.org>
Subject Re: Re: Question Of TimeZone
Date Sun, 16 Jul 2017 04:56:38 GMT
The internal timestamp value will not change, it still the epoch timestamp.
Have you tried to read the result through JDBC, with Timezone setting?
"2017-07-11 01:18:36" is the GMT time, not GMT+8 time.

2017-07-14 10:59 GMT+08:00 junpan2@iflytek.com <junpan2@iflytek.com>:

> the situation is : For exaple : the origin value the column I specify as
> the business timestamp is : 1499735916686, converted to beijing time
> shoule be 2017-07-11 09:18:36,
> but when searching data the web GUI shows the value is : 2017-07-11
> 01:18:36.
> How Hbase save the data? as 1499735916686 or 2017-07-11 01:18:36?  Or
> when the convertion of long to timestamp  happens?
>
> ------------------------------
> junpan2@iflytek.com
>
>
> *From:* ShaoFeng Shi <shaofengshi@apache.org>
> *Date:* 2017-07-14 10:37
> *To:* user <user@kylin.apache.org>
> *Subject:* Re: Question Of TimeZone
> The timestamp in Cube has no timezone info. If you want to convert it to a
> specific timezone, the application side need do the conversion.
>
> In Calcite's online document (https://calcite.
> apache.org/docs/reference.html), there is this statement:
>
> *DATE, TIME and TIMESTAMP have no time zone. There is not even an implicit
> time zone, such as UTC (as in Java) or the local time zone. It is left to
> the user or application to supply a time zone*
>
>
> 2017-07-13 19:56 GMT+08:00 junpan2@iflytek.com <junpan2@iflytek.com>:
>
>> Hi,
>>       Recently I tried to use Kylin Streaming to do something,but I got
>> some problems:
>> First I specified  a longmills column ENDTIME  as  the timestamp
>> column,and used a derived column  MIMUTE_START .
>> After I succeeded to bulid a cube and began to serarch data from the WEB
>> GUI, I faced the following situation:
>> the value of the column I specified  and the derived column has 8 HOURS
>> difference with the corrent time they present.
>> I guess the problem is due to TIMEZONE, so I tried to change "GMT" to
>> "GMT+08" in the kylin original code.
>> Unfortunately,it does not work! So what I need to do to solve this
>> problem?
>> Thanks!
>>
>> For examples:
>> the columns ENDTIME and MINUTE_START is 2017-07-11 01:18,
>> actually,they should be 2017-07-11 09:18.
>>
>> ------------------------------
>> junpan2@iflytek.com
>>
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>
>

Mime
View raw message