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]> > >
