Georgi Varbanov
05/14/2025, 7:57 AMXiang Fu
Xiang Fu
select count(distinct UUID) to check the original doc sizeGeorgi Varbanov
05/14/2025, 8:10 AMXiang Fu
Georgi Varbanov
05/14/2025, 8:52 AMXiang Fu
Georgi Varbanov
05/14/2025, 8:53 AMXiang Fu
Xiang Fu
Georgi Varbanov
05/14/2025, 8:54 AMXiang Fu
SET skipUpsert=true;
Select count(*) FROM betsGeorgi Varbanov
05/14/2025, 8:55 AMXiang Fu
SET skipUpsert=true; to check whyGeorgi Varbanov
05/14/2025, 8:56 AMXiang Fu
Xiang Fu
Georgi Varbanov
05/14/2025, 8:58 AMXiang Fu
Xiang Fu
Georgi Varbanov
05/14/2025, 8:58 AMGeorgi Varbanov
05/14/2025, 9:00 AMXiang Fu
{
Id: 1231231,
BetsSelection: xx1
},
{
Id: 1231231,
BetsSelection: xx2
},
...,
{
Id: 1231231,
BetsSelection: xx10
}
so all the 10 rows will be ingested, but because this is an upsert table, the first 9 rows will be consider as old rowsXiang Fu
{
Id: 1231231,
BetsSelection: xx10
}
becomes validGeorgi Varbanov
05/14/2025, 9:00 AMXiang Fu
Georgi Varbanov
05/14/2025, 9:01 AMXiang Fu
Bets fieldGeorgi Varbanov
05/14/2025, 9:56 AMGeorgi Varbanov
05/14/2025, 9:58 AMXiang Fu
Georgi Varbanov
05/14/2025, 11:56 AMXiang Fu
Georgi Varbanov
05/14/2025, 12:33 PMGeorgi Varbanov
05/14/2025, 12:34 PMXiang Fu
Georgi Varbanov
05/15/2025, 9:18 AM