# 输出示例如下：
Welcome to the TDengine shell from Linux, Client Version:3.4.0.9
Copyright (c) 2023 by TAOS Data, Inc. All rights reserved.

taos> SHOW DATABASES;

name |
=================================
information_schema |
performance_schema |

# 查看服务器状态
taos> SHOW DNODES;

id | endpoint | vnodes | support_vnodes | status | create_time | reboot_time |
======================================================================================================================================
1 | 192.168.1.51:6030 | 0 | 256 | ready | 2026-04-04 10:15:00.000 | 2026-04-04 10:15:00.000 |

# 查看版本
taos> SELECT SERVER_VERSION();

server_version() |
===================
3.4.0.9 |

# 查看服务器状态
taos> SELECT SERVER_STATUS();

server_status() |
==================
ready |

创建超级表和子表

# 使用数据库
taos> USE iot;

# 创建超级表
taos> CREATE STABLE meters (ts TIMESTAMP, current FLOAT, voltage INT, phase FLOAT)
-> TAGS (location BINARY(64), groupId INT);

# 输出示例如下：
Create stable success

# 创建子表
taos> CREATE TABLE d1001 USING meters TAGS (“Beijing.Chaoyang”, 2);

# 输出示例如下：
Create table success

# 插入数据
taos> INSERT INTO d1001 VALUES
-> (NOW, 10.3, 219, 0.31)
-> (NOW + 1s, 12.6, 218, 0.33)
-> (NOW + 2s, 12.3, 221, 0.31);

# 输出示例如下：
Insert success, 3 row(s) affected (0.001000s)

# 查询数据
taos> SELECT * FROM d1001;

ts | current | voltage | phase |
================================================================================
2026-04-04 10:20:00.000 | 10.30 | 219 | 0.31 |
2026-04-04 10:20:01.000 | 12.60 | 218 | 0.33 |
2026-04-04 10:20:02.000 | 12.30 | 221 | 0.31 |

# 聚合查询
taos> SELECT AVG(current), MAX(voltage), MIN(phase) FROM meters;

avg(current) | max(voltage) | min(phase) |
=========================================================
11.733333 | 221 | 0.31 |

RESTful API测试

# 输出示例如下：
{
“status”: “succ”,
“head”: [“name”],
“column_meta”: [[“name”, 8, 32]],
“data”: [
[“information_schema”],
[“performance_schema”],
[“testdb”],
[“iot”]
],
“rows”: 4
}

# 执行SQL查询
$ curl -u root:taosdata -d ‘select * from iot.d1001’ http://192.168.1.51:6041/rest/sql

# 输出示例如下：
{
“status”: “succ”,
“head”: [“ts”, “current”, “voltage”, “phase”],
“column_meta”: [
[“ts”, 9, 8],
[“current”, 6, 4],
[“voltage”, 4, 4],
[“phase”, 6, 4]
],
“data”: [
[“2026-04-04 10:20:00.000”, 10.3, 219, 0.31],
[“2026-04-04 10:20:01.000”, 12.6, 218, 0.33],
[“2026-04-04 10:20:02.000”, 12.3, 221, 0.31]
],
“rows”: 3
}

taosBenchmark性能测试

# 输出示例如下：
taosBenchmark is running…
Create database: test
Create stable: meters
Create tables: 10000
Insert data: 10000000 rows
Insert speed: 500000 rows/second
Query speed: 100000 queries/second

# 简单写入测试
$ taosBenchmark -d test -t 1000 -n 100000 -v 4

# 参数说明：
# -d: 数据库名
# -t: 表数量
# -n: 每表记录数
# -v: 字段数量

# 输出示例如下：
Creating database: test
Creating stable: stb
Creating 1000 tables
Inserting 100000000 records…
Insert completed in 200.00 seconds
Insert speed: 500000 rows/second