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

← cluster search objects olap_reference_identifier_terms_mv
Overview Objects Graph History
materialized view · search.olap_reference_identifier_terms_mv Explain plan ▶
Parallelism
2
Actors
2 / 2
running
Distribution
HASH
Rows
124
State size
13.8 KiB
Created
2026-08-11 21:27
Initialized
2026-08-11 21:27
Fragment flags
MVIEWSNAPSHOT_BACKFILL_STREAM_SCANSTREAM_SCAN
Actors
ActorFragmentWorkerState
156795 12443 33 running
156796 12443 33 running
sql · search.olap_reference_identifier_terms_mv — click to expand 
CREATE MATERIALIZED VIEW search.olap_reference_identifier_terms_mv AS
SELECT
  ri.entity_id AS owner_entity_id,
  ri.entity_type AS owner_entity_type,
  u.val,
  u.val AS ar_val
FROM olap.reference_identifiers AS ri
CROSS JOIN UNNEST(ARRAY[ri.value, REPLACE(ri.value, '-', '')]) AS u(val)
WHERE
  ri.entity_type IN ('account', 'client', 'portfolio')
Lineage · search.olap_reference_identifier_terms_mv 4 objects
Direct (1-hop) dependencies from rw_depend, across schemas. Click a neighbor to expand its dependencies; ⌘/Ctrl-click opens its page. Drag to pan, scroll to zoom. External source/sink endpoints (Kafka, Iceberg) are not shown.