配置单元查询状态时的大小写

vptzau2j 于 2021-06-24 发布在 Hive

关注(0)|答案(1)|浏览(276)

我想使用带有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里不起作用。请帮我解决这个问题。

sql Hive hiveql case

来源：https://stackoverflow.com/questions/65517439/hive-query-case-when-status

1条答案

按热度按时间

4nkexdtk1#

通过以下方式将案例添加到组：

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 cnt
  FROM matches 
GROUP BY CASE WHEN home_score > away_score THEN away_team 
              WHEN home_score < away_score THEN home_team  
         END
ORDER BY cnt desc 
limit 5;

赞(0）回复(0）举报 2021-06-24

我来回答

配置单元查询状态时的大小写

1条答案

相关问题

热门标签

最新问答