set odps.sql.type.system.odps2=true;
select DATE_FORMAT(DATEADD(CURRENT_TIMESTAMP(),-1,'hh'),'yyyy-mm-dd hh:mi:ss')
select from_unixtime(unix_timestamp(cast(CURRENT_TIMESTAMP() as datetime))-60*60);
set odps.sql.type.system.odps2=true;
select DATE_FORMAT(DATEADD(CURRENT_TIMESTAMP(),-1,'hh'),'yyyy-mm-dd hh:mi:ss')
select from_unixtime(unix_timestamp(cast(CURRENT_TIMESTAMP() as datetime))-60*60);