hive -e "insert overwrite table test.mydate select from_unixtime( unix_timestamp(deptno )+6*60*60)from test.mydate;"
insert overwrite table test.mydate
select
`if`(mytime < curentime,add_time,deptno)
from
(select from_unixtime(unix_timestamp(deptno)+6*60*60,'yyyy-MM-dd HH:mm:ss') mytime,
from_unixtime(unix_timestamp(deptno)+10*60,'yyyy-MM-dd HH:mm:ss') add_time,
from_unixtime(unix_timestamp(),'yyyy-MM-dd HH:mm:ss') curentime,
deptno
from test.mydate) tt;
time=`hive -e "select deptno from test.mydate;" | tail -n 1`
echo $time
current_time=`date +%s`
mytime_stamp=`date -d "$time" +%s`
echo $current_time
echo $mytime_stamp
let diff_stamp=($current_time - $mytime_stamp)
echo $diff_stamp
if (( $diff_stamp > 21600 ))
then
echo "大于6个小时没有数据!!!"
fi