Inconsistent Data Import with Lightning

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

Original topic: lightning导入数据不一致

| username: 天蓝色的小九

When importing with Lightning, one table had one more row than the original table. Deleting this table in the target database and re-importing it resolved the issue, and the data became consistent. Why is this happening? There were no errors reported in the logs.

| username: xiaohetao | Original post link

Was the second import done using the same file as the first import?

What import mode was used?

| username: 天蓝色的小九 | Original post link

It is a file.

| username: 天蓝色的小九 | Original post link

The import mode is logical import.

| username: db_user | Original post link

Are you sure there are no other writes during the import?

| username: 天蓝色的小九 | Original post link

No write operation

| username: db_user | Original post link

Is it a reproducible operation? There’s no way to troubleshoot like this.

| username: Ming | Original post link

Is there any specific information, or can this kind of operation be reproduced?

| username: 天蓝色的小九 | Original post link

Cannot reproduce it anymore.

| username: 天蓝色的小九 | Original post link

It can no longer be reproduced.

| username: xiaohetao | Original post link

Was the table a temporal table when you imported it for the first time?

| username: xiaohetao | Original post link

What is the extra data after the first import, and is it the same as the data in the original table when compared?

| username: xiaohetao | Original post link

Are the system language environment variables consistent when importing?

| username: gary | Original post link

Did you check if the target table had data before importing? This situation can occur when using logical import.

| username: alfred | Original post link

You can try verifying it a few more times. If there is indeed no more data, it is likely that the data was written incorrectly.