Consider the following scenario:
- create a base table which we replicate
- create a materialized view in the target hive based on the base table
- modify (delete/update) the base table in the source hive
- replicate the changes (delete/update) to the target hive
- query the materialized view in the target hive
We do not refresh the data, since when the transaction is created by replication we set ctc_update_delete to 'N'.