Dataphin数据质量规则试跑失败

产品名称

Dataphin

产品模块

数据质量

概述

描述数据质量规则试跑失败的原因。

问题描述

试跑数据质量规则的时候发现试跑失败，规则是想检测出cust_XXX_temp不等于10的异常数据。

试跑日志如下：

2021-08-12 14:05:12 ---------------- DQE Metric Summary ----------------
2021-08-12 14:05:12 metric task push metrics success, metric values:
-------------------------------------------------------------------------------------------------
| metricName          | timeStamp           | measure             | target              
-------------------------------------------------------------------------------------------------
| CUSTOM_30154    | 2021-08-11 00:00:00 | 1.0                 | XXXX_ODS.H_XXXX   
-------------------------------------------------------------------------------------------------

2021-08-12 14:05:12 Metric task finished with status:SUCCESS
2021-08-12 14:05:12 Execute monitor id:1000136
2021-08-12 14:05:12 Execute monitor expressions:BIZDATE_MEASURE=0.0, with BIZDATE:2021-08-11 00:00:00
2021-08-12 14:05:12 Execute monitor conditions return false!
2021-08-12 14:05:12 Total 1 conditions, execute details:
2021-08-12 14:05:12     condition rule id:1000352
2021-08-12 14:05:12     condition rule expression:BIZDATE_MEASURE=0.0
2021-08-12 14:05:12     condition params:{reason=XXX, bizdate_measure=1.00, tableName=XXX_ODS.XXX}
2021-08-12 14:05:12     condition result:false
2021-08-12 14:05:12 #################### Quality Rule Task Summary ####################
2021-08-12 14:05:12 Monitor execute status: FAILED
2021-08-12 14:05:12 Quality rule check FAILED!
2021-08-12 14:05:12 #################### Quality Rule Task End ####################

问题原因

目前自定义数据质量规则的查询的值是1。对比设置是等于目标值0，所以试跑失败。

解决方案

正常产品机制。试跑就是判断这个规则执行结果是否符合条件，是否满足规则。满足规则就试跑成功，否则失败。

更多信息

NA

相关文档

NA