blob: c1274a9264eaa956624aa5a466faa661ff91c8a8 [file]
-- SELECT
-- label,
-- count() AS c
-- FROM github_events
-- LATERAL VIEW explode_split(labels, ',') t AS label
-- WHERE (event_type IN ('IssuesEvent', 'PullRequestEvent', 'IssueCommentEvent')) AND (action IN ('created', 'opened', 'labeled'))
-- GROUP BY label
-- ORDER BY c DESC
-- LIMIT 50