hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Richard Ding (JIRA)" <>
Subject [jira] [Commented] (HIVE-3107) More semantic analysis errors
Date Mon, 11 Jun 2012 16:40:43 GMT


Richard Ding commented on HIVE-3107:

FAILED: Error in semantic analysis: Line 1:15 Expression not in GROUP BY key 'c'
12/06/11 09:36:56 ERROR ql.Driver: FAILED: Error in semantic analysis: Line 1:15 Expression
not in GROUP BY key 'c'
org.apache.hadoop.hive.ql.parse.SemanticException: Line 1:15 Expression not in GROUP BY key
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genExprNodeDesc(
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genSelectPlan(
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genSelectPlan(
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genBodyPlan(
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.genPlan(
	at org.apache.hadoop.hive.ql.parse.SemanticAnalyzer.analyzeInternal(
	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(
	at org.apache.hadoop.hive.ql.parse.ExplainSemanticAnalyzer.analyzeInternal(
	at org.apache.hadoop.hive.ql.parse.BaseSemanticAnalyzer.analyze(
	at org.apache.hadoop.hive.ql.Driver.compile(
	at org.apache.hadoop.hive.ql.Driver.compile(
	at org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(
	at org.apache.hadoop.hive.cli.CliDriver.processCmd(
	at org.apache.hadoop.hive.cli.CliDriver.processLine(
	at org.apache.hadoop.hive.cli.CliDriver.main(
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(
	at java.lang.reflect.Method.invoke(
	at org.apache.hadoop.util.RunJar.main(
> More semantic analysis errors
> -----------------------------
>                 Key: HIVE-3107
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.9.0
>            Reporter: Richard Ding
> This is related to HIVE-1922.
> Following queries all fail with various SemanticExceptions:
> {code}
> explain select t.c from t group by c;
> explain select t.c from t group by c sort by t.c; 
> explain select t.c as c0 from t group by c0;
> explain select t.c from t group by t.c sort by t.c; 
> {code}
> It is true that one could always find a version of any of above queries that works. But
one has to try to find out and it doesn't work well with machine generated SQL queries.

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:!default.jspa
For more information on JIRA, see:


View raw message