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.