hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Navis Ryu" <navis....@nexr.com>
Subject Review Request 25628: alias of compound aggregation functions fails in having clause
Date Mon, 15 Sep 2014 01:43:56 GMT

-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/25628/
-----------------------------------------------------------

Review request for hive.


Bugs: HIVE-7981
    https://issues.apache.org/jira/browse/HIVE-7981


Repository: hive-git


Description
-------

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'


Diffs
-----

  ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java 86e4602 
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 392f7ce 
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckCtx.java a95ae20 
  ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java e44f5ae 
  ql/src/test/queries/clientpositive/having3.q PRE-CREATION 
  ql/src/test/results/clientpositive/having3.q.out PRE-CREATION 

Diff: https://reviews.apache.org/r/25628/diff/


Testing
-------


Thanks,

Navis Ryu


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message