from_unixtime获取当前的时间：

select from_unixtime(unix_timestamp(),'yyyy-MM-dd HH:mm:ss')

hive (default)> 
              > 
              > 
              > select from_unixtime(unix_timestamp(),'yyyy-MM-dd HH:mm:ss');
unix_timestamp(void) is deprecated. Use current_timestamp instead.
OK
_c0
2019-05-30 20:11:37
Time taken: 0.083 seconds, Fetched: 1 row(s)
hive (default)>