question hive query to display Week of the timestamp and its start Date and End Date. in Archives of Support Questions (Read Only)

hive query to display Week of the timestamp and its start Date and End Date.

Gayathridevi — Mon, 25 Sep 2017 17:20:54 GMT

balavignesh_nag — Mon, 25 Sep 2017 18:19:53 GMT

select weekofyear(current_timestamp)

Above query would give you the week of the timestamp.

To get the first day of the week -->

select date_sub(current_timestamp,pmod(datediff(current_timestamp,'1900-01-07'),7));

To get last day of the week -->

select last_day(current_timestamp);

balavignesh_nag — Tue, 26 Sep 2017 18:04:24 GMT

I couldn't think of any built in function in hive to handle this scenario.

The other way of doing this is by using something like below:

select from_unixtime(unix_timestamp(current_timestamp)+7200);

7200 implies seconds needed for 2 hours as mentioned in your quetion. You can alter it based on your need.

Instead of the hardcoded value you can pass variable or row_number()over() * 3600 can be used to generate sequentially.

Hope it Helps!!