HI: Because kylin only stores the aggregated data, not the detailed information of the data source. If ‘entrust_balance’ be added to model as a dimension, you can query detail like select entrust_balance from table xx and get correct result. If you want to query SQL like ’Select * from table’ , you can config pushdown:http://kylin.apache.org/cn/docs/tutorial/query_pushdown.html <http://kylin.apache.org/cn/docs/tutorial/query_pushdown.html>
> 在 2020年8月12日，15:43，魏帅 <[email protected]> 写道： > > > Hi > when i use kylin V3.1.0 With CDH 5.14.2. > hive table column type is decimal(19,2) entrust_balance used as Measures In > model and add measures like sum,max,top as example，the return type is > decimal(19,2); > after build cube success; if query sum(entrust_balance) then return success ; > sum return xx.00 > max return xx > topn return xx > but when i query detail like select entrust_balance from table xx then return > empty cloumn; > > <[email protected]> > <[email protected]> > 软件工程师 魏帅 > ============================================== > Just do it ! > >
