| Actor | Fragment | Worker | State |
|---|---|---|---|
| 743673 | 63932 | 51 | running |
| 743674 | 63932 | 51 | running |
| 743731 | 63941 | 51 | running |
| 743732 | 63941 | 51 | running |
| 746908 | 63934 | 51 | running |
| 746909 | 63934 | 51 | running |
| 746910 | 63933 | 51 | running |
| 746911 | 63933 | 51 | running |
| 746912 | 63935 | 51 | running |
| 746913 | 63935 | 51 | running |
| 746914 | 63936 | 51 | running |
| 746915 | 63936 | 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