Hive Date Magic

In this post, I will share different scenarios of date handling in hive.

1- Use below code for Converting julian date to calender date

substr(from_unixtime(unix_timestamp(cast(concat('2017001') AS string),'yyyyDDD')),1,10) AS trans_dt