Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@hive.apache.org
Received-SPF: pass (athena.apache.org: domain of caofangkun@gmail.com
 designates 209.85.160.48 as permitted sender)
MIME-Version: 1.0
Date: Tue, 10 Jan 2012 20:15:51 +0800
Message-ID: 
 <CALnhseUfzY=feU3wBoUZEbNDfkTH_0tR8dbNX=i46j1bOLTyHQ@mail.gmail.com>
Subject: should throw semantic error if subquery has duplicate columns name
From: =?GB2312?B?stzApA==?= <caofangkun@gmail.com>
To: hive-dev@hadoop.apache.org
Content-Type: multipart/alternative; boundary=e89a8f6470b9e73b4904b62b7986

--e89a8f6470b9e73b4904b62b7986
Content-Type: text/plain; charset=ISO-8859-1

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

--e89a8f6470b9e73b4904b62b7986--