You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by "Cpaulyz (via GitHub)" <gi...@apache.org> on 2023/09/04 08:45:35 UTC
[GitHub] [iotdb] Cpaulyz opened a new pull request, #11032: [IOTDB-6130] Delete data by specific pattern didn't work
Cpaulyz opened a new pull request, #11032:
URL: https://github.com/apache/iotdb/pull/11032
## Description
Execute the following sql, you will see data of root.sg.d2.s1 doesn't delete by `delete from root.*.*.s1`.
```
IoTDB> insert into root.sg.d2(time,s1,s2) values(1,2,3)
Msg: The statement is executed successfully.
IoTDB> flush
Msg: The statement is executed successfully.
IoTDB> select ** from root
+-----------------------------+-------------+-------------+
| Time|root.sg.d2.s1|root.sg.d2.s2|
+-----------------------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00| 2.0| 3.0|
+-----------------------------+-------------+-------------+
Total line number = 1
It costs 0.153s
IoTDB> delete from root.*.*.s1
Msg: The statement is executed successfully.
IoTDB> select ** from root
+-----------------------------+-------------+-------------+
| Time|root.sg.d2.s1|root.sg.d2.s2|
+-----------------------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00| 2.0| 3.0|
+-----------------------------+-------------+-------------+
Total line number = 1
It costs 0.013s
IoTDB> delete from root.**.s1
Msg: The statement is executed successfully.
IoTDB> select ** from root
+-----------------------------+-------------+-------------+
| Time|root.sg.d2.s1|root.sg.d2.s2|
+-----------------------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00| null| 3.0|
+-----------------------------+-------------+-------------+
Total line number = 1
It costs 0.018s
```
--
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] JackieTien97 merged pull request #11032: [IOTDB-6130] Delete data by specific pattern didn't work
Posted by "JackieTien97 (via GitHub)" <gi...@apache.org>.
JackieTien97 merged PR #11032:
URL: https://github.com/apache/iotdb/pull/11032
--
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