This is an automated email from the ASF dual-hosted git repository.
qiaojialin pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/iotdb.git
The following commit(s) were added to refs/heads/master by this push:
new 2ab81ae760 update Maintenance-Command.md (#6454)
2ab81ae760 is described below
commit 2ab81ae760a94aa696570c40b6736048ce0c6f7e
Author: 任宇华 <[email protected]>
AuthorDate: Mon Jun 27 23:10:27 2022 +0800
update Maintenance-Command.md (#6454)
Co-authored-by: renyuhua <[email protected]>
---
.../Maintenance-Tools/Maintenance-Command.md | 90 +++++++++++-----------
.../Maintenance-Tools/Maintenance-Command.md | 90 +++++++++++-----------
2 files changed, 92 insertions(+), 88 deletions(-)
diff --git a/docs/UserGuide/Maintenance-Tools/Maintenance-Command.md
b/docs/UserGuide/Maintenance-Tools/Maintenance-Command.md
index c24631b8f9..6df5352bf9 100644
--- a/docs/UserGuide/Maintenance-Tools/Maintenance-Command.md
+++ b/docs/UserGuide/Maintenance-Tools/Maintenance-Command.md
@@ -130,52 +130,54 @@ Currently, IoTDB supports Region query using the
following SQL：
- `SHOW DATA REGIONS`: Show all DataRegion distribution
```sql
+IoTDB> create timeseries root.sg.d1.s1 with datatype=BOOLEAN,encoding=PLAIN
+Msg: The statement is executed successfully.
+IoTDB> create timeseries root.sg.d2.s1 with datatype=BOOLEAN,encoding=PLAIN
+Msg: The statement is executed successfully.
+IoTDB> create timeseries root.ln.d1.s1 with datatype=BOOLEAN,encoding=PLAIN
+Msg: The statement is executed successfully.
IoTDB> show regions
-+--------+------------+------+-------------+-----+----------+----------+----+
-|RegionId| Type|Status|storage group|Slots|DataNodeId|Host|Port|
-+--------+------------+------+-------------+-----+----------+----------+----+
-| 0|SchemaRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 1|SchemaRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 2|SchemaRegion| Up| root.sg| 1| 4| 127.0.0.1|6671|
-| 3| DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 4| DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 5| DataRegion| Up| root.sg| 1| 1| 127.0.0.1|6667|
-| 6| DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 7| DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 8| DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 9| DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 10| DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 11| DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 12| DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-+--------+------------+------+-------------+-----+----------+----------+----+
-Total line number = 13
-It costs 0.107s
-IoTDB> show schema regions
-+--------+------------+------+-------------+-----+----------+----------+----+
-|RegionId| Type|Status|storage group|Slots|DataNodeId|Host|Port|
-+--------+------------+------+-------------+-----+----------+----------+----+
-| 0|SchemaRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 1|SchemaRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 2|SchemaRegion| Up| root.sg| 1| 4| 127.0.0.1|6671|
-+--------+------------+------+-------------+-----+----------+----------+----+
++--------+------------+------+-------------+-----+----------+---------+----+
+|RegionId| Type|Status|storage group|Slots|DataNodeId| Host|Port|
++--------+------------+------+-------------+-----+----------+---------+----+
+| 0|SchemaRegion| Up| root.sg| 2| 2|127.0.0.1|6669|
+| 1|SchemaRegion| Up| root.ln| 1| 3|127.0.0.1|6667|
++--------+------------+------+-------------+-----+----------+---------+----+
+Total line number = 2
+It costs 0.035s
+
+IoTDB> insert into root.sg.d1(timestamp,s1) values(1,true)
+Msg: The statement is executed successfully.
+IoTDB> show regions
++--------+------------+------+-------------+-----+----------+---------+----+
+|RegionId| Type|Status|storage group|Slots|DataNodeId| Host|Port|
++--------+------------+------+-------------+-----+----------+---------+----+
+| 0|SchemaRegion| Up| root.sg| 2| 2|127.0.0.1|6669|
+| 1|SchemaRegion| Up| root.ln| 1| 3|127.0.0.1|6667|
+| 2| DataRegion| Up| root.sg| 1| 1|127.0.0.1|6671|
++--------+------------+------+-------------+-----+----------+---------+----+
Total line number = 3
-It costs 0.009s
+It costs 0.010s
+
+IoTDB> insert into root.ln.d1(timestamp,s1) values(1,true)
+Msg: The statement is executed successfully.
IoTDB> show data regions
-+--------+----------+------+-------------+-----+----------+----------+----+
-|RegionId| Type|Status|storage group|Slots|DataNodeId|Host|Port|
-+--------+----------+------+-------------+-----+----------+----------+----+
-| 3|DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 4|DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 5|DataRegion| Up| root.sg| 1| 1| 127.0.0.1|6667|
-| 6|DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 7|DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 8|DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 9|DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 10|DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 11|DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 12|DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-+--------+----------+------+-------------+-----+----------+----------+----+
-Total line number = 10
-It costs 0.023s
++--------+----------+------+-------------+-----+----------+---------+----+
+|RegionId| Type|Status|storage group|Slots|DataNodeId| Host|Port|
++--------+----------+------+-------------+-----+----------+---------+----+
+| 2|DataRegion| Up| root.sg| 1| 1|127.0.0.1|6671|
+| 3|DataRegion| Up| root.ln| 1| 1|127.0.0.1|6671|
++--------+----------+------+-------------+-----+----------+---------+----+
+Total line number = 2
+It costs 0.011s
+IoTDB> show schema regions
++--------+------------+------+-------------+-----+----------+---------+----+
+|RegionId| Type|Status|storage group|Slots|DataNodeId| Host|Port|
++--------+------------+------+-------------+-----+----------+---------+----+
+| 0|SchemaRegion| Up| root.sg| 2| 2|127.0.0.1|6669|
+| 1|SchemaRegion| Up| root.ln| 1| 3|127.0.0.1|6667|
++--------+------------+------+-------------+-----+----------+---------+----+
+Total line number = 2
+It costs 0.012s
```
diff --git a/docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md
b/docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md
index 33a28e45ed..875014ad75 100644
--- a/docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md
+++ b/docs/zh/UserGuide/Maintenance-Tools/Maintenance-Command.md
@@ -125,52 +125,54 @@ KILL QUERY <queryId>
- `SHOW DATA REGIONS`: 展示所有 DataRegion 分布
```sql
+IoTDB> create timeseries root.sg.d1.s1 with datatype=BOOLEAN,encoding=PLAIN
+Msg: The statement is executed successfully.
+IoTDB> create timeseries root.sg.d2.s1 with datatype=BOOLEAN,encoding=PLAIN
+Msg: The statement is executed successfully.
+IoTDB> create timeseries root.ln.d1.s1 with datatype=BOOLEAN,encoding=PLAIN
+Msg: The statement is executed successfully.
IoTDB> show regions
-+--------+------------+------+-------------+-----+----------+----------+----+
-|RegionId| Type|Status|storage group|Slots|DataNodeId|Host|Port|
-+--------+------------+------+-------------+-----+----------+----------+----+
-| 0|SchemaRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 1|SchemaRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 2|SchemaRegion| Up| root.sg| 1| 4| 127.0.0.1|6671|
-| 3| DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 4| DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 5| DataRegion| Up| root.sg| 1| 1| 127.0.0.1|6667|
-| 6| DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 7| DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 8| DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 9| DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 10| DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 11| DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 12| DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-+--------+------------+------+-------------+-----+----------+----------+----+
-Total line number = 13
-It costs 0.107s
-IoTDB> show schema regions
-+--------+------------+------+-------------+-----+----------+----------+----+
-|RegionId| Type|Status|storage group|Slots|DataNodeId|Host|Port|
-+--------+------------+------+-------------+-----+----------+----------+----+
-| 0|SchemaRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 1|SchemaRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 2|SchemaRegion| Up| root.sg| 1| 4| 127.0.0.1|6671|
-+--------+------------+------+-------------+-----+----------+----------+----+
++--------+------------+------+-------------+-----+----------+---------+----+
+|RegionId| Type|Status|storage group|Slots|DataNodeId| Host|Port|
++--------+------------+------+-------------+-----+----------+---------+----+
+| 0|SchemaRegion| Up| root.sg| 2| 2|127.0.0.1|6669|
+| 1|SchemaRegion| Up| root.ln| 1| 3|127.0.0.1|6667|
++--------+------------+------+-------------+-----+----------+---------+----+
+Total line number = 2
+It costs 0.035s
+
+IoTDB> insert into root.sg.d1(timestamp,s1) values(1,true)
+Msg: The statement is executed successfully.
+IoTDB> show regions
++--------+------------+------+-------------+-----+----------+---------+----+
+|RegionId| Type|Status|storage group|Slots|DataNodeId| Host|Port|
++--------+------------+------+-------------+-----+----------+---------+----+
+| 0|SchemaRegion| Up| root.sg| 2| 2|127.0.0.1|6669|
+| 1|SchemaRegion| Up| root.ln| 1| 3|127.0.0.1|6667|
+| 2| DataRegion| Up| root.sg| 1| 1|127.0.0.1|6671|
++--------+------------+------+-------------+-----+----------+---------+----+
Total line number = 3
-It costs 0.009s
+It costs 0.010s
+
+IoTDB> insert into root.ln.d1(timestamp,s1) values(1,true)
+Msg: The statement is executed successfully.
IoTDB> show data regions
-+--------+----------+------+-------------+-----+----------+----------+----+
-|RegionId| Type|Status|storage group|Slots|DataNodeId|Host|Port|
-+--------+----------+------+-------------+-----+----------+----------+----+
-| 3|DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 4|DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 5|DataRegion| Up| root.sg| 1| 1| 127.0.0.1|6667|
-| 6|DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 7|DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 8|DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 9|DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-| 10|DataRegion| Up| root.sg| 0| 4| 127.0.0.1|6671|
-| 11|DataRegion| Up| root.sg| 0| 3| 127.0.0.1|6669|
-| 12|DataRegion| Up| root.sg| 0| 1| 127.0.0.1|6667|
-+--------+----------+------+-------------+-----+----------+----------+----+
-Total line number = 10
-It costs 0.023s
++--------+----------+------+-------------+-----+----------+---------+----+
+|RegionId| Type|Status|storage group|Slots|DataNodeId| Host|Port|
++--------+----------+------+-------------+-----+----------+---------+----+
+| 2|DataRegion| Up| root.sg| 1| 1|127.0.0.1|6671|
+| 3|DataRegion| Up| root.ln| 1| 1|127.0.0.1|6671|
++--------+----------+------+-------------+-----+----------+---------+----+
+Total line number = 2
+It costs 0.011s
+IoTDB> show schema regions
++--------+------------+------+-------------+-----+----------+---------+----+
+|RegionId| Type|Status|storage group|Slots|DataNodeId| Host|Port|
++--------+------------+------+-------------+-----+----------+---------+----+
+| 0|SchemaRegion| Up| root.sg| 2| 2|127.0.0.1|6669|
+| 1|SchemaRegion| Up| root.ln| 1| 3|127.0.0.1|6667|
++--------+------------+------+-------------+-----+----------+---------+----+
+Total line number = 2
+It costs 0.012s
```
