You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by "xiamud (via GitHub)" <gi...@apache.org> on 2024/04/01 08:50:52 UTC
[I] sql任务报错，sql解析的不对 [dolphinscheduler]
xiamud opened a new issue, #15787:
URL: https://github.com/apache/dolphinscheduler/issues/15787
### 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
SQL作业使用oracle数据源类型，sql中使用union all时任务出错。
执行以下sql：
select a,b,c,b-c as d
from
(select 1 as a,2 as b,3 as c from dual)
union all
select 1 as a,2 as b,3 as c,4 as d from dual
通过查询日志，可以看到以上sql被解析为：
SELECT a, b, c, b - c AS d
FROM (
SELECT 1 AS a, 2 AS b, 3 AS c
FROM dual
UNION ALL
SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS d
FROM dual
)
### What you expected to happen
正常显示合并结果集
### How to reproduce
在SQL任务中执行以下sql：
select a,b,c,b-c as d
from
(select 1 as a,2 as b,3 as c from dual)
union all
select 1 as a,2 as b,3 as c,4 as d from dual
### Anything else
_No response_
### Version
3.2.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
Re: [I] The sql task reports an error, and the sql parsing is incorrect. [dolphinscheduler]
Posted by "SbloodyS (via GitHub)" <gi...@apache.org>.
SbloodyS closed issue #15787: The sql task reports an error, and the sql parsing is incorrect.
URL: https://github.com/apache/dolphinscheduler/issues/15787
--
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
Re: [I] The sql task reports an error, and the sql parsing is incorrect. [dolphinscheduler]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #15787:
URL: https://github.com/apache/dolphinscheduler/issues/15787#issuecomment-2029427466
### 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
The SQL job uses the oracle data source type, and the task error occurs when union all is used in sql.
Execute the following sql:
select a,b,c,b-c as d
from
(select 1 as a,2 as b,3 as c from dual)
union all
select 1 as a,2 as b,3 as c,4 as d from dual
By querying the log, you can see that the above sql is parsed as:
SELECT a, b, c, b - c AS d
FROM (
SELECT 1 AS a, 2 AS b, 3 AS c
FROM dual
UNION ALL
SELECT 1 AS a, 2 AS b, 3 AS c, 4 AS d
FROM dual
)
### What you expected to happen
Display the merged result set normally
### How to reproduce
Execute the following sql in the SQL task:
select a,b,c,b-c as d
from
(select 1 as a,2 as b,3 as c from dual)
union all
select 1 as a,2 as b,3 as c,4 as d from dual
### Anything else
_No response_
### Version
3.2.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
Re: [I] The sql task reports an error, and the sql parsing is incorrect. [dolphinscheduler]
Posted by "xinxingi (via GitHub)" <gi...@apache.org>.
xinxingi commented on issue #15787:
URL: https://github.com/apache/dolphinscheduler/issues/15787#issuecomment-2033881771
@SbloodyS please assign to me
--
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