Anish Mahto created SPARK-56923:
-----------------------------------
Summary: Implement SCD1 Batch Processor; Merge Microbatch onto
Auxiliary
Key: SPARK-56923
URL: https://issues.apache.org/jira/browse/SPARK-56923
Project: Spark
Issue Type: Sub-task
Components: Declarative Pipelines
Affects Versions: 4.2.0, 4.3.0
Reporter: Anish Mahto
{*}Preamble{*}:
The SCD type 1 flow is a foreachBatch streaming query on an input
change-data-feed, and is responsible for reconciling the incoming change data
onto some target table that follows SCD1 replication semantics.
SCD1 flows also maintain an "auxiliary" table to keep track of early-arriving
out-of-order received events state. Each microbatch will need to reconcile
against this auxiliary table as well, and update the auxiliary table's state
appropriately for future microbatches.
{*}Merge Microbatch onto Auxiliary{*}:
The auxiliary table should be updated such that;
# Stale tombstones (delete events now succeeded by upserts/deletes in the
incoming microbatch) should be removed from the auxiliary table. They will
never be meaningful for SCD1 again.
# New tombstones introduced in the incoming microbatch should be persisted in
the auxiliary table, for future microbatches to reconcile agianst.
Implement this update operation as a MERGE.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
