Question: how to convert date to yyyymmdd in hive?
Answer: select from_unixtime(unix_timestamp(),'yyyyMMdd') from table_name;
unix_timestamp(): this function returns a unix timestamp.
from_unixtime(): this function is used to return date in desired format.
show functions;
describe function function_name;
describe function extended function_name;