[HIVE-560] column pruning not working with map joins

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.4.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: He Yongqiang
• Reporter: Namit Jain
• Created: 15/Jun/09 20:43
• Updated: 17/Dec/11 00:07
• Resolved: 25/Jun/09 05:51

Description

drop table tst1;
drop table tst2;

create table tst1(a1 string, a2 string, a3 string, a4 string);
create table tst2(b1 string, b2 string, b3 string, b4 string);

explain select /*+ MAPJOIN(a) */ a.a1, a.a2 from tst1 a join tst2 b ON a.a2=b.b2;

the select is after the join - column pruning is not happening

Issue Links

• is related to: HIVE-460 Improve ColumnPruner to prune more aggressively and keep column information for input tables