# 启动CLI客户端
# cd /fgeudb/iotdb/sbin
# ./start-cli.sh -h 192.168.1.51 -p 6667 -u root -pw root

# 输出示例如下：
Starting IoTDB Cli
_____ _________ ______ ______
|_ _| | _ _ ||_ _ `.|_ _ \
| | .–.|_/ | | \_| | | `. \ | |_) |
| | / (`–‘) | | | | | | | __’.
_| |_| `.___.’ _| |_ _| |_.’ /_| |__) )
|_____| |_____| |______.’|_______/

IoTDB Client version: 1.3.7
IoTDB>

# 查看版本
IoTDB> show version;

+—————+
| version|
+—————+
| 1.3.7 |
+—————+
Total line number = 1

# 查看服务器状态
IoTDB> show server info;

+———————-+———————-+
| ServerInfo| Value|
+———————-+———————-+
| System Version| 1.3.7|
| System BuildTime| 2025-03-04T07:52:00|
| System CPUUsage| 5.2%|
| System MemoryUsage| 45.6%|
+———————-+———————-+

创建存储组和时间序列

# 创建存储组
IoTDB> CREATE STORAGE GROUP root.ln;

# 输出示例如下：
Msg: The statement is executed successfully.

# 创建时间序列
IoTDB> CREATE TIMESERIES root.ln.wf01.wt01.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN;

# 输出示例如下：
Msg: The statement is executed successfully.

IoTDB> CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=RLE;

# 输出示例如下：
Msg: The statement is executed successfully.

# 查看存储组
IoTDB> SHOW STORAGE GROUP;

+————-+
| StorageGroup|
+————-+
| root.ln |
+————-+
Total line number = 1

# 查看时间序列
IoTDB> SHOW TIMESERIES root.ln.**;

+—————————–+—–+——–+——–+
| Timeseries|Alias|DataType|Encoding|
+—————————–+—–+——–+——–+
|root.ln.wf01.wt01.temperature| null| FLOAT| RLE|
| root.ln.wf01.wt01.status| null| BOOLEAN| PLAIN|
+—————————–+—–+——–+——–+
Total line number = 2

插入和查询数据

# 插入数据
IoTDB> INSERT INTO root.ln.wf01.wt01(timestamp, status, temperature) VALUES (1712217600000, true, 25.5);

# 输出示例如下：
Msg: The statement is executed successfully.

IoTDB> INSERT INTO root.ln.wf01.wt01(timestamp, status, temperature) VALUES (1712217601000, false, 26.3);

# 输出示例如下：
Msg: The statement is executed successfully.

IoTDB> INSERT INTO root.ln.wf01.wt01(timestamp, status, temperature) VALUES (1712217602000, true, 27.1);

# 输出示例如下：
Msg: The statement is executed successfully.

# 查询数据
IoTDB> SELECT * FROM root.ln.wf01.wt01;

+—————————–+—————————–+————————+
| Time|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status|
+—————————–+—————————–+————————+
|2026-04-04T10:00:00.000+08:00| 25.5| true|
|2026-04-04T10:00:01.000+08:00| 26.3| false|
|2026-04-04T10:00:02.000+08:00| 27.1| true|
+—————————–+—————————–+————————+
Total line number = 3

# 聚合查询
IoTDB> SELECT COUNT(temperature), AVG(temperature), MAX_VALUE(temperature) FROM root.ln.wf01.wt01;

+—————————-+—————————–+—————————+
|COUNT(root.ln.wf01.wt01.temperature)|AVG(root.ln.wf01.wt01.temperature)|MAX_VALUE(root.ln.wf01.wt01.temperature)|
+—————————-+—————————–+—————————+
| 3| 26.300000000000000| 27.1|
+—————————-+—————————–+—————————+
Total line number = 1

# 退出客户端
IoTDB> quit;

REST API测试

# 使用curl测试REST API
$ curl -X POST “http://192.168.1.51:8181/rest/v1/sql” \
-H “Content-Type: application/json” \
-d ‘{“sql”: “SHOW STORAGE GROUP”}’

# 输出示例如下：
{
“code”: 200,
“message”: “SUCCESS”,
“result”: {
“columnNames”: [“StorageGroup”],
“columnTypes”: [“STRING”],
“values”: [[“root.ln”]]
}
}

# 插入数据
$ curl -X POST “http://192.168.1.51:8181/rest/v1/sql” \
-H “Content-Type: application/json” \
-d ‘{“sql”: “INSERT INTO root.ln.wf01.wt01(timestamp, temperature) VALUES (1712217603000, 28.0)”}’

# 输出示例如下：
{
“code”: 200,
“message”: “SUCCESS”
}

# 查询数据
$ curl -X POST “http://192.168.1.51:8181/rest/v1/sql” \
-H “Content-Type: application/json” \
-d ‘{“sql”: “SELECT * FROM root.ln.wf01.wt01”}’

# 输出示例如下：
{
“code”: 200,
“message”: “SUCCESS”,
“result”: {
“columnNames”: [“Time”, “root.ln.wf01.wt01.temperature”, “root.ln.wf01.wt01.status”],
“columnTypes”: [“LONG”, “FLOAT”, “BOOLEAN”],
“values”: [
[1712217600000, 25.5, true],
[1712217601000, 26.3, false],
[1712217602000, 27.1, true],
[1712217603000, 28.0, null]
]
}
}