You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Wei Shao (Jira)" <ji...@apache.org> on 2020/12/16 05:49:00 UTC
[jira] [Assigned] (IOTDB-1060) Delete from does not take effect
[ https://issues.apache.org/jira/browse/IOTDB-1060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Wei Shao reassigned IOTDB-1060:
-------------------------------
Assignee: Wei Shao
> Delete from does not take effect
> --------------------------------
>
> Key: IOTDB-1060
> URL: https://issues.apache.org/jira/browse/IOTDB-1060
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Engine
> Affects Versions: 0.10.1, 0.11.2
> Reporter: Yuan Tian
> Assignee: Wei Shao
> Priority: Major
>
> IoTDB> insert into root.sg1.d1(time,s1) values(1,1);
> Msg: The statement is executed successfully.
> IoTDB>
> IoTDB> select last s1 from root.*.*;
> +-----------------------------+--------------+-----+
> | Time| timeseries|value|
> +-----------------------------+--------------+-----+
> |1970-01-01T08:00:00.001+08:00|root.sg1.d1.s1| 1.0|
> +-----------------------------+--------------+-----+
> Total line number = 1
> It costs 0.077s
> IoTDB> delete from root.sg1.d1.s1
> Msg: The statement is executed successfully.
> IoTDB> select last s1 from root.*.*;
> +-----------------------------+--------------+-----+
> | Time| timeseries|value|
> +-----------------------------+--------------+-----+
> |1970-01-01T08:00:00.001+08:00|root.sg1.d1.s1| 1.0|
> +-----------------------------+--------------+-----+
> Total line number = 1
> It costs 0.004s
> IoTDB> select s1 from root.sg1.d1
> +-----------------------------+--------------+
> | Time|root.sg1.d1.s1|
> +-----------------------------+--------------+
> |1970-01-01T08:00:00.001+08:00| 1.0|
> +-----------------------------+--------------+
> Total line number = 1
> It costs 0.072s
> IoTDB> delete from root.sg1.d1.s1 where time <= 10;
> Msg: The statement is executed successfully.
> IoTDB> select last s1 from root.*.*;
> +-----------------------------+--------------+-----+
> | Time| timeseries|value|
> +-----------------------------+--------------+-----+
> |1970-01-01T08:00:00.001+08:00|root.sg1.d1.s1| 1.0|
> +-----------------------------+--------------+-----+
> Total line number = 1
> It costs 0.004s
> IoTDB> select s1 from root.sg1.d1
> +----+--------------+
> |Time|root.sg1.d1.s1|
> +----+--------------+
> +----+--------------+
> Empty set.
> It costs 0.004s
--
This message was sent by Atlassian Jira
(v8.3.4#803005)