shell按照天小时遍历

天：

#!/bin/bash

#firstDay=`date -d "-1 day" +%Y%m%d`

firstDay="20210101"
endDay="20210201"

#遍历某月的每一天
while (( $firstDay < $endDay ))
do
beeline -e "select * from dw.dw_doc_phone_$firstDay "  > $firstDay.csv
firstDay=`date -d "+1 day $firstDay" +%Y%m%d`

done

按照小时

#!/bin/bash

#stime=`date -d "-48 hours" +%Y%m%d%H`

stime="2021010100"
etime="2021020100"

#以小时循环
while :
do
echo $stime
beeline -e "select * from  ods.ods_order_info_dd_${stime}" > ${stime}.csv
stime=$(date -d "${stime:0:8} ${stime:8:2} 1hour" +%Y%m%d%H)
if [[ $stime -gt $etime ]]
	then
	break
	fi
done