question Re: How to find week of the year of hive column(String) in Archives of Support Questions (Read Only)

How to find week of the year of hive column(String)

bsuresh — Thu, 17 Dec 2015 18:33:16 GMT

Hi everyone, In my hive table i have values in one column are like " Thu Dec 17 15:55:08 IST 2015 " .For this particular column i would like to find "week of the year".How can i do that one .Assume column name is survey_date and data type is string.

Re: How to find week of the year of hive column(String)

gbraccialli3 — Thu, 17 Dec 2015 20:51:27 GMT

@Suresh Bonam

Try this:

select weekofyear(from_unixtime(unix_timestamp('Thu Dec 17 15:55:08 IST 2015', 'EEE MMM d HH:mm:ss Z yyyy'),'yyyy-MM-dd')) from sample_07 limit 1;


select weekofyear(from_unixtime(unix_timestamp('Thu Dec 02 15:55:08 IST 2015', 'EEE MMM d HH:mm:ss Z yyyy'),'yyyy-MM-dd')) from sample_07 limit 1;

Re: How to find week of the year of hive column(String)

bsuresh — Fri, 18 Dec 2015 13:33:09 GMT

I guess,from_unixtime function has to convert bigint to "yyyy-MM-dd" not "yyyy-mm-dd".

Re: How to find week of the year of hive column(String)

gbraccialli3 — Fri, 18 Dec 2015 18:19:08 GMT

@Suresh Bonam you are right. I updated the answer. Thank you!