2017年哪个公司对开源贡献最多？让我们用GitHub的数据分析下

TO_JSON_STRING(STRUCT(b.repo_name,stars))) repos

FROM period a

JOIN repo_stars b

ON a.repo.id=b.id

WHERE type='PushEvent'

GROUP BY 1

HAVING c>3

)

SELECT * FROM (

SELECT domain

, githubers

, (SELECT COUNT(DISTINCT repo) FROM UNNEST(repos) repo) repos_contributed_to

, ARRAY(

SELECT AS STRUCT JSON_EXTRACT_SCALAR(repo, '$.repo_name') repo_name

, CAST(JSON_EXTRACT_SCALAR(repo, '$.stars') AS INT64) stars

, COUNT(*) githubers_from_domain FROM UNNEST(repos) repo

GROUP BY 1, 2

HAVING githubers_from_domain>1

ORDER BY stars DESC LIMIT 3

) top

, (SELECT SUM(CAST(JSON_EXTRACT_SCALAR(repo, '$.stars') AS INT64)) FROM (SELECT DISTINCT repo FROM UNNEST(repos) repo)) sum_stars_projects_contributed_to

FROM (

SELECT domain, COUNT(*) githubers, ARRAY_CONCAT_AGG(ARRAY(SELECT * FROM UNNEST(repos) repo)) repos

FROM pushers_guess_emails_and_top_projects

#WHERE domain IN UNNEST(SPLIT('google.com|microsoft.com|amazon.com', '|'))

3/4 首页上一页 1 2 3 4 下一页尾页

　　推荐阅读

　　如何分析博客中最流行的编程语言

Tech Neo技巧沙龙 | 11月25号，九州云/ZStack与您一路商量云时代收集界线治理实践摘要：这篇文┞仿我们将对一些各类各样的博客的风行度相对于他们在谷歌上的排名进行一个分析。所有代码可>>>详细阅读

本文标题：2017年哪个公司对开源贡献最多？让我们用GitHub的数据分析下

地址：http://www.17bianji.com/lsqh/38843.html

1/2 1