验证flume采集日志延迟

 

 

select
    data_date
    ,hour
    ,count(*)
from (select
    data_date 
    ,from_unixtime(floor(rtime/1000),'yyyyMMddHH') as hour
from tmp.table_tmp
where data_date >= 2019062800
 and data_date <= 2019070108) a 
group by data_date,hour

order by data_date,hour