Skip to content

Instantly share code, notes, and snippets.

Álvaro Hernández Tortosa ahachete

Block or report user

Report or block ahachete

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View Stampede-GithuQuery-PostgreSQL-F
SELECT repo.name_s, avg(payload.size_i)
FROM github.events AS events
INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
WHERE events.type_s = 'PushEvent' AND payload.size_i > 2
GROUP BY repo.name_s
ORDER BY avg DESC;
View Stampede-GithuQuery-PostgreSQL-E
WITH distinct_commits AS (
SELECT DISTINCT repo.name_s, actor.login_s
FROM github.events AS events
INNER JOIN github.events_actor AS actor ON (events.did = actor.did)
INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
WHERE events.type_s = 'PushEvent'
)
SELECT name_s, count(*)
FROM distinct_commits
GROUP BY name_s
View Stampede-GithuQuery-PostgreSQL-D
SELECT action_s, count(*)
FROM github.events_payload
WHERE action_s IS NOT NULL
GROUP BY action_s
ORDER BY count DESC;
View Stampede-GithuQuery-PostgreSQL-C
SELECT events.type_s, count(*)
FROM github.events AS events
JOIN github.events_actor AS actor ON (events.did = actor.did)
GROUP BY type_s
ORDER BY count DESC;
View Stampede-GithuQuery-PostgreSQL-B
SELECT type_s, count(*)
FROM github.events
GROUP BY type_s
ORDER BY count desc;
View Stampede-GithuQuery-PostgreSQL-A
SELECT repo.name_s, count(*)
FROM github.events AS events
INNER JOIN github.events_repo AS repo ON (events.did = repo.did)
INNER JOIN github.events_payload AS payload ON (events.did=payload.did)
WHERE events.type_s = 'IssuesEvent' AND payload.action_s = 'opened'
GROUP BY repo.name_s
ORDER BY count desc;
View Stampede-GithubQuery-MongoDB-F
db.events.aggregate(
[
{ $match: { "type": "PushEvent", "payload.size": { $gt : 2 } } },
{ $group: { _id: "$repo.name", avg: { $avg: "$payload.size" } } },
{ $sort: { avg: -1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);
View Stampede-GithubQuery-MongoDB-E
db.events.aggregate(
[
{ $match: { "type": "PushEvent" } },
{ $project: { "repo.name": 1, "actor.login": 1 } },
{ $group:
{
_id: "$repo.name",
actor: { $first: "$actor.login"},
count: { $sum: 1 }
}
View Stampede-GithubQuery-MongoDB-D
db.events.aggregate(
[
{ $match: { "payload.action": { $exists: true } } },
{ $group: { _id: "$payload.action", total: { $sum: 1 } } },
{ $sort: { total: 1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);
View Stampede-GithubQuery-MongoDB-C
db.events.aggregate(
[
{ $group: { _id: "$type", total: { $sum: 1 } } },
{ $sort: { total: -1 } }
],
{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);
You can’t perform that action at this time.