Hi,all:
There's a question that when I use hive2 explain the Sql such as :
select a.*,b.* from test a left join test b on a.id=b.id where a.id in
('1','2') and b.id in ('1','2');
The explain plan shows that the test b will not be filtered before join.
However,I changed the sql to :
select a.*,b.* from test a left join test b on a.id=b.id where a.id in
('1','2') and b.id ='1';
The explain plan shows that the test b will be filterd before join.
Does the hive needs to ues "=" instead of "in" to predicate pushdown?
Thanks.
