hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "caofangkun (Created) (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-2723) should throw "Ambiguous column reference key" Exception in particular join condition
Date Tue, 17 Jan 2012 03:16:51 GMT
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
    Affects Versions: 0.8.0
         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
            Priority: Minor
             Fix For: 0.9.0


This Bug can be Repeated as following :

create table test(key string, value string);
create table test1(key string, value string);

1: Correct!
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


2: Uncorrect!! Should throw Exception as above too!
select t.key --Is this a.key or b.key ? It's ambiduous!
from 
  (select a.*, b.* from (select * from src ) a right outer join (select * from src1) b on
(a.value = b.value)) 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_201201170959_0004, Tracking URL = http://zongren-VirtualBox:50030/jobdetails.jsp?jobid=job_201201170959_0004
Kill Command = /home/zongren/workspace/hadoop-adh/bin/hadoop job  -Dmapred.job.tracker=zongren-VirtualBox:9001
-kill job_201201170959_0004
Hadoop job information for Stage-1: number of mappers: 2; number of reducers: 1
2012-01-17 11:02:47,507 Stage-1 map = 0%,  reduce = 0%
2012-01-17 11:02:55,002 Stage-1 map = 100%,  reduce = 0%
2012-01-17 11:03:04,240 Stage-1 map = 100%,  reduce = 33%
2012-01-17 11:03:05,258 Stage-1 map = 100%,  reduce = 100%
Ended Job = job_201201170959_0004
MapReduce Jobs Launched: 
Job 0: Map: 2  Reduce: 1   HDFS Read: 669 HDFS Write: 216 SUCESS
Total MapReduce CPU Time Spent: 0 msec
OK



--
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

        

Mime
View raw message