Spark vs. Hadoop

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select 
  DATEFROMPARTS( year(p.creationDate), month(p.creationDate), 1) as date, 
  count(distinct p.id) as total, 
  sum(case when t.tagName = 'hadoop' then 1 else 0 end) as 'Hadoop', 
  sum(case when t.tagName = 'apache-spark' then 1 else 0 end) as 'Spark' 
from posts p 
  join PostTags pTags on pTags.postId = p.id
  join Tags t on t.id = pTags.tagId
where 
  p.postTypeId = 1 -- questions
  AND
  t.tagName in ('hadoop', 'apache-spark')
  AND year(p.creationDate) < 2017
group by month (p.creationDate), year(p.creationDate)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results