我无法成功运行查询
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'
有人可以指出我要去哪里了吗?
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;
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句