Reply
Explorer
Posts: 31
Registered: ‎08-29-2017

Need a hive query to display Week of the timestamp and its start Date and End Date ?

 Hi,

 

 

I have a timestamp column in Hbase.

 

I have a table in Hbase and want to access through impala.

 

The table has a row key combination of three columns (abcshsk#2017-08-01 00:00:00.0#cpu)

 

Three columns (string,timestamp,string) this is my row key now.

 

I need to write a hive query to display Week of the timestamp and its start Date and End Date.

 

 

I used week of the year command in hive to calculate the week from timestamp. but need to know its start date of the week and end Date of the week.

 

pls suggest. thanks.

 

I created a external table in hive and hbase storage handler.

 

I write insert overwrite in hive ( select statement from hbase).

Announcements