Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Test query on main page does not work #95

Closed
samtstern opened this issue Mar 9, 2015 · 1 comment
Closed

Test query on main page does not work #95

samtstern opened this issue Mar 9, 2015 · 1 comment

Comments

@samtstern
Copy link

The following query is listed on githubarchive.org

SELECT event as issue_status, COUNT(*) as cnt FROM (
  SELECT type, repo.name, actor.login,
    JSON_EXTRACT(payload, '$.action') as event, 
  FROM (TABLE_DATE_RANGE(day.events_, 
    TIMESTAMP('2015-01-01'), 
    TIMESTAMP('2015-02-01')
  )) 
  WHERE type = 'IssuesEvent'
)
GROUP by issue_status;

However if you create a new Google Developer's Console project and run that, you will get an error. The solution is to replace day.events_ with githubarchive:day.events_.

@igrigorik
Copy link
Owner

Thanks, should be fixed now!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants