Skip to content

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

Description

@stevenzhang-support

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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions