RWM Console cluster: risingwave-ai-hub-int.ai-hub-rwm.svc.cluster.local

← cluster insights objects transactions_merged_mv explain
Overview Objects Graph History
materialized view · insights.transactions_merged_mv profiled over 5s
seconds (1–30)

Job is idle — throughput ~0; structure shown.

Stateful hash join (4 state tables) — consider a temporal join for dimension lookupsAggregation state — unbounded unless keyed or temporally filtered
120 operators
Materialize · insights.transactions_merged_mv
0% idle 2 actors
Union
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · IsNull(transactions_dm.order_id)
— — 2 actors
Filter · IsNull(transactions_dm.order_id)
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · LeftOuter · transactions_intraday_dm.order_id = transactions_dm.order_i…
— — 2 actors
HashJoin · LeftOuter · transactions_intraday_dm.order_id = transactions_dm.order_i… Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
HashAgg Aggregation state — unbounded unless keyed or temporally filtered
0% idle 2 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Filter · transactions_dm
0% idle 2 actors
StreamScan · transactions_dm
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Filter · IsNull(transactions_dm.transaction_id)
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · LeftOuter · transactions_intraday_dm.transaction_id = transactions_dm.t…
— — 2 actors
HashJoin · LeftOuter · transactions_intraday_dm.transaction_id = transactions_dm.t… Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamScan · transactions_dm
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Filter · IsNull(transactions_intraday_dm.transaction_id)
0% idle 2 actors
Project · IsNull(transactions_intraday_dm.transaction_id)
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · LeftOuter · transactions_intraday_dm.transaction_id = transactions_intr…
— — 2 actors
HashJoin · LeftOuter · transactions_intraday_dm.transaction_id = transactions_intr… Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · LeftSemi · transactions_intraday_dm.status_label_id = active_transacti…
— — 2 actors
HashJoin · LeftSemi · transactions_intraday_dm.status_label_id = active_transacti… Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
StreamScan · active_transaction_status_id_mv
0% idle 1 actor
BatchPlan
— — 1 actor
Merge
— — 1 actor
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · transactions_intraday_dm
— — 2 actors
Filter · transactions_intraday_dm
0% idle 2 actors
StreamScan · transactions_intraday_dm
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · transactions_intraday_dm
— — 2 actors
Filter · transactions_intraday_dm
0% idle 2 actors
StreamScan · transactions_intraday_dm
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · IsNull(transactions_intraday_dm.transaction_id)
— — 2 actors
Filter · IsNull(transactions_intraday_dm.transaction_id)
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · LeftOuter · transactions_dm.transaction_id = transactions_intraday_dm.t…
— — 2 actors
HashJoin · LeftOuter · transactions_dm.transaction_id = transactions_intraday_dm.t… Stateful hash join (4 state tables) — consider a temporal join for dimension lookups
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
LocalityProvider
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project · transactions_dm
— — 2 actors
Filter · transactions_dm
0% idle 2 actors
StreamScan · transactions_dm
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
Project
— — 2 actors
Merge
— — 2 actors
Heat = the operator's output-buffer backpressure over the sampling window. Click a node to fold its subtree.
Materialize · insights.transactions_merged_mv Materialize insights.transactions_m… idle · 2 actors Union Union idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project · IsNull(transactions_dm.order_id) Project IsNull(transactions_dm.… — · 2 actors Filter · IsNull(transactions_dm.order_id) Filter IsNull(transactions_dm.… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · LeftOuter · transactions_intraday_dm.order_id = transactions_dm.order_i… SyncLogStore LeftOuter · transaction… — · 2 actors HashJoin · LeftOuter · transactions_intraday_dm.order_id = transactions_dm.order_i… HashJoin LeftOuter · transaction… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors HashAgg HashAgg idle · 2 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Filter · transactions_dm Filter transactions_dm idle · 2 actors StreamScan · transactions_dm StreamScan transactions_dm idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Filter · IsNull(transactions_dm.transaction_id) Filter IsNull(transactions_dm.… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · LeftOuter · transactions_intraday_dm.transaction_id = transactions_dm.t… SyncLogStore LeftOuter · transaction… — · 2 actors HashJoin · LeftOuter · transactions_intraday_dm.transaction_id = transactions_dm.t… HashJoin LeftOuter · transaction… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors StreamScan · transactions_dm StreamScan transactions_dm idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Filter · IsNull(transactions_intraday_dm.transaction_id) Filter IsNull(transactions_int… idle · 2 actors Project · IsNull(transactions_intraday_dm.transaction_id) Project IsNull(transactions_int… — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · LeftOuter · transactions_intraday_dm.transaction_id = transactions_intr… SyncLogStore LeftOuter · transaction… — · 2 actors HashJoin · LeftOuter · transactions_intraday_dm.transaction_id = transactions_intr… HashJoin LeftOuter · transaction… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore SyncLogStore — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore SyncLogStore — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · LeftSemi · transactions_intraday_dm.status_label_id = active_transacti… SyncLogStore LeftSemi · transactions… — · 2 actors HashJoin · LeftSemi · transactions_intraday_dm.status_label_id = active_transacti… HashJoin LeftSemi · transactions… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors StreamScan · active_transaction_status_id_mv StreamScan active_transaction_stat… idle · 1 actor BatchPlan BatchPlan — · 1 actor Merge Merge — · 1 actor Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project · transactions_intraday_dm Project transactions_intraday_dm — · 2 actors Filter · transactions_intraday_dm Filter transactions_intraday_dm idle · 2 actors StreamScan · transactions_intraday_dm StreamScan transactions_intraday_dm idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project · transactions_intraday_dm Project transactions_intraday_dm — · 2 actors Filter · transactions_intraday_dm Filter transactions_intraday_dm idle · 2 actors StreamScan · transactions_intraday_dm StreamScan transactions_intraday_dm idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project · IsNull(transactions_intraday_dm.transaction_id) Project IsNull(transactions_int… — · 2 actors Filter · IsNull(transactions_intraday_dm.transaction_id) Filter IsNull(transactions_int… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors SyncLogStore · LeftOuter · transactions_dm.transaction_id = transactions_intraday_dm.t… SyncLogStore LeftOuter · transaction… — · 2 actors HashJoin · LeftOuter · transactions_dm.transaction_id = transactions_intraday_dm.t… HashJoin LeftOuter · transaction… idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors LocalityProvider LocalityProvider idle · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project · transactions_dm Project transactions_dm — · 2 actors Filter · transactions_dm Filter transactions_dm idle · 2 actors StreamScan · transactions_dm StreamScan transactions_dm idle · 2 actors BatchPlan BatchPlan — · 2 actors Merge Merge — · 2 actors Merge Merge — · 2 actors Exchange Exchange idle · 0 actors Project Project — · 2 actors Merge Merge — · 2 actors
Streaming operator plan from EXPLAIN ANALYZE. Node heat = backpressure. Drag to pan, scroll to zoom.
Fragments (DESCRIBE FRAGMENTS) — click to expand 
Fragment 12528 (Actor 157347,157346)
StreamMaterialize { columns: [transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, transaction_source, transactions_intraday_dm.status_label_id(hidden), transactions_intraday_dm.transaction_id(hidden), null:Varchar(hidden), null:Varchar#1(hidden), null:Varchar#2(hidden), null:Varchar#3(hidden), $src(hidden)], stream_key: [transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar#1, null:Varchar#2, null:Varchar#3, $src], pk_columns: [transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar#1, null:Varchar#2, null:Varchar#3, $src], pk_conflict: NoCheck }
├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, $src ]
├── stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, $src ]
└── StreamUnion { all: true }
    ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, $src ]
    ├── stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, $src ]
    ├── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, 0:Int32 ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
    ├── MergeExecutor { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, 'EOD':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, 1:Int32 ], stream key: [ transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
    └── MergeExecutor
        ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id, 2:Int32 ]
        └── stream key: [ transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]

Fragment 12529 (Actor 157351,157350)
StreamProject { exprs: [transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, 0:Int32] }
├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, 0:Int32 ]
├── stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ]
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }

Fragment 12530 (Actor 157352,157353)
StreamProject { exprs: [transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id] }
├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id ]
├── stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ]
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }

Fragment 12531 (Actor 157360,157361)
StreamSyncLogStore { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }

Fragment 12532 (Actor 157356,157357)
StreamSyncLogStore { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }

Fragment 12533 (Actor 157359,157358)
StreamSyncLogStore { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
└── StreamHashJoin { type: LeftSemi, predicate: transactions_intraday_dm.status_label_id = active_transaction_status_id_mv.status_label_id } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
    ├── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
    └── MergeExecutor { output: [ active_transaction_status_id_mv.status_label_id, active_transaction_status_id_mv._row_id ], stream key: [ active_transaction_status_id_mv.status_label_id, active_transaction_status_id_mv._row_id ] }

Fragment 12534 (Actor 157365,157364)
StreamLocalityProvider { locality_columns: [transactions_intraday_dm.status_label_id] } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id ] }

Fragment 12535 (Actor 157403,157402)
StreamProject { exprs: [transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id] }
├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id ]
├── stream key: [ transactions_intraday_dm.transaction_id ]
└── StreamFilter { predicate: IsNull(transactions_intraday_dm.disabled_at) } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id, transactions_intraday_dm.disabled_at ], stream key: [ transactions_intraday_dm.transaction_id ] }
    └── StreamTableScan { table: transactions_intraday_dm, columns: [transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, status_label_id, disabled_at] }
        ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.status_label_id, transactions_intraday_dm.disabled_at ]
        ├── stream key: [ transactions_intraday_dm.transaction_id ]
        ├── Upstream { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, status_label_id, disabled_at ], stream key: [] }
        └── BatchPlanNode { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, status_label_id, disabled_at ], stream key: [] }

Fragment 12536 (Actor 157366,157367)
StreamLocalityProvider { locality_columns: [active_transaction_status_id_mv.status_label_id] } { output: [ active_transaction_status_id_mv.status_label_id, active_transaction_status_id_mv._row_id ], stream key: [ active_transaction_status_id_mv.status_label_id, active_transaction_status_id_mv._row_id ] }
└── MergeExecutor { output: [ active_transaction_status_id_mv.status_label_id, active_transaction_status_id_mv._row_id ], stream key: [ active_transaction_status_id_mv._row_id ] }

Fragment 12537 (Actor 157404)
StreamTableScan { table: active_transaction_status_id_mv, columns: [status_label_id, _row_id] } { output: [ active_transaction_status_id_mv.status_label_id, active_transaction_status_id_mv._row_id ], stream key: [ active_transaction_status_id_mv._row_id ] }
├── Upstream { output: [ status_label_id, _row_id ], stream key: [] }
└── BatchPlanNode { output: [ status_label_id, _row_id ], stream key: [] }

Fragment 12538 (Actor 157373,157372)
StreamProject { exprs: [transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, 'EOD':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, 1:Int32] }
├── output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, 'EOD':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id, null:Varchar, null:Varchar, null:Varchar, null:Varchar, 1:Int32 ]
├── stream key: [ transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ]
└── StreamFilter { predicate: IsNull(transactions_intraday_dm.transaction_id) } { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
    └── MergeExecutor { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ] }

Fragment 12539 (Actor 157370,157371)
StreamSyncLogStore { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
└── StreamHashJoin { type: LeftOuter, predicate: transactions_dm.transaction_id = transactions_intraday_dm.transaction_id } { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
    ├── MergeExecutor { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity ], stream key: [ transactions_dm.transaction_id ] }
    └── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }

Fragment 12540 (Actor 157405,157406)
StreamProject { exprs: [transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity] } { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity ], stream key: [ transactions_dm.transaction_id ] }
└── StreamFilter { predicate: IsNull(transactions_dm.disabled_at) } { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, transactions_dm.disabled_at ], stream key: [ transactions_dm.transaction_id ] }
    └── StreamTableScan { table: transactions_dm, columns: [transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, disabled_at] } { output: [ transactions_dm.transaction_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_valuation_date, transactions_dm.transaction_valuation_timestamp, transactions_dm.transaction_settlement_date, transactions_dm.transaction_type_id, transactions_dm.currency_code, transactions_dm.net_value, transactions_dm.quantity, transactions_dm.disabled_at ], stream key: [ transactions_dm.transaction_id ] }
        ├── Upstream { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, disabled_at ], stream key: [] }
        └── BatchPlanNode { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, disabled_at ], stream key: [] }

Fragment 12541 (Actor 157375,157374)
StreamLocalityProvider { locality_columns: [transactions_intraday_dm.transaction_id] } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }

Fragment 12542 (Actor 157363,157362)
StreamProject { exprs: [transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id] } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }

Fragment 12543 (Actor 157379,157378)
StreamProject { exprs: [transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id, 2:Int32] }
├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id, 2:Int32 ]
├── stream key: [ transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
└── StreamFilter { predicate: IsNull(transactions_dm.order_id) }
    ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY_SETTLING':Varchar, transactions_dm.order_id, transactions_intraday_dm.order_id, transactions_intraday_dm.status_label_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ]
    ├── stream key: [ transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    └── MergeExecutor
        ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY_SETTLING':Varchar, transactions_dm.order_id, transactions_intraday_dm.order_id, transactions_intraday_dm.status_label_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ]
        └── stream key: [ transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]

Fragment 12544 (Actor 157376,157377)
StreamSyncLogStore
├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY_SETTLING':Varchar, transactions_dm.order_id, transactions_intraday_dm.order_id, transactions_intraday_dm.status_label_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ]
├── stream key: [ transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
└── StreamHashJoin { type: LeftOuter, predicate: transactions_intraday_dm.order_id = transactions_dm.order_id AND transactions_intraday_dm.account_id = transactions_dm.account_id AND transactions_intraday_dm.asset_id = transactions_dm.asset_id AND transactions_intraday_dm.transaction_type_id = transactions_dm.transaction_type_id AND (transactions_intraday_dm.order_id <> '':Varchar) }
    ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY_SETTLING':Varchar, transactions_dm.order_id, transactions_intraday_dm.order_id, transactions_intraday_dm.status_label_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ]
    ├── stream key: [ transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    ├── MergeExecutor
    │   ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    │   └── stream key: [ transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    └── MergeExecutor { output: [ transactions_dm.order_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ], stream key: [ transactions_dm.order_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ] }

Fragment 12545 (Actor 157380,157381)
StreamLocalityProvider { locality_columns: [transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id] }
├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ]
├── stream key: [ transactions_intraday_dm.order_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }

Fragment 12546 (Actor 157382,157383)
StreamFilter { predicate: IsNull(transactions_dm.transaction_id) } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }

Fragment 12547 (Actor 157385,157384)
StreamSyncLogStore { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
└── StreamHashJoin { type: LeftOuter, predicate: transactions_intraday_dm.transaction_id = transactions_dm.transaction_id }
    ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    ├── stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    ├── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
    └── MergeExecutor { output: [ transactions_dm.transaction_id ], stream key: [ transactions_dm.transaction_id ] }

Fragment 12548 (Actor 157386,157387)
StreamLocalityProvider { locality_columns: [transactions_intraday_dm.transaction_id] } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }

Fragment 12549 (Actor 157390,157391)
StreamFilter { predicate: IsNull(transactions_intraday_dm.transaction_id) } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
└── StreamProject { exprs: [transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id] }
    ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, 'INTRADAY_SETTLING':Varchar, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    ├── stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    └── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }

Fragment 12550 (Actor 157389,157388)
StreamSyncLogStore { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
└── StreamHashJoin { type: LeftOuter, predicate: transactions_intraday_dm.transaction_id = transactions_intraday_dm.transaction_id }
    ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    ├── stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ]
    ├── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id ], stream key: [ transactions_intraday_dm.transaction_id ] }
    └── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }

Fragment 12551 (Actor 157408,157407)
StreamProject { exprs: [transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id] }
├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id ]
├── stream key: [ transactions_intraday_dm.transaction_id ]
└── StreamFilter { predicate: (transactions_intraday_dm.retire_reason = 'SETTLED':Varchar) } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, transactions_intraday_dm.retire_reason ], stream key: [ transactions_intraday_dm.transaction_id ] }
    └── StreamTableScan { table: transactions_intraday_dm, columns: [transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, order_id, retire_reason] }
        ├── output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, transactions_intraday_dm.order_id, transactions_intraday_dm.retire_reason ]
        ├── stream key: [ transactions_intraday_dm.transaction_id ]
        ├── Upstream { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, order_id, retire_reason ], stream key: [] }
        └── BatchPlanNode { output: [ transaction_id, account_id, asset_id, transaction_valuation_date, transaction_valuation_timestamp, transaction_settlement_date, transaction_type_id, currency_code, net_value, quantity, order_id, retire_reason ], stream key: [] }

Fragment 12552 (Actor 157395,157394)
StreamLocalityProvider { locality_columns: [transactions_intraday_dm.transaction_id] } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }

Fragment 12553 (Actor 157355,157354)
StreamProject { exprs: [transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id] } { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }
└── MergeExecutor { output: [ transactions_intraday_dm.transaction_id, transactions_intraday_dm.account_id, transactions_intraday_dm.asset_id, transactions_intraday_dm.transaction_valuation_date, transactions_intraday_dm.transaction_valuation_timestamp, transactions_intraday_dm.transaction_settlement_date, transactions_intraday_dm.transaction_type_id, transactions_intraday_dm.currency_code, transactions_intraday_dm.net_value, transactions_intraday_dm.quantity, 'INTRADAY':Varchar, transactions_intraday_dm.status_label_id ], stream key: [ transactions_intraday_dm.status_label_id, transactions_intraday_dm.transaction_id ] }

Fragment 12554 (Actor 157410,157409)
StreamTableScan { table: transactions_dm, columns: [transaction_id] } { output: [ transactions_dm.transaction_id ], stream key: [ transactions_dm.transaction_id ] }
├── Upstream { output: [ transaction_id ], stream key: [] }
└── BatchPlanNode { output: [ transaction_id ], stream key: [] }

Fragment 12555 (Actor 157400,157401)
StreamLocalityProvider { locality_columns: [transactions_dm.order_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id] } { output: [ transactions_dm.order_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ], stream key: [ transactions_dm.order_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ] }
└── MergeExecutor { output: [ transactions_dm.order_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ], stream key: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id ] }

Fragment 12556 (Actor 157399,157398)
StreamProject { exprs: [transactions_dm.order_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id] } { output: [ transactions_dm.order_id, transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id ], stream key: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id ] }
└── StreamHashAgg { group_key: [transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id], aggs: [count] } { output: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id, count ], stream key: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id ] }
    └── StreamLocalityProvider { locality_columns: [transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id] } { output: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id, transactions_dm.transaction_id ], stream key: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id, transactions_dm.transaction_id ] }
        └── MergeExecutor { output: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id, transactions_dm.transaction_id ], stream key: [ transactions_dm.transaction_id ] }

Fragment 12557 (Actor 157412,157411)
StreamFilter { predicate: (transactions_dm.order_id <> '':Varchar) } { output: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id, transactions_dm.transaction_id ], stream key: [ transactions_dm.transaction_id ] }
└── StreamTableScan { table: transactions_dm, columns: [account_id, asset_id, transaction_type_id, order_id, transaction_id] } { output: [ transactions_dm.account_id, transactions_dm.asset_id, transactions_dm.transaction_type_id, transactions_dm.order_id, transactions_dm.transaction_id ], stream key: [ transactions_dm.transaction_id ] }
    ├── Upstream { output: [ account_id, asset_id, transaction_type_id, order_id, transaction_id ], stream key: [] }
    └── BatchPlanNode { output: [ account_id, asset_id, transaction_type_id, order_id, transaction_id ], stream key: [] }