千亿数仓第四章(指标计算_用户的退货指标分析)

最新推荐文章于 2024-02-22 14:15:00 发布

a大数据yyds

最新推荐文章于 2024-02-22 14:15:00 发布

阅读量505

点赞数 1

分类专栏：千亿项目

本文链接：https://blog.csdn.net/qq_45765882/article/details/106571959

版权

退货表指标统计
在这里插入图片描述
参考代码：
–dw层创建fact_order_refunds表

drop table if exists itcast_dw.fact_order_refunds;
create table itcast_dw.fact_order_refunds(
id bigint,
orderId bigint,
goodsId bigint,
refundTo bigint,
refundReson bigint,
refundOtherReson string,
backMoney double,
refundTradeNo string,
refundRemark string,
refundTime string,
shopRejectReason string,
refundStatus bigint,
createTime string
)
partitioned by (dt string)
STORED AS PARQUET;

–从ods抽取数据到dw层中的fact_order_refunds

INSERT OVERWRITE TABLE itcast_dw.fact_order_refunds PARTITION (dt=‘20190908’)
SELECT
id
,orderId
,goodsId
,refundTo
,refundReson
,refundOtherReson
,backMoney
,refundTradeNo
,refundRemark
,refundTime
,shopRejectReason
,refundStatus
,createTime
FROM itcast_ods.itcast_order_refunds WHERE dt=‘20190908’ ;