| Actor | Fragment | Worker | State |
|---|---|---|---|
| 739523 | 61589 | 51 | running |
| 739524 | 61589 | 51 | running |
| 739531 | 61590 | 51 | running |
| 739532 | 61590 | 51 | running |
| 739533 | 61591 | 51 | running |
| 739534 | 61591 | 51 | running |
| 739535 | 61592 | 51 | running |
| 739536 | 61592 | 51 | running |
| 739537 | 61593 | 51 | running |
| 739538 | 61593 | 51 | running |
| 739543 | 61594 | 51 | running |
| 739544 | 61594 | 51 | running |
CREATE MATERIALIZED VIEW alinma_bff.client_fee_totals_mv AS SELECT cag.client_id, cag.type AS account_group_type, SUM(fv.net_value_group) AS total_fees, SUM(CASE WHEN ft.fee_type = 'TRANSACTIONAL' THEN fv.net_value_group ELSE 0 END) AS transactional_fees, SUM(CASE WHEN ft.fee_type = 'NON_TRANSACTIONAL' THEN fv.net_value_group ELSE 0 END) AS non_transactional_fees, SUM(fv.net_value_system) AS total_fees_system_currency, SUM(CASE WHEN ft.fee_type = 'TRANSACTIONAL' THEN fv.net_value_system ELSE 0 END) AS transactional_fees_system_currency, SUM(CASE WHEN ft.fee_type = 'NON_TRANSACTIONAL' THEN fv.net_value_system ELSE 0 END) AS non_transactional_fees_system_currency FROM insights.flow_values_mv AS fv JOIN olap.fee_transactions_dm AS ft ON ft.transaction_id = fv.transaction_id JOIN insights.client_to_account_groups_mv AS cag ON cag.account_group_id = fv.account_group_id WHERE fv.transaction_type = 'FEE' AND fv.position_type = 'POSITION' GROUP BY cag.client_id, cag.type