ClickHouse / ClickHouse/github-explorer

Fix for "Top commented issues for each of the top repositories"

未关闭
#21 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看
主要语言
HTML
星标
180
派生
19
平均合并
3 小时 8 分钟
30 天内合并 PR
1

描述

I think `sum` is wrong here. Each row contains the total number of stars.

```patch
---
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
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 *
--
```

贡献指南

这个仓库没有索引到贡献指南

评估

这个 Issue 还没有评估数据。

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。