You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by "jack-wqing (via GitHub)" <gi...@apache.org> on 2025/04/15 08:51:19 UTC
[I] hive sql java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out [dolphinscheduler]
jack-wqing opened a new issue, #17133:
URL: https://github.com/apache/dolphinscheduler/issues/17133
### 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
dolphin使用HikariDataSource，而在数据信息中只支持配置DriverClassName，此时创建的DriverDataSource中，使用配置参数设置HikariDataSource connectionTimeOut不起作用, 在HiveSql底层的Thrift使用socket Timeout 使用connectionTimeOut来设置，当sql解析时间长就会报错；可以在数据初始化地方优化参数设置，HikariDataSource默认是30s
### What you expected to happen
优化 HikariDataSource 参数配置，可以使用数据源中心的配置参数生效
### How to reproduce
hive环境下，执行executeUpdate当hive sql解析时间较长时
### Anything else
_No response_
### Version
dev
### 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] hive sql java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out [dolphinscheduler]
Posted by "SbloodyS (via GitHub)" <gi...@apache.org>.
SbloodyS commented on issue #17133:
URL: https://github.com/apache/dolphinscheduler/issues/17133#issuecomment-2808062937
Please using hive task type instead of sql task to perform hive sql. The sql task of hive will be deprecated in the future.
--
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] hive sql java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out [dolphinscheduler]
Posted by "SbloodyS (via GitHub)" <gi...@apache.org>.
SbloodyS closed issue #17133: hive sql java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out
URL: https://github.com/apache/dolphinscheduler/issues/17133
--
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] hive sql java.sql.SQLException: org.apache.thrift.transport.TTransportException: java.net.SocketTimeoutException: Read timed out [dolphinscheduler]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #17133:
URL: https://github.com/apache/dolphinscheduler/issues/17133#issuecomment-2804317078
### 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
dolphin uses HikariDataSource, and only supports configuration of DriverClassName in the data information. In the DriverDataSource created at this time, using configuration parameters to set HikariDataSource connectionTimeOut does not work. Thrift in the underlying HiveSql uses socket Timeout to set it. When SQL parsing time is long, an error will be reported; parameter settings can be optimized at the data initialization location. HikariDataSource defaults to 30s
### What you expected to happen
Optimize the HikariDataSource parameter configuration, and can use the configuration parameters of the data source center to take effect.
### How to reproduce
In the hive environment, execute executeUpdate when the hive sql parsing time is long
### Anything else
_No response_
### Version
dev
### 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