You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (Created) (JIRA)" <ji...@apache.org> on 2011/10/18 11:50:10 UTC
[jira] [Created] (HIVE-2507) Self join fails
Self join fails
---------------
Key: HIVE-2507
URL: https://issues.apache.org/jira/browse/HIVE-2507
Project: Hive
Issue Type: Bug
Components: Query Processor
Reporter: Ashutosh Chauhan
{code}
hive> create table src (key string, value string);
OK
Time taken: 0.096 seconds
hive> select * from src join src on (src.key == src.key);
FAILED: Error in semantic analysis: Line 1:23 Ambiguous table alias 'src'
{code}
--
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] [Resolved] (HIVE-2507) Self join fails
Posted by "John Sichi (Resolved) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2507?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John Sichi resolved HIVE-2507.
------------------------------
Resolution: Not A Problem
What kalyan said.
> Self join fails
> ---------------
>
> Key: HIVE-2507
> URL: https://issues.apache.org/jira/browse/HIVE-2507
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Ashutosh Chauhan
>
> {code}
> hive> create table src (key string, value string);
> OK
> Time taken: 0.096 seconds
> hive> select * from src join src on (src.key == src.key);
> FAILED: Error in semantic analysis: Line 1:23 Ambiguous table alias 'src'
> {code}
--
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-2507) Self join fails
Posted by "kalyan ram (Commented) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2507?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13129707#comment-13129707 ]
kalyan ram commented on HIVE-2507:
----------------------------------
Isn't it an alias issue ? The src.key can't be resolved. The below one works.
select * from src s1 join src s2 on (s1.key == s2.key);
> Self join fails
> ---------------
>
> Key: HIVE-2507
> URL: https://issues.apache.org/jira/browse/HIVE-2507
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Ashutosh Chauhan
>
> {code}
> hive> create table src (key string, value string);
> OK
> Time taken: 0.096 seconds
> hive> select * from src join src on (src.key == src.key);
> FAILED: Error in semantic analysis: Line 1:23 Ambiguous table alias 'src'
> {code}
--
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