You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@dolphinscheduler.apache.org by GitBox <gi...@apache.org> on 2022/08/11 07:38:52 UTC
[GitHub] [dolphinscheduler] fuchanghai opened a new issue, #11423: [Bug] [DataX] If the reader is oracle, there is a problem with the ***columns*** field of the generated dataxjson
fuchanghai opened a new issue, #11423:
URL: https://github.com/apache/dolphinscheduler/issues/11423
### 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
The ***columns*** fields are all uppercase, causing some databases to fail to import
<img width="911" alt="企业微信截图_321836cd-3e37-43b4-addb-c7397ff39137" src="https://user-images.githubusercontent.com/33984497/184086044-d12a417a-b872-4fd4-9386-da6031f43377.png">
### What you expected to happen
- if reader is oracle lowercase column names
- if writer is oracle capitalize column names
### How to reproduce
- if reader is oracle lowercase column names
- if writer is oracle capitalize column names
### Anything else
_No response_
### Version
3.0.0
### Are you willing to submit 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.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [dolphinscheduler] fuchanghai commented on issue #11423: [Bug] [DataX] If the reader is oracle, there is a problem with the ***columns*** field of the generated dataxjson
Posted by GitBox <gi...@apache.org>.
fuchanghai commented on issue #11423:
URL: https://github.com/apache/dolphinscheduler/issues/11423#issuecomment-1213629780
@SbloodyS i had test again ，the cause of things is not oracle field capitalization.
My target database is CLICKHOUSE , it is case sensitive, and in this example its column names are lowercase fields。so it leads to the problem of not being able to import.
We need to add a parameter to indicate whether the fields in the datax json should be converted to lowercase or uppercase?
which can solve some databases that is case sensitive (if we use 'select *' will occur )
--
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 #11423: [Bug] [DataX] If the reader is oracle, there is a problem with the ***columns*** field of the generated dataxjson
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #11423:
URL: https://github.com/apache/dolphinscheduler/issues/11423#issuecomment-1211665347
### 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
The ***columns*** fields are all uppercase, causing some databases to fail to import
<img width="911" alt="企业微信截图_321836cd-3e37-43b4-addb-c7397ff39137" src="https://user-images.githubusercontent.com/33984497/184086044-d12a417a-b872-4fd4-9386-da6031f43377.png">
### What you expected to happen
- if reader is oracle lowercase column names
- if writer is oracle capitalize column names
### How to reproduce
- if reader is oracle lowercase column names
- if writer is oracle capitalize column names
### Anything else
_No response_
### Version
3.0.0
### Are you willing to submit 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
[GitHub] [dolphinscheduler] fuchanghai commented on issue #11423: [Bug] [DataX] If the reader is oracle, there is a problem with the ***columns*** field of the generated dataxjson
Posted by GitBox <gi...@apache.org>.
fuchanghai commented on issue #11423:
URL: https://github.com/apache/dolphinscheduler/issues/11423#issuecomment-1213629880
cc @ruanwenjun plz take a look
--
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] fuchanghai closed issue #11423: [Bug] [DataX] If the reader is oracle, there is a problem with the ***columns*** field of the generated dataxjson
Posted by GitBox <gi...@apache.org>.
fuchanghai closed issue #11423: [Bug] [DataX] If the reader is oracle, there is a problem with the ***columns*** field of the generated dataxjson
URL: https://github.com/apache/dolphinscheduler/issues/11423
--
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 #11423: [Bug] [DataX] If the reader is oracle, there is a problem with the ***columns*** field of the generated dataxjson
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #11423:
URL: https://github.com/apache/dolphinscheduler/issues/11423#issuecomment-1211665637
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