支持的命令列表
用户在连接到GeminiDB Influx数据库后,需要关注以下支持的命令。
GeminiDB Influx常用的命令、基础语法以及示例,可参考购买并连接GeminiDB Influx实例。
用户管理
命令名称 |
读写模式下是否支持该命令 |
只读模式下是否支持该命令 |
---|---|---|
create user |
√ |
√ |
show user |
√ |
√ |
drop user |
√ |
√ |
set password |
√ |
√ |
grant |
√ |
√ |
show grants |
√ |
√ |
revoke |
√ |
√ |
influx client登录后的CLI
命令名称 |
读写模式下是否支持该命令 |
只读模式下是否支持该命令 |
---|---|---|
connect |
√ |
√ |
auth |
√ |
√ |
pretty |
√ |
√ |
chunked |
√ |
√ |
chunk size |
√ |
√ |
use |
√ |
√ |
fromat |
√ |
√ |
precision |
√ |
√ |
consistency |
√ |
√ |
history |
√ |
√ |
settings |
√ |
√ |
clear |
√ |
√ |
exit/quit/ctrl+d |
√ |
√ |
元数据管理
命令名称 |
读写模式下是否支持该命令 |
只读模式下是否支持该命令 |
---|---|---|
create database |
√ |
√ |
show databases |
√ |
√ |
drop database |
√ |
√ |
show measurements |
√ |
√ |
show measurement cardinality |
√ |
√ |
show measurement exact cardinality |
√ |
√ |
drop measurement |
√ |
√ |
create retention policy |
√ |
√ |
alter retention policy |
√ |
√ |
drop retention policy |
√ |
√ |
show retention policies |
√ |
√ |
create continuous query |
√ |
√ |
show continuous queries |
√ |
√ |
drop continuous query |
√ |
√ |
show series |
√ |
√ |
show series cardinality |
√ |
√ |
show series exact cardinality |
√ |
√ |
drop series |
√ |
√ |
show tag keys |
√ |
√ |
show tag key cardinality |
√ |
√ |
show tag key exact cardinality |
√ |
√ |
show tag values |
√ |
√ |
show tag values cardinality |
√ |
√ |
show tag values exact cardinality |
√ |
√ |
show field keys |
√ |
√ |
show field key cardinality |
√ |
√ |
show field key exact cardinality |
√ |
√ |
show shards |
√ |
√ |
show shard groups |
√ |
√ |
drop shard |
√ |
√ |
查询监控和管理
命令名称 |
读写模式下是否支持该命令 |
只读模式下是否支持该命令 |
---|---|---|
kill query |
√ |
√ |
show queries |
√ |
√ |
数据点查询、写入和删除
命令名称 |
读写模式下是否支持该命令 |
只读模式下是否支持该命令 |
---|---|---|
select |
√ |
√ |
select xxx into |
√ |
√ |
insert into |
√ |
× |
insert |
√ |
× |
limit |
√ |
√ |
offset |
√ |
√ |
delete |
√ |
√ |
explain |
√ |
√ |
explain analyze |
√ |
√ |
聚合函数
命令名称 |
读写模式下是否支持该命令 |
只读模式下是否支持该命令 |
---|---|---|
count |
√ |
√ |
distinct |
√ |
√ |
integral |
√ |
√ |
mean |
√ |
√ |
median |
√ |
√ |
mode |
√ |
√ |
spread |
√ |
√ |
stddev |
√ |
√ |
sum |
√ |
√ |
选择函数
命令名称 |
读写模式下是否支持该命令 |
只读模式下是否支持该命令 |
---|---|---|
bottom |
√ |
√ |
top |
√ |
√ |
first |
√ |
√ |
last |
√ |
√ |
max |
√ |
√ |
min |
√ |
√ |
percentile |
√ |
√ |
sample |
√ |
√ |
转换函数
命令名称 |
读写模式下是否支持该命令 |
只读模式下是否支持该命令 |
---|---|---|
abs |
√ |
√ |
acos |
√ |
√ |
asin |
√ |
√ |
atan |
√ |
√ |
atan2 |
√ |
√ |
ceil |
√ |
√ |
cos |
√ |
√ |
sin |
√ |
√ |
tan |
√ |
√ |
sqrt |
√ |
√ |
round |
√ |
√ |
floor |
√ |
√ |
exp |
√ |
√ |
ln |
√ |
√ |
log2 |
√ |
√ |
log10 |
√ |
√ |
log |
√ |
√ |
pow |
√ |
√ |
cumulative_sum |
√ |
√ |
difference |
√ |
√ |
non_negative_difference |
√ |
√ |
derivative |
√ |
√ |
non_negative_derivative |
√ |
√ |
elapsed |
√ |
√ |
moving_average |
√ |
√ |
“√”表示支持,“×”表示不支持。