| 输出 | 总行数、各字段空值数、空值率 |
|---|---|
| 阈值 | 关键字段接近 0，业务可空字段设上限 |
| 趋势 | 与近 7 天空值率对比 |
| 落库 | 写入稽核结果表供看板展示 |
多字段空值检测
多字段空值检测
SELECT COUNT(1) AS total_cnt,
SUM(CASE WHEN order_id IS NULL THEN 1 ELSE 0 END) AS null_order_id,
SUM(CASE WHEN user_id IS NULL THEN 1 ELSE 0 END) AS null_user_id,
SUM(CASE WHEN pay_amount IS NULL THEN 1 ELSE 0 END) AS null_pay_amount,
ROUND(SUM(CASE WHEN pay_amount IS NULL THEN 1 ELSE 0 END) / COUNT(1), 4) AS null_pay_rate
FROM dwd_trade_order_detail_di
WHERE dt = '2026-10-11';把每个字段的“是否允许为空”写进数据字典，检测规则才有明确判定标准。