In RisingWave, create a materialized view that offers insights into user behavior on different pages for analyzing website traffic and engagement.
Copy
Ask AI
CREATE MATERIALIZED VIEW visits_stream_mv ASSELECT page_id,count(*) AS total_visits,count(DISTINCT user_id) AS unique_visitors,max(timestamp) AS last_visit_timeFROM website_visits_streamGROUP BY page_id;