Firstly, thank you for your reply!
In my cube, I have set SHOP_NAME as a derived dimension. And I also found that all normal dimensions can return correctly, but not all derived dimensions returned results. ------------------ ???????? ------------------ ??????: "Yaqian Zhang"<[email protected]>; ????????: 2019??11??13??(??????) ????6:39 ??????: "user"<[email protected]>; ????: Re: The results return some fields empty. But when I tried in hive with the same query, I got what I wanted to get. Hi: Did you add SHOP_NAME to the dimension when you create cube? If not, kylin will not save the details of the original table when building the cube, and will return null when querying the column. > ?? 2019??11??13????14:01???????? <[email protected]> ?????? > > 1. Environment: > kylin 2.6.3 > > 2. Question: > > In kylin Insight interface, I input query clause like this ?? > > select DATE_DIM."DATE", SHOP_DIM.SHOP_NAME,A.DISTRICT_ID,SUM(TOTALFEE) from DW_ERP_BY_SHOPSALE_FACT > > inner join DATE_DIM > > on > > DW_ERP_BY_SHOPSALE_FACT.DATE_KEY = DATE_DIM.DATE_KEY > > inner join TIME_DIM > > on > > DW_ERP_BY_SHOPSALE_FACT.TIME_KEY = TIME_DIM.TIME_KEY > > inner join SHOP_DIM > > on > > DW_ERP_BY_SHOPSALE_FACT.SHOP_KEY=SHOP_DIM.SHOP_KEY > > inner join ADMINISTRATIVE_DISTRICT A > > on > > SHOP_DIM.AREAID=A.DISTRICT_ID > > inner join ERP_BY_DEPARTMENT > > on > > SHOP_DIM.REGION=ERP_BY_DEPARTMENT.ID > > GROUP BY DATE_DIM."DATE",SHOP_DIM.SHOP_NAME,A.DISTRICT_ID. > > The results return some fields empty. But when I tried in hive with the same query, I got what I wanted to get. > > 3. Please help me solve the quesiton if you have some solutions, thank you! > > <[email protected]> > > > <[email protected]> > >
