date_sub hive code example

Example: hadoop hive get time from timestamp

from_unixtime(UNIX_TIMESTAMP(your_unix_timestamp), 'HH:mm:ss')