You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by Li Yang <li...@apache.org> on 2017/09/03 08:47:56 UTC

Re: Re: how to keep two digital after point when using sum or avg in kylin jdbc query?

Can log a JIRA. GUI should allow editing decimal precision.

On Fri, Aug 25, 2017 at 5:22 PM, Billy Liu <bi...@apache.org> wrote:

> Could you edit the JSON directly? "Edit Cube Desc"
>
> 2017-08-25 10:59 GMT+08:00 liubo@fcyun.com <li...@fcyun.com>:
>
>>
>> when I'm creating a new cube, the Return Type cannot edit, is there other
>> way to set the return type to be decimal(19,2)
>>
>>
>> thanks very much!
>>
>>
>> ------------------------------
>> liubo@fcyun.com
>>
>>
>> *From:* Billy Liu <bi...@apache.org>
>> *Date:* 2017-08-23 12:33
>> *To:* user <us...@kylin.apache.org>
>> *Subject:* Re: how to keep two digital after point when using sum or avg
>> in kylin jdbc query?
>> Hi Liubo,
>>
>> Could you try to define the return type of measure SUM(FINAL_MONEY) to
>> decimal(19,2) in Cube?
>>
>> 2017-08-23 12:13 GMT+08:00 liubo@fcyun.com <li...@fcyun.com>:
>>
>>> hi,
>>>
>>> I want the  decimal(float or double data type) values alway keep two
>>> digital after the point. Is there a way to do it?
>>>
>>> Any suggestios?
>>>
>>> Thanks very much!
>>>
>>> ------------------------------
>>> liubo@fcyun.com
>>>
>>
>>
>