Esta página aún no está disponible en su idioma local. Estamos trabajando arduamente para agregar más versiones de idiomas. Gracias por tu apoyo.
Supported Commands
The following table lists the commands supported by GeminiDB Influx.
User Management
Command |
Supported In Write Mode |
Supported In Read-Only Mode |
---|---|---|
create user |
√ |
√ |
show user |
√ |
√ |
drop user |
√ |
√ |
set password |
√ |
√ |
grant |
√ |
√ |
show grants |
√ |
√ |
revoke |
√ |
√ |
CLI Commands Used on Influx-client
Command |
Supported In Write Mode |
Supported In Read-Only Mode |
---|---|---|
connect |
√ |
√ |
auth |
√ |
√ |
pretty |
√ |
√ |
chunked |
√ |
√ |
chunk size |
√ |
√ |
use |
√ |
√ |
fromat |
√ |
√ |
precision |
√ |
√ |
consistency |
√ |
√ |
history |
√ |
√ |
settings |
√ |
√ |
clear |
√ |
√ |
exit/quit/ctrl+d |
√ |
√ |
Metadata Management
Command |
Supported In Write Mode |
Supported In Read-Only Mode |
---|---|---|
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 |
√ |
√ |
Monitoring and Management of Queries
Command |
Supported In Write Mode |
Supported In Read-Only Mode |
---|---|---|
kill query |
√ |
√ |
show queries |
√ |
√ |
Querying, Writing, and Deleting Data Points
Command |
Supported In Write Mode |
Supported In Read-Only Mode |
---|---|---|
select |
√ |
√ |
select xxx into |
√ |
√ |
insert into |
√ |
× |
insert |
√ |
× |
limit |
√ |
√ |
offset |
√ |
√ |
delete |
√ |
√ |
explain |
√ |
√ |
explain analyze |
√ |
√ |
Aggregate Functions
Command |
Supported In Write Mode |
Supported In Read-Only Mode |
---|---|---|
count |
√ |
√ |
distinct |
√ |
√ |
integral |
√ |
√ |
mean |
√ |
√ |
median |
√ |
√ |
mode |
√ |
√ |
spread |
√ |
√ |
stddev |
√ |
√ |
sum |
√ |
√ |
SELECT Function
Command |
Supported In Write Mode |
Supported In Read-Only Mode |
---|---|---|
bottom |
√ |
√ |
top |
√ |
√ |
first |
√ |
√ |
last |
√ |
√ |
max |
√ |
√ |
min |
√ |
√ |
percentile |
√ |
√ |
sample |
√ |
√ |
Conversion Function
Command |
Supported In Write Mode |
Supported In Read-Only Mode |
---|---|---|
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 |
√ |
√ |
√ indicates that an item is supported, and × indicates that an item is not supported.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.