influxdb 如何按 field 去重计数

V2EX = way to explore

V2EX 是一个关于分享和探索的地方

For Existing Member Sign In

This topic created in 3064 days ago, the information mentioned may be changed or developed.

SELECT count("user_id") FROM "alg_read_log" Where time >= now() - 7d GROUP BY time(1d) fill(null)

SELECT count("id") FROM "alg_read_log" Where time >= now() - 7d GROUP BY time(1d) fill(null)

以上两个语句返回的数据一样。期望第一个语句能够对用户总数计数，而非记录数。在 influxdb 中是否有方法可以实现呢？

1 replies • 2017-12-19 11:15:32 +08:00

yongzhong

Dec 19, 2017

获得总数要 JOIN 才行
为何不加个定时脚本每分钟把 count 再存到另外一个 measurement 里然后读这个就好了