支持的命令列表
用户在连接到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 |
√ |
√ |
“√”表示支持，“×”表示不支持。
