链路分层
| 层 | 对象 | 产出时间 |
|---|---|---|
| ODS | ods_order / ods_refund | 01:30 |
| DWD | dwd_trade_order_di | 02:30 |
| DWS | dws_trade_store_day / dws_item_sku_day | 04:00 |
| ADS | ads_sale_board_day | 05:30 |
链路串联
链路串联
-- DWS 依赖 DWD，仅按当日分区计算
INSERT OVERWRITE TABLE dws_trade_store_day PARTITION (dt='2026-10-12')
SELECT store_id,
count(DISTINCT order_id) AS order_cnt,
sum(pay_amt) AS pay_amt
FROM dwd_trade_order_di
WHERE dt='2026-10-12' AND order_status='PAID'
GROUP BY store_id;链路按「层-小时」排布产出时间，核心看板在早上班前完成。