hadoop - hql查询报错

Question

我尝试在 hql 中执行此查询

SELECT
  t.retweeted_screen_name,
  sum(retweets) AS total_retweets,
  count(*) AS tweet_count
FROM (SELECT
        retweeted_status.user.screen_name as retweeted_screen_name,
         retweeted_status.text,
         max(retweet_count) as retweets
      FROM tweets
      GROUP BY retweeted_status.user.screen_name,
               retweeted_status.text) t
GROUP BY t.retweeted_screen_name
ORDER BY total_retweets DESC
LIMIT 10;

但是我收到了这个错误:

Error while processing statement: FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

谁能帮我解决这个问题？

Answer 1

我认为你需要写 sum(t.retweets) AS total_retweets，而不是 sum(retweets) AS total_retweets，