Anish Mahto created SPARK-56856:
-----------------------------------
Summary: Implement SCD1 Batch Processor; Microbatch Deduplication
Key: SPARK-56856
URL: https://issues.apache.org/jira/browse/SPARK-56856
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.
{*}Microbatch Deduplication{*}:
The first step of microbatch reconciliation for SCD1 is deduplicating the
microbatch such that there is a single row per key.
Since SCD1 is only concerned with maintaining _latest_ state per key from the
change data source, within a microbatch we only care about the row with the
latest sequencing per key - drop all other rows for that same key.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
