Oracle Query conversion to Hive?

[#1]

I am really new to Hive/Impala. I am looking to convert some SQL queries into Hive.

I have  a column called date (Ex:2011-09-22 05:01:38) and I would like to convert it into the following format: 09-22-2011-05.01.38 AM

Any help is appreciated.

[#2 · Accepted solution]

Hi ,

To change the format of the input time we need to use unix_timestamp along with from_unixtime funcitons.

Can you check this below Cloudera community article:

https://community.cloudera.com/t5/Support-Questions/Format-date-in-HIVE/td-p/203463

[#3]

@naush_madaka07 Has your issue been resolved? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

mark as solution button