ossinsight icon indicating copy to clipboard operation
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

Open happy-v587 opened this issue 1 year ago • 0 comments

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

happy-v587 avatar Jun 28 '23 03:06 happy-v587