Thank you for your reply!
Our installation environment is HDP 3.1.0.0. And the dimension tables also can be updated. Is it this model and environment induce the problem? I will appreciate it very much if you konw the solution. Best wishes, Qiuying Mei ------------------ ???????? ------------------ ??????: "Xiaoxiang Yu"<[email protected]>; ????????: 2019??11??14??(??????) ????3:02 ??????: "[email protected]"<[email protected]>;"??????"<[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 friend, Do you deploy you Kylin on Hadoop3 env like HDP3? And are your dimension table an ACID transaction table? ---------------- Best wishes, Xiaoxiang Yu ??????: ?????? <[email protected]> ????: "[email protected]" <[email protected]> ????: 2019??11??13?? ?????? 19:19 ??????: user <[email protected]> ????: ?????? The results return some fields empty. But when I tried in hive with the same query, I got what I wanted to get. 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]> > >
