position_snapshot_mv · explain

← cluster insights objects position_snapshot_mv explain
materialized view · insights.position_snapshot_mv profiled over 5s
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
Heat tree Operator graph
44 operators
Materialize · insights.position_snapshot_mv
0% idle 2 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
Expand · (Not(IsNull(fx_rates_snapshot_mv.rate)) OR (holding_values_…
0% idle 2 actors
Project · (Not(IsNull(fx_rates_snapshot_mv.rate)) OR (holding_values_…
— — 2 actors
Project · (Not(IsNull(fx_rates_snapshot_mv.rate)) OR (holding_values_…
— — 2 actors
Filter · (Not(IsNull(fx_rates_snapshot_mv.rate)) OR (holding_values_…
0% idle 2 actors
Merge
— — 2 actors
Exchange
0% idle 0 actors
SyncLogStore · LeftOuter · holding_values_latest_mv.currency_code = fx_rates_snapshot_…
— — 2 actors
HashJoin · LeftOuter · holding_values_latest_mv.currency_code = fx_rates_snapshot_… 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 · fx_rates_snapshot_mv
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
SyncLogStore · Inner · holding_values_latest_mv.account_id = account_to_account_gr…
— — 2 actors
HashJoin · Inner · holding_values_latest_mv.account_id = account_to_account_gr… 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 · account_to_account_groups_mv_next
— — 2 actors
Filter · account_to_account_groups_mv_next
0% idle 2 actors
StreamScan · account_to_account_groups_mv_next
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
StreamScan · holding_values_latest_mv
0% idle 2 actors
BatchPlan
— — 2 actors
Merge
— — 2 actors
Heat = the operator's output-buffer backpressure over the sampling window. Click a node to fold its subtree.
Streaming operator plan from EXPLAIN ANALYZE. Node heat = backpressure. Drag to pan, scroll to zoom.
Fragments (DESCRIBE FRAGMENTS) — click to expand
Fragment 61237 (Actor 738650,738651)
StreamMaterialize { columns: [account_group_id, dim_balance_date, position_type, currency_code, market_value, fair_value, accrued_value, market_value_system_currency, fair_value_system_currency, accrued_value_system_currency, relationship_value, fair_relationship_value, relationship_value_system_currency, fair_relationship_value_system_currency, holding_values_latest_mv.type_expanded(hidden), flag(hidden)], stream_key: [account_group_id, currency_code, holding_values_latest_mv.type_expanded, flag], pk_columns: [account_group_id, currency_code, holding_values_latest_mv.type_expanded, flag], pk_conflict: NoCheck }
├── output: [ account_to_account_groups_mv_next.account_group_id_expanded, max(holding_values_latest_mv.dim_value_date), $expr9, account_to_account_groups_mv_next.base_currency_expanded, sum($expr2), sum($expr3), sum($expr4), sum(holding_values_latest_mv.market_value_system_currency), sum(holding_values_latest_mv.fair_value_system_currency), sum(holding_values_latest_mv.accrued_value_system_currency), sum($expr5), sum($expr6), sum($expr7), sum($expr8), holding_values_latest_mv.type_expanded, flag ]
├── stream key: [ account_to_account_groups_mv_next.account_group_id_expanded, account_to_account_groups_mv_next.base_currency_expanded, holding_values_latest_mv.type_expanded, flag ]
└── StreamProject { exprs: [account_to_account_groups_mv_next.account_group_id_expanded, max(holding_values_latest_mv.dim_value_date), Coalesce(holding_values_latest_mv.type_expanded, 'POSITION':Varchar) as $expr9, account_to_account_groups_mv_next.base_currency_expanded, sum($expr2), sum($expr3), sum($expr4), sum(holding_values_latest_mv.market_value_system_currency), sum(holding_values_latest_mv.fair_value_system_currency), sum(holding_values_latest_mv.accrued_value_system_currency), sum($expr5), sum($expr6), sum($expr7), sum($expr8), holding_values_latest_mv.type_expanded, flag] }
    ├── output: [ account_to_account_groups_mv_next.account_group_id_expanded, max(holding_values_latest_mv.dim_value_date), $expr9, account_to_account_groups_mv_next.base_currency_expanded, sum($expr2), sum($expr3), sum($expr4), sum(holding_values_latest_mv.market_value_system_currency), sum(holding_values_latest_mv.fair_value_system_currency), sum(holding_values_latest_mv.accrued_value_system_currency), sum($expr5), sum($expr6), sum($expr7), sum($expr8), holding_values_latest_mv.type_expanded, flag ]
    ├── stream key: [ account_to_account_groups_mv_next.account_group_id_expanded, account_to_account_groups_mv_next.base_currency_expanded, holding_values_latest_mv.type_expanded, flag ]
    └── StreamHashAgg { group_key: [account_to_account_groups_mv_next.account_group_id_expanded, account_to_account_groups_mv_next.base_currency_expanded, holding_values_latest_mv.type_expanded, flag], aggs: [max(holding_values_latest_mv.dim_value_date), sum($expr2), sum($expr3), sum($expr4), sum(holding_values_latest_mv.market_value_system_currency), sum(holding_values_latest_mv.fair_value_system_currency), sum(holding_values_latest_mv.accrued_value_system_currency), sum($expr5), sum($expr6), sum($expr7), sum($expr8), count] }
        ├── output: [ account_to_account_groups_mv_next.account_group_id_expanded, account_to_account_groups_mv_next.base_currency_expanded, holding_values_latest_mv.type_expanded, flag, max(holding_values_latest_mv.dim_value_date), sum($expr2), sum($expr3), sum($expr4), sum(holding_values_latest_mv.market_value_system_currency), sum(holding_values_latest_mv.fair_value_system_currency), sum(holding_values_latest_mv.accrued_value_system_currency), sum($expr5), sum($expr6), sum($expr7), sum($expr8), count ]
        ├── stream key: [ account_to_account_groups_mv_next.account_group_id_expanded, account_to_account_groups_mv_next.base_currency_expanded, holding_values_latest_mv.type_expanded, flag ]
        └── StreamLocalityProvider { locality_columns: [account_to_account_groups_mv_next.account_group_id_expanded, account_to_account_groups_mv_next.base_currency_expanded, holding_values_latest_mv.type_expanded, flag] }
            ├── output:
            │   ┌── account_to_account_groups_mv_next.account_group_id_expanded
            │   ├── account_to_account_groups_mv_next.base_currency_expanded
            │   ├── holding_values_latest_mv.type_expanded
            │   ├── holding_values_latest_mv.dim_value_date_expanded
            │   ├── $expr2_expanded
            │   ├── $expr3_expanded
            │   ├── $expr4_expanded
            │   ├── holding_values_latest_mv.market_value_system_currency_expanded
            │   ├── holding_values_latest_mv.fair_value_system_currency_expanded
            │   ├── holding_values_latest_mv.accrued_value_system_currency_expanded
            │   ├── $expr5_expanded
            │   ├── $expr6_expanded
            │   ├── $expr7_expanded
            │   ├── $expr8_expanded
            │   ├── holding_values_latest_mv.currency_code_expanded
            │   ├── holding_values_latest_mv.account_id_expanded
            │   ├── holding_values_latest_mv.asset_id_expanded
            │   ├── account_to_account_groups_mv_next.open_accounts_mv.account_id_expanded
            │   ├── account_to_account_groups_mv_next.null:Varchar_expanded
            │   ├── account_to_account_groups_mv_next.null:Date_expanded
            │   ├── account_to_account_groups_mv_next.null:Int32_expanded
            │   ├── account_to_account_groups_mv_next.null:Varchar#1_expanded
            │   ├── account_to_account_groups_mv_next.null:Date#1_expanded
            │   ├── account_to_account_groups_mv_next.null:Varchar#2_expanded
            │   ├── account_to_account_groups_mv_next.null:Varchar#3_expanded
            │   ├── account_to_account_groups_mv_next.null:Varchar#4_expanded
            │   ├── account_to_account_groups_mv_next.$src_expanded
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id_expanded
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar_expanded
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Int32_expanded
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1_expanded
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.$src_expanded
            │   ├── account_to_account_groups_mv_next.account_group_id
            │   ├── account_to_account_groups_mv_next.base_currency
            │   ├── holding_values_latest_mv.type
            │   ├── holding_values_latest_mv.dim_value_date
            │   ├── $expr2
            │   ├── $expr3
            │   ├── $expr4
            │   ├── holding_values_latest_mv.market_value_system_currency
            │   ├── holding_values_latest_mv.fair_value_system_currency
            │   ├── holding_values_latest_mv.accrued_value_system_currency
            │   ├── $expr5
            │   ├── $expr6
            │   ├── $expr7
            │   ├── $expr8
            │   ├── holding_values_latest_mv.currency_code
            │   ├── holding_values_latest_mv.account_id
            │   ├── holding_values_latest_mv.asset_id
            │   ├── account_to_account_groups_mv_next.open_accounts_mv.account_id
            │   ├── account_to_account_groups_mv_next.null:Varchar
            │   ├── account_to_account_groups_mv_next.null:Date
            │   ├── account_to_account_groups_mv_next.null:Int32
            │   ├── account_to_account_groups_mv_next.null:Varchar#1
            │   ├── account_to_account_groups_mv_next.null:Date#1
            │   ├── account_to_account_groups_mv_next.null:Varchar#2
            │   ├── account_to_account_groups_mv_next.null:Varchar#3
            │   ├── account_to_account_groups_mv_next.null:Varchar#4
            │   ├── account_to_account_groups_mv_next.$src
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Int32
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.$src
            │   └── flag
            ├── stream key:
            │   ┌── account_to_account_groups_mv_next.account_group_id_expanded
            │   ├── account_to_account_groups_mv_next.base_currency_expanded
            │   ├── holding_values_latest_mv.type_expanded
            │   ├── flag
            │   ├── holding_values_latest_mv.currency_code
            │   ├── account_to_account_groups_mv_next.base_currency
            │   ├── holding_values_latest_mv.account_id
            │   ├── holding_values_latest_mv.asset_id
            │   ├── holding_values_latest_mv.type
            │   ├── account_to_account_groups_mv_next.account_group_id
            │   ├── account_to_account_groups_mv_next.open_accounts_mv.account_id
            │   ├── account_to_account_groups_mv_next.null:Varchar
            │   ├── account_to_account_groups_mv_next.null:Date
            │   ├── account_to_account_groups_mv_next.null:Int32
            │   ├── account_to_account_groups_mv_next.null:Varchar#1
            │   ├── account_to_account_groups_mv_next.null:Date#1
            │   ├── account_to_account_groups_mv_next.null:Varchar#2
            │   ├── account_to_account_groups_mv_next.null:Varchar#3
            │   ├── account_to_account_groups_mv_next.null:Varchar#4
            │   ├── account_to_account_groups_mv_next.$src
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Int32
            │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1
            │   └── account_to_account_groups_mv_next.account_groups_mv_next.$src
            └── MergeExecutor
                ├── output:
                │   ┌── account_to_account_groups_mv_next.account_group_id_expanded
                │   ├── account_to_account_groups_mv_next.base_currency_expanded
                │   ├── holding_values_latest_mv.type_expanded
                │   ├── holding_values_latest_mv.dim_value_date_expanded
                │   ├── $expr2_expanded
                │   ├── $expr3_expanded
                │   ├── $expr4_expanded
                │   ├── holding_values_latest_mv.market_value_system_currency_expanded
                │   ├── holding_values_latest_mv.fair_value_system_currency_expanded
                │   ├── holding_values_latest_mv.accrued_value_system_currency_expanded
                │   ├── $expr5_expanded
                │   ├── $expr6_expanded
                │   ├── $expr7_expanded
                │   ├── $expr8_expanded
                │   ├── holding_values_latest_mv.currency_code_expanded
                │   ├── holding_values_latest_mv.account_id_expanded
                │   ├── holding_values_latest_mv.asset_id_expanded
                │   ├── account_to_account_groups_mv_next.open_accounts_mv.account_id_expanded
                │   ├── account_to_account_groups_mv_next.null:Varchar_expanded
                │   ├── account_to_account_groups_mv_next.null:Date_expanded
                │   ├── account_to_account_groups_mv_next.null:Int32_expanded
                │   ├── account_to_account_groups_mv_next.null:Varchar#1_expanded
                │   ├── account_to_account_groups_mv_next.null:Date#1_expanded
                │   ├── account_to_account_groups_mv_next.null:Varchar#2_expanded
                │   ├── account_to_account_groups_mv_next.null:Varchar#3_expanded
                │   ├── account_to_account_groups_mv_next.null:Varchar#4_expanded
                │   ├── account_to_account_groups_mv_next.$src_expanded
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id_expanded
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar_expanded
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Int32_expanded
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1_expanded
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.$src_expanded
                │   ├── account_to_account_groups_mv_next.account_group_id
                │   ├── account_to_account_groups_mv_next.base_currency
                │   ├── holding_values_latest_mv.type
                │   ├── holding_values_latest_mv.dim_value_date
                │   ├── $expr2
                │   ├── $expr3
                │   ├── $expr4
                │   ├── holding_values_latest_mv.market_value_system_currency
                │   ├── holding_values_latest_mv.fair_value_system_currency
                │   ├── holding_values_latest_mv.accrued_value_system_currency
                │   ├── $expr5
                │   ├── $expr6
                │   ├── $expr7
                │   ├── $expr8
                │   ├── holding_values_latest_mv.currency_code
                │   ├── holding_values_latest_mv.account_id
                │   ├── holding_values_latest_mv.asset_id
                │   ├── account_to_account_groups_mv_next.open_accounts_mv.account_id
                │   ├── account_to_account_groups_mv_next.null:Varchar
                │   ├── account_to_account_groups_mv_next.null:Date
                │   ├── account_to_account_groups_mv_next.null:Int32
                │   ├── account_to_account_groups_mv_next.null:Varchar#1
                │   ├── account_to_account_groups_mv_next.null:Date#1
                │   ├── account_to_account_groups_mv_next.null:Varchar#2
                │   ├── account_to_account_groups_mv_next.null:Varchar#3
                │   ├── account_to_account_groups_mv_next.null:Varchar#4
                │   ├── account_to_account_groups_mv_next.$src
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Int32
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1
                │   ├── account_to_account_groups_mv_next.account_groups_mv_next.$src
                │   └── flag
                └── stream key:
                    ┌── holding_values_latest_mv.currency_code
                    ├── account_to_account_groups_mv_next.base_currency
                    ├── holding_values_latest_mv.account_id
                    ├── holding_values_latest_mv.asset_id
                    ├── holding_values_latest_mv.type
                    ├── account_to_account_groups_mv_next.account_group_id
                    ├── account_to_account_groups_mv_next.open_accounts_mv.account_id
                    ├── account_to_account_groups_mv_next.null:Varchar
                    ├── account_to_account_groups_mv_next.null:Date
                    ├── account_to_account_groups_mv_next.null:Int32
                    ├── account_to_account_groups_mv_next.null:Varchar#1
                    ├── account_to_account_groups_mv_next.null:Date#1
                    ├── account_to_account_groups_mv_next.null:Varchar#2
                    ├── account_to_account_groups_mv_next.null:Varchar#3
                    ├── account_to_account_groups_mv_next.null:Varchar#4
                    ├── account_to_account_groups_mv_next.$src
                    ├── account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id
                    ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar
                    ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Int32
                    ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1
                    ├── account_to_account_groups_mv_next.account_groups_mv_next.$src
                    └── flag

Fragment 61238 (Actor 738653,738652)
StreamExpand { column_subsets: [[account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.type], [account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency]] }
├── output:
│   ┌── account_to_account_groups_mv_next.account_group_id_expanded
│   ├── account_to_account_groups_mv_next.base_currency_expanded
│   ├── holding_values_latest_mv.type_expanded
│   ├── holding_values_latest_mv.dim_value_date_expanded
│   ├── $expr2_expanded
│   ├── $expr3_expanded
│   ├── $expr4_expanded
│   ├── holding_values_latest_mv.market_value_system_currency_expanded
│   ├── holding_values_latest_mv.fair_value_system_currency_expanded
│   ├── holding_values_latest_mv.accrued_value_system_currency_expanded
│   ├── $expr5_expanded
│   ├── $expr6_expanded
│   ├── $expr7_expanded
│   ├── $expr8_expanded
│   ├── holding_values_latest_mv.currency_code_expanded
│   ├── holding_values_latest_mv.account_id_expanded
│   ├── holding_values_latest_mv.asset_id_expanded
│   ├── account_to_account_groups_mv_next.open_accounts_mv.account_id_expanded
│   ├── account_to_account_groups_mv_next.null:Varchar_expanded
│   ├── account_to_account_groups_mv_next.null:Date_expanded
│   ├── account_to_account_groups_mv_next.null:Int32_expanded
│   ├── account_to_account_groups_mv_next.null:Varchar#1_expanded
│   ├── account_to_account_groups_mv_next.null:Date#1_expanded
│   ├── account_to_account_groups_mv_next.null:Varchar#2_expanded
│   ├── account_to_account_groups_mv_next.null:Varchar#3_expanded
│   ├── account_to_account_groups_mv_next.null:Varchar#4_expanded
│   ├── account_to_account_groups_mv_next.$src_expanded
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id_expanded
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar_expanded
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Int32_expanded
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1_expanded
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.$src_expanded
│   ├── account_to_account_groups_mv_next.account_group_id
│   ├── account_to_account_groups_mv_next.base_currency
│   ├── holding_values_latest_mv.type
│   ├── holding_values_latest_mv.dim_value_date
│   ├── $expr2
│   ├── $expr3
│   ├── $expr4
│   ├── holding_values_latest_mv.market_value_system_currency
│   ├── holding_values_latest_mv.fair_value_system_currency
│   ├── holding_values_latest_mv.accrued_value_system_currency
│   ├── $expr5
│   ├── $expr6
│   ├── $expr7
│   ├── $expr8
│   ├── holding_values_latest_mv.currency_code
│   ├── holding_values_latest_mv.account_id
│   ├── holding_values_latest_mv.asset_id
│   ├── account_to_account_groups_mv_next.open_accounts_mv.account_id
│   ├── account_to_account_groups_mv_next.null:Varchar
│   ├── account_to_account_groups_mv_next.null:Date
│   ├── account_to_account_groups_mv_next.null:Int32
│   ├── account_to_account_groups_mv_next.null:Varchar#1
│   ├── account_to_account_groups_mv_next.null:Date#1
│   ├── account_to_account_groups_mv_next.null:Varchar#2
│   ├── account_to_account_groups_mv_next.null:Varchar#3
│   ├── account_to_account_groups_mv_next.null:Varchar#4
│   ├── account_to_account_groups_mv_next.$src
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Int32
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1
│   ├── account_to_account_groups_mv_next.account_groups_mv_next.$src
│   └── flag
├── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, flag ]
└── StreamProject { exprs: [account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, (holding_values_latest_mv.market_value * $expr1) as $expr2, (holding_values_latest_mv.fair_value * $expr1) as $expr3, (holding_values_latest_mv.accrued_value * $expr1) as $expr4, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, (Abs(holding_values_latest_mv.market_value) * $expr1) as $expr5, (Abs(holding_values_latest_mv.fair_value) * $expr1) as $expr6, Abs(holding_values_latest_mv.market_value_system_currency) as $expr7, Abs(holding_values_latest_mv.fair_value_system_currency) as $expr8, holding_values_latest_mv.currency_code, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src] }
    ├── output: [ account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, $expr2, $expr3, $expr4, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, $expr5, $expr6, $expr7, $expr8, holding_values_latest_mv.currency_code, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    ├── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    └── StreamProject { exprs: [holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, fx_rates_snapshot_mv.rate, Coalesce(fx_rates_snapshot_mv.rate, Case((holding_values_latest_mv.currency_code = account_to_account_groups_mv_next.base_currency), 1:Int32, null:Int32)::Decimal) as $expr1, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src] }
        ├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, fx_rates_snapshot_mv.rate, $expr1, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
        ├── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
        └── StreamFilter { predicate: (Not(IsNull(fx_rates_snapshot_mv.rate)) OR (holding_values_latest_mv.currency_code = account_to_account_groups_mv_next.base_currency)) }
            ├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, fx_rates_snapshot_mv.rate, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, fx_rates_snapshot_mv.source_currency_code, fx_rates_snapshot_mv.target_currency_code ]
            ├── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
            └── MergeExecutor
                ├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, fx_rates_snapshot_mv.rate, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, fx_rates_snapshot_mv.source_currency_code, fx_rates_snapshot_mv.target_currency_code ]
                └── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]

Fragment 61239 (Actor 738654,738655)
StreamSyncLogStore
├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, fx_rates_snapshot_mv.rate, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, fx_rates_snapshot_mv.source_currency_code, fx_rates_snapshot_mv.target_currency_code ]
├── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
└── StreamHashJoin { type: LeftOuter, predicate: holding_values_latest_mv.currency_code = fx_rates_snapshot_mv.source_currency_code AND account_to_account_groups_mv_next.base_currency = fx_rates_snapshot_mv.target_currency_code }
    ├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, fx_rates_snapshot_mv.rate, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, fx_rates_snapshot_mv.source_currency_code, fx_rates_snapshot_mv.target_currency_code ]
    ├── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    ├── MergeExecutor
    │   ├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    │   └── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    └── MergeExecutor { output: [ fx_rates_snapshot_mv.source_currency_code, fx_rates_snapshot_mv.target_currency_code, fx_rates_snapshot_mv.rate ], stream key: [ fx_rates_snapshot_mv.source_currency_code, fx_rates_snapshot_mv.target_currency_code ] }

Fragment 61240 (Actor 738656,738657)
StreamLocalityProvider { locality_columns: [holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency] }
├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
├── stream key: [ holding_values_latest_mv.currency_code, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
└── MergeExecutor
    ├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    └── stream key: [ holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]

Fragment 61241 (Actor 738659,738658)
StreamSyncLogStore
├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
├── stream key: [ holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
└── StreamHashJoin { type: Inner, predicate: holding_values_latest_mv.account_id = account_to_account_groups_mv_next.account_id }
    ├── output: [ holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    ├── stream key: [ holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    ├── MergeExecutor { output: [ holding_values_latest_mv.account_id, holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, holding_values_latest_mv.asset_id ], stream key: [ holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type ] }
    └── MergeExecutor
        ├── output: [ account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
        └── stream key: [ account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]

Fragment 61242 (Actor 738661,738660)
StreamLocalityProvider { locality_columns: [holding_values_latest_mv.account_id] } { output: [ holding_values_latest_mv.account_id, holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, holding_values_latest_mv.asset_id ], stream key: [ holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type ] }
└── MergeExecutor { output: [ holding_values_latest_mv.account_id, holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, holding_values_latest_mv.asset_id ], stream key: [ holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type ] }

Fragment 61243 (Actor 738669,738668)
StreamTableScan { table: holding_values_latest_mv, columns: [account_id, type, dim_value_date, currency_code, market_value, fair_value, accrued_value, market_value_system_currency, fair_value_system_currency, accrued_value_system_currency, asset_id] } { output: [ holding_values_latest_mv.account_id, holding_values_latest_mv.type, holding_values_latest_mv.dim_value_date, holding_values_latest_mv.currency_code, holding_values_latest_mv.market_value, holding_values_latest_mv.fair_value, holding_values_latest_mv.accrued_value, holding_values_latest_mv.market_value_system_currency, holding_values_latest_mv.fair_value_system_currency, holding_values_latest_mv.accrued_value_system_currency, holding_values_latest_mv.asset_id ], stream key: [ holding_values_latest_mv.account_id, holding_values_latest_mv.asset_id, holding_values_latest_mv.type ] }
├── Upstream { output: [ account_id, type, dim_value_date, currency_code, market_value, fair_value, accrued_value, market_value_system_currency, fair_value_system_currency, accrued_value_system_currency, asset_id ], stream key: [] }
└── BatchPlanNode { output: [ account_id, type, dim_value_date, currency_code, market_value, fair_value, accrued_value, market_value_system_currency, fair_value_system_currency, accrued_value_system_currency, asset_id ], stream key: [] }

Fragment 61244 (Actor 738666,738667)
StreamLocalityProvider { locality_columns: [account_to_account_groups_mv_next.account_id] }
├── output: [ account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
├── stream key: [ account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
└── MergeExecutor
    ├── output: [ account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    └── stream key: [ account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]

Fragment 61245 (Actor 738671,738670)
StreamProject { exprs: [account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src] }
├── output: [ account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
├── stream key: [ account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
└── StreamFilter { predicate: IsNull(account_to_account_groups_mv_next.effective_end_date) AND (account_to_account_groups_mv_next.source_entity_type <> 'user':Varchar) }
    ├── output: [ account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, account_to_account_groups_mv_next.effective_end_date, account_to_account_groups_mv_next.source_entity_type ]
    ├── stream key: [ account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
    └── StreamTableScan { table: account_to_account_groups_mv_next, columns: [account_id, account_group_id, base_currency, open_accounts_mv.account_id, null:Varchar, null:Date, null:Int32, null:Varchar#1, null:Date#1, null:Varchar#2, null:Varchar#3, null:Varchar#4, $src, account_groups_mv_next.open_accounts_mv.account_id, account_groups_mv_next.null:Varchar, account_groups_mv_next.null:Int32, account_groups_mv_next.null:Varchar#1, account_groups_mv_next.$src, effective_end_date, source_entity_type] }
        ├── output: [ account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.base_currency, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src, account_to_account_groups_mv_next.effective_end_date, account_to_account_groups_mv_next.source_entity_type ]
        ├── stream key: [ account_to_account_groups_mv_next.account_group_id, account_to_account_groups_mv_next.account_id, account_to_account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.null:Date, account_to_account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.null:Date#1, account_to_account_groups_mv_next.null:Varchar#2, account_to_account_groups_mv_next.null:Varchar#3, account_to_account_groups_mv_next.null:Varchar#4, account_to_account_groups_mv_next.$src, account_to_account_groups_mv_next.account_groups_mv_next.open_accounts_mv.account_id, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar, account_to_account_groups_mv_next.account_groups_mv_next.null:Int32, account_to_account_groups_mv_next.account_groups_mv_next.null:Varchar#1, account_to_account_groups_mv_next.account_groups_mv_next.$src ]
        ├── Upstream { output: [ account_id, account_group_id, base_currency, open_accounts_mv.account_id, null:Varchar, null:Date, null:Int32, null:Varchar#1, null:Date#1, null:Varchar#2, null:Varchar#3, null:Varchar#4, $src, account_groups_mv_next.open_accounts_mv.account_id, account_groups_mv_next.null:Varchar, account_groups_mv_next.null:Int32, account_groups_mv_next.null:Varchar#1, account_groups_mv_next.$src, effective_end_date, source_entity_type ], stream key: [] }
        └── BatchPlanNode { output: [ account_id, account_group_id, base_currency, open_accounts_mv.account_id, null:Varchar, null:Date, null:Int32, null:Varchar#1, null:Date#1, null:Varchar#2, null:Varchar#3, null:Varchar#4, $src, account_groups_mv_next.open_accounts_mv.account_id, account_groups_mv_next.null:Varchar, account_groups_mv_next.null:Int32, account_groups_mv_next.null:Varchar#1, account_groups_mv_next.$src, effective_end_date, source_entity_type ], stream key: [] }

Fragment 61246 (Actor 738676,738677)
StreamTableScan { table: fx_rates_snapshot_mv, columns: [source_currency_code, target_currency_code, rate] } { output: [ fx_rates_snapshot_mv.source_currency_code, fx_rates_snapshot_mv.target_currency_code, fx_rates_snapshot_mv.rate ], stream key: [ fx_rates_snapshot_mv.source_currency_code, fx_rates_snapshot_mv.target_currency_code ] }
├── Upstream { output: [ source_currency_code, target_currency_code, rate ], stream key: [] }
└── BatchPlanNode { output: [ source_currency_code, target_currency_code, rate ], stream key: [] }
RWM Console cluster: risingwave-alinma.alinma-rw.svc.cluster.local
