Github Archive IssuesEvent

IssuesEvent.json

{
    "type": "IssuesEvent",
    "actor": {
        "avatar_url": "https://secure.gravatar.com/avatar/96270e4c3e5e9806cf7245475c00b275?d=http://github.dev%2Fimages%2Fgravatars%2Fgravatar-user-420.png",
        "url": "https://api.github.dev/users/addyosmani",
        "login": "addyosmani",
        "id": 110953,
        "gravatar_id": "96270e4c3e5e9806cf7245475c00b275"
    },
    "repo": {
        "url": "https://api.github.dev/repos/addyosmani/todomvc",
        "id": 1844251,
        "name": "addyosmani/todomvc"
    },
    "public": true,
    "payload": {
        "action": "closed",
        "issue": {
            "html_url": "https://github.com/addyosmani/todomvc/issues/22",
            "comments": 1,
            "url": "https://api.github.com/repos/addyosmani/todomvc/issues/22",
            "closed_at": "2012-01-01T01:21:46Z",
            "labels": [],
            "updated_at": "2012-01-01T01:21:46Z",
            "state": "closed",
            "milestone": null,
            "assignee": {
                "avatar_url": "https://secure.gravatar.com/avatar/96270e4c3e5e9806cf7245475c00b275?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png",
                "url": "https://api.github.com/users/addyosmani",
                "login": "addyosmani",
                "id": 110953,
                "gravatar_id": "96270e4c3e5e9806cf7245475c00b275"
            },
            "body": "In the index.html file there is this code:\r\n\r\n\r\n\r\nThis fails while loading from the file:// scheme for obvious reasons.\r\nNot sure if it should be considered a bug but in chrome 14 it's quite annoying having the page trying to load for some time before failing.",
            "pull_request": {
                "html_url": null,
                "patch_url": null,
                "diff_url": null
            },
            "user": {
                "avatar_url": "https://secure.gravatar.com/avatar/37fc491db95105ff67aa9b45a2834dca?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png",
                "url": "https://api.github.com/users/graphnode",
                "login": "graphnode",
                "id": 216518,
                "gravatar_id": "37fc491db95105ff67aa9b45a2834dca"
            },
            "id": 2016566,
            "created_at": "2011-10-21T15:27:47Z",
            "title": "Twitter \"widgets.js\" fails when in file://",
            "number": 22
        }
    },
    "id": "1508515785",
    "created_at": "2012-01-01T01:21:48Z"
}

recommend.pig

/* Create issues events - implies a user has already downloaded/forked and tried the software */
issues_events = LOAD '/tmp/IssuesEvent' AS (json: map[]); /* s3://github-explorer/IssuesEvent */
issues_ratings = FOREACH issues_events GENERATE (chararray)$0#'actor_attributes'#'login' AS follower:chararray,
                                                StringConcat((chararray)$0#'repository'#'owner', '/', $0#'repository'#'name') AS repo:chararray,
                                                2.0 AS rating;