The query is assuming Keyword/Hour is unique which I am not sure if that's
an assumption per requirement.
If not, you'd probably want to group by those two columns.
select k.keyword
, h.hour
, sum(coalesce(t.totalcount,0))
from (select distinct keyword from t)
as k
join (select
Dear Friends,
I have a hive table with column name Keyword,Hour,TotalTweets.
for example, I have the date for three keyword as below.
*KeywordHourTotalCount*
iphone 11 500
iphone 12 1000
Samsung 11 300
Samsung 12 600
Nokia
Hi,
Hive-2.0.1 configured in secure hadoop cluster. Hive ACL enabled.
User Kumar is Hive admin and Babu is normal user.
1. User Kumar granted permission to user Babu with grant option
grant all on sample to user Babu with grant option
1. User Babu granted permission to user Rajesh
gran
