[
https://issues.apache.org/jira/browse/HIVE-18345?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
kai updated HIVE-18345:
-----------------------
Description:
Hive gives the error message - _Expression not in GROUP BY key_ if a column
which is not present in GBY clause is projected without aggregation.
{code:java}
// Some comments here
public String getFoo()
{
return foo;
}
{code}
Example:
{code:sql}
Select x,y from A group by y;
FAILED: SemanticException Error 10025: Line 1:7 Expression not in GROUP BY key
'x'
{code}
But, in case of a subquery, the error message is misleading.
{code:sql}
CREATE TABLE A(x int, y int);
Select a.x, a.y from (select x, y from A) as a group by a.y;
FAILED: SemanticException Error 10002: Line 1:9 Invalid column reference 'x'
{code}
was:
Hive gives the error message - _Expression not in GROUP BY key_ if a column
which is not present in GBY clause is projected without aggregation.
Example:
{code:sql}
Select x,y from A group by y;
FAILED: SemanticException Error 10025: Line 1:7 Expression not in GROUP BY key
'x'
{code}
But, in case of a subquery, the error message is misleading.
{code:sql}
CREATE TABLE A(x int, y int);
Select a.x, a.y from (select x, y from A) as a group by a.y;
FAILED: SemanticException Error 10002: Line 1:9 Invalid column reference 'x'
{code}
> Incorrect Error Message when column is not present in GroupBy clause
> --------------------------------------------------------------------
>
> Key: HIVE-18345
> URL: https://issues.apache.org/jira/browse/HIVE-18345
> Project: Hive
> Issue Type: Improvement
> Components: Query Planning
> Affects Versions: 2.1.0
> Reporter: Nitin Khandelwal
> Priority: Minor
>
> Hive gives the error message - _Expression not in GROUP BY key_ if a column
> which is not present in GBY clause is projected without aggregation.
> {code:java}
> // Some comments here
> public String getFoo()
> {
> return foo;
> }
> {code}
> Example:
> {code:sql}
> Select x,y from A group by y;
> FAILED: SemanticException Error 10025: Line 1:7 Expression not in GROUP BY
> key 'x'
> {code}
> But, in case of a subquery, the error message is misleading.
> {code:sql}
> CREATE TABLE A(x int, y int);
> Select a.x, a.y from (select x, y from A) as a group by a.y;
> FAILED: SemanticException Error 10002: Line 1:9 Invalid column reference 'x'
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
