You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by Navis Ryu <na...@nexr.com> on 2014/10/20 11:14:33 UTC
Re: Review Request 25628: alias of compound aggregation functions
fails in having clause
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/25628/
-----------------------------------------------------------
(Updated Oct. 20, 2014, 9:14 a.m.)
Review request for hive.
Changes
-------
Rebased to trunk
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 (updated)
-----
ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java 02c4be9
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 1b7a41d
ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckCtx.java 3b6178f
ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java e065983
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
Re: Review Request 25628: alias of compound aggregation functions
fails in having clause
Posted by Navis Ryu <na...@nexr.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/25628/
-----------------------------------------------------------
(Updated Dec. 12, 2014, 7:57 a.m.)
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 (updated)
-----
ql/src/java/org/apache/hadoop/hive/ql/parse/QBParseInfo.java 02c4be9
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 6f44f9c
ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckCtx.java b19e2bf
ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java bd610d9
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