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. [cid:[email protected]] ------------------ 原始邮件 ------------------ 发件人: "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]> > >
