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/13 07:30:53 UTC
Create Aggr Func(SUM,MIN,MAX) For Every Measure
Hello all,
I have many measures(about fifty), and I have to create SUM, MIN and MAX for every measure. Is there any good ways to create them at a time instead of create one by one?
Re: Re: Create Aggr Func(SUM,MIN,MAX) For Every Measure
Posted by Li Yang <li...@apache.org>.
Cannot agree more. GUI has many to improve..
On Sun, Dec 18, 2016 at 11:27 PM, Alberto Ramón <a....@gmail.com>
wrote:
> yes, Nowadays, I'm doing a performance testing creating a lot of cubes,
> changing configuration of dimensions to evaluate their impact on building
> time and size of cube
>
> I'm bored of Create Cube Wizard :(, a lot of clicks !!
>
> Some small changes:
>
> * Default names of columns. I think this will be a new feature in 1.6.1 ??
> * Add Normal and Derived Dim, can be faster if see all available columns
> and tables in the main windows (Similar to add Joint Dim)
> * Add Measures UI is very heavy ... Default names? add all measures of the
> one column at same time (no measure by measure)
> .... Other people will have a lot of better ideas, I'm sure !!
>
> Did I dream that you will load / save the Create Cube configuration wizard
> to a file using UI ? now I can't find JIRA.
> Will be great save & load configuration of unfinished cubes
>
> 2016-12-18 11:43 GMT+01:00 Luke Han <lu...@gmail.com>:
>
> > There's REST API for cube creation, you could try to write some scripts
> to
> > bulk load measures.
> >
> > Thanks.
> >
> >
> > Best Regards!
> > ---------------------
> >
> > Luke Han
> >
> > On Sun, Dec 18, 2016 at 2:23 PM, Li Yang <li...@apache.org> wrote:
> >
> > > Btw it is not often that MIN/MAX is as useful as SUM. For the sake of
> > build
> > > time and storage, you may not want to add MAX/MIN for every measure.
> > >
> > > On Tue, Dec 13, 2016 at 9:44 PM, 汪胜 <sk...@163.com> wrote:
> > >
> > > > Thanks for your suggestion! I'll try this way.
> > > >
> > > >
> > > >
> > > > 在2016年12月13日 21:26， Billy Liu<bi...@apache.org>写道：
> > > >
> > > > Maybe you could edit the cube json directly, but be careful always.
> > > >
> > > > 2016-12-13 15:30 GMT+08:00 汪胜 <sk...@163.com>:
> > > >
> > > > > Hello all,
> > > > > I have many measures(about fifty), and I have to create SUM,
> MIN
> > > and
> > > > > MAX for every measure. Is there any good ways to create them at a
> > time
> > > > > instead of create one by one?
> > > > >
> > > > >
> > > >
> > >
> >
>
Re: Re: Create Aggr Func(SUM,MIN,MAX) For Every Measure
Posted by Alberto Ramón <a....@gmail.com>.
yes, Nowadays, I'm doing a performance testing creating a lot of cubes,
changing configuration of dimensions to evaluate their impact on building
time and size of cube
I'm bored of Create Cube Wizard :(, a lot of clicks !!
Some small changes:
* Default names of columns. I think this will be a new feature in 1.6.1 ??
* Add Normal and Derived Dim, can be faster if see all available columns
and tables in the main windows (Similar to add Joint Dim)
* Add Measures UI is very heavy ... Default names? add all measures of the
one column at same time (no measure by measure)
.... Other people will have a lot of better ideas, I'm sure !!
Did I dream that you will load / save the Create Cube configuration wizard
to a file using UI ? now I can't find JIRA.
Will be great save & load configuration of unfinished cubes
2016-12-18 11:43 GMT+01:00 Luke Han <lu...@gmail.com>:
> There's REST API for cube creation, you could try to write some scripts to
> bulk load measures.
>
> Thanks.
>
>
> Best Regards!
> ---------------------
>
> Luke Han
>
> On Sun, Dec 18, 2016 at 2:23 PM, Li Yang <li...@apache.org> wrote:
>
> > Btw it is not often that MIN/MAX is as useful as SUM. For the sake of
> build
> > time and storage, you may not want to add MAX/MIN for every measure.
> >
> > On Tue, Dec 13, 2016 at 9:44 PM, 汪胜 <sk...@163.com> wrote:
> >
> > > Thanks for your suggestion! I'll try this way.
> > >
> > >
> > >
> > > 在2016年12月13日 21:26， Billy Liu<bi...@apache.org>写道：
> > >
> > > Maybe you could edit the cube json directly, but be careful always.
> > >
> > > 2016-12-13 15:30 GMT+08:00 汪胜 <sk...@163.com>:
> > >
> > > > Hello all,
> > > > I have many measures(about fifty), and I have to create SUM, MIN
> > and
> > > > MAX for every measure. Is there any good ways to create them at a
> time
> > > > instead of create one by one?
> > > >
> > > >
> > >
> >
>
Re: Re: Create Aggr Func(SUM,MIN,MAX) For Every Measure
Posted by Luke Han <lu...@gmail.com>.
There's REST API for cube creation, you could try to write some scripts to
bulk load measures.
Thanks.
Best Regards!
---------------------
Luke Han
On Sun, Dec 18, 2016 at 2:23 PM, Li Yang <li...@apache.org> wrote:
> Btw it is not often that MIN/MAX is as useful as SUM. For the sake of build
> time and storage, you may not want to add MAX/MIN for every measure.
>
> On Tue, Dec 13, 2016 at 9:44 PM, 汪胜 <sk...@163.com> wrote:
>
> > Thanks for your suggestion! I'll try this way.
> >
> >
> >
> > 在2016年12月13日 21:26， Billy Liu<bi...@apache.org>写道：
> >
> > Maybe you could edit the cube json directly, but be careful always.
> >
> > 2016-12-13 15:30 GMT+08:00 汪胜 <sk...@163.com>:
> >
> > > Hello all,
> > > I have many measures(about fifty), and I have to create SUM, MIN
> and
> > > MAX for every measure. Is there any good ways to create them at a time
> > > instead of create one by one?
> > >
> > >
> >
>
Re: Re: Create Aggr Func(SUM,MIN,MAX) For Every Measure
Posted by Li Yang <li...@apache.org>.
Btw it is not often that MIN/MAX is as useful as SUM. For the sake of build
time and storage, you may not want to add MAX/MIN for every measure.
On Tue, Dec 13, 2016 at 9:44 PM, 汪胜 <sk...@163.com> wrote:
> Thanks for your suggestion! I'll try this way.
>
>
>
> 在2016年12月13日 21:26， Billy Liu<bi...@apache.org>写道：
>
> Maybe you could edit the cube json directly, but be careful always.
>
> 2016-12-13 15:30 GMT+08:00 汪胜 <sk...@163.com>:
>
> > Hello all,
> > I have many measures(about fifty), and I have to create SUM, MIN and
> > MAX for every measure. Is there any good ways to create them at a time
> > instead of create one by one?
> >
> >
>
回复：Re: Create Aggr Func(SUM,MIN,MAX) For Every Measure
Posted by 汪胜 <sk...@163.com>.
Thanks for your suggestion! I'll try this way.
在2016年12月13日 21:26， Billy Liu<bi...@apache.org>写道：
Maybe you could edit the cube json directly, but be careful always.
2016-12-13 15:30 GMT+08:00 汪胜 <sk...@163.com>:
> Hello all,
> I have many measures(about fifty), and I have to create SUM, MIN and
> MAX for every measure. Is there any good ways to create them at a time
> instead of create one by one?
>
>
Re: Create Aggr Func(SUM,MIN,MAX) For Every Measure
Posted by Billy Liu <bi...@apache.org>.
Maybe you could edit the cube json directly, but be careful always.
2016-12-13 15:30 GMT+08:00 汪胜 <sk...@163.com>:
> Hello all,
> I have many measures(about fifty), and I have to create SUM, MIN and
> MAX for every measure. Is there any good ways to create them at a time
> instead of create one by one?
>
>