Analyzing GitHub issues and comments with BigQuery

Some people have asked “can we analyze GitHub issues on BigQuery?”. Good news: While that data is not part of the new open source GitHub code on BigQuery dataset, you can find this in the classic GitHub Archive dataset. Let’s quickly find the 10 repos with the most comments in their issues: SELECT repo.name, COUNT(*) c FROM [githubarchive:month.201606] WHERE type IN ( 'IssueCommentEvent') GROUP BY

[yosuke_furukawa]

ふおおおお、 BigQuery で GitHub issue の分析してみた記事すげー