The output is:
Spark SQ:6828127
Hive:6980574.1269

发自 网易邮箱大师
在2016年04月20日 18:06,FangFang Chen 写道:
Hi all,
Please give some suggestions. Thanks

With following same sql, spark sql and hive give different result. The sql is sum(decimal(38,18)) columns.
Select sum(column) from table;
column is defined as decimal(38,18).

Spark version:1.5.3
Hive version:2.0.0