[jira] [Updated] (HIVE-2709) Semantic Analysis failed for GroupBy query with aliase.
[ 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
[jira] [Updated] (HIVE-2709) Semantic Analysis failed for GroupBy query with aliase.
[ 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
[jira] [Updated] (HIVE-2709) Semantic Analysis failed for GroupBy query with aliase.
[ https://issues.apache.org/jira/browse/HIVE-2709?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Navis updated HIVE-2709: Attachment: HIVE-2709.1.patch.txt Hive does not search column properly if row resolver of previous operator is expressional (rs or gby). If some equivalent logic is added, this issue could be resolved. Attached patch is just a simple scratch. > 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 > > > 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
