[ 
https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Phabricator updated HIVE-2723:
------------------------------

    Attachment: HIVE-2723.D1275.1.patch

navis requested code review of "HIVE-2723 [jira] should throw  "Ambiguous 
column reference key"  Exception in particular join condition".
Reviewers: JIRA

  DPAL-638 Does not throw "Ambiguous column reference key" exception in sub 
query with select star/pattern

  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

TEST PLAN
  EMPTY

REVISION DETAIL
  https://reviews.facebook.net/D1275

AFFECTED FILES
  ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
  ql/src/test/queries/clientnegative/ambiguous_col_patterned.q
  ql/src/test/results/clientnegative/ambiguous_col_patterned.q.out

MANAGE HERALD DIFFERENTIAL RULES
  https://reviews.facebook.net/herald/view/differential/

WHY DID I GET THIS EMAIL?
  https://reviews.facebook.net/herald/transcript/2673/

Tip: use the X-Herald-Rules header to filter Herald messages in your client.

                
> 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
>              Labels: exception-handling, query, queryparser
>             Fix For: 0.9.0
>
>         Attachments: HIVE-2723.D1275.1.patch
>
>
> 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

        

Reply via email to