[HIVE-3988] lateral view followed by mapjoin should not be allowed

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Query Processor
• Assignee: Unassigned
• Reporter: Namit Jain
• Created: 05/Feb/13 08:32
• Updated: 05/Feb/13 08:33

Description

Consider the following queries:

drop table lazy_array_map;
create table lazy_array_map (map_col map<int,string>, array_col array <string> );
INSERT OVERWRITE TABLE lazy_array_map select map(1,'one',2,'two',3,'three'), array('100','200','300') FROM src LIMIT 1;

select /*+ MAPJOIN(a) */ * from
(SELECT array_col, myCol from lazy_array_map lateral view explode(array_col) X AS myCol) subq1
join
src a
on subq1.myCol = a.key;

select /*+ MAPJOIN(subq1) */ * from
(SELECT array_col, myCol from lazy_array_map lateral view explode(array_col) X AS myCol) subq1
join
src a
on subq1.myCol = a.key;

The last 2 queries should throw an error, but they work fine right now.
The same affect can be achieved without a mapjoin hint.

Issue Links

• relates to: HIVE-2839 Filters on outer join with mapjoin hint is not applied correctly