select dt_time,count(disinct uid) from ( select uid,begin_time,end_time from a )a cross join bp.yyzc_dt b ---秒级别时间维表 where b.dt_time between begin_time and end_time group by dt_time