kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: How to configure the default data type measure decimal(19, 4)?
Date Tue, 03 Jul 2018 11:34:01 GMT
Hi Neethu,

I just realized these configurations are used when there is no defined
scale and precision, such as "decimal"; If the scale and precision is
presented, the parameter has no effect.

So far there is no way for the user to modify the return type on GUI, but
you can workaround by modifying the metadata with the metadata backup and
restore. (https://kylin.apache.org/docs/howto/howto_backup_metadata.html)

After taking a backup, you can find the cube description in /cube_desc
folder, find your cube, and then edit it. Find the measure you want to
modify, change it; for example:

"measures" : [ {
    "name" : "GMV_SUM",
    "function" : {
      "expression" : "SUM",
      "parameter" : {
        "type" : "column",
        "value" : "KYLIN_SALES.PRICE",
        "next_parameter" : null
      },
      "returntype" : "decimal(19,4)"
    }
  },


2018-07-03 19:14 GMT+08:00 mvneethu <neethu.mv@tigeranalytics.com>:

> Yes, I have sync the hive table again and seems to take the default
> decimal(19,4).
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>



-- 
Best regards,

Shaofeng Shi 史少锋

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message