New Contributor
Posts: 1
Registered: ‎06-09-2017

Date Dimension table using HIVE

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-.-.