precision about the sum results

["qixin_song@163.com" <qi...@163.com>]

Does kylin support user-defined precision and scale of the sum results?
It seems like web UI query couldn't handle round(double,int) func.
When i use cast(double as decimal(10,2)), it doesn't work as well.



qixin_song@163.com

Re: precision about the sum results

[Li Yang <li...@apache.org>]

Confirm currently cast(.. as decimal(10,2)) does not do rounding or
truncate.

You can work around by doing some further formatting in GUI or report I
guess.

On Mon, Jul 13, 2015 at 2:13 PM, Luke Han <lu...@gmail.com> wrote:

> Which version you are using?
> I think it could be handled by Calcite, @Julian, do you have any comments
> on this?
>
> Thanks.
>
>
> Best Regards!
> ---------------------
>
> Luke Han
>
> On Tue, Jul 7, 2015 at 3:26 PM, qixin_song@163.com <qi...@163.com>
> wrote:
>
> > Does kylin support user-defined precision and scale of the sum results?
> > It seems like web UI query couldn't handle round(double,int) func.
> > When i use cast(double as decimal(10,2)), it doesn't work as well.
> >
> >
> >
> > qixin_song@163.com
> >
>

Re: precision about the sum results

[Luke Han <lu...@gmail.com>]

Which version you are using?
I think it could be handled by Calcite, @Julian, do you have any comments
on this?

Thanks.


Best Regards!
---------------------

Luke Han

On Tue, Jul 7, 2015 at 3:26 PM, qixin_song@163.com <qi...@163.com>
wrote:

> Does kylin support user-defined precision and scale of the sum results?
> It seems like web UI query couldn't handle round(double,int) func.
> When i use cast(double as decimal(10,2)), it doesn't work as well.
>
>
>
> qixin_song@163.com
>