Hive SQL query to find the week of quarter

[#1]

Hi All,

I need help on writing sql query to find the week of quarter. I had a querie which works in sql server

(DATEDIFF(DD, DATEADD(QQ, DATEDIFF(QQ, 0, getdate()), 0), getdate()) / 7) + 1 AS WeekOfQuarter

Please suggest work around.

Thanks

Amit Sharma

[#2]

Hi, 

Can you provide the DDL of the table and some sample data to check this out?

Thanks