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

[Explorer] Some problem for question 1e41e3c7-f0ae-4b5f-a55b-4f0a6c7333f8: who are the top 5 contributors of TiDB? #1568

Open
Mini256 opened this issue Aug 3, 2023 · 0 comments

Comments

@Mini256
Copy link
Member

Mini256 commented Aug 3, 2023

Hi, I have some problems with the question 1e41e3c7-f0ae-4b5f-a55b-4f0a6c7333f8 who are the top 5 contributors of TiDB? (errorType = none):

Generated SQL

SELECT
  actor_login,
  COUNT(*) AS contributions
FROM
  github_events
WHERE
  repo_name = 'pingcap/tidb'
GROUP BY
  actor_login
ORDER BY
  contributions DESC
LIMIT
  5

Chart:

{
  "chartName": "Table",
  "columns": [
    "Contributor",
    "Contributions"
  ],
  "title": "Top 5 Contributors of TiDB"
}

Result:

// Fields
  [
  {
    "columnType": 253,
    "name": "actor_login"
  },
  {
    "columnType": 8,
    "name": "contributions"
  }
]

// First result (Totally 5 rows)
  {
  "actor_login": "ti-chi-bot",
  "contributions": 99041
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant