TimescaleDB时序分析函数

TimescaleDB时序分析函数

一、first()

first(value, time)获取分组内返回时间最早的数据
代码如下（示例）：

SELECT
	station_id,
	first( jsondata, dcollectdate )  
FROM
	sc_customer_data 
GROUP BY
	station_id

2. last()

last(value, time)获取分组内返回时间最晚的数据

代码如下（示例）：

SELECT
	station_id,
	LAST ( jsondata, dcollectdate )  
FROM
	sc_customer_data 
GROUP BY
	station_id

3.time_bucket()

time_bucket()每隔一段时间进行聚合查询

查询每隔五分钟的最后一条数据
SELECT
	time_bucket ( '5 minutes', dcollectdate ) AS TIME,
	LAST ( jsondata, dcollectdate ) 
FROM
	sc_customer_data 
WHERE
	station_id = 'ff1eed991ae90ad3e0c50bf14a0a3c21' 
GROUP BY
TIME 
ORDER BY
	TIME DESC;