You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 杨浩 <ya...@gmail.com> on 2017/10/25 06:58:09 UTC

question about joint dimensions

I have used aggregation groups to reduce cuboids, but it seems not take
effect. A table has dimension A, B, C, D, E, and set this aggregation
groups:
group 1: A,B,C which has joint dimensions A,B,C
group 2: A,B,D which has joint dimensions A,B,D
group 3: A,B,E which has joint dimensions A,B,E
but I can query the table using "group by A B C E" ,  is it OK?

Re: question about joint dimensions

Posted by 杨浩 <ya...@gmail.com>.
I see, it cannot use old cube data if we want to add new aggregation group
to speed up query.

2017-10-27 9:18 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:

> You can disable the cube, purge the data, edit it to add new group, and
> then rebuild it.
>
> Or you can clone it into a new cube, and then make the change on it. After
> the new cube is ready, disable the old one.
>
> 2017-10-26 16:31 GMT+08:00 杨浩 <ya...@gmail.com>:
>
> > Thanks for your explanation. If we want to add new aggregation group ,
> what
> > should I do?
> >
> > 2017-10-25 18:36 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
> >
> > > Hi hao,
> > >
> > > It will go to the base cuboid: ABCDE, and aggregate D at running time.
> So
> > > in theory, it can answer all combinations even if you customized the
> > > groups.
> > >
> > > 2017-10-25 14:58 GMT+08:00 杨浩 <ya...@gmail.com>:
> > >
> > > > I have used aggregation groups to reduce cuboids, but it seems not
> take
> > > > effect. A table has dimension A, B, C, D, E, and set this aggregation
> > > > groups:
> > > > group 1: A,B,C which has joint dimensions A,B,C
> > > > group 2: A,B,D which has joint dimensions A,B,D
> > > > group 3: A,B,E which has joint dimensions A,B,E
> > > > but I can query the table using "group by A B C E" ,  is it OK?
> > > >
> > >
> > >
> > >
> > > --
> > > Best regards,
> > >
> > > Shaofeng Shi 史少锋
> > >
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>

Re: question about joint dimensions

Posted by ShaoFeng Shi <sh...@apache.org>.
You can disable the cube, purge the data, edit it to add new group, and
then rebuild it.

Or you can clone it into a new cube, and then make the change on it. After
the new cube is ready, disable the old one.

2017-10-26 16:31 GMT+08:00 杨浩 <ya...@gmail.com>:

> Thanks for your explanation. If we want to add new aggregation group , what
> should I do?
>
> 2017-10-25 18:36 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:
>
> > Hi hao,
> >
> > It will go to the base cuboid: ABCDE, and aggregate D at running time. So
> > in theory, it can answer all combinations even if you customized the
> > groups.
> >
> > 2017-10-25 14:58 GMT+08:00 杨浩 <ya...@gmail.com>:
> >
> > > I have used aggregation groups to reduce cuboids, but it seems not take
> > > effect. A table has dimension A, B, C, D, E, and set this aggregation
> > > groups:
> > > group 1: A,B,C which has joint dimensions A,B,C
> > > group 2: A,B,D which has joint dimensions A,B,D
> > > group 3: A,B,E which has joint dimensions A,B,E
> > > but I can query the table using "group by A B C E" ,  is it OK?
> > >
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi 史少锋
> >
>



-- 
Best regards,

Shaofeng Shi 史少锋

Re: question about joint dimensions

Posted by 杨浩 <ya...@gmail.com>.
Thanks for your explanation. If we want to add new aggregation group , what
should I do?

2017-10-25 18:36 GMT+08:00 ShaoFeng Shi <sh...@apache.org>:

> Hi hao,
>
> It will go to the base cuboid: ABCDE, and aggregate D at running time. So
> in theory, it can answer all combinations even if you customized the
> groups.
>
> 2017-10-25 14:58 GMT+08:00 杨浩 <ya...@gmail.com>:
>
> > I have used aggregation groups to reduce cuboids, but it seems not take
> > effect. A table has dimension A, B, C, D, E, and set this aggregation
> > groups:
> > group 1: A,B,C which has joint dimensions A,B,C
> > group 2: A,B,D which has joint dimensions A,B,D
> > group 3: A,B,E which has joint dimensions A,B,E
> > but I can query the table using "group by A B C E" ,  is it OK?
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi 史少锋
>

Re: question about joint dimensions

Posted by ShaoFeng Shi <sh...@apache.org>.
Hi hao,

It will go to the base cuboid: ABCDE, and aggregate D at running time. So
in theory, it can answer all combinations even if you customized the groups.

2017-10-25 14:58 GMT+08:00 杨浩 <ya...@gmail.com>:

> I have used aggregation groups to reduce cuboids, but it seems not take
> effect. A table has dimension A, B, C, D, E, and set this aggregation
> groups:
> group 1: A,B,C which has joint dimensions A,B,C
> group 2: A,B,D which has joint dimensions A,B,D
> group 3: A,B,E which has joint dimensions A,B,E
> but I can query the table using "group by A B C E" ,  is it OK?
>



-- 
Best regards,

Shaofeng Shi 史少锋