confused by multi model and cube in a project

[刘波 <10...@qq.com>]

dear users,


First of all, I create the first model and cube for my business logic. Then there have a table which I can submmit SQL, it's all okey.


Later, when I found the first model and cube  missing some demessions, so I create the second model and cube, add some demessions.


Finally,  both of  the  cubes  build successly.


But in the "Insight" tab, there's only one table under the "DEFAULT" database. By my intuition, I think there will be two tables, one table for a cube respectively.


And it's ok when I submmit the previouse SQL for the first cube. 


My questions:
 1.Is it correct to use Kylin this way?
 2.Which cube will be used when submmit a SQL? or Kylin with automatically chose the right cube for the SQL?

回复： confused by multi model and cube in a project

[刘波 <10...@qq.com>]

Thank you~


Maybe the best practice is:  one project ,one model, one cube. 

Hope more books written about Kylin will be out. 
for example :
 Apache Kylin Cookbook
 Apache Kylin Best Practice
 Real world Kylin
 Kylin  Optimization 
 etc...






------------------ 原始邮件 ------------------
发件人:                                                                                                                        "user"                                                                                    <Yaqian_Zhang@126.com&gt;;
发送时间:&nbsp;2020年12月28日(星期一) 晚上6:17
收件人:&nbsp;"user"<user@kylin.apache.org&gt;;

主题:&nbsp;Re: confused by multi model and cube in a project



Hi：

"There's only one table under the "DEFAULT” database” is normal，because the data source of two cubes is the same table.
1、"I found the first model and cube&nbsp; missing some demessions, so I create the second model and cube, add some demessions.” is correct. Or you can edit the original model and cube and rebuild it. But before editing a cube, you must disable and purge it.
2、When there are two cubes in kylin that can answer a query, kylin will choose the most recently updated one. If you are sure that the old cube will not be used again, you can disable it.

在 2020年12月27日，16:35，刘波 <1091643978@qq.com&gt; 写道：

dear users,


First of all, I create the first model and cube for my business logic. Then there have a table which I can submmit SQL, it's all okey.


Later, when I found the first model and cube&nbsp; missing some demessions, so I create the second model and cube, add some demessions.


Finally,&nbsp; both of&nbsp; the&nbsp; cubes&nbsp; build successly.


But in the "Insight" tab, there's only one table under the "DEFAULT" database. By my intuition, I think there will be two tables, one table for a cube respectively.


And it's ok when I submmit the previouse SQL for the first cube. 


My questions:
&nbsp;1.Is it correct to use Kylin this way?
&nbsp;2.Which cube will be used when submmit a SQL? or Kylin with automatically chose the right cube for the SQL?


<8935B693@1BDD1512.4847E85F.png.jpg&gt;






<3C696FEF@E051C409.4847E85F.jpg&gt;

Re: confused by multi model and cube in a project

[Yaqian Zhang <Ya...@126.com>]

Hi：

"There's only one table under the "DEFAULT” database” is normal，because the data source of two cubes is the same table.
1、"I found the first model and cube  missing some demessions, so I create the second model and cube, add some demessions.” is correct. Or you can edit the original model and cube and rebuild it. But before editing a cube, you must disable and purge it.
2、When there are two cubes in kylin that can answer a query, kylin will choose the most recently updated one. If you are sure that the old cube will not be used again, you can disable it.

> 在 2020年12月27日，16:35，刘波 <10...@qq.com> 写道：
> 
> dear users,
> 
> First of all, I create the first model and cube for my business logic. Then there have a table which I can submmit SQL, it's all okey.
> 
> Later, when I found the first model and cube  missing some demessions, so I create the second model and cube, add some demessions.
> 
> Finally,  both of  the  cubes  build successly.
> 
> But in the "Insight" tab, there's only one table under the "DEFAULT" database. By my intuition, I think there will be two tables, one table for a cube respectively.
> 
> And it's ok when I submmit the previouse SQL for the first cube.
> 
> My questions:
>  1.Is it correct to use Kylin this way?
>  2.Which cube will be used when submmit a SQL? or Kylin with automatically chose the right cube for the SQL?
> 
> <89...@1BDD1512.4847E85F.png.jpg>
> 
> 
> 
> <3C...@E051C409.4847E85F.jpg>
> 
> 
>