You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
SELECT
name, login, prNum, created_at, action
FROM (
SELECT
repo.name,
actor.login,
JSON_EXTRACT(payload,'$.action') AS action,
JSON_EXTRACT(payload,'$.number') AS prNum,
JSON_EXTRACT(payload,'$.pull_request.created_at') AS created_at,
FROM
`githubarchive.month.202002`
WHERE
type = 'PullRequestEvent')
WHERE
name = 'willycornelissen/willycornelissen.github.io' AND
prNum = '1'
On executing the following on bigquery:
The result list is:
I don't see how this is possible because it would mean that the same pull request would be created in multiple events at different times. Issuing a call to the github api (https://api.github.com/repos/willycornelissen/willycornelissen.github.io/pulls/1) we can see that the
latest
event seems okay.Can someone shed some light on what could be happening?
The text was updated successfully, but these errors were encountered: