Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
SELECT repository_url, repository_language
FROM [publicdata:samples.github_timeline] AS t1
WHERE repository_language IN
(SELECT repository_language FROM
(SELECT repository_language, COUNT(repository_url) AS count
FROM [publicdata:samples.github_timeline] AS t2
WHERE t2.repository_url = t1.repository_url AND t2.repository_url IS NOT NULL AND repository_language IS NOT NULL
GROUP EACH BY repository_language
ORDER BY count DESC)
LIMIT 1)
GROUP EACH BY repository_url, repository_language
-- Error: Failed to find field t1.repository_url in schema message
-- Msg_0_CLOUD_QUERY_TABLE { optional string repository_url = 1; optional
-- string repository_language = 17; } Field repository_language preserves
-- nulls Field repository_url preserves nulls
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment