| 步骤 | 找重复键 → 展开明细 → 对比差异字段 |
|---|---|
| 线索字段 | 加载时间、来源系统、批次号 |
| 常见原因 | 重跑未覆盖、双写、关联放大、去重键缺失 |
| 修复 | 按分区覆盖重写并补自动化校验 |
重复键展开明细
重复键展开明细
WITH dup AS (
SELECT order_id FROM dwd_trade_order_detail_di
WHERE dt = '2026-10-11'
GROUP BY order_id HAVING COUNT(1) > 1
)
SELECT d.order_id, d.item_no, d.pay_amount, d.load_time, d.src_sys
FROM dwd_trade_order_detail_di d
JOIN dup ON d.order_id = dup.order_id
WHERE d.dt = '2026-10-11'
ORDER BY d.order_id, d.load_time;同时检查多条业务键组合（订单号加明细号）比只查单列更接近真实粒度。