You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by dong wang <el...@gmail.com> on 2015/03/03 07:14:03 UTC
about the setting of time zone for Kylin
1, on web GUI, when we build a cube, a job is started, whose name is based
on the selected date(suppose that partition column is date type) with PST
timezone, so could we change the default timezone to GMT or something else?
2, when using RESTFUL API to rebuild a cube, we should assign the startTime
and endTime as parameters in millseconds, so what's timezone will be used
internally?and also, can we adjust the timezone?
Re: about the setting of time zone for Kylin
Posted by jason zhong <he...@gmail.com>.
@dong
*Q*: 1, on web GUI, when we build a cube, a job is started, whose name is
based
on the selected date(suppose that partition column is date type) with PST
timezone, so could we change the default timezone to GMT or something else?
-----------------------------
*A*:In kylin.properties you can config *kylin.rest.timezone*=*GMT+X* or
*GMT-X* , e.g. you can config GMT+0 as GMT 0 timezone ,by default the
timezone is PST(GMT-8)
*Q:*2, when using RESTFUL API to rebuild a cube, we should assign the
startTime
and endTime as parameters in millseconds, so what's timezone will be used
internally?and also, can we adjust the timezone?
------------------------------
*A:* for cube build startTime and endTime,we use GMT+0 by default.
currently it's not configurable
On Tue, Mar 3, 2015 at 2:14 PM, dong wang <el...@gmail.com> wrote:
> 1, on web GUI, when we build a cube, a job is started, whose name is based
> on the selected date(suppose that partition column is date type) with PST
> timezone, so could we change the default timezone to GMT or something else?
>
> 2, when using RESTFUL API to rebuild a cube, we should assign the startTime
> and endTime as parameters in millseconds, so what's timezone will be used
> internally?and also, can we adjust the timezone?
>
Re: about the setting of time zone for Kylin
Posted by jason zhong <he...@gmail.com>.
*Q:*a further question: if I want to daily refresh a cube, i.e.
2015-03-03(just one day)...
*A:*Yes
On Tue, Mar 3, 2015 at 2:42 PM, dong wang <el...@gmail.com> wrote:
> a further question: if I want to daily refresh a cube, i.e.
> 2015-03-03(just one day), based on the SQL from the tomcat/logs/kylin.log,
> should I get the millseconds of "2015-03-03 00:00:00" as the restful API's
> startTime? and "2015-03-04 00:00:00" as the parameter endTime?
>
> 2015-03-03 14:31 GMT+08:00 周千昊 <z....@gmail.com>:
>
> > Hi, dong
> > 1. currently there is no config for TIMEZONE
> > 2. time in milliseconds is also in PST time
> > we have gone through this issue and we are working on a display
> > time-zone for users not in PST
> >
> > On Tue, Mar 3, 2015 at 2:14 PM dong wang <el...@gmail.com> wrote:
> >
> > > 1, on web GUI, when we build a cube, a job is started, whose name is
> > based
> > > on the selected date(suppose that partition column is date type) with
> PST
> > > timezone, so could we change the default timezone to GMT or something
> > else?
> > >
> > > 2, when using RESTFUL API to rebuild a cube, we should assign the
> > startTime
> > > and endTime as parameters in millseconds, so what's timezone will be
> used
> > > internally?and also, can we adjust the timezone?
> > >
> >
>
Re: about the setting of time zone for Kylin
Posted by dong wang <el...@gmail.com>.
a further question: if I want to daily refresh a cube, i.e.
2015-03-03(just one day), based on the SQL from the tomcat/logs/kylin.log,
should I get the millseconds of "2015-03-03 00:00:00" as the restful API's
startTime? and "2015-03-04 00:00:00" as the parameter endTime?
2015-03-03 14:31 GMT+08:00 周千昊 <z....@gmail.com>:
> Hi, dong
> 1. currently there is no config for TIMEZONE
> 2. time in milliseconds is also in PST time
> we have gone through this issue and we are working on a display
> time-zone for users not in PST
>
> On Tue, Mar 3, 2015 at 2:14 PM dong wang <el...@gmail.com> wrote:
>
> > 1, on web GUI, when we build a cube, a job is started, whose name is
> based
> > on the selected date(suppose that partition column is date type) with PST
> > timezone, so could we change the default timezone to GMT or something
> else?
> >
> > 2, when using RESTFUL API to rebuild a cube, we should assign the
> startTime
> > and endTime as parameters in millseconds, so what's timezone will be used
> > internally?and also, can we adjust the timezone?
> >
>
Re: about the setting of time zone for Kylin
Posted by 周千昊 <z....@gmail.com>.
Hi, dong
1. currently there is no config for TIMEZONE
2. time in milliseconds is also in PST time
we have gone through this issue and we are working on a display
time-zone for users not in PST
On Tue, Mar 3, 2015 at 2:14 PM dong wang <el...@gmail.com> wrote:
> 1, on web GUI, when we build a cube, a job is started, whose name is based
> on the selected date(suppose that partition column is date type) with PST
> timezone, so could we change the default timezone to GMT or something else?
>
> 2, when using RESTFUL API to rebuild a cube, we should assign the startTime
> and endTime as parameters in millseconds, so what's timezone will be used
> internally?and also, can we adjust the timezone?
>