HiveQL if operators regroup in one line

Request:

select IF(type='view', count(*), 0), IF(type='click', count(*), 0)
from ad_events
where year=2013 and month=01 and day=18 and (hour=01 or hour=02)
group by type

      

Result:

      _c0       _c1
0      0         0
1      0         0
2      0       1368
3      0         0
4      0         0
5      0         0
6      0         0
7      0         0
8   277917       0
9      0         0

      

Is there any result for just one line?

      _c0       _c1
0    277917     1368

      

+3


source to share


2 answers


Ok, I just did this in a nested query:



select SUM(c), SUM(v)
from (
select tracking_id, IF(type='view', count(*), 0) AS v, IF(type='click', count(*), 0) AS c
from ad_events
where year=2013 and month=01 and day=18
group by tracking_id, type
) t2

      

+5


source


Please try to follow



select
   type,
   count(type) TypeCount
from ad_events
where
   year=2013 and 
   month=01 and 
   day=18 and 
   (hour=01 or 
    hour=02)
group by type

      

+2


source







All Articles