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/12 07:43:30 UTC

decimal（19，2） measure original value is loss 

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&nbsp;Measures In model&nbsp; and add measures like sum,max,top as example，the return type is decimal(19,2);&nbsp;&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&nbsp;entrust_balance from table xx then return empty cloumn;





软件工程师&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;

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

Posted by 魏帅 <jx...@qq.com>.
&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;

Re: decimal（19，2） measure original value is loss

Posted by Yaqian Zhang <Ya...@126.com>.
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，魏帅 <jx...@qq.com> 写道：
> 
> 
> 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;
> 
> <69...@D0D44362.A29D335F.bmp.jpg>
> <05...@8B378D24.A29D335F.bmp.jpg>
> 软件工程师  魏帅
> ==============================================
> Just do it !
> 
>