查询某个字段
q=SELECT real_used_size FROM opensips WHERE time > '2019-12-05T00:10:00Z'
正常查询结果，下面是例子，和上面的sql没有关系。
:::warning 时间必须用单引号括起来，不能用双引号，格式也必须是YYYY-MM-DDTHH:MM:SSZ :::
{
"results": [
{
"statement_id": 0,
"series": [
{
"name": "cpu_load_short",
"columns": [
"time",
"value"
],
"values": [
[
"2015-01-29T21:55:43.702900257Z",
2
],
[
"2015-01-29T21:55:43.702900257Z",
0.55
],
[
"2015-06-11T20:46:02Z",
0.64
]
]
}
]
}
]
}
如果有报错，数组项中的某一个会有error属性，值为报错原因
{
"results":[
{
"statement_id": 0,
"error": "invalid operation: time and *influxql.StringLiteral are not compatible"
}
]
}
批次查询
语句之间用分号隔开
q=SELECT real_used_size FROM opensips WHERE time > '2019-12-05T00:10:00Z';SELECT real_used_size FROM opensips WHERE time > '2019-12-09T00:10:00Z'
返回结果中的statement_id就表示对应的语句
{
"results": [
{
"statement_id": 0,
"series": [
{
"name": "cpu_load_short",
"columns": [
"time",
"value"
],
"values": [
[
"2015-01-29T21:55:43.702900257Z",
2
],
[
"2015-01-29T21:55:43.702900257Z",
0.55
],
[
"2015-06-11T20:46:02Z",
0.64
]
]
}
]
},
{
"statement_id": 1,
"series": [
{
"name": "cpu_load_short",
"columns": [
"time",
"count"
],
"values": [
[
"1970-01-01T00:00:00Z",
3
]
]
}
]
}
]
}
查询结果 按分钟求平均值
q=SELECT MEAN(real_used_size) FROM opensips WHERE time > '2019-12-05T03:10:00Z' GROUP BY time(1m)
其他查询参数
| chunked=[true | | ||
|---|---|---|
| db=<database_name> | ||
| epoch=[ns,u,µ,ms,s,m,h] | ||
| p= | ||
| pretty=true | ||
| q= | ||
| u= |