[HIVE-4146] bug with hive.auto.convert.join.noconditionaltask with outer joins

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Namit Jain
• Reporter: Namit Jain
• Created: 11/Mar/13 05:05
• Updated: 16/May/13 21:10
• Resolved: 20/Mar/13 16:03

Description

Consider the following scenario:

create table s1 as select * from src where key = 0;

set hive.auto.convert.join.noconditionaltask=false;

SELECT * FROM s1 src1 LEFT OUTER JOIN s1 src2 ON (src1.key = src2.key AND src2.key > 10);

gives correct results

0 val_0 NULL NULL
0 val_0 NULL NULL
0 val_0 NULL NULL

whereas it gives no results with hive.auto.convert.join.noconditionaltask set
to true

Issue Links

• is depended upon by: HIVE-4042 ignore mapjoin hint