Docker

shell docker run --name iotdb-cli -d ghcr.io/iotdb-lab/iotdb-cli docker exec -it iotdb-cli iotdb

Installation

1. Using Cargo

```shell cargo install -f iotdb-cli

cargo install -f --git https://github.com/iotdb-lab/iotdb-cli.git ```

1. From binary

```shell curl -s https://raw.githubusercontent.com/iotdb-lab/iotdb-cli/main/install.sh | bash

curl -s https://raw.githubusercontent.com/iotdb-lab/iotdb-cli/main/install.sh | bash -s -- x.x.x ```

```shell wget -qO- https://raw.githubusercontent.com/iotdb-lab/iotdb-cli/main/install.sh | bash

wget -qO- https://raw.githubusercontent.com/iotdb-lab/iotdb-cli/main/install.sh | bash -s -- x.x.x ```

Usage

shell iotdb -h

```shell

▀██▀ ▄▄█▀▀██ █▀▀██▀▀█ ▀██▀▀█▄ ▀██▀▀█▄ ██ ▄█▀ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██▀▀▀█▄ ██ ▀█▄ ██ ██ ██ ██ ██ ██ ▄██▄ ▀▀█▄▄▄█▀ ▄██▄ ▄██▄▄▄█▀ ▄██▄▄▄█▀

Author: github.com/francis-du me@francis.run Version: iotdb-cli 0.0.3

USAGE: iotdb [FLAGS] [OPTIONS] [sql] [SUBCOMMAND]

FLAGS: -d, --debug Enable debug mode --dev Dev server -h, --help Prints help information -V, --version Prints version information

OPTIONS: -e, --endpoint Set server endpoint, eg: localhost:6667 -f, --file Execute batch form sql file, eg: iotdb -f ddl.sql -H, --host Set server hostname or ip address, eg: 127.0.0.1 -p, --password Set user password -P, --port Set server port -t, --timezone Set timezone, eg: UTC+8 -u, --user Set user name

ARGS: Execute single sql, eg: iotdb "show storage group"

SUBCOMMANDS: csv Csv util(TODO) file Execute batch form sql file, eg: iotdb file ddl.sql help Prints this message or the help of the given subcommand(s) load Load TsFile util (TODO) update Update binary (TODO) usage Print usage info version Prints server version information ```

1. Connect to IoTDB server

• Use default username and password

shell $ iotdb "SHOW STORAGE GROUP" +---------------+ | storage group | +---------------+ | root.ln | | root.sg1 | +---------------+

• Specify parameters

```shell iotdb -u root -p root -e 127.0.0.1:6667 -t UTC+8

or

iotdb -u root -p root -H 127.0.0.1 -P 6667 -t UTC+8 ```

1. Execute single SQL interactively

```shell $ iotdb -u root -p root --e 127.0.0.1:6667 -t UTC+8

▀██▀ ▄▄█▀▀██ █▀▀██▀▀█ ▀██▀▀█▄ ▀██▀▀█▄ ██ ▄█▀ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██ ██▀▀▀█▄ ██ ▀█▄ ██ ██ ██ ██ ██ ██ ▄██▄ ▀▀█▄▄▄█▀ ▄██▄ ▄██▄▄▄█▀ ▄██▄▄▄█▀

Author: github.com/francis-du me@francis.run Version: iotdb-cli v0.0.3 Usage: 1. Print usage info: ? or help 2. Exec system command on OS: !ps 3. Exit: exit or quit or Ctrl-C or Ctrl-D IOTDB#(127.0.0.1:6667)> SHOW STORAGE GROUP +---------------+ | storage group | +---------------+ | root.ln | | root.sg1 | +---------------+ ```

1. Execute sql from the specified sql file

shell $ iotdb file tests/create_and_insert.sql $ iotdb -file tests/create_and_insert.sql $ iotdb -f tests/create_and_insert.sql Statements: [ "DELETE STORAGE GROUP root.test;", "CREATE TIMESERIES root.test.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN;", "CREATE TIMESERIES root.test.temperature WITH DATATYPE=FLOAT, ENCODING=RLE;", "INSERT INTO root.test(timestamp, status)\n values (1637960249484, true);", "INSERT INTO root.test(timestamp, status, temperature)\n values (1637960256493, false, 20.71);", "INSERT INTO root.test(timestamp, status, temperature)\n values (1637960261494, true, 32.43);", "INSERT INTO root.test(timestamp, status, temperature)\n values (1637960272492, false, 28.66);", "INSERT INTO root.test(timestamp, status, temperature)\n values (1637960272492, true, 22.61);", "INSERT INTO root.test(timestamp, status, temperature)\n values (1637960296493, false, 28.66);", ] 23:00:23 [INFO] Execute batch statements successfully

1. Print usage info

shell $ iotdb usage

License

Apache License 2.0