Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

delete command given in MySQL and the deleted data cannot be fully reflected by the data deleted in BigQuery! #164

Open
stevenzhang-support opened this issue Aug 19, 2021 · 0 comments

Comments

@stevenzhang-support
Copy link

Issue summary:
Following up the Google Documented tutorial as per [1]
[1] https://cloud.google.com/data-fusion/docs/tutorials/replicating-data/mysql-to-bigquery?hl=uk&skip_cache=true

The Data Fusion features to replicate the changed data from MySQL to BigQuery that have been tested Success the followings:
1)、 update,insert
2)、 Automatically copy pre-existing data
3)、 Mysql adds columns, so does bigquery

However the following tested failed :
1)、 delete command was given in MySQL the deleted data cannot be fully reflected by the data deleted in BigQuery but only 10-11 rows can be deleted and then the operation terminated. There is no Any error message shows up to investigate the cause.

Expected behaviour:
The deleted data in MySQL can be captured and replicated the change to BigQuery as well.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant