hive 计算次日留存率代码

hive中计算次日留存率的代码可能长这样:

WITH temp_table AS (
  SELECT 
    date, 
    user_id, 
    COUNT(DISTINCT event_name) AS event_count 
  FROM 
    events 
  WHERE 
    event_name = 'register' 
  GROUP BY 
    date, user_id
)

SELECT 
  retention_date, 
  retention_count / total_count as retention_rate 
FR