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

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.