You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "eyal gruss (JIRA)" <ji...@apache.org> on 2014/09/04 15:52:52 UTC
[jira] [Created] (HIVE-7981) alias of compound aggregation
functions fails in having clause
eyal gruss created HIVE-7981:
--------------------------------
Summary: alias of compound aggregation functions fails in having clause
Key: HIVE-7981
URL: https://issues.apache.org/jira/browse/HIVE-7981
Project: Hive
Issue Type: Bug
Affects Versions: 0.13.0
Reporter: eyal gruss
Priority: Minor
hive> select max(time)-min(time) as span from mytable group by name having span>0;
FAILED: SemanticException [Error 10025]: Line 1:92 Expression not in GROUP BY key '0'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)