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

Updated on 2025-04-09 GMT+08:00

Supported Commands

The following table lists the commands supported by GeminiDB Influx API.

User Management

**Table 1** Commands supported by user management
Command	Supported In Read/Write Mode	Supported In Read-Only Mode
create user	√	√
show user	√	√
drop user	√	√
set password	√	√
grant	√	√
show grants	√	√
revoke	√	√

CLI Commands Used on an InfluxDB Client

**Table 2** CLI commands used on an InfluxDB client
Command	Supported In Read/Write Mode	Supported In Read-Only Mode
connect	√	√
auth	√	√
pretty	√	√
chunked	√	√
chunk size	√	√
use	√	√
format	√	√
precision	√	√
consistency	√	√
history	√	√
settings	√	√
clear	√	√
exit/quit/ctrl+d	√	√

Metadata Management

**Table 3** Commands supported by metadata management
Command	Supported In Read/Write Mode	Supported In Read-Only Mode
create database	√	√
show databases	√	√
drop database	√	√
show measurements	√	√
show measurement cardinality	√	√
show measurement exact cardinality	√	√
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 Read/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 Read/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 Read/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 Read/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 Read/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