You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 魏帅 <jx...@qq.com> on 2020/08/13 09:12:00 UTC

回复： decimal（19，2） measure original value is loss 

&nbsp;
thks for U reply.


column ‘entrust_balance’ be added to model as a dimension； and&nbsp;add measures like sum,max,top as example，the return type is decimal(19,2) 【 SHOW AS&nbsp;dimension】;&nbsp;
after build cube success;&nbsp;
if query sum(entrust_balance) then return success ;
sum return xx.00
max return xx
topn return xx
BUT select&nbsp;entrust_balance from table xx still get uncorrect result.

------------------&nbsp;原始邮件&nbsp;------------------
发件人:                                                                                                                        "user"                                                                                    <Yaqian_Zhang@126.com&gt;;
发送时间:&nbsp;2020年8月13日(星期四) 上午9:56
收件人:&nbsp;"user"<user@kylin.apache.org&gt;;

主题:&nbsp;Re: decimal（19，2） measure original value is loss 



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 &nbsp;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


在 2020年8月12日，15:43，魏帅 <jxgl9965@qq.com&gt; 写道：



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&nbsp; and add measures like sum,max,top as example，the return type is decimal(19,2);&nbsp; 
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;


<69573603@D0D44362.A29D335F.bmp.jpg&gt;
<05CD119A@8B378D24.A29D335F.bmp.jpg&gt;

软件工程师&nbsp; 魏帅
==============================================
Just do it !




&nbsp;

回复： decimal（19，2） measure original value is loss

Posted by 魏帅 <jx...@qq.com>.
has resolved , no reply





------------------&nbsp;原始邮件&nbsp;------------------
发件人:                                                                                                                        "魏帅"                                                                                    <jxgl9965@qq.com&gt;;
发送时间:&nbsp;2020年8月13日(星期四) 下午5:12
收件人:&nbsp;"user"<user@kylin.apache.org&gt;;

主题:&nbsp;回复： decimal（19，2） measure original value is loss 



&nbsp;
thks for U reply.


column ‘entrust_balance’ be added to model as a dimension； and add measures like sum,max,top as example，the return type is decimal(19,2) 【 SHOW AS dimension】; 
after build cube success; 
if query sum(entrust_balance) then return success ;
sum return xx.00
max return xx
topn return xx
BUT select entrust_balance from table xx still get uncorrect result.

------------------ 原始邮件 ------------------
发件人:                                                                                                                        "user"                                                                                    <Yaqian_Zhang@126.com&gt;;
发送时间:&nbsp;2020年8月13日(星期四) 上午9:56
收件人:&nbsp;"user"<user@kylin.apache.org&gt;;

主题:&nbsp;Re: decimal（19，2） measure original value is loss 



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 &nbsp;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


在 2020年8月12日，15:43，魏帅 <jxgl9965@qq.com&gt; 写道：



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&nbsp; and add measures like sum,max,top as example，the return type is decimal(19,2);&nbsp; 
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;


<69573603@D0D44362.A29D335F.bmp.jpg&gt;
<05CD119A@8B378D24.A29D335F.bmp.jpg&gt;

软件工程师&nbsp; 魏帅
==============================================
Just do it !




&nbsp;