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;