Hive関数で週番号を取得 ref: http://qiita.com/kyoro1/items/b4efa6a6da7573498f95

file0.sql

weekofyear("yyyy-mm-dd")

file1.sql

select weekofyear("1970-11-01")
---44

file2.sql

select weekofyear("2016-09-11")
---36 <- 日曜
select weekofyear("2016-09-12")
---37 <- 月曜

file3.sql

select weekofyear('2015-12-28')
 --- 53 <- 月曜

select weekofyear('2016-01-01')
 --- 53 <- 木曜

select weekofyear('2016-01-03')
 --- 53 <- 日曜

select weekofyear('2016-01-04')
 --- 1 <- 月曜

file4.sql

select weekofyear(from_unixtime(unix_timestamp('20151228','yyyymmdd'), 'yyyy-mm-dd'))
 --- 53