groupby子句，在case中以hiveql结尾

owfi6suc 于 2021-06-28 发布在 Hive

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

我在成功运行查询时遇到问题

select session from (select F_SESSION as session       
                     FROM T_TEMP GROUP BY F_SESSION  ) a ;

以上运行成功。然而，下面的一个失败了

select session, count(total) from (select F_SESSION as session,                     
                   case when F_RECORDED_VALUE != 0 then F_RECORDED_VALUE end as total   FROM T_TEMP GROUP BY F_SESSION  ) a ;

错误是

FAILED: SemanticException [Error 10025]: Line 4:30 Expression not in GROUP BY key '0'

有人能告诉我哪里出了问题吗？

Hive hiveql

来源：https://stackoverflow.com/questions/38865923/group-by-clause-in-case-then-end-in-hiveql

1条答案

按热度按时间

piwo6bdm1#

select session, count(total) from (select F_SESSION as session,                     
  case when F_RECORDED_VALUE != 0 then F_RECORDED_VALUE end as total FROM T_TEMP ) a
group by session;

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

我来回答

groupby子句，在case中以hiveql结尾

1条答案

相关问题

热门标签

最新问答