06-09-2017 01:28 PM
I have to create a date dimension table which will contains following information - date , year, month , day , week of year etc details-. As per the requirment , i have to populate week of the year as per business
logic , cant use weekofyear function which automatically take january 1st as week 1-. In my case , oct 1 shou
ld be treated as week 1 and onwards and dec 7 should contain
last week no for the ca
lendar year , next yeat again oct 1 wou
ld be treated as week1, can you p
lease suggest how to do it using hive-.-.