Spark SQL 条件在inner join 和 where 的区别？

Question

有三段语句：

第一段：

select

t1.id, t1.name, t2.sub_id, sum(t2.amount) as t_amount

from t1 inner join t2

on t1.id = t2.id and t1.dt between '20190701' and '20190705' and t2.dt = '20190705'

第二段:

select

t1.id, t1.name, t2.sub_id, sum(t2.amount) as t_amount

from t1 inner join t2

on t1.id = t2.id

where t1.dt between '20190701' and '20190705' and t2.dt = '20190705'

第三段:

select

s1.id, s1.name, s2.sub_id, sum(s2.amount) as t_amount

from (select id, name from t1 where dt between '20190701' and '20190705'

)s1

inner join (select t2.id,t2.sub_id,t2.amount from t2)s2

on s1.id = s2.id

这三段语句在spark sql中执行性能的区别是什么