-
-
Save RanaivosonHerimanitra/07ef89b41fec9f99f1596675bfd4c608 to your computer and use it in GitHub Desktop.
Sample query for github dataset in big-query
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
cont.sample_repo_name, | |
repo.watch_count | |
FROM | |
[bigquery-public-data:github_repos.sample_contents] as cont | |
JOIN [bigquery-public-data:github_repos.sample_repos] as repo | |
ON cont.sample_repo_name = repo.repo_name | |
WHERE | |
cont.content CONTAINS 'findbugs-maven-plugin</artifactId>' | |
AND cont.sample_path LIKE 'pom.xml' | |
ORDER BY repo.watch_count DESC | |
LIMIT | |
40; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment