ossinsight
ossinsight copied to clipboard
[Explorer] Execution failed for question 9d9228a1-20d2-4515-a797-df3a1e7944f0: In GitHub, find the top 10 users who only commit code on Saturdays or Sundays and have no commit records from Monday to Friday
Hi, It's failed to execute the question 9d9228a1-20d2-4515-a797-df3a1e7944f0 In GitHub, find the top 10 users who only commit code on Saturdays or Sundays and have no commit records from Monday to Friday (errorType = error-query-execute):
- executedAt: 2023-06-28T03:15:07.000+00:00
- requestedAt: 2023-06-28T03:15:07.000+00:00
Error message
other error for mpp stream: From MPP<query:442478652766552153,task:5>: Code: 0, e.displayText() = DB::TiFlashException: Memory limit (total) exceeded caused by 'out of memory quota for data computing' : would use 104.00 GiB for data computing (attempt to allocate chunk of 1179648 bytes), limit of memory for data computing: 104.00 GiB, e.what() = DB::TiFlashException,
Generated SQL
SELECT
actor_login,
COUNT(*) AS commit_count
FROM
github_events
WHERE
DAYOFWEEK(created_at) IN (1, 7)
AND actor_login NOT IN(
SELECT
actor_login
FROM
github_events
WHERE
DAYOFWEEK(created_at) BETWEEN 2 AND 6
)
GROUP BY
actor_login
ORDER BY
commit_count DESC
LIMIT
10