blocks|key|1878225|text|加载到GithubArchive中的BigQuery数据没有源代码的副本，因此在代码中搜索术语是不可能的。但是，如果您想在存储库描述中搜索一个术语，然后根据提交的数量选择顶级存储库，下面是一个如何实现它的示例(这个例子中的术语是"SQL“)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1878226|select+count(*)+c,+repository_url,+repository_description
from+[githubarchive:github.timeline]
where+type+=+'PushEvent'+and+repository_description+contains+'SQL'
group+by+2,+3
order+by+c+desc
limit+10|code-block|syntax|javascript|1878227|这会导致|1878228|14925+++https://github.com/danberindei/infinispan+++Infinispan+is+an+open+source+data+grid+platform+and+highly+scalable+NoSQL+cloud+data+store.++
9377++++https://github.com/postgres/postgres++++Mirror+of+the+official+PostgreSQL+GIT+repository.+Note+that+this+is+just+a+*mirror*+-+we+don't+work+with+pull+requests+on+github.+To+contribute,+please+see+http://wiki.postgresql.org/wiki/Submitting_a_Patch+++
4876++++https://github.com/galderz/infinispan+++Infinispan+is+an+open+source+data+grid+platform+and+highly+scalable+NoSQL+cloud+data+store.++
4747++++https://github.com/triAGENS/ArangoDB++++ArangoDB+is+a+multi-purpose,+open-source+database+with+flexible+data+models+for+documents,+graphs,+and+key-values.+Build+high+performance+applications+using+a+convenient+SQL-like+query+language+or+JavaScript/Ruby+extensions.+Use+ACID+transaction+if+you+require+them.+Scale+horizontally+and+vertically+with+a+few+mouse+clicks.++++
3590++++https://github.com/webnotes/erpnext+Open+Source,+web-based+ERP+based+on+Python,+Javascript+and+MySQL.++++
3489++++https://github.com/anistor/infinispan+++Infinispan+is+an+open+source+data+grid+platform+and+highly+scalable+NoSQL+cloud+data+store.++
3263++++https://github.com/youtube/vitess+++vitess+provides+servers+and+tools+which+facilitate+scaling+of+MySQL+databases+for+large+scale+web+services.++
3071++++https://github.com/infinispan/infinispan++++Infinispan+is+an+open+source+data+grid+platform+and+highly+scalable+NoSQL+cloud+data+store.++
2631++++https://github.com/theory/sqitch++++Simple+SQL+change+management+++++
2358++++https://github.com/zzzeek/sqlalchemy++++Mirror+of+SQLAlchemy|1878229|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

The GithubArchive data loaded into BigQuery doesn't have copy of the source code, so search term in code wouldn't be possible. But if you wanted to search for a term in repository description, and then pick top repositories by number of commits, here is an example how to do it (the term is "SQL" in this example):

<pre><code>select count(*) c, repository_url, repository_description
from [githubarchive:github.timeline]
where type = 'PushEvent' and repository_description contains 'SQL'
group by 2, 3
order by c desc
limit 10
</code></pre>

This results in

<pre><code>14925 https://github.com/danberindei/infinispan Infinispan is an open source data grid platform and highly scalable NoSQL cloud data store. 
9377 https://github.com/postgres/postgres Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see http://wiki.postgresql.org/wiki/Submitting_a_Patch 
4876 https://github.com/galderz/infinispan Infinispan is an open source data grid platform and highly scalable NoSQL cloud data store. 
4747 https://github.com/triAGENS/ArangoDB ArangoDB is a multi-purpose, open-source database with flexible data models for documents, graphs, and key-values. Build high performance applications using a convenient SQL-like query language or JavaScript/Ruby extensions. Use ACID transaction if you require them. Scale horizontally and vertically with a few mouse clicks. 
3590 https://github.com/webnotes/erpnext Open Source, web-based ERP based on Python, Javascript and MySQL. 
3489 https://github.com/anistor/infinispan Infinispan is an open source data grid platform and highly scalable NoSQL cloud data store. 
3263 https://github.com/youtube/vitess vitess provides servers and tools which facilitate scaling of MySQL databases for large scale web services. 
3071 https://github.com/infinispan/infinispan Infinispan is an open source data grid platform and highly scalable NoSQL cloud data store. 
2631 https://github.com/theory/sqitch Simple SQL change management 
2358 https://github.com/zzzeek/sqlalchemy Mirror of SQLAlchemy
</code></pre>

blocks|key|1275744|text|SELECT+COUNT(1)+c,+repository_url,+repository_description
FROM+[githubarchive:github.timeline]
WHERE+type+=+'PushEvent'+
AND+REGEXP_MATCH(repository_description,+r'(?i)SQL')
GROUP+BY+2,+3
ORDER+BY+c+DESC
LIMIT+10|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|1275745|BigQuery支持正则表达式，因此您可以大大改进/缩小搜索结果，具有使用搜索模式与搜索引擎术语的灵活性。|unstyled|1275746|以下参考资料可进一步帮助您：|1275747|BigQuery正则表达式函数|offset|length|1275748|re2语法|1275749|entityMap|0|LINK|mutability|MUTABLE|url|https://cloud.google.com/bigquery/query-reference#regularexpressionfunctions|1|https://github.com/google/re2/blob/master/doc/syntax.txt^0|0|0|0|0|F|0|0|0|5|1|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$B|C]]|$1|D|3|E|5|F|7|Z|8|@]|9|@]|A|$]]|$1|G|3|H|5|F|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|F|7|11|8|@]|9|@$K|12|L|13|1|14]]|A|$]]|$1|M|3|N|5|F|7|15|8|@]|9|@$K|16|L|17|1|18]]|A|$]]|$1|O|3|-4|5|F|7|19|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]|W|$5|R|S|T|A|$U|X]]]]

<pre><code>SELECT COUNT(1) c, repository_url, repository_description
FROM [githubarchive:github.timeline]
WHERE type = 'PushEvent' 
AND REGEXP_MATCH(repository_description, r'(?i)SQL')
GROUP BY 2, 3
ORDER BY c DESC
LIMIT 10
</code></pre>

BigQuery supports Regular Expression so you can greatly improve / narrow down your search result having flexibility of using search pattern vs. seach term

Below references can help you further:

<a href="https://cloud.google.com/bigquery/query-reference#regularexpressionfunctions" rel="nofollow">BigQuery Regular expression functions</a> 
<a href="https://github.com/google/re2/blob/master/doc/syntax.txt" rel="nofollow">re2 Syntax</a>

I was thinking of trying out BigQuery and GithubArchive, but I'm not sure how to compose a query that would let me search for a term in code or project and order the results by number of commits descending.

Thanks for any tips

How to search github projects ordered by number of commits?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在考虑尝试BigQuery和GithubArchive，但我不知道如何编写一个查询，这样我就可以在代码或项目中搜索一个术语，并按提交下降的次数对结果排序。谢谢你的建议

问如何搜索按提交次数排序的github项目？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何搜索按提交次数排序的github项目？EN