[ https://issues.apache.org/jira/browse/FLINK-25330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17465751#comment-17465751 ]
Jing Ge commented on FLINK-25330: --------------------------------- Thanks [~Bruce Wong] for the information. I think it is a complicated case beyond CDC and it is hopefully clear for you that changing to addColumns() will not solve it in the correct way. Would you mind if I took over from here? > Flink SQL doesn't retract all versions of Hbase data > ---------------------------------------------------- > > Key: FLINK-25330 > URL: https://issues.apache.org/jira/browse/FLINK-25330 > Project: Flink > Issue Type: Bug > Components: Connectors / HBase > Reporter: Bruce Wong > Assignee: Jing Ge > Priority: Major > Labels: pull-request-available > Attachments: Flink-SQL-Test.zip, bundle_data.zip, bundle_data1.zip, > image-2021-12-15-20-05-18-236.png, test_res.png, test_res2.png, test_res_1.png > > > h2. Background > When we use CDC to synchronize mysql data to HBase, we find that HBase > deletes only the last version of the specified rowkey when deleting mysql > data. The data of the old version still exists. You end up using the wrong > data. And I think its a bug of HBase connector. > The following figure shows Hbase data changes before and after mysql data is > deleted. > !image-2021-12-15-20-05-18-236.png|width=910,height=669! > > h2. -- This message was sent by Atlassian Jira (v8.20.1#820001)