ahachete

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;

ahachete

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

ahachete

SELECT		action_s, count(*)
FROM		github.events_payload
WHERE 		action_s IS NOT NULL
GROUP BY	action_s
ORDER BY	count DESC;

ahachete

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;

ahachete

SELECT		type_s, count(*)
FROM		github.events
GROUP BY	type_s 
ORDER BY	count desc;

ahachete

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;

ahachete

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 } }
);

ahachete

db.events.aggregate(
	[
		{ $match: { "type": "PushEvent" } },
		{ $project: { "repo.name": 1, "actor.login": 1 } },
		{ $group:
			{ 
				_id: "$repo.name",
				actor: { $first: "$actor.login"},
				count: { $sum: 1 }
			}

ahachete

db.events.aggregate(
	[
   		{ $match: { "payload.action": { $exists: true } } },
   		{ $group: { _id: "$payload.action", total: { $sum: 1 } } },
   		{ $sort: { total: 1 } }
	],
	{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);

ahachete

db.events.aggregate(
	[
   		{ $group: { _id: "$type", total: { $sum: 1 } } },
   		{ $sort: { total: -1 } }
	],
	{ allowDiskUse: true, cursor: { batchSize: 100000000 } }
);