hanfengcan commented on issue #9596:
URL:
https://github.com/apache/dolphinscheduler/issues/9596#issuecomment-1103585686
```
[LOG-PATH]:
/opt/apache-dolphinscheduler-2.0.1-bin/logs/5241061414816_1/100/275.log,
[HOST]: 192.168.160.3
[INFO] 2022-04-20 10:37:30.007 -
[taskAppId=TASK-5241061414816_1-100-275]:[121] - Full sql parameters:
SqlParameters{type='MYSQL', datasource=3, sql='INSERT into
fy_payment_db.wx_payment_details SELECT
CAST ( split_part(create_time, '`', 2) as datetime ) as create_time,
0 + split_part(amount, '`', 2) as amount,
0 - split_part(settlement_refund_fee, '`', 2) as settlement_refund_fee ,
split_part(goods_name, '`', 2) as goods_name,
CASE goods_name
when '`门诊缴费' then '门诊缴费'
when '`诊间支付-缴费订单' then '门诊缴费'
when '`住院缴费' then '住院缴费'
when '`住院缴费-住院预交' then '住院缴费'
else goods_name end as goods_type,
split_part(transaction_id, '`', 2) as transaction_id
FROM fy_payment_db.wx_payment_details_load', sqlType=0, sendEmail=false,
displayRows=10, limit=0, udfs='', showType='null', connParams='', groupId='0',
title='', preStatements=[], postStatements=[]}
[INFO] 2022-04-20 10:37:30.014 -
[taskAppId=TASK-5241061414816_1-100-275]:[122] - sql type : MYSQL, datasource :
3, sql : INSERT into fy_payment_db.wx_payment_details SELECT
CAST ( split_part(create_time, '`', 2) as datetime ) as create_time,
0 + split_part(amount, '`', 2) as amount,
0 - split_part(settlement_refund_fee, '`', 2) as settlement_refund_fee ,
split_part(goods_name, '`', 2) as goods_name,
CASE goods_name
when '`门诊缴费' then '门诊缴费'
when '`诊间支付-缴费订单' then '门诊缴费'
when '`住院缴费' then '住院缴费'
when '`住院缴费-住院预交' then '住院缴费'
else goods_name end as goods_type,
split_part(transaction_id, '`', 2) as transaction_id
FROM fy_payment_db.wx_payment_details_load , localParams : [],udfs :
,showType : null,connParams : ,varPool : [] ,query max result limit 0
[INFO] 2022-04-20 10:37:30.017 -
[taskAppId=TASK-5241061414816_1-100-275]:[450] - after replace sql , preparing
: INSERT into fy_payment_db.wx_payment_details SELECT
CAST ( split_part(create_time, '`', 2) as datetime ) as create_time,
0 + split_part(amount, '`', 2) as amount,
0 - split_part(settlement_refund_fee, '`', 2) as settlement_refund_fee ,
split_part(goods_name, '`', 2) as goods_name,
CASE goods_name
when '`门诊缴费' then '门诊缴费'
when '`诊间支付-缴费订单' then '门诊缴费'
when '`住院缴费' then '住院缴费'
when '`住院缴费-住院预交' then '住院缴费'
else goods_name end as goods_type,
split_part(transaction_id, '`', 2) as transaction_id
FROM fy_payment_db.wx_payment_details_load
[INFO] 2022-04-20 10:37:30.018 -
[taskAppId=TASK-5241061414816_1-100-275]:[459] - Sql Params are replaced sql ,
parameters:
[INFO] 2022-04-20 10:37:30.019 -
[taskAppId=TASK-5241061414816_1-100-275]:[529] - can't find udf function
resource
[INFO] 2022-04-20 10:37:30.029 -
[taskAppId=TASK-5241061414816_1-100-275]:[403] - prepare statement replace sql
: HikariProxyPreparedStatement@1988302493 wrapping
com.mysql.cj.jdbc.ClientPreparedStatement: INSERT into
fy_payment_db.wx_payment_details SELECT
CAST ( split_part(create_time, '`', 2) as datetime ) as create_time,
0 + split_part(amount, '`', 2) as amount,
0 - split_part(settlement_refund_fee, '`', 2) as settlement_refund_fee ,
split_part(goods_name, '`', 2) as goods_name,
CASE goods_name
when '`门诊缴费' then '门诊缴费'
when '`住院缴费' then '住院缴费'
else goods_name end as goods_type,
split_part(transaction_id, '`', 2) as transaction_id
FROM fy_payment_db.wx_payment_details_load
[ERROR] 2022-04-20 10:37:30.030 -
[taskAppId=TASK-5241061414816_1-100-275]:[212] - execute sql error: Can not
issue data manipulation statements with executeQuery().
[ERROR] 2022-04-20 10:37:30.031 -
[taskAppId=TASK-5241061414816_1-100-275]:[163] - sql task error:
java.sql.SQLException: Can not issue data manipulation statements with
executeQuery().
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
