Docker
docker run --name iotdb-cli -d ghcr.io/iotdb-lab/iotdb-cli
docker exec -it iotdb-cli iotdb
Installation
- Using
Cargo
cargo install -f iotdb-cli
cargo install -f --git https://github.com/iotdb-lab/iotdb-cli.git
- From binary
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
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
iotdb -h
▀██▀ ▄▄█▀▀██ █▀▀██▀▀█ ▀██▀▀█▄ ▀██▀▀█▄
██ ▄█▀ ██ ██ ██ ██ ██ ██
██ ██ ██ ██ ██ ██ ██▀▀▀█▄
██ ▀█▄ ██ ██ ██ ██ ██ ██
▄██▄ ▀▀█▄▄▄█▀ ▄██▄ ▄██▄▄▄█▀ ▄██▄▄▄█▀
Author: github.com/francis-du <me@francis.run>
Version: iotdb-cli 0.1.0
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 <endpoint> Set server endpoint, eg: `localhost:6667`
-f, --file <file> Execute batch form sql file, eg: `iotdb -f ddl.sql`
-H, --host <host> Set server hostname or ip address, eg: `127.0.0.1`
-p, --password <password> Set user password
-P, --port <port> Set server port
-t, --timezone <timezone> Set timezone, eg: `UTC+8`
-u, --user <user> Set user name
ARGS:
<sql> 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
- Connect to IoTDB server
- Use default username and password
$ iotdb "SHOW STORAGE GROUP"
+---------------+
| storage group |
+---------------+
| root.ln |
| root.sg1 |
+---------------+
- Specify parameters
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
- Execute single SQL interactively
$ 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.1.0
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 |
+---------------+
- Execute sql from the specified sql file
$ 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
- Print usage info
$ iotdb usage