Question: how to subtract days from a date in hive?
Answer: 2 Answers. Convert the current_timestamp to unix timestamp and subtract 10 days=10*86400 seconds. Then use from_unixtime to get the timestamp string.