Please go through UDFs in detail :
https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF
I presume that your column is STRING datatype.
You may want to do the following:
SELECT CAST (to_date(from_unixtime(unix_timestamp(, "MMM dd,
"))) AS DATE)
FROM ;
Once you have your DATE d
Hi,
Need some suggestions on Date function in Hive.
The data appearing in the source file is in the format of "May 31, 2015". I
want to convert the same in MM-DD- format.
Please suggest if this can be done with existing Hive 14.0 functionality
or it will require custom UDF.
Please let me kno
