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.