You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2021/09/02 03:52:09 UTC
[GitHub] [iotdb] ijihang opened a new pull request #3889: [IOTDB-1601]Add Like and REGEXP statement user guide in DML
ijihang opened a new pull request #3889:
URL: https://github.com/apache/iotdb/pull/3889
## Description
After #3738 cherry pick to 0.12 , This pr need to cherry pick 0.12
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou commented on a change in pull request #3889: [IOTDB-1601]Add Like and REGEXP statement user guide in DML
Posted by GitBox <gi...@apache.org>.
HTHou commented on a change in pull request #3889:
URL: https://github.com/apache/iotdb/pull/3889#discussion_r700793056
##########
File path: docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -924,7 +924,81 @@ Total line number = 2
It costs 0.002s
```
+### Fuzzy query
+Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of TEXT type data.
+
+Like statement:
+
+Example 1: Query data containing `'cc'` in `value` under `root.sg.device`.
+The percentage (`%`) wildcard matches any string of zero or more characters.
+
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+--------------------+
+| Time|root.sg.device.value|
++-----------------------------+--------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+--------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+Example 2: Query data that consists of 3 characters and the second character is `'b'` in `value` under `root.sg.device`.
+The underscore (`_`) wildcard matches any single character.
+```
+IoTDB> select * from root.sg.device where value like '_b_'
++-----------------------------+--------------------+
+| Time|root.sg.device.value|
++-----------------------------+--------------------+
+|2017-11-07T23:59:00.000+08:00| abc|
++-----------------------------+--------------------+
+Total line number = 1
+It costs 0.002s
+```
+
+Regexp statement：
+
+The filter conditions that need to be passed in are regular expressions in the Java standard library style
+
+Example 1: Query a string composed of 26 English characters for the value under root.sg.device
+```
+IoTDB> select * from root.sg.device where value regexp '^[A-Za-z]+$'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+Example 2: Query root.sg.device where the value value is a string composed of 26 lowercase English characters and the time is greater than 100
+```
+IoTDB> select * from root.sg.device where value regexp '^[a-z]+$' and time > 100
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+Examples of common regular matching:
+
+```
+All characters with a length of 3-20: ^.{3,20}$
+Uppercase english characters: ^[A-Z]+$
+Numbers and English characters: ^[A-Za-z0-9]+$
+Beginning with a: ^a.*
+```
+
+更多语法请参照 [SQL REFERENCE](../Appendix/SQL-Reference.md).
Review comment:
English?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou commented on a change in pull request #3889: [IOTDB-1601]Add Like and REGEXP statement user guide in DML
Posted by GitBox <gi...@apache.org>.
HTHou commented on a change in pull request #3889:
URL: https://github.com/apache/iotdb/pull/3889#discussion_r700795413
##########
File path: docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -696,6 +696,81 @@ Total line number = 2
It costs 0.002s
```
+### 模糊查询
+
+模糊查询分为Like语句和Regexp语句，都可以支持对Text类型的数据进行模糊匹配
+
+Like语句：
+
+示例 1：查询 root.sg.device 下 value 含有c的数据，%表示任意0个或多个字符
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+示例 2：查询 root.sg.device 下 value 值中间为b，前后为单个字符， _表示任意单个字符
Review comment:
```suggestion
示例 2：查询 `root.sg.device` 下 `value` 中间为 `'b'`、前后为任意单个字符的数据。
`_` 表示任意单个字符。
```
##########
File path: docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -696,6 +696,81 @@ Total line number = 2
It costs 0.002s
```
+### 模糊查询
+
+模糊查询分为Like语句和Regexp语句，都可以支持对Text类型的数据进行模糊匹配
+
+Like语句：
+
+示例 1：查询 root.sg.device 下 value 含有c的数据，%表示任意0个或多个字符
Review comment:
```suggestion
示例 1：查询 `root.sg.device` 下 `value` 含有`'cc'`的数据。
`%` 表示任意0个或多个字符。
```
##########
File path: docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -924,7 +924,81 @@ Total line number = 2
It costs 0.002s
```
+### Fuzzy query
+Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of TEXT type data.
+
+Like statement:
+
+Example 1: Query data containing `'cc'` in `value` under `root.sg.device`.
+The percentage (`%`) wildcard matches any string of zero or more characters.
+
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+--------------------+
+| Time|root.sg.device.value|
++-----------------------------+--------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+--------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+Example 2: Query data that consists of 3 characters and the second character is `'b'` in `value` under `root.sg.device`.
+The underscore (`_`) wildcard matches any single character.
+```
+IoTDB> select * from root.sg.device where value like '_b_'
++-----------------------------+--------------------+
+| Time|root.sg.device.value|
++-----------------------------+--------------------+
+|2017-11-07T23:59:00.000+08:00| abc|
++-----------------------------+--------------------+
+Total line number = 1
+It costs 0.002s
+```
+
+Regexp statement：
+
+The filter conditions that need to be passed in are regular expressions in the Java standard library style
+
+Example 1: Query a string composed of 26 English characters for the value under root.sg.device
+```
+IoTDB> select * from root.sg.device where value regexp '^[A-Za-z]+$'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+Example 2: Query root.sg.device where the value value is a string composed of 26 lowercase English characters and the time is greater than 100
+```
+IoTDB> select * from root.sg.device where value regexp '^[a-z]+$' and time > 100
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
Review comment:
```suggestion
+-----------------------------+--------------------+
| Time|root.sg.device.value|
+-----------------------------+--------------------+
|2017-11-07T23:59:00.000+08:00| aabbccdd|
|2017-11-07T23:59:00.000+08:00| cc|
+-----------------------------+--------------------+
```
##########
File path: docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -696,6 +696,81 @@ Total line number = 2
It costs 0.002s
```
+### 模糊查询
+
+模糊查询分为Like语句和Regexp语句，都可以支持对Text类型的数据进行模糊匹配
+
+Like语句：
+
+示例 1：查询 root.sg.device 下 value 含有c的数据，%表示任意0个或多个字符
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+示例 2：查询 root.sg.device 下 value 值中间为b，前后为单个字符， _表示任意单个字符
+
+```
+IoTDB> select * from root.sg.device where value like '_b_'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| abc|
++-----------------------------+-----------------------------+
+Total line number = 1
+It costs 0.002s
+```
+
+Regexp语句：
+
+需要传入的过滤条件为 Java 标准库风格的正则表达式
+
+示例 1：查询 root.sg.device 下 value 值为26个英文字符组成的字符串
+
+```
+IoTDB> select * from root.sg.device where value regexp '^[A-Za-z]+$'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+示例 2：查询 root.sg.device 下 value 值为26个小写英文字符组成的字符串 且时间大于100的
+
+```
+IoTDB> select * from root.sg.device where value regexp '^[a-z]+$' and time > 100
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
Review comment:
```suggestion
+-----------------------------+--------------------+
| Time|root.sg.device.value|
+-----------------------------+--------------------+
|2017-11-07T23:59:00.000+08:00| aabbccdd|
|2017-11-07T23:59:00.000+08:00| cc|
+-----------------------------+--------------------+
```
##########
File path: docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -696,6 +696,81 @@ Total line number = 2
It costs 0.002s
```
+### 模糊查询
+
+模糊查询分为Like语句和Regexp语句，都可以支持对Text类型的数据进行模糊匹配
+
+Like语句：
+
+示例 1：查询 root.sg.device 下 value 含有c的数据，%表示任意0个或多个字符
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+示例 2：查询 root.sg.device 下 value 值中间为b，前后为单个字符， _表示任意单个字符
+
+```
+IoTDB> select * from root.sg.device where value like '_b_'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| abc|
++-----------------------------+-----------------------------+
Review comment:
```suggestion
+-----------------------------+--------------------+
| Time|root.sg.device.value|
+-----------------------------+--------------------+
|2017-11-07T23:59:00.000+08:00| abc|
+-----------------------------+--------------------+
```
##########
File path: docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -696,6 +696,81 @@ Total line number = 2
It costs 0.002s
```
+### 模糊查询
+
+模糊查询分为Like语句和Regexp语句，都可以支持对Text类型的数据进行模糊匹配
+
+Like语句：
+
+示例 1：查询 root.sg.device 下 value 含有c的数据，%表示任意0个或多个字符
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
Review comment:
```suggestion
+-----------------------------+--------------------+
| Time|root.sg.device.value|
+-----------------------------+--------------------+
|2017-11-07T23:59:00.000+08:00| aabbccdd|
|2017-11-07T23:59:00.000+08:00| cc|
+-----------------------------+--------------------+
Total line number = 2
```
##########
File path: docs/zh/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -696,6 +696,81 @@ Total line number = 2
It costs 0.002s
```
+### 模糊查询
+
+模糊查询分为Like语句和Regexp语句，都可以支持对Text类型的数据进行模糊匹配
+
+Like语句：
+
+示例 1：查询 root.sg.device 下 value 含有c的数据，%表示任意0个或多个字符
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+示例 2：查询 root.sg.device 下 value 值中间为b，前后为单个字符， _表示任意单个字符
+
+```
+IoTDB> select * from root.sg.device where value like '_b_'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| abc|
++-----------------------------+-----------------------------+
+Total line number = 1
+It costs 0.002s
+```
+
+Regexp语句：
+
+需要传入的过滤条件为 Java 标准库风格的正则表达式
+
+示例 1：查询 root.sg.device 下 value 值为26个英文字符组成的字符串
+
+```
+IoTDB> select * from root.sg.device where value regexp '^[A-Za-z]+$'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
Review comment:
```suggestion
+-----------------------------+--------------------+
| Time|root.sg.device.value|
+-----------------------------+--------------------+
|2017-11-07T23:59:00.000+08:00| aabbccdd|
|2017-11-07T23:59:00.000+08:00| cc|
+-----------------------------+--------------------+
```
##########
File path: docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -924,7 +924,81 @@ Total line number = 2
It costs 0.002s
```
+### Fuzzy query
+Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of TEXT type data.
+
+Like statement:
+
+Example 1: Query data containing `'cc'` in `value` under `root.sg.device`.
+The percentage (`%`) wildcard matches any string of zero or more characters.
+
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+--------------------+
+| Time|root.sg.device.value|
++-----------------------------+--------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+--------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+Example 2: Query data that consists of 3 characters and the second character is `'b'` in `value` under `root.sg.device`.
+The underscore (`_`) wildcard matches any single character.
+```
+IoTDB> select * from root.sg.device where value like '_b_'
++-----------------------------+--------------------+
+| Time|root.sg.device.value|
++-----------------------------+--------------------+
+|2017-11-07T23:59:00.000+08:00| abc|
++-----------------------------+--------------------+
+Total line number = 1
+It costs 0.002s
+```
+
+Regexp statement：
+
+The filter conditions that need to be passed in are regular expressions in the Java standard library style
+
+Example 1: Query a string composed of 26 English characters for the value under root.sg.device
+```
+IoTDB> select * from root.sg.device where value regexp '^[A-Za-z]+$'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
Review comment:
```suggestion
+-----------------------------+--------------------+
| Time|root.sg.device.value|
+-----------------------------+--------------------+
|2017-11-07T23:59:00.000+08:00| aabbccdd|
|2017-11-07T23:59:00.000+08:00| cc|
+-----------------------------+--------------------+
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou merged pull request #3889: [IOTDB-1601]Add Like and REGEXP statement user guide in DML
Posted by GitBox <gi...@apache.org>.
HTHou merged pull request #3889:
URL: https://github.com/apache/iotdb/pull/3889
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] HTHou commented on a change in pull request #3889: [IOTDB-1601]Add Like and REGEXP statement user guide in DML
Posted by GitBox <gi...@apache.org>.
HTHou commented on a change in pull request #3889:
URL: https://github.com/apache/iotdb/pull/3889#discussion_r700763210
##########
File path: docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -924,7 +924,78 @@ Total line number = 2
It costs 0.002s
```
+### Fuzzy query
+Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of Text type data
+
+Like statement：
+
+Example 1: Query data containing c in value under root.sg.device,% means any 0 or more characters
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+Example 2: Query root.sg.device The middle of the value value is b, before and after it is a single character, _ means any single character
+```
+IoTDB> select * from root.sg.device where value like '_b_'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| abc|
++-----------------------------+-----------------------------+
Review comment:
```suggestion
IoTDB> select * from root.sg.device where value like '_b_'
+-----------------------------+--------------------+
| Time|root.sg.device.value|
+-----------------------------+--------------------+
|2017-11-07T23:59:00.000+08:00| abc|
+-----------------------------+--------------------+
```
##########
File path: docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -924,7 +924,78 @@ Total line number = 2
It costs 0.002s
```
+### Fuzzy query
+Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of Text type data
+
+Like statement：
+
+Example 1: Query data containing c in value under root.sg.device,% means any 0 or more characters
Review comment:
```suggestion
Like statement:
Example 1: Query data containing `'cc'` in `value` under `root.sg.device`.
The percentage (`%`) wildcard matches any string of zero or more characters.
```
##########
File path: docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -924,7 +924,78 @@ Total line number = 2
It costs 0.002s
```
+### Fuzzy query
+Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of Text type data
Review comment:
```suggestion
Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of TEXT type data.
```
##########
File path: docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -924,7 +924,78 @@ Total line number = 2
It costs 0.002s
```
+### Fuzzy query
+Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of Text type data
+
+Like statement：
+
+Example 1: Query data containing c in value under root.sg.device,% means any 0 or more characters
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
Review comment:
```suggestion
+-----------------------------+--------------------+
| Time|root.sg.device.value|
+-----------------------------+--------------------+
|2017-11-07T23:59:00.000+08:00| aabbccdd|
|2017-11-07T23:59:00.000+08:00| cc|
+-----------------------------+--------------------+
```
##########
File path: docs/UserGuide/IoTDB-SQL-Language/DML-Data-Manipulation-Language.md
##########
@@ -924,7 +924,78 @@ Total line number = 2
It costs 0.002s
```
+### Fuzzy query
+Fuzzy query is divided into Like statement and Regexp statement, both of which can support fuzzy matching of Text type data
+
+Like statement：
+
+Example 1: Query data containing c in value under root.sg.device,% means any 0 or more characters
+
+```
+IoTDB> select * from root.sg.device where value like '%cc%'
++-----------------------------+-----------------------------+
+| Time| root.sg.device.value|
++-----------------------------+-----------------------------+
+|2017-11-07T23:59:00.000+08:00| aabbccdd|
+|2017-11-07T23:59:00.000+08:00| cc|
++-----------------------------+-----------------------------+
+Total line number = 2
+It costs 0.002s
+```
+
+Example 2: Query root.sg.device The middle of the value value is b, before and after it is a single character, _ means any single character
Review comment:
```suggestion
Example 2: Query data that consists of 3 characters and the second character is `'b'` in `value` under `root.sg.device`.
The underscore (`_`) wildcard matches any single character.
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org