20250128

• • 实践使用Hive进行数据离线分析。
  • 存储分析结果。

   

  -- 创建分析表
  CREATE TABLE IF NOT EXISTS hot_words_analysis AS
  SELECT word, SUM(frequency) AS total_frequency
  FROM hot_words
  GROUP BY word
  ORDER BY total_frequency DESC;
  
  -- 查询分析结果
  SELECT * FROM hot_words_analysis LIMIT 10;