Help Center/ GeminiDB/ GeminiDB Influx API/ Working with GeminiDB Influx API/ Database Commands/ Supported Commands

Updated on 2023-11-21 GMT+08:00

View PDF

Supported Commands

The following table lists the commands supported by GeminiDB Influx.

For GeminiDB Influx common commands, basic syntax, and examples, see Buying and Connecting to a GeminiDB Influx Instance.

User Management

**Table 1** Commands supported by 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

**Table 2** 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

**Table 3** Commands supported by 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

**Table 4** Commands for 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

**Table 5** Commands supported by 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

**Table 6** Commands supported by aggregate functions
Command	Supported In Write Mode	Supported In Read-Only Mode
count	√	√
distinct	√	√
integral	√	√
mean	√	√
median	√	√
mode	√	√
spread	√	√
stddev	√	√
sum	√	√

SELECT Function

**Table 7** Commands supported by the SELECT function
Command	Supported In Write Mode	Supported In Read-Only Mode
bottom	√	√
top	√	√
first	√	√
last	√	√
max	√	√
min	√	√
percentile	√	√
sample	√	√

Conversion Function

**Table 8** Commands supported by the 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.

Parent topic: Database Commands

Previous topic: Database Commands

Next topic: Cold and Hot Data Separation

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.