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/05/19 07:44:23 UTC
performance is slow when click "Jobs" tab on web
It always takes long time show "Loading Jobs", actually, there should not
be that much data in the hbase for the "jobs", why it is always slow to
fetch the jobs?
Re: performance is slow when click "Jobs" tab on web
Posted by jason zhong <he...@gmail.com>.
Resolved by @qianhao
https://issues.apache.org/jira/browse/KYLIN-773
On Tue, May 26, 2015 at 4:06 PM, Li Yang <li...@apache.org> wrote:
> Labels the JIRA "newbie", looks like a simple one.
>
> On Tue, May 19, 2015 at 7:38 PM, Luke Han <lu...@gmail.com> wrote:
>
> > This should be fixed in coming releases, will weave into coming sprint
> > plan.
> >
> > If anyone has bandwidth and interesting for this, please feel free to
> leave
> > your comments in JIRA.
> >
> > Thanks.
> >
> >
> > Best Regards!
> > ---------------------
> >
> > Luke Han
> >
> > 2015-05-19 17:11 GMT+08:00 周千昊 <z....@gmail.com>:
> >
> > > it is a known issue, since there is no secondary index on the job id,
> all
> > > job will be scanned (separately not in batch).
> > > So as the number of job increase, query time increases.
> > > As a workaround, you may just delete all entries whose the rowkey
> started
> > > with /execute/{job_id} and /execute_output/{job_id}
> > >
> > > jason zhong <he...@gmail.com>于2015年5月19日周二 下午4:53写道：
> > >
> > > > seems BasicService.listAllCubingJobs() takes a long time to fetch
> > > data.
> > > >
> > > > has fired a jirap ticket to track this
> > > >
> > > > https://issues.apache.org/jira/browse/KYLIN-773
> > > >
> > >
> >
>
Re: performance is slow when click "Jobs" tab on web
Posted by Li Yang <li...@apache.org>.
Labels the JIRA "newbie", looks like a simple one.
On Tue, May 19, 2015 at 7:38 PM, Luke Han <lu...@gmail.com> wrote:
> This should be fixed in coming releases, will weave into coming sprint
> plan.
>
> If anyone has bandwidth and interesting for this, please feel free to leave
> your comments in JIRA.
>
> Thanks.
>
>
> Best Regards!
> ---------------------
>
> Luke Han
>
> 2015-05-19 17:11 GMT+08:00 周千昊 <z....@gmail.com>:
>
> > it is a known issue, since there is no secondary index on the job id, all
> > job will be scanned (separately not in batch).
> > So as the number of job increase, query time increases.
> > As a workaround, you may just delete all entries whose the rowkey started
> > with /execute/{job_id} and /execute_output/{job_id}
> >
> > jason zhong <he...@gmail.com>于2015年5月19日周二 下午4:53写道：
> >
> > > seems BasicService.listAllCubingJobs() takes a long time to fetch
> > data.
> > >
> > > has fired a jirap ticket to track this
> > >
> > > https://issues.apache.org/jira/browse/KYLIN-773
> > >
> >
>
Re: performance is slow when click "Jobs" tab on web
Posted by Luke Han <lu...@gmail.com>.
This should be fixed in coming releases, will weave into coming sprint plan.
If anyone has bandwidth and interesting for this, please feel free to leave
your comments in JIRA.
Thanks.
Best Regards!
---------------------
Luke Han
2015-05-19 17:11 GMT+08:00 周千昊 <z....@gmail.com>:
> it is a known issue, since there is no secondary index on the job id, all
> job will be scanned (separately not in batch).
> So as the number of job increase, query time increases.
> As a workaround, you may just delete all entries whose the rowkey started
> with /execute/{job_id} and /execute_output/{job_id}
>
> jason zhong <he...@gmail.com>于2015年5月19日周二 下午4:53写道：
>
> > seems BasicService.listAllCubingJobs() takes a long time to fetch
> data.
> >
> > has fired a jirap ticket to track this
> >
> > https://issues.apache.org/jira/browse/KYLIN-773
> >
>
Re: performance is slow when click "Jobs" tab on web
Posted by 周千昊 <z....@gmail.com>.
it is a known issue, since there is no secondary index on the job id, all
job will be scanned (separately not in batch).
So as the number of job increase, query time increases.
As a workaround, you may just delete all entries whose the rowkey started
with /execute/{job_id} and /execute_output/{job_id}
jason zhong <he...@gmail.com>于2015年5月19日周二 下午4:53写道：
> seems BasicService.listAllCubingJobs() takes a long time to fetch data.
>
> has fired a jirap ticket to track this
>
> https://issues.apache.org/jira/browse/KYLIN-773
>
Re: performance is slow when click "Jobs" tab on web
Posted by jason zhong <he...@gmail.com>.
seems BasicService.listAllCubingJobs() takes a long time to fetch data.
has fired a jirap ticket to track this
https://issues.apache.org/jira/browse/KYLIN-773