Hi: Kylin does not support precomputation between columns. If you want to perform aggregate operation (such as sum) on the results of adding two columns, you can define a column z = x * y in hive table, and then define sum (z) in kylin as a measure. If you don't want to add a column to the hive table, you can define the column in the hive view, and then use the hive view as the fact table of the cube.
> 在 2020年8月13日,19:22,guojial...@smartbi.com.cn 写道: > > Hi, > I've created a Cube. like > <Catch.jpg> > > Then I found that if I exec SQL like > > ' select > CATEG_LVL2_NAME as F_INSIGHT_FIELD_OUTER_1, > sum(LEAF_CATEG_ID) +sum( SITE_ID) as F_INSIGHT_FIELD_OUTER_2 > from > KYLIN_CATEGORY_GROUPINGS > group by > CATEG_LVL2_NAME > order by > CATEG_LVL2_NAME' , it will success. > > > But if I exec SQL like > > 'select > CATEG_LVL2_NAME as F_INSIGHT_FIELD_OUTER_1, > SUM( sum(LEAF_CATEG_ID+SITE_ID) ) as F_INSIGHT_FIELD_OUTER_2 > from > KYLIN_CATEGORY_GROUPINGS > group by > CATEG_LVL2_NAME > order by > CATEG_LVL2_NAME', it will fail. > > How could I make it seccuss? > > Look forward to your favourable reply. > Jaylin Guo