| 拦截 | 关键字段错误时阻断下游,强一致优先 |
|---|---|
| 隔离 | 错误行进隔离表,主流程不中断 |
| 放行并标注 | 小比例容忍,下游可见质量标记 |
| 降级 | 用前一日数据兜底,需公告口径 |
隔离写法示例
隔离写法示例
INSERT INTO quarantine_orders
SELECT *, 'dup_pk' AS dq_reason, CURRENT_TIMESTAMP() AS dq_time
FROM stage_orders
WHERE order_id IN (
SELECT order_id FROM stage_orders GROUP BY order_id HAVING COUNT(*) > 1
);放行必须留痕:没有质量标记的默默放行,下游往往在数周后才发现口径问题。