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

Hive Optimization - Multi insert

check below link

http://tech-terminologies.blogspot.com/2018/07/hive-optimization-using-multi-insert.html