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...@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 史少锋