You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 张雷 <73...@qq.com> on 2019/10/10 03:45:56 UTC
多个cube关联查询
你好,在使用kylin的过程中碰到了如下的问题,望给予帮助和解答:
多个模型多个cube,多个cube关联查询的时候存在查询结果为null,而实际上结果不为0
eg:
1、创建的模型和构建的cube
2、模型tea_info 表之间的对应关系
3、模型tea_edu 表之间的对应关系
查询SQL:
select * from HR_FACT_TEA_EDU edu
left join HR_FACT_TEA_INFO info on edu.tea_id=info.no_
报错信息:
No model found for OLAPContext, CUBE_NOT_CONTAIN_ALL_COLUMN[2_6116a66:DMM_HR.HR_FACT_TEA_INFO.TEACH_DEPT_ID, 2_6116a66:DMM_HR.HR_FACT_TEA_INFO.ID, 2_6116a66:DMM_HR.HR_FACT_TEA_INFO.NAME_, 2_6116a66:DMM_HR.HR_FACT_TEA_INFO.FIR_EDU_ID], rel#110156:OLAPTableScan.OLAP.[](table=[DMM_HR, HR_FACT_TEA_EDU],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9]), JoinDesc [type=LEFT, primary_key=[NO_], foreign_key=[TEA_ID]] while executing SQL: "select * from HR_FACT_TEA_EDU edu left join HR_FACT_TEA_INFO info on edu.tea_id=info.no_ LIMIT 50000"