noahtaite commented on issue #10172:
URL: https://github.com/apache/hudi/issues/10172#issuecomment-1828531674

   I have verified that the "additional" records are those that have moved to 
__HIVE_DEFAULT_PARTITION_ after we applied a soft delete from our incoming DMS 
records.
   
   After clustering, the snapshot shows these records as 'live' and I can see 
duplicates records output in my snapshot query:
   
   ```
   val ctrl = spark.read.format("hudi").load("s3://bucket/path/table.all_hudi/")
   
   
ctrl.filter(col("datasource").equalTo("datasource1")).filter(col("uuid").equalTo(ID_VALUE)).
   select("_hoodie_commit_time","uuid","Op","CaptureDate","totalvalue").
   show(10,false)
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to