Question: how to specify 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.