我偶然遇到了查询来计算SO声誉的CDF:
SELECT
Reputation,
SUM(COUNT(*)) OVER(
ORDER BY Reputation
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS UserCount
FROM
Users
GROUP BY Reputation
ORDER BY Reputation
我制作了自己的查询,看起来像
select reputation, cume_dist() over (order by reputation)
from users
gro
但是搭建了本地DNS,客户端(windows)创建后立马报NOT IMPLEMENTED,buffer_read_ipv4_address_at,是Windows不支持,但是我看教程搭建都是客户端是windows,不搭建本地DNS,直接设置权威服务器DNS,返回只有answer<1,会直接报DNS DNS didn't return an answer