You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by "aaronwenbo (via GitHub)" <gi...@apache.org> on 2023/02/24 07:45:44 UTC

[GitHub] [dolphinscheduler] aaronwenbo opened a new issue, #13615: [Bug] [] 内置参数写在sql中,无法执行。

aaronwenbo opened a new issue, #13615:
URL: https://github.com/apache/dolphinscheduler/issues/13615

   ### 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
   
   insert into table2 
   select * from table1 from dt >= $[yyyyyMMdd-1] and dt <$[yyyyMMdd]
   ;
   
   无法在3.1.3中执行,但在之前版本是ok的
   
   ### What you expected to happen
   
   兼容前版本
   
   ### How to reproduce
   
   rt
   
   ### 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] SbloodyS closed issue #13615: [Bug] [] Built-in parameters are written in sql and cannot be executed.

Posted by "SbloodyS (via GitHub)" <gi...@apache.org>.
SbloodyS closed issue #13615: [Bug] [] Built-in parameters are written in sql and cannot be executed.
URL: https://github.com/apache/dolphinscheduler/issues/13615


-- 
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] zhongjiajie commented on issue #13615: [Bug] [] Built-in parameters are written in sql and cannot be executed.

Posted by "zhongjiajie (via GitHub)" <gi...@apache.org>.
zhongjiajie commented on issue #13615:
URL: https://github.com/apache/dolphinscheduler/issues/13615#issuecomment-1545485015

   I assigned to you, looking forward your contributors


-- 
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] batmanneverdie commented on issue #13615: [Bug] [] Built-in parameters are written in sql and cannot be executed.

Posted by "batmanneverdie (via GitHub)" <gi...@apache.org>.
batmanneverdie commented on issue #13615:
URL: https://github.com/apache/dolphinscheduler/issues/13615#issuecomment-1545233486

   @zhongjiajie yes, I'm willing to do


-- 
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] zhongjiajie commented on issue #13615: [Bug] [] Built-in parameters are written in sql and cannot be executed.

Posted by "zhongjiajie (via GitHub)" <gi...@apache.org>.
zhongjiajie commented on issue #13615:
URL: https://github.com/apache/dolphinscheduler/issues/13615#issuecomment-1545224253

   > 我在 ds 3.1.3 中也遇到了这个问题,我的解决方案是替换 3.1.3 中 `org.apache.dolphinscheduler.plugin.task.sql.SqlTask#getSqlAndSqlParamsMap` 的`Map<String, Property> paramsMap = taskExecutionContext.getPrepareParamsMap();`代码为 ds 2.0.7-release 版本的同方法的下的
   > 
   > ```
   > // combining local and global parameters
   > Map<String, Property> paramsMap = ParamUtils.convert(taskExecutionContext, getParameters());
   > ```
   
   do you want to submit a pr in dev branch to fix it? @batmanneverdie 


-- 
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 #13615: [Bug] [] Built-in parameters are written in sql and cannot be executed.

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #13615:
URL: https://github.com/apache/dolphinscheduler/issues/13615#issuecomment-1442988078

   Thank you for your feedback, we have received your issue, Please wait patiently for a reply.
   * In order for us to understand your request as soon as possible, please provide detailed information, version or pictures.
   * If you haven't received a reply for a long time, you can [join our slack](https://s.apache.org/dolphinscheduler-slack) and send your question to channel `#troubleshooting`


-- 
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] batmanneverdie commented on issue #13615: [Bug] [] Built-in parameters are written in sql and cannot be executed.

Posted by "batmanneverdie (via GitHub)" <gi...@apache.org>.
batmanneverdie commented on issue #13615:
URL: https://github.com/apache/dolphinscheduler/issues/13615#issuecomment-1463685245

   我在 ds 3.1.3 中也遇到了这个问题,我的解决方案是替换 3.1.3 中 `org.apache.dolphinscheduler.plugin.task.sql.SqlTask#getSqlAndSqlParamsMap` 的`Map<String, Property> paramsMap = taskExecutionContext.getPrepareParamsMap();`代码为 ds 2.0.7-release 版本的同方法的下的 
   ```
   // combining local and global parameters
   Map<String, Property> paramsMap = ParamUtils.convert(taskExecutionContext, getParameters());
   ```


-- 
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 #13615: [Bug] [] Built-in parameters are written in sql and cannot be executed.

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #13615:
URL: https://github.com/apache/dolphinscheduler/issues/13615#issuecomment-1442987421

   ### 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
   
   insert into table2 
   select * from table1 from dt >= $[yyyyyMMdd-1] and dt <$[yyyyMMdd]
   ;
   
   无法在3.1.3中执行,但在之前版本是ok的
   
   ### What you expected to happen
   
   兼容前版本
   
   ### How to reproduce
   
   rt
   
   ### 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