hive timestamp类型增加小时

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;

#!  /bin/bash

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