遇到的问题
spark sql当使用分区字段过滤时,分区过滤在where中的顺序对查询效率有没有影响,如下两个sql,分区字段为hp_stat_date
1.分区过滤在where条件中排最前(sqlA)
select dxyid as username
from bdl_app_server_di
where hp_stat_date between "2021-08-02" and "2021-08-08"
and (lv='mama-0.1')
group by dxyid
2.分区过滤在where条件中非最前(sqlB)
select dxyid as username, 1 as revisit0
from bdl_app_server_di
where
(</