question Oracle Query conversion to Hive? in Support Questions

Oracle Query conversion to Hive?

naush_madaka07 — Thu, 27 May 2021 10:04:57 GMT

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.

Re: Oracle Query conversion to Hive?

ChethanYM — Fri, 28 May 2021 07:48:03 GMT

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

Re: Oracle Query conversion to Hive?

cjervis — Thu, 03 Jun 2021 12:30:47 GMT

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