Impala - Convert MON-YY to YYYYMM

Question

I have one column Month_year in staging table having below data. Please suggest query to get the desired output.

Input:

+----------+
month_year
+----------+
Jan-19
Dec-18
+----------+

Expected Output:

+----------+
month_year
+----------+
201901
201812
+----------+

Thanks in Advance!

Shambhu Nath · Accepted Answer · 2019-01-18T21:58:00.837

0

If column's month_year date format is MMM-yy then contact 01 as default date for avoid to null result, however it will not effect expected out because you are going to get output in format yyyyMM.  
Try this:  
select from_unixtime(unix_timestamp(concat('01-',month_year),'dd-MMM-yy'),'yyyyMM')

edited Jan 18 '19 at 21:58

answered Jan 12 '19 at 17:03

Shambhu Nath

109
4

Month_year column is string type. please suggest solution to convert String to yyyyMM (String type) – A Saraf Jan 12 '19 at 17:59
try the query, since from_unixtime functions will return string hence need not required to convert to String. – Shambhu Nath Jan 12 '19 at 18:13

Impala - Convert MON-YY to YYYYMM

1 Answers1