Question: how to change current date format in hive?
Answer: select from_unixtime(unix_timestamp('2016/06/01','yyyy/MM/dd'),'yyyy-MM-dd') from table1; where table1 is the table name present in my hive database. I hope this help you!!! The above command would help convert the date to unix timestamp format which you may format as you want using the Simple Date Function.