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
