Support Questions
Find answers, ask questions, and share your expertise

Oracle Query conversion to Hive?

New Contributor

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.

1 ACCEPTED SOLUTION

Expert Contributor

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

 

 

View solution in original post

2 REPLIES 2

Expert Contributor

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

 

 

Community Manager

@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. 

 

Screen Shot 2019-08-06 at 1.54.47 PM.png


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.