gary0416 commented on issue #908: #864 Hive datasource support set role URL: https://github.com/apache/incubator-dolphinscheduler/pull/908#issuecomment-544436285 > I don't think use a special key value pair in database connection parameter is a good solution. Because those parameters are used for JDBC driver. and should only be understandable by JDBC Drivers. > > Can "PreStatement" ("前置sql") in SQL Task works for you? You can add "set role admin" as PreStatement Like I said in #864 : ``` In dolphin scheduler 1.1.0, preStatementsBinds is executed after funcStmt, so pre sql can't solve this issue. (https://github.com/apache/incubator-dolphinscheduler/blob/1.1.0/escheduler-server/src/main/java/cn/escheduler/server/worker/task/sql/SqlTask.java#L271) ```
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
