You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 汪胜 <sk...@163.com> on 2016/12/09 01:46:16 UTC
Date error when query streaming cube
Sorry for that. I used JDBC and Kylin Web to test the sql query for streaming cube, but the records came from JDBC and Kylin Web are incorrect. All of theses records' date are earlier than my PC date(8 hours).
I found that records came from Kylin server are incorrected when I did query by remote debug. I guess something wrong when Kylin parsed messages from kafka, maybe the default time parser class didn't took the timezone into consideration? I'm not sure.
Another probelm is the segments' start/end time displayed on Kylin Web, also earlier than my PC date. I checked the cube's json data storaged in HBase, and I found that these segments' start/end timestamp(transfromed in to date manually) are same with my PC date. If there any probelm when Kylin web tranform the segments' timestamp into date in new streaming cube?
Re: Re: Re: Re: Date error when query streaming cube
Posted by 汪胜 <sk...@163.com>.
Of coure, I created an JIRA for my problems.Here is the url: https://issues.apache.org/jira/browse/KYLIN-2264
On 12/9/2016 14:48, Billy Liu<bi...@apache.org>wrote:
Could you file an JIRA for this issue? The segment time may not process
properly.
2016-12-09 14:26 GMT+08:00 汪胜 <sk...@163.com>:
> Yes, server date is same with PC date. And I didn't found this situation
> in Kylin 1.5.*. I'm confused that cube's Last Build Time and Create Time
> displayed on Kylin Web are same with PC date, but segments' start time and
> end time are eralier 8 hours than PC date. Aren't they used the same
> timezone?
>
>
>
> On 12/9/2016 14:04, Billy Liu<bi...@apache.org>wrote:
>
> How about your server timezone? Is your server at the right time? Try run
> 'date' on your server.
>
> 2016-12-09 13:58 GMT+08:00 汪胜 <sk...@163.com>:
>
> > I only changed "kylin.rest.timezone=GMT" to "kylin.rest.timezone=GM+8" in
> > file "kylin.properties", and I don't know kylin.web.timezone, this
> > propertiey should be default.
> >
> >
> >
> >
> > On 12/9/2016 12:05, Billy Liu<bi...@apache.org>wrote:
> >
> > Thanks for the reporting. Could you provide more information? including
> > Kylin server timezone, kylin.web.timezone.
> >
> > 2016-12-09 9:46 GMT+08:00 汪胜 <sk...@163.com>:
> >
> > > Sorry for that. I used JDBC and Kylin Web to test the sql query for
> > > streaming cube, but the records came from JDBC and Kylin Web are
> > incorrect.
> > > All of theses records' date are earlier than my PC date(8 hours).
> > >
> > >
> > > I found that records came from Kylin server are incorrected when I did
> > > query by remote debug. I guess something wrong when Kylin parsed
> messages
> > > from kafka, maybe the default time parser class didn't took the
> timezone
> > > into consideration? I'm not sure.
> > >
> > >
> > > Another probelm is the segments' start/end time displayed on Kylin Web,
> > > also earlier than my PC date. I checked the cube's json data storaged
> in
> > > HBase, and I found that these segments' start/end timestamp(transfromed
> > in
> > > to date manually) are same with my PC date. If there any probelm when
> > Kylin
> > > web tranform the segments' timestamp into date in new streaming cube?
> >
>
Re: Re: Re: Date error when query streaming cube
Posted by Billy Liu <bi...@apache.org>.
Could you file an JIRA for this issue? The segment time may not process
properly.
2016-12-09 14:26 GMT+08:00 汪胜 <sk...@163.com>:
> Yes, server date is same with PC date. And I didn't found this situation
> in Kylin 1.5.*. I'm confused that cube's Last Build Time and Create Time
> displayed on Kylin Web are same with PC date, but segments' start time and
> end time are eralier 8 hours than PC date. Aren't they used the same
> timezone?
>
>
>
> On 12/9/2016 14:04, Billy Liu<bi...@apache.org>wrote:
>
> How about your server timezone? Is your server at the right time? Try run
> 'date' on your server.
>
> 2016-12-09 13:58 GMT+08:00 汪胜 <sk...@163.com>:
>
> > I only changed "kylin.rest.timezone=GMT" to "kylin.rest.timezone=GM+8" in
> > file "kylin.properties", and I don't know kylin.web.timezone, this
> > propertiey should be default.
> >
> >
> >
> >
> > On 12/9/2016 12:05, Billy Liu<bi...@apache.org>wrote:
> >
> > Thanks for the reporting. Could you provide more information? including
> > Kylin server timezone, kylin.web.timezone.
> >
> > 2016-12-09 9:46 GMT+08:00 汪胜 <sk...@163.com>:
> >
> > > Sorry for that. I used JDBC and Kylin Web to test the sql query for
> > > streaming cube, but the records came from JDBC and Kylin Web are
> > incorrect.
> > > All of theses records' date are earlier than my PC date(8 hours).
> > >
> > >
> > > I found that records came from Kylin server are incorrected when I did
> > > query by remote debug. I guess something wrong when Kylin parsed
> messages
> > > from kafka, maybe the default time parser class didn't took the
> timezone
> > > into consideration? I'm not sure.
> > >
> > >
> > > Another probelm is the segments' start/end time displayed on Kylin Web,
> > > also earlier than my PC date. I checked the cube's json data storaged
> in
> > > HBase, and I found that these segments' start/end timestamp(transfromed
> > in
> > > to date manually) are same with my PC date. If there any probelm when
> > Kylin
> > > web tranform the segments' timestamp into date in new streaming cube?
> >
>
Re: Re: Re: Date error when query streaming cube
Posted by 汪胜 <sk...@163.com>.
Yes, server date is same with PC date. And I didn't found this situation in Kylin 1.5.*. I'm confused that cube's Last Build Time and Create Time displayed on Kylin Web are same with PC date, but segments' start time and end time are eralier 8 hours than PC date. Aren't they used the same timezone?
On 12/9/2016 14:04, Billy Liu<bi...@apache.org>wrote:
How about your server timezone? Is your server at the right time? Try run
'date' on your server.
2016-12-09 13:58 GMT+08:00 汪胜 <sk...@163.com>:
> I only changed "kylin.rest.timezone=GMT" to "kylin.rest.timezone=GM+8" in
> file "kylin.properties", and I don't know kylin.web.timezone, this
> propertiey should be default.
>
>
>
>
> On 12/9/2016 12:05, Billy Liu<bi...@apache.org>wrote:
>
> Thanks for the reporting. Could you provide more information? including
> Kylin server timezone, kylin.web.timezone.
>
> 2016-12-09 9:46 GMT+08:00 汪胜 <sk...@163.com>:
>
> > Sorry for that. I used JDBC and Kylin Web to test the sql query for
> > streaming cube, but the records came from JDBC and Kylin Web are
> incorrect.
> > All of theses records' date are earlier than my PC date(8 hours).
> >
> >
> > I found that records came from Kylin server are incorrected when I did
> > query by remote debug. I guess something wrong when Kylin parsed messages
> > from kafka, maybe the default time parser class didn't took the timezone
> > into consideration? I'm not sure.
> >
> >
> > Another probelm is the segments' start/end time displayed on Kylin Web,
> > also earlier than my PC date. I checked the cube's json data storaged in
> > HBase, and I found that these segments' start/end timestamp(transfromed
> in
> > to date manually) are same with my PC date. If there any probelm when
> Kylin
> > web tranform the segments' timestamp into date in new streaming cube?
>
Re: Re: Date error when query streaming cube
Posted by Billy Liu <bi...@apache.org>.
How about your server timezone? Is your server at the right time? Try run
'date' on your server.
2016-12-09 13:58 GMT+08:00 汪胜 <sk...@163.com>:
> I only changed "kylin.rest.timezone=GMT" to "kylin.rest.timezone=GM+8" in
> file "kylin.properties", and I don't know kylin.web.timezone, this
> propertiey should be default.
>
>
>
>
> On 12/9/2016 12:05, Billy Liu<bi...@apache.org>wrote:
>
> Thanks for the reporting. Could you provide more information? including
> Kylin server timezone, kylin.web.timezone.
>
> 2016-12-09 9:46 GMT+08:00 汪胜 <sk...@163.com>:
>
> > Sorry for that. I used JDBC and Kylin Web to test the sql query for
> > streaming cube, but the records came from JDBC and Kylin Web are
> incorrect.
> > All of theses records' date are earlier than my PC date(8 hours).
> >
> >
> > I found that records came from Kylin server are incorrected when I did
> > query by remote debug. I guess something wrong when Kylin parsed messages
> > from kafka, maybe the default time parser class didn't took the timezone
> > into consideration? I'm not sure.
> >
> >
> > Another probelm is the segments' start/end time displayed on Kylin Web,
> > also earlier than my PC date. I checked the cube's json data storaged in
> > HBase, and I found that these segments' start/end timestamp(transfromed
> in
> > to date manually) are same with my PC date. If there any probelm when
> Kylin
> > web tranform the segments' timestamp into date in new streaming cube?
>
Re: Re: Date error when query streaming cube
Posted by 汪胜 <sk...@163.com>.
I only changed "kylin.rest.timezone=GMT" to "kylin.rest.timezone=GM+8" in file "kylin.properties", and I don't know kylin.web.timezone, this propertiey should be default.
On 12/9/2016 12:05, Billy Liu<bi...@apache.org>wrote:
Thanks for the reporting. Could you provide more information? including
Kylin server timezone, kylin.web.timezone.
2016-12-09 9:46 GMT+08:00 汪胜 <sk...@163.com>:
> Sorry for that. I used JDBC and Kylin Web to test the sql query for
> streaming cube, but the records came from JDBC and Kylin Web are incorrect.
> All of theses records' date are earlier than my PC date(8 hours).
>
>
> I found that records came from Kylin server are incorrected when I did
> query by remote debug. I guess something wrong when Kylin parsed messages
> from kafka, maybe the default time parser class didn't took the timezone
> into consideration? I'm not sure.
>
>
> Another probelm is the segments' start/end time displayed on Kylin Web,
> also earlier than my PC date. I checked the cube's json data storaged in
> HBase, and I found that these segments' start/end timestamp(transfromed in
> to date manually) are same with my PC date. If there any probelm when Kylin
> web tranform the segments' timestamp into date in new streaming cube?
Re: Date error when query streaming cube
Posted by Billy Liu <bi...@apache.org>.
Thanks for the reporting. Could you provide more information? including
Kylin server timezone, kylin.web.timezone.
2016-12-09 9:46 GMT+08:00 汪胜 <sk...@163.com>:
> Sorry for that. I used JDBC and Kylin Web to test the sql query for
> streaming cube, but the records came from JDBC and Kylin Web are incorrect.
> All of theses records' date are earlier than my PC date(8 hours).
>
>
> I found that records came from Kylin server are incorrected when I did
> query by remote debug. I guess something wrong when Kylin parsed messages
> from kafka, maybe the default time parser class didn't took the timezone
> into consideration? I'm not sure.
>
>
> Another probelm is the segments' start/end time displayed on Kylin Web,
> also earlier than my PC date. I checked the cube's json data storaged in
> HBase, and I found that these segments' start/end timestamp(transfromed in
> to date manually) are same with my PC date. If there any probelm when Kylin
> web tranform the segments' timestamp into date in new streaming cube?