[GitHub] [dolphinscheduler] github-actions[bot] commented on issue #9665: [Improvement][python] sql type can not be specified

[GitBox <gi...@apache.org>]

github-actions[bot] commented on issue #9665:
URL: https://github.com/apache/dolphinscheduler/issues/9665#issuecomment-1106209693

   ### Search before asking
   
   - [X] I had searched in the [issues](https://github.com/apache/dolphinscheduler/issues?q=is%3Aissue) and found no similar feature requirement.
   
   
   ### Description
   
   When I deploy sql task through python-gate.
   Sql type will be identified by the regex.
   I think it should be specified by a parameter.
   
   When I upload a sql type task through python gate
   The type of sql (SELECT / NOT_SELECT) can only be determined by regular
   It should be more intuitive to specify through a parameter
   
   ### Use case
   
   I can't create table task through python-gate.
   Because the "create table xxx" sql will be identified as "SELECT" type.
   
   When I try to make a sql task that creates a table, it will be recognized as "SELECT" type, which will cause the task to fail because the regular expression is
    "^(?!(.* |)insert |(.* |)delete |(.* |)drop |(.* |)update |(.* |)alter ).*"
   
   ### Related issues
   
   _No response_
   
   ### Are you willing to submit a PR?
   
   - [X] 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