INSERT INTO 数据丢失

[HigherLove520]

使用JDBC的方式去Doris执行INSERT INTO table SELECT * FROM other_table Conditions; 存在数据丢失情况，other_table中的所有列每一行数据长度和类型都是一样的，应该不存在有长度和类型不匹配的问题，开启了严格模式也不起作用。

[yagagagaga]

Can you show me the table's ddl?

[HigherLove520]

ok, thank you for your replay. here is my table's ddl

I have a view table and an entity table, with the view having the same number of columns and names as the entity table. When I use INSERT INTO to import data from the view table to the entity table, data loss occurs. Strangely, the data that is lost and the data that is not lost are exactly the same in length and type, as they are simulated fake data by the program.

[yagagagaga]

Is there duplicate data in the METER_NO column?

[HigherLove520]

Thank you for your reply. There are no duplicates of METER_NO. I am implementing a feature to move data from a complex view to an entity table. When inserting data from the view into the entity table, data loss always occurs. METER_NO is unique in both the view and the entity table. When executing the INSERT via JDBC, the executeUpdate method returns successfully for 50 records, but only 30 records appear in the entity table.

[HigherLove520]

The same import statement is executed twice in the unique model at the same time. The ReturnRows in the log are different. The previous statement indicates that I lost 10 pieces of data during the import process, while the subsequent execution shows that I did not lose any data in this Insert INTO import

[yagagagaga]

It is very strange, there must be a mistake somewhere. Maybe you can join the community and we have deeper communication. #16887

[GongXiaokang]

解决了吗，我在2.17版本也遇到了，表里本来有1200多行不重复的数据，插入几十条后只剩1000条了，这也太可怕了吧。