Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Highlighted

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).