You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "caofangkun (Created) (JIRA)" <ji...@apache.org> on 2012/01/17 04:16:51 UTC
[jira] [Created] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
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
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Phabricator (Updated) (JIRA)" <ji...@apache.org>.
[ 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
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Phabricator (Updated) (JIRA)" <ji...@apache.org>.
[ 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.2.patch
navis updated the revision "HIVE-2723 [jira] should throw "Ambiguous column reference key" Exception in particular join condition".
Reviewers: JIRA
1. Added test cases
2. Avoid throwing exception if it's possible
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_col0.q
ql/src/test/queries/clientnegative/ambiguous_col1.q
ql/src/test/queries/clientnegative/ambiguous_col2.q
ql/src/test/queries/clientpositive/ambiguous_col.q
ql/src/test/results/clientnegative/ambiguous_col0.q.out
ql/src/test/results/clientnegative/ambiguous_col1.q.out
ql/src/test/results/clientnegative/ambiguous_col2.q.out
ql/src/test/results/clientnegative/ambiguous_col_patterned.q.out
ql/src/test/results/clientpositive/ambiguous_col.q.out
> 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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Fix For: 0.9.0
>
> Attachments: HIVE-2723.D1275.1.patch, HIVE-2723.D1275.2.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
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2723:
---------------------------------
Status: Open (was: Patch Available)
@Navis: Looks like this patch almost applies cleanly except for one small reject in SemanticAnalyzer.java. Would you be willing to rebase this patch and submit it for review? Thanks.
> 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.9.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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.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
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "caofangkun (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
caofangkun updated HIVE-2723:
-----------------------------
Description:
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
was:
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
> 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
>
>
> 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
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Ashutosh Chauhan (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-2723:
-----------------------------------
Affects Version/s: 0.9.0
Fix Version/s: (was: 0.9.0)
Unlinking from 0.9
> 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.9.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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: HIVE-2723.D1275.1.patch, HIVE-2723.D1275.2.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
[jira] [Commented] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Hudson (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13511257#comment-13511257 ]
Hudson commented on HIVE-2723:
------------------------------
Integrated in Hive-trunk-h0.21 #1836 (See [https://builds.apache.org/job/Hive-trunk-h0.21/1836/])
HIVE-2723 should throw "Ambiguous column reference key" Exception in particular
join condition (Navis via namit) (Revision 1417743)
Result = ABORTED
namit : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1417743
Files :
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/RowResolver.java
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
* /hive/trunk/ql/src/test/queries/clientnegative/ambiguous_col0.q
* /hive/trunk/ql/src/test/queries/clientnegative/ambiguous_col1.q
* /hive/trunk/ql/src/test/queries/clientnegative/ambiguous_col2.q
* /hive/trunk/ql/src/test/queries/clientpositive/ambiguous_col.q
* /hive/trunk/ql/src/test/results/clientnegative/ambiguous_col0.q.out
* /hive/trunk/ql/src/test/results/clientnegative/ambiguous_col1.q.out
* /hive/trunk/ql/src/test/results/clientnegative/ambiguous_col2.q.out
* /hive/trunk/ql/src/test/results/clientnegative/ambiguous_col_patterned.q.out
* /hive/trunk/ql/src/test/results/clientpositive/ambiguous_col.q.out
> 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
> 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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, hive.2723.1.patch, HIVE-2723.D1275.3.patch
>
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Navis (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis updated HIVE-2723:
------------------------
Affects Version/s: (was: 0.8.0)
Status: Patch Available (was: Open)
Passed all tests
> 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
> 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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Fix For: 0.9.0
>
> Attachments: HIVE-2723.D1275.1.patch, HIVE-2723.D1275.2.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
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Phabricator (JIRA)" <ji...@apache.org>.
[ 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.3.patch
navis updated the revision "HIVE-2723 [jira] should throw "Ambiguous column reference key" Exception in particular join condition".
Reviewers: JIRA
Moved column checking logic into RowResolver
REVISION DETAIL
https://reviews.facebook.net/D1275
AFFECTED FILES
ql/src/java/org/apache/hadoop/hive/ql/parse/RowResolver.java
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java
ql/src/test/queries/clientnegative/ambiguous_col0.q
ql/src/test/queries/clientnegative/ambiguous_col1.q
ql/src/test/queries/clientnegative/ambiguous_col2.q
ql/src/test/queries/clientpositive/ambiguous_col.q
ql/src/test/results/clientnegative/ambiguous_col0.q.out
ql/src/test/results/clientnegative/ambiguous_col1.q.out
ql/src/test/results/clientnegative/ambiguous_col2.q.out
ql/src/test/results/clientnegative/ambiguous_col_patterned.q.out
ql/src/test/results/clientpositive/ambiguous_col.q.out
To: JIRA, navis
> 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.9.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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, HIVE-2723.D1275.3.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
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2723:
-----------------------------
Resolution: Fixed
Hadoop Flags: Reviewed
Status: Resolved (was: Patch Available)
Committed. Thanks Navis
> 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
> 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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, hive.2723.1.patch, HIVE-2723.D1275.3.patch
>
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Navis (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis updated HIVE-2723:
------------------------
Affects Version/s: (was: 0.9.0)
Status: Patch Available (was: Open)
> 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
> 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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, HIVE-2723.D1275.3.patch
>
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Carl Steinbach (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Carl Steinbach updated HIVE-2723:
---------------------------------
Description: (was: 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
)
> 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.9.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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, HIVE-2723.D1275.3.patch
>
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Navis (Assigned) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Navis reassigned HIVE-2723:
---------------------------
Assignee: Navis
> 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
> Assignee: Navis
> 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
[jira] [Commented] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13511099#comment-13511099 ]
Namit Jain commented on HIVE-2723:
----------------------------------
+1
Looks good. running tests
> 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
> 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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, hive.2723.1.patch, HIVE-2723.D1275.3.patch
>
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (HIVE-2723) should throw "Ambiguous column
reference key" Exception in particular join condition
Posted by "Namit Jain (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/HIVE-2723?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Namit Jain updated HIVE-2723:
-----------------------------
Attachment: hive.2723.1.patch
> 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
> 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
> Assignee: Navis
> Priority: Minor
> Labels: exception-handling, query, queryparser
> Attachments: ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.1.patch, ASF.LICENSE.NOT.GRANTED--HIVE-2723.D1275.2.patch, hive.2723.1.patch, HIVE-2723.D1275.3.patch
>
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira