Fix for "Top commented issues for each of the top repositories"
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 72/100
Research direction
Start with the aggregation in queries.sql around line 671 and compare it with the matching query in index.html around line 3685. Check the top-commented-issues result to confirm that each row's stars value is preserved rather than combined across rows, then verify both copies produce the same output.
Written by the indexing model from the issue text.
Description
I think sum is wrong here. Each row contains the total number of stars.
---
index.html | 2 +-
queries.sql | 2 +-
2 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/index.html b/index.html
index a1b6343..03af266 100644
--- a/index.html
+++ b/index.html
@@ -3685,7 +3685,7 @@ LIMIT 50</span>
max(comments),
argMax(authors, comments) AS authors,
argMax(number, comments) AS number,
- sum(stars) AS stars
+ any(stars) AS stars
FROM
(
SELECT *
diff --git a/queries.sql b/queries.sql
index 938e358..e7c13a6 100644
--- a/queries.sql
+++ b/queries.sql
@@ -671,7 +671,7 @@ SELECT
max(comments),
argMax(authors, comments) AS authors,
argMax(number, comments) AS number,
- sum(stars) AS stars
+ any(stars) AS stars
FROM
(
SELECT *
--
- Dominant language
- HTML
- Stars
- 180
- Forks
- 19
- Avg merge
- 3h 8m
- Merged PRs (30d)
- 1
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from ClickHouse/github-explorer
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
ClickHouse/github-explorer#10 · 5 comments · 1 reaction ·
-
Difficulty 5/5 Over a week Newbie friendliness 15/100
ClickHouse/github-explorer#8 · 5 comments · 1 reaction ·
-
Difficulty 1/5 Under an hour Newbie friendliness 20/100
ClickHouse/github-explorer#6 · 8 comments ·
-
The `body` attribute of `PullRequestReviewComment` event is from PR itself, not from the comment. Open
Difficulty 3/5 1-2 days Newbie friendliness 25/100
ClickHouse/github-explorer#3 · 1 comment ·
All issues in ClickHouse/github-explorer
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 74/100
bancolombia/sentinel#23 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
AOSSIE-Org/OrgExplorer#245 · 1 assignee ·
-
tech-debt
Difficulty 2/5 1-3 hours Newbie friendliness 78/100
-
Difficulty 2/5 1-3 hours Newbie friendliness 72/100
gordonwatts/test-wsl2-llm#151 ·
-
bug
Difficulty 2/5 1-3 hours Newbie friendliness 72/100