Fragment 52097 (Actor 737175,737176)
StreamMaterialize { columns: [party_id, entity_id, entity_type, accounts_dm.account_id(hidden), customer_relationships.id(hidden), active_parties_mv.id(hidden), party_involvements_dm.id(hidden), $src(hidden), $src#1(hidden)], stream_key: [accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, $src#1], pk_columns: [accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, $src#1], pk_conflict: NoCheck }
├── output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, 'account':Varchar, accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, $src ]
├── stream key: [ accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, $src ]
└── StreamUnion { all: true } { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, 'account':Varchar, accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, $src ], stream key: [ accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, $src ] }
├── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, 'account':Varchar, accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, 0:Int32 ], stream key: [ accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, 'portfolio':Varchar, portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, 1:Int32 ], stream key: [ portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52098 (Actor 737181,737182)
StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.entity_id, 'account':Varchar, accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, 0:Int32] }
├── output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, 'account':Varchar, accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, 0:Int32 ]
├── stream key: [ accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ]
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52099 (Actor 737180,737179)
StreamSyncLogStore { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── StreamHashJoin { type: Inner, predicate: accounts_dm.account_id = party_involvements_dm.entity_id } { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ accounts_dm.account_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
├── MergeExecutor { output: [ accounts_dm.account_id ], stream key: [ accounts_dm.account_id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.entity_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52100 (Actor 737135,737136)
StreamProject { exprs: [accounts_dm.account_id] } { output: [ accounts_dm.account_id ], stream key: [ accounts_dm.account_id ] }
└── StreamFilter { predicate: IsNull(accounts_dm.disabled_at) } { output: [ accounts_dm.account_id, accounts_dm.disabled_at ], stream key: [ accounts_dm.account_id ] }
└── StreamTableScan { table: accounts_dm, columns: [account_id, disabled_at] } { output: [ accounts_dm.account_id, accounts_dm.disabled_at ], stream key: [ accounts_dm.account_id ] }
├── Upstream { output: [ account_id, disabled_at ], stream key: [] }
└── BatchPlanNode { output: [ account_id, disabled_at ], stream key: [] }
Fragment 52101 (Actor 737184,737183)
StreamLocalityProvider { locality_columns: [party_involvements_dm.entity_id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.entity_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52102 (Actor 737186,737185)
StreamSyncLogStore { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── StreamHashJoin { type: Inner, predicate: customer_relationships.id = party_involvements_dm.customer_relationship_id } { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
├── MergeExecutor { output: [ customer_relationships.id ], stream key: [ customer_relationships.id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52103 (Actor 737138,737137)
StreamProject { exprs: [customer_relationships.id] } { output: [ customer_relationships.id ], stream key: [ customer_relationships.id ] }
└── StreamFilter { predicate: (customer_relationships.type = 'CUSTOMER':Varchar) AND (customer_relationships.status = 'ACTIVE':Varchar) AND IsNull(customer_relationships.disabled_at) } { output: [ customer_relationships.id, customer_relationships.type, customer_relationships.status, customer_relationships.disabled_at ], stream key: [ customer_relationships.id ] }
└── StreamTableScan { table: customer_relationships, columns: [id, type, status, disabled_at] } { output: [ customer_relationships.id, customer_relationships.type, customer_relationships.status, customer_relationships.disabled_at ], stream key: [ customer_relationships.id ] }
├── Upstream { output: [ id, type, status, disabled_at ], stream key: [] }
└── BatchPlanNode { output: [ id, type, status, disabled_at ], stream key: [] }
Fragment 52104 (Actor 737187,737188)
StreamLocalityProvider { locality_columns: [party_involvements_dm.customer_relationship_id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52105 (Actor 737190,737189)
StreamSyncLogStore { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ active_parties_mv.id, party_involvements_dm.id, $src ] }
└── StreamHashJoin { type: Inner, predicate: active_parties_mv.id = party_involvements_dm.party_id } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ active_parties_mv.id, party_involvements_dm.id, $src ] }
├── MergeExecutor { output: [ active_parties_mv.id ], stream key: [ active_parties_mv.id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.party_id, party_involvements_dm.id, $src ] }
Fragment 52106 (Actor 737234,737233)
StreamTableScan { table: active_parties_mv, columns: [id] } { output: [ active_parties_mv.id ], stream key: [ active_parties_mv.id ] }
├── Upstream { output: [ id ], stream key: [] }
└── BatchPlanNode { output: [ id ], stream key: [] }
Fragment 52107 (Actor 737191,737192)
StreamLocalityProvider { locality_columns: [party_involvements_dm.party_id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.party_id, party_involvements_dm.id, $src ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.id, $src ] }
Fragment 52108 (Actor 737193,737194)
StreamUnion { all: true } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.id, $src ] }
├── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 0:Int32 ], stream key: [ party_involvements_dm.id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 1:Int32 ], stream key: [ party_involvements_dm.id ] }
Fragment 52109 (Actor 737199,737200)
StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 0:Int32] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 0:Int32 ], stream key: [ party_involvements_dm.id ] }
└── StreamDynamicFilter { predicate: ($expr2 > now), output_watermarks: [[$expr2]], output: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, $expr2, party_involvements_dm.id], cleaned_by_watermark: true } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, $expr2, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
├── StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, AtTimeZone(party_involvements_dm.effective_to::Timestamp, 'UTC':Varchar) as $expr2, party_involvements_dm.id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, $expr2, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
│ └── StreamFilter { predicate: IsNotTrue(IsNull(party_involvements_dm.effective_to)) } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
│ └── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
└── MergeExecutor { output: [ now ], stream key: [] }
Fragment 52110 (Actor 737202,737201)
StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
└── StreamDynamicFilter { predicate: ($expr1 <= now), output: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, $expr1, party_involvements_dm.id], cleaned_by_watermark: true }
├── output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, $expr1, party_involvements_dm.id ]
├── stream key: [ party_involvements_dm.id ]
├── StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, AtTimeZone(party_involvements_dm.effective_from::Timestamp, 'UTC':Varchar) as $expr1, party_involvements_dm.id] }
│ ├── output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, $expr1, party_involvements_dm.id ]
│ ├── stream key: [ party_involvements_dm.id ]
│ └── StreamFilter { predicate: (IsNotTrue(IsNull(party_involvements_dm.effective_to)) OR IsNull(party_involvements_dm.effective_to)) AND (party_involvements_dm.entity_type = 'ACCOUNT':Varchar) AND (party_involvements_dm.involvement_type = 'ACCOUNT_HOLDER':Varchar) AND (party_involvements_dm.status = 'ACTIVE':Varchar) AND IsNull(party_involvements_dm.disabled_at) }
│ ├── output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_from, party_involvements_dm.effective_to, party_involvements_dm.id, party_involvements_dm.involvement_type, party_involvements_dm.entity_type, party_involvements_dm.status, party_involvements_dm.disabled_at ]
│ ├── stream key: [ party_involvements_dm.id ]
│ └── StreamTableScan { table: party_involvements_dm, columns: [party_id, customer_relationship_id, entity_id, effective_from, effective_to, id, involvement_type, entity_type, status, disabled_at] }
│ ├── output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_from, party_involvements_dm.effective_to, party_involvements_dm.id, party_involvements_dm.involvement_type, party_involvements_dm.entity_type, party_involvements_dm.status, party_involvements_dm.disabled_at ]
│ ├── stream key: [ party_involvements_dm.id ]
│ ├── Upstream { output: [ party_id, customer_relationship_id, entity_id, effective_from, effective_to, id, involvement_type, entity_type, status, disabled_at ], stream key: [] }
│ └── BatchPlanNode { output: [ party_id, customer_relationship_id, entity_id, effective_from, effective_to, id, involvement_type, entity_type, status, disabled_at ], stream key: [] }
└── MergeExecutor { output: [ now ], stream key: [] }
Fragment 52111 (Actor 737195)
StreamNow { output: [ now ], stream key: [] }
Fragment 52112 (Actor 737196)
StreamNow { output: [ now ], stream key: [] }
Fragment 52113 (Actor 737197,737198)
StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 1:Int32] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 1:Int32 ], stream key: [ party_involvements_dm.id ] }
└── StreamFilter { predicate: IsNull(party_involvements_dm.effective_to) } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
Fragment 52114 (Actor 737204,737203)
StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.entity_id, 'portfolio':Varchar, portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, 1:Int32] }
├── output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, 'portfolio':Varchar, portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src, 1:Int32 ]
├── stream key: [ portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ]
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52115 (Actor 737206,737205)
StreamSyncLogStore { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── StreamHashJoin { type: Inner, predicate: portfolios_dm.portfolio_id = party_involvements_dm.entity_id } { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ portfolios_dm.portfolio_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
├── MergeExecutor { output: [ portfolios_dm.portfolio_id ], stream key: [ portfolios_dm.portfolio_id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.entity_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52116 (Actor 737235,737236)
StreamProject { exprs: [portfolios_dm.portfolio_id] } { output: [ portfolios_dm.portfolio_id ], stream key: [ portfolios_dm.portfolio_id ] }
└── StreamFilter { predicate: IsNull(portfolios_dm.disabled_at) } { output: [ portfolios_dm.portfolio_id, portfolios_dm.disabled_at ], stream key: [ portfolios_dm.portfolio_id ] }
└── StreamTableScan { table: portfolios_dm, columns: [portfolio_id, disabled_at] } { output: [ portfolios_dm.portfolio_id, portfolios_dm.disabled_at ], stream key: [ portfolios_dm.portfolio_id ] }
├── Upstream { output: [ portfolio_id, disabled_at ], stream key: [] }
└── BatchPlanNode { output: [ portfolio_id, disabled_at ], stream key: [] }
Fragment 52117 (Actor 737212,737211)
StreamLocalityProvider { locality_columns: [party_involvements_dm.entity_id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.entity_id, customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52118 (Actor 737214,737213)
StreamSyncLogStore { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── StreamHashJoin { type: Inner, predicate: customer_relationships.id = party_involvements_dm.customer_relationship_id } { output: [ party_involvements_dm.party_id, party_involvements_dm.entity_id, customer_relationships.id, party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ customer_relationships.id, active_parties_mv.id, party_involvements_dm.id, $src ] }
├── MergeExecutor { output: [ customer_relationships.id ], stream key: [ customer_relationships.id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52119 (Actor 737237,737238)
StreamProject { exprs: [customer_relationships.id] } { output: [ customer_relationships.id ], stream key: [ customer_relationships.id ] }
└── StreamFilter { predicate: (customer_relationships.type = 'CUSTOMER':Varchar) AND (customer_relationships.status = 'ACTIVE':Varchar) AND IsNull(customer_relationships.disabled_at) } { output: [ customer_relationships.id, customer_relationships.type, customer_relationships.status, customer_relationships.disabled_at ], stream key: [ customer_relationships.id ] }
└── StreamTableScan { table: customer_relationships, columns: [id, type, status, disabled_at] } { output: [ customer_relationships.id, customer_relationships.type, customer_relationships.status, customer_relationships.disabled_at ], stream key: [ customer_relationships.id ] }
├── Upstream { output: [ id, type, status, disabled_at ], stream key: [] }
└── BatchPlanNode { output: [ id, type, status, disabled_at ], stream key: [] }
Fragment 52120 (Actor 737217,737218)
StreamLocalityProvider { locality_columns: [party_involvements_dm.customer_relationship_id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.customer_relationship_id, active_parties_mv.id, party_involvements_dm.id, $src ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ active_parties_mv.id, party_involvements_dm.id, $src ] }
Fragment 52121 (Actor 737219,737220)
StreamSyncLogStore { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ active_parties_mv.id, party_involvements_dm.id, $src ] }
└── StreamHashJoin { type: Inner, predicate: active_parties_mv.id = party_involvements_dm.party_id } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, active_parties_mv.id, party_involvements_dm.id, $src ], stream key: [ active_parties_mv.id, party_involvements_dm.id, $src ] }
├── MergeExecutor { output: [ active_parties_mv.id ], stream key: [ active_parties_mv.id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.party_id, party_involvements_dm.id, $src ] }
Fragment 52122 (Actor 737239,737240)
StreamTableScan { table: active_parties_mv, columns: [id] } { output: [ active_parties_mv.id ], stream key: [ active_parties_mv.id ] }
├── Upstream { output: [ id ], stream key: [] }
└── BatchPlanNode { output: [ id ], stream key: [] }
Fragment 52123 (Actor 737221,737222)
StreamLocalityProvider { locality_columns: [party_involvements_dm.party_id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.party_id, party_involvements_dm.id, $src ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.id, $src ] }
Fragment 52124 (Actor 737223,737224)
StreamUnion { all: true } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, $src ], stream key: [ party_involvements_dm.id, $src ] }
├── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 0:Int32 ], stream key: [ party_involvements_dm.id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 1:Int32 ], stream key: [ party_involvements_dm.id ] }
Fragment 52125 (Actor 737230,737229)
StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 0:Int32] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 0:Int32 ], stream key: [ party_involvements_dm.id ] }
└── StreamDynamicFilter { predicate: ($expr4 > now), output_watermarks: [[$expr4]], output: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, $expr4, party_involvements_dm.id], cleaned_by_watermark: true } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, $expr4, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
├── StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, AtTimeZone(party_involvements_dm.effective_to::Timestamp, 'UTC':Varchar) as $expr4, party_involvements_dm.id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, $expr4, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
│ └── StreamFilter { predicate: IsNotTrue(IsNull(party_involvements_dm.effective_to)) } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
│ └── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
└── MergeExecutor { output: [ now ], stream key: [] }
Fragment 52126 (Actor 737232,737231)
StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
└── StreamDynamicFilter { predicate: ($expr3 <= now), output: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, $expr3, party_involvements_dm.id], cleaned_by_watermark: true }
├── output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, $expr3, party_involvements_dm.id ]
├── stream key: [ party_involvements_dm.id ]
├── StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, AtTimeZone(party_involvements_dm.effective_from::Timestamp, 'UTC':Varchar) as $expr3, party_involvements_dm.id] }
│ ├── output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, $expr3, party_involvements_dm.id ]
│ ├── stream key: [ party_involvements_dm.id ]
│ └── StreamFilter { predicate: (IsNotTrue(IsNull(party_involvements_dm.effective_to)) OR IsNull(party_involvements_dm.effective_to)) AND (party_involvements_dm.entity_type = 'PORTFOLIO':Varchar) AND (party_involvements_dm.involvement_type = 'PORTFOLIO_HOLDER':Varchar) AND (party_involvements_dm.status = 'ACTIVE':Varchar) AND IsNull(party_involvements_dm.disabled_at) }
│ ├── output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_from, party_involvements_dm.effective_to, party_involvements_dm.id, party_involvements_dm.involvement_type, party_involvements_dm.entity_type, party_involvements_dm.status, party_involvements_dm.disabled_at ]
│ ├── stream key: [ party_involvements_dm.id ]
│ └── StreamTableScan { table: party_involvements_dm, columns: [party_id, customer_relationship_id, entity_id, effective_from, effective_to, id, involvement_type, entity_type, status, disabled_at] }
│ ├── output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_from, party_involvements_dm.effective_to, party_involvements_dm.id, party_involvements_dm.involvement_type, party_involvements_dm.entity_type, party_involvements_dm.status, party_involvements_dm.disabled_at ]
│ ├── stream key: [ party_involvements_dm.id ]
│ ├── Upstream { output: [ party_id, customer_relationship_id, entity_id, effective_from, effective_to, id, involvement_type, entity_type, status, disabled_at ], stream key: [] }
│ └── BatchPlanNode { output: [ party_id, customer_relationship_id, entity_id, effective_from, effective_to, id, involvement_type, entity_type, status, disabled_at ], stream key: [] }
└── MergeExecutor { output: [ now ], stream key: [] }
Fragment 52127 (Actor 737225)
StreamNow { output: [ now ], stream key: [] }
Fragment 52128 (Actor 737226)
StreamNow { output: [ now ], stream key: [] }
Fragment 52129 (Actor 737227,737228)
StreamProject { exprs: [party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 1:Int32] } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.id, 1:Int32 ], stream key: [ party_involvements_dm.id ] }
└── StreamFilter { predicate: IsNull(party_involvements_dm.effective_to) } { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }
└── MergeExecutor { output: [ party_involvements_dm.party_id, party_involvements_dm.customer_relationship_id, party_involvements_dm.entity_id, party_involvements_dm.effective_to, party_involvements_dm.id ], stream key: [ party_involvements_dm.id ] }