[
https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13527350#comment-13527350
]
Namit Jain commented on HIVE-2723:
----------------------------------
I will let Navis confirm, but the output columns from the sub-query have the
same name.
select * from (select * from src) a join (select * from src1) b on (a.key =
b.key)
This will return a.key, a.value, b.key, b.value with column names key, value,
key, value respectively.
> should throw "Ambiguous column reference key" Exception in particular join
> condition
> --------------------------------------------------------------------------------------
>
> Key: HIVE-2723
> URL: https://issues.apache.org/jira/browse/HIVE-2723
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Environment: Linux zongren-VirtualBox 3.0.0-14-generic #23-Ubuntu SMP
> Mon Nov 21 20:34:47 UTC 2011 i686 i686 i386 GNU/Linux
> java version "1.6.0_25"
> hadoop-0.20.2-cdh3u0
> hive-0.7.0-cdh3u0
> Reporter: caofangkun
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch,
> ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, hive.2723.1.patch,
> HIVE-2723.D1275.3.patch
>
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
