????????????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"

Reply via email to