spark sql 踩坑记

sql语句如下：

val s = "select a.*,b.* from test1 a  left  join test1 b on a.cust_id = b.cust_id" +
  " and a.month_id=201709 and a.day_id=25 and b.month_id=201709 and b.day_id=25  "

这条语句会导致a表全表扫描，不会走分区字段。版本spark1.6