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

CREATE MATERIALIZED VIEW search.party_items_mv AS
SELECT
  p.id AS entity_id,
  'party' AS entity_type,
  u.val,
  u.val AS ar_val,
  CAST(NULL AS VARCHAR) AS filter_val
FROM search.active_parties_mv AS p
CROSS JOIN UNNEST(ARRAY[p.id, REPLACE(p.id, '-', ''), p.display_name, REPLACE(p.display_name, '-', '')]) AS u(val)
UNION ALL
SELECT
  ft.entity_id,
  'party',
  CAST(NULL AS VARCHAR),
  CAST(NULL AS VARCHAR),
  ft.filter_val
FROM search.party_filter_tags_mv AS ft
UNION ALL
SELECT
  cp.id,
  'party',
  t.val,
  t.ar_val,
  CAST(NULL AS VARCHAR)
FROM search.party_customer_parties_mv AS cp
JOIN search.party_reference_identifier_terms_mv AS t
  ON t.owner_entity_id = cp.id AND t.owner_entity_type = 'party'
UNION ALL
SELECT
  e.target_entity_id,
  e.target_entity_type,
  t.val,
  t.ar_val,
  CAST(NULL AS VARCHAR)
FROM search.active_identifier_edges_mv AS e
JOIN search.olap_reference_identifier_terms_mv AS t
  ON t.owner_entity_id = e.owner_entity_id
  AND t.owner_entity_type = e.owner_entity_type
WHERE
  e.target_entity_type = 'party'