Anish Mahto created SPARK-57322:
-----------------------------------
Summary: Implement SCD2 Batch Processor; Reconcile StartAt/EndAt
Key: SPARK-57322
URL: https://issues.apache.org/jira/browse/SPARK-57322
Project: Spark
Issue Type: Sub-task
Components: Declarative Pipelines
Affects Versions: 4.3.0
Reporter: Anish Mahto
{*}Preamble{*}:
The SCD type 2 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 SCD2 replication semantics.
SCD2 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.
*Reconcile StartAt/EndAt*
Once we have all of the relevant rows for microbatch SCD2 reconciliation
decomposed, we can begin setting the start/end-at for incoming microbatch rows,
and rewriting existing start/end-at of existing rows in the aux/target tables
to account for late arriving events.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
