[ 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.2.patch navis updated the revision "HIVE-2709 [jira] Semantic Analysis failed for GroupBy query with aliase.". Reviewers: JIRA support searching table.column from column name move notable_alias3 to positive 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/queries/clientpositive/notable_alias3.q ql/src/test/queries/clientnegative/notable_alias3.q ql/src/test/results/clientpositive/groupby_alias.q.out ql/src/test/results/clientpositive/notable_alias3.q.out > 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, > HIVE-2709.D1305.2.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