[
https://issues.apache.org/jira/browse/HIVE-2709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Phabricator updated HIVE-2709:
------------------------------
Attachment: HIVE-2709.D1305.1.patch
navis requested code review of "HIVE-2709 [jira] Semantic Analysis failed for
GroupBy query with aliase.".
Reviewers: JIRA
DPAL-625 Semantic Analysis failed for GroupBy query with aliase
In the SQL ,
"select empno from test t group by t.empno"
type of query work fine where as in hive ,below exception
"org.apache.hadoop.hive.ql.parse.SemanticException: line 1:7 Expression Not
In Group By Key ename".
For the above, column_name with aliase work fine i.e
"select t.empno from test t group by t.empno" is work fine.
TEST PLAN
EMPTY
REVISION DETAIL
https://reviews.facebook.net/D1305
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/parse/ExprRowResolver.java
ql/src/java/org/apache/hadoop/hive/ql/parse/RowResolver.java
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
ql/src/java/org/apache/hadoop/hive/ql/parse/TypeCheckProcFactory.java
ql/src/test/queries/clientpositive/groupby_alias.q
ql/src/test/results/clientpositive/groupby_alias.q.out
MANAGE HERALD DIFFERENTIAL RULES
https://reviews.facebook.net/herald/view/differential/
WHY DID I GET THIS EMAIL?
https://reviews.facebook.net/herald/transcript/2709/
Tip: use the X-Herald-Rules header to filter Herald messages in your client.
> Semantic Analysis failed for GroupBy query with aliase.
> -------------------------------------------------------
>
> Key: HIVE-2709
> URL: https://issues.apache.org/jira/browse/HIVE-2709
> Project: Hive
> Issue Type: Bug
> Components: SQL
> Affects Versions: 0.8.0
> Environment: SuSE11 SP1
> Reporter: rohithsharma
> Priority: Minor
> Attachments: HIVE-2709.1.patch.txt, HIVE-2709.D1305.1.patch
>
>
> In the SQL ,
> "select empno from test t group by t.empno"
> type of query work fine where as in hive ,below exception
> "org.apache.hadoop.hive.ql.parse.SemanticException: line 1:7 Expression Not
> In Group By Key ename".
> For the above, column_name with aliase work fine i.e
> "select t.empno from test t group by t.empno" is work fine.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
