As reported by Fabian, if there is a file with an internal duplicate:
with the modality "Dedupe and merge", there is not the information for "Vanessa" on hive.
This happens because in the function "generateMergeNonPartitionQueryWithDedupe" in file TableMergeSyncSupport.java there is the control "having count(processing_dttm) = 1".
This check avoid the correct insert of data because for "Vanessa" the count is 2.
This bug can be solved by add a group by for the second part of the query *union all select " + selectSQL.