You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by "xujie0120 (via GitHub)" <gi...@apache.org> on 2023/07/03 03:07:27 UTC
[GitHub] [dolphinscheduler] xujie0120 opened a new issue, #14436: [Bug] [data-quality] 3.1.x版本数据质量规则类型“自定义SQL”节点实际运行成功结束后，页面状态显示为“正在执行”无法结束。
xujie0120 opened a new issue, #14436:
URL: https://github.com/apache/dolphinscheduler/issues/14436
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues.
### What happened
1、创建一个数据质量规则类型为“自定义SQL”节点。
2、配置如下:
3、查看节点日志发现节点运行成功并结束
4、页面节点显示运行中，无法结束。
### What you expected to happen
1、测试版本，3.1.1和3.1.7
2、创建一个数据质量规则类型为“自定义SQL”节点：
数据源：mysql
源数据表：xxxxxx(任务一张mysql的表)
实际值名: len
实际值计算SQL：select LENGTH(任意字段) AS len from ${src_table}
校验方式：Actual - Expected
校验操作符：>
阈值：0
失败策略：Alert
期望值类型：FixValue
固定值 0
### How to reproduce
无
### Anything else
_No response_
### Version
3.1.x
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] xujie0120 closed issue #14436: [Bug] [data-quality] After the 3.1.x version of the data quality rule type "custom SQL" node is successfully executed, the page status is displayed as "executing" and cannot end.
Posted by "xujie0120 (via GitHub)" <gi...@apache.org>.
xujie0120 closed issue #14436: [Bug] [data-quality] After the 3.1.x version of the data quality rule type "custom SQL" node is successfully executed, the page status is displayed as "executing" and cannot end.
URL: https://github.com/apache/dolphinscheduler/issues/14436
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] xujie0120 commented on issue #14436: [Bug] [data-quality] After the 3.1.x version of the data quality rule type "custom SQL" node is successfully executed, the page status is displayed as "executing" and cannot end.
Posted by "xujie0120 (via GitHub)" <gi...@apache.org>.
xujie0120 commented on issue #14436:
URL: https://github.com/apache/dolphinscheduler/issues/14436#issuecomment-1619601751
我知道原因 啦，自定义SQL的返回值只能返回单行记录（只能返回统计值的结果），不可以多行记录，上诉SQL需要修改为：
select count(*) from (select * from table where length(field) > 10 )
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #14436: [Bug] [data-quality] After the 3.1.x version of the data quality rule type "custom SQL" node is successfully executed, the page status is displayed as "executing" and cannot end.
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #14436:
URL: https://github.com/apache/dolphinscheduler/issues/14436#issuecomment-1617154510
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar issues.
### What happened
1. Create a data quality rule type as "Custom SQL" node.
2. The configuration is as follows:
3. Check the node log and find that the node runs successfully and ends
4. The page node shows that it is running and cannot be ended.
### What you expected to happen
1. Test version, 3.1.1 and 3.1.7
2. Create a data quality rule type as "Custom SQL" node:
Data source: mysql
Source data table: xxxxxx (task a mysql table)
Actual value name: len
Actual value calculation SQL: select LENGTH (any field) AS len from ${src_table}
Verification method: Actual - Expected
Validation operator: >
Threshold: 0
Failure Policy: Alert
Expected value type: FixValue
fixed value 0
### How to reproduce
none
### Anything else
_No response_
### Version
3.1.x
### Are you willing to submit PR?
- [ ] Yes I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@dolphinscheduler.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org