You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@seatunnel.apache.org by GitBox <gi...@apache.org> on 2022/10/01 00:46:31 UTC
[GitHub] [incubator-seatunnel] laglangyue opened a new issue, #2963: [Bug] [sqlserver] timestamp convert exception
laglangyue opened a new issue, #2963:
URL: https://github.com/apache/incubator-seatunnel/issues/2963
### Search before asking
- [X] I had searched in the [issues](https://github.com/apache/incubator-seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
### What happened
There is a bug here. The timestamp of sqlserver is a version number, which is synonymous with rowversion. It is stored as a binary number and can be converted to bigint by function, not timestamp type.
![image](https://user-images.githubusercontent.com/35491928/193376328-e358f1e2-d822-4155-ad1f-19c5e073b9f3.png)
### SeaTunnel Version
dev
### SeaTunnel Config
```conf
not need
```
### Running Command
```shell
not need
```
### Error Exception
```log
not need
```
### Flink or Spark Version
not need
### Java or Scala Version
not need
### Screenshots
not need
### 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@seatunnel.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-seatunnel] FWLamb commented on issue #2963: [Bug] [sqlserver] timestamp convert exception
Posted by GitBox <gi...@apache.org>.
FWLamb commented on issue #2963:
URL: https://github.com/apache/incubator-seatunnel/issues/2963#issuecomment-1264414645
> ### Search before asking
> * [x] I had searched in the [issues](https://github.com/apache/incubator-seatunnel/issues?q=is%3Aissue+label%3A%22bug%22) and found no similar issues.
>
> ### What happened
> There is a bug here. The timestamp of sqlserver is a version number, which is synonymous with rowversion. It is stored as a binary number and can be converted to bigint by function, not timestamp type.
>
> ![image](https://user-images.githubusercontent.com/35491928/193376328-e358f1e2-d822-4155-ad1f-19c5e073b9f3.png)
>
> ### SeaTunnel Version
> dev
>
> ### SeaTunnel Config
> ```
> not need
> ```
>
> ### Running Command
> ```shell
> not need
> ```
>
> ### Error Exception
> ```
> not need
> ```
>
> ### Flink or Spark Version
> not need
>
> ### Java or Scala Version
> not need
>
> ### Screenshots
> not need
>
> ### 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)
you can use Timestamp.valueOf() to convert it
--
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@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-seatunnel] jinkachy commented on issue #2963: [Bug] [sqlserver] timestamp convert exception
Posted by GitBox <gi...@apache.org>.
jinkachy commented on issue #2963:
URL: https://github.com/apache/incubator-seatunnel/issues/2963#issuecomment-1264387566
> Please don't assign it to others. I have a friend from Amway to deal with it
yes, I can try it @laglangyue
--
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@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-seatunnel] jinkachy commented on issue #2963: [Bug] [sqlserver] timestamp convert exception
Posted by GitBox <gi...@apache.org>.
jinkachy commented on issue #2963:
URL: https://github.com/apache/incubator-seatunnel/issues/2963#issuecomment-1272333298
> you can use Timestamp.valueOf() to convert it
The sqlserver timestamp type(rowversion) is not a timestamp, but a binary stored version number. It cant be convert to timestamp
--
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@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-seatunnel] laglangyue commented on issue #2963: [Bug] [sqlserver] timestamp convert exception
Posted by GitBox <gi...@apache.org>.
laglangyue commented on issue #2963:
URL: https://github.com/apache/incubator-seatunnel/issues/2963#issuecomment-1264174779
Please don't assign it to others. I have a friend from Amway to deal with it
--
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@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-seatunnel] Hisoka-X closed issue #2963: [Bug] [sqlserver] timestamp convert exception
Posted by GitBox <gi...@apache.org>.
Hisoka-X closed issue #2963: [Bug] [sqlserver] timestamp convert exception
URL: https://github.com/apache/incubator-seatunnel/issues/2963
--
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@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-seatunnel] FWLamb commented on issue #2963: [Bug] [sqlserver] timestamp convert exception
Posted by GitBox <gi...@apache.org>.
FWLamb commented on issue #2963:
URL: https://github.com/apache/incubator-seatunnel/issues/2963#issuecomment-1264414593
you can use Timestamp.valueOf() to convert it
--
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@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-seatunnel] FWLamb commented on issue #2963: [Bug] [sqlserver] timestamp convert exception
Posted by GitBox <gi...@apache.org>.
FWLamb commented on issue #2963:
URL: https://github.com/apache/incubator-seatunnel/issues/2963#issuecomment-1264414689
you can use Timestamp.valueOf() to convert it
--
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@seatunnel.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org