Issues with Migrating HBase to TiDB - Seeking Advice

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: Hbase 迁移到Tidb 的问题 请教

| username: Cheriston

The structure of the HBase table

Migration JSON script


MySQL table structure:

Migration structure error prompt:

The migration looks like this, everyone please help to see where the problem is.

| username: WalterWj | Original post link

There is a primary key conflict with the data. How about removing the primary key attribute of the id first?
Or try using the update mode in DataX.

| username: 大飞哥online | Original post link

The error indicates a primary key conflict.
On the MySQL side, you can remove the primary key from the table structure first and then insert the data. Alternatively, you can modify the data.

| username: Cheriston | Original post link

The table has been emptied.

| username: WalterWj | Original post link

You already have data conflicts, it doesn’t matter if the table is clear or not.

| username: Cheriston | Original post link

Only 2 records were migrated.

I want all the data.

| username: tidb菜鸟一只 | Original post link

Don’t you only have two pieces of data in your HBase?

| username: Cheriston | Original post link

Yes, I didn’t realize it. Thank you.

| username: redgame | Original post link

It’s impressive that it was resolved so quickly.