我想使用带有case和when的配置单元编写查询。
SELECT CASE WHEN home_score > away_score THEN away_team
WHEN home_score < away_score THEN home_team
END AS year_group,
COUNT(1) AS count
FROM matches
GROUP BY year_group
ORDER BY count desc
limit 5;
但这在Hive里不起作用。请帮我解决这个问题。
1条答案
按热度按时间4nkexdtk1#
通过以下方式将案例添加到组: