最简单的测试方法
select sum(a),sum(b)
from(
select 1 as a,2 as b
union all
select 1 as a,-2 as b
) t
查询结果显示
因此,hive sum求和是考虑正负的。
最简单的测试方法
select sum(a),sum(b)
from(
select 1 as a,2 as b
union all
select 1 as a,-2 as b
) t
查询结果显示
因此,hive sum求和是考虑正负的。