should throw semantic error if subquery has duplicate columns name

[曹坤 <ca...@gmail.com>]

I find a bug today.
Does anybody come across this ?

hive> desc src;
OK
key string
value string
Time taken: 0.314 seconds

hive> desc src1;
OK
key string
value string
Time taken: 0.112 seconds

hive> select t.key
    > from
    > (select a.key, b.key from (select * from src ) a right  outer join
(select *  from src1) b on (a.key = b.key)) t;

FAILED: Error in semantic analysis: Ambiguous column reference key


The query below should throw FAILED: Error in semantic analysis: Ambiguous
column reference key.

hive> select t.key
    > from
    > (select a.*, b.* from (select * from src ) a right  outer join
(select *  from src1) b on (a.key = b.key)) t;

Total MapReduce jobs = 1
Launching Job 1 out of 1
Number of reduce tasks not specified. Defaulting to jobconf value of: 1
In order to change the average load for a reducer (in bytes):
  set hive.exec.reducers.bytes.per.reducer=<number>
In order to limit the maximum number of reducers:
  set hive.exec.reducers.max=<number>
In order to set a constant number of reducers:
  set mapred.reduce.tasks=<number>
Starting Job = job_201201100909_0007, Tracking URL =
http://zongren-VirtualBox:50030/jobdetails.jsp?jobid=job_201201100909_0007
Kill Command = /home/zongren/workspace/hadoop-adh/bin/hadoop job
 -Dmapred.job.tracker=zongren-VirtualBox:9001 -kill job_201201100909_0007
Hadoop job information for Stage-1: number of mappers: 2; number of
reducers: 1
2012-01-10 20:00:03,667 Stage-1 map = 0%,  reduce = 0%
2012-01-10 20:00:06,741 Stage-1 map = 100%,  reduce = 0%
2012-01-10 20:00:14,926 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201201100909_0007
MapReduce Jobs Launched:
Job 0: Map: 2  Reduce: 1   HDFS Read: 669 HDFS Write: 68 SUCESS
Total MapReduce CPU Time Spent: 0 msec
OK