You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by 奥威软件 <35...@qq.com> on 2019/03/27 12:01:42 UTC

星座模型问题-- 有用到多张事实表都需要聚合情况，请问有解决的方法吗？

Hi,
星座模型问题：
有用到多张事实表关联情况，需要聚合多张事实表的度量值，请问有解决的方法吗？


如果把事实表当作维度表，这张就不能聚合事实表的度量值了把？




请帮忙看下怎么解决，谢谢！


Best regards

Re: 星座模型问题-- 有用到多张事实表都需要聚合情况，请问有解决的方法吗？

Posted by Xiaoxiang Yu <xi...@kyligence.io>.

Hi, 
    I have some ideas which may be helpful. 
    1. Try to join these fact tables into another hive table(new fact table) which contains all column, but be careful for some measure(such as SUM) because rows will be duplicate after join.
    2. Create single cube for each fact table, and merge result at your side.  

    If you find any mistake, please let me know.

----------------
Best wishes,
Xiaoxiang Yu 
 

On 2019/3/27, 20:09, "奥威软件" <35...@qq.com> wrote:

    Hi,
    星座模型问题：
    有用到多张事实表关联情况，需要聚合多张事实表的度量值，请问有解决的方法吗？
    
    
    如果把事实表当作维度表，这张就不能聚合事实表的度量值了把？
    
    
    
    
    请帮忙看下怎么解决，谢谢！
    
    
    Best regards