You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "kalyan ram (Commented) (JIRA)" <ji...@apache.org> on 2011/10/18 15:08:10 UTC
[jira] [Commented] (HIVE-2507) Self join fails
[ 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