search

pingcap / ossinsight

Analysis, Comparison, Trends, Rankings of Open Source Software, you can also get insight from more than 7 billion with natural language (powered by OpenAI). Follow us on Twitter: https://twitter.com/ossinsight
https://ossinsight.io/
Apache License 2.0
1.77k stars 332 forks source link

[Explorer] Execution failed for question 1212077c-808d-4476-8cf7-6914512b58da: what are top contributors from poland #1770

Open lukaszgryglicki opened 2 months ago

lukaszgryglicki commented 2 months ago

Hi, It's failed to execute the question 1212077c-808d-4476-8cf7-6914512b58da what are top contributors from poland (errorType = error-query-timeout):

Error message

Query inactivity timeout

Generated SQL

SELECT
  gu.login AS user_login,
  COUNT(*) AS contributions
FROM
  github_events AS ge
  JOIN github_users AS gu ON ge.actor_id = gu.id
WHERE
  gu.country_code = 'PL'
  AND ge.actor_login NOT LIKE '%bot%'
GROUP BY
  user_login
ORDER BY
  contributions DESC
LIMIT
  20