You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by AS <al...@163.com> on 2019/07/17 02:44:01 UTC
wonder how to config a blacklist of cuboids
When I config a cube , I fund Mandatory Cuboids in Advanced Setting. As the explain in official website , it means Whitelist of the cuboids that you want to build.
I wonder how to config a blacklist of the cuboids that I do not want to build.
In my case, I just want to remove the cubid who contains the Dimension of C and D. And I have no idea how to config it.
Or should I filled the Mandatory Cuboids with all cuboids that I need ??
Wating for your reply!
Re: wonder how to config a blacklist of cuboids
Posted by "allensu213@163.com" <al...@163.com>.
Thank you for your reply!
I think it is a math game. It already meets the need via the existing rules.
Sorry to bother you without some deep research.
Thank you so much!
On 07/23/2019 22:42，ShaoFeng Shi<sh...@apache.org> wrote：
Hi, so far Kylin allows user to enter a whitelist, no blacklist.
If you can list all the cuboids you want, you can do that with the whitelist + a minimal aggregation group (say only 1 dim in that group). Because at least you should have one agg. group.
In the picture, I see you want to avoid that cuboid that C+D appeared at the same time (mutually exclusive). You can do that by separating them into two agg groups: 1) ABC, 2) ABD .Then you will have
the following cuboids: ABCD, ABC, AB, BC, AC, ABD, AD, BD, A, B, C, D
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
AS <al...@163.com> 于2019年7月17日周三 上午10:45写道：
When I config a cube , I fund Mandatory Cuboids in Advanced Setting. As the explain in official website , it means Whitelist of the cuboids that you want to build.
I wonder how to config a blacklist of the cuboids that I do not want to build.
In my case, I just want to remove the cubid who contains the Dimension of C and D. And I have no idea how to config it.
Or should I filled the Mandatory Cuboids with all cuboids that I need ??
Wating for your reply!
Re: wonder how to config a blacklist of cuboids
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi, so far Kylin allows user to enter a whitelist, no blacklist.
If you can list all the cuboids you want, you can do that with the
whitelist + a minimal aggregation group (say only 1 dim in that group).
Because at least you should have one agg. group.
In the picture, I see you want to avoid that cuboid that C+D appeared at
the same time (mutually exclusive). You can do that by separating them into
two agg groups: 1) ABC, 2) ABD .Then you will have
the following cuboids: ABCD, ABC, AB, BC, AC, ABD, AD, BD, A, B, C, D
Best regards,
Shaofeng Shi 史少锋
Apache Kylin PMC
Email: shaofengshi@apache.org
Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html
Join Kylin user mail group: user-subscribe@kylin.apache.org
Join Kylin dev mail group: dev-subscribe@kylin.apache.org
AS <al...@163.com> 于2019年7月17日周三 上午10:45写道：
> When I config a cube , I fund Mandatory Cuboids in Advanced Setting. As
> the explain in official website , it means Whitelist of the cuboids that
> you want to build.
> I wonder how to config a blacklist of the cuboids that I do not want to
> build.
>
> In my case, I just want to remove the cubid who contains the Dimension of
> C and D. And I have no idea how to config it.
> Or should I filled the Mandatory Cuboids with all cuboids that I need ??
> Wating for your reply!
>
>