--Spark on hive中列判断逻辑if函数
select
a1,
if(abs(a2300) > 100000.00,null,cast(a2300 as decimal(10,2))) a2300
from ku1.table1
--长判断逻辑
select
a1,
if(a2300 is not null and a2400 is not null and a2400 > a2300 and (a2400 - a2300) * comp_1 < yuzhi,round((a2400 - a2300) * comp_1,2),null) a2300
from ku1.table1
--group by聚合
select a1,a2,a3,a4
sum(a1) a1
sum(a1) a1
sum(a1) a1
sum(a1) a1
group by a1,a2,a3,a4 order by ......
--round 函数计算
select a1,a2
round(a1 / comp_1 * 100,4) bl
from table1
SparkOnHive_应用案例1
于 2024-06-18 10:23:16 首次发布