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
[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
#1520
Open
happy-v587 opened this issue
Jun 28, 2023
· 0 comments
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 2AND6
)
GROUP BY
actor_login
ORDER BY
commit_count DESCLIMIT10
The text was updated successfully, but these errors were encountered:
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):
Error message
Generated SQL
The text was updated successfully, but these errors were encountered: