需求:交易订单数据基本聚合统计:最大金额max、最小金额min、平均金额avg:
SparkSql创建临时视图:
orderDF.createOrReplaceTempView("view_tmp_orders")
spark.sql("""
with tmp AS (SELECT CAST(order_money AS DOUBLE) FROM view_tmp_orders WHERE order_status = '0')
select
max(order_money) as max_money,
min(order_money) as min_money,
round(avg(order_money),2) as avg_money
from tmp
|""").show()
12-07
2345
08-09
1万+
11-17
1419