You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "rohithsharma (Created) (JIRA)" <ji...@apache.org> on 2012/01/11 09:56:39 UTC
[jira] [Created] (HIVE-2709) Semantic Analysis failed for GroupBy
query with aliase.
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
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.
Posted by "Phabricator (Updated) (JIRA)" <ji...@apache.org>.
[ 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] [Commented] (HIVE-2709) Semantic Analysis failed for GroupBy
query with aliase.
Posted by "Phabricator (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2709?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13188246#comment-13188246 ]
Phabricator commented on HIVE-2709:
-----------------------------------
navis has commented on the revision "HIVE-2709 [jira] Semantic Analysis failed for GroupBy query with aliase.".
Resolves HIVE-695, HIVE-1449, HIVE-2348, HIVE-2709
REVISION DETAIL
https://reviews.facebook.net/D1305
> 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.
Posted by "Navis (Updated) (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Updated] (HIVE-2709) Semantic Analysis failed for GroupBy
query with aliase.
Posted by "Phabricator (Updated) (JIRA)" <ji...@apache.org>.
[ 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