最简单的测试方法
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求和是考虑正负的。
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
