You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by Wei Shao <ko...@163.com> on 2020/06/15 10:47:56 UTC

[Discuss] Delete time range expression syntax

Hi all,


I am currently working on issue[1], to support delete data within a time range. 
The time range in where expressions is to be determined. I am planning to support simple Lt/LE, Gt/GE, EQ, AND with two Lt/LE, Gt/GE, EQs, in the where expression.
e.g.
```
delete from root.sg.d1.s1 where time < 10
delete from root.sg.d1.s1 where time <= 10
delete from root.sg.d1.s1 where time < 20 and time > 10
delete from root.sg.d1.s1 where time <= 20 and time >= 10
delete from root.sg.d1.s1 where time > 20
delete from root.sg.d1.s1 where time >= 20
delete from root.sg.d1.s1 where time = 20
```


If you have any suggestions, please leave your comments.


[1]https://issues.apache.org/jira/browse/IOTDB-627


Thanks,
Wei Shao

Re: [Discuss] Delete time range expression syntax

Posted by Jialin Qiao <qj...@mails.tsinghua.edu.cn>.
Hi,

Great! This is an important feature. 

Please consider this scenario: time <= 20 and time > 10

In this work, we need to consider the online upgrade of the modification file.

Thanks,
--
Jialin Qiao
School of Software, Tsinghua University

乔嘉林
清华大学 软件学院

> -----原始邮件-----
> 发件人: "Wei Shao" <ko...@163.com>
> 发送时间: 2020-06-15 18:47:56 (星期一)
> 收件人: "dev@iotdb.apache.org" <de...@iotdb.apache.org>
> 抄送: 
> 主题: [Discuss] Delete time range expression syntax
> 
> Hi all,
> 
> 
> I am currently working on issue[1], to support delete data within a time range. 
> The time range in where expressions is to be determined. I am planning to support simple Lt/LE, Gt/GE, EQ, AND with two Lt/LE, Gt/GE, EQs, in the where expression.
> e.g.
> ```
> delete from root.sg.d1.s1 where time < 10
> delete from root.sg.d1.s1 where time <= 10
> delete from root.sg.d1.s1 where time < 20 and time > 10
> delete from root.sg.d1.s1 where time <= 20 and time >= 10
> delete from root.sg.d1.s1 where time > 20
> delete from root.sg.d1.s1 where time >= 20
> delete from root.sg.d1.s1 where time = 20
> ```
> 
> 
> If you have any suggestions, please leave your comments.
> 
> 
> [1]https://issues.apache.org/jira/browse/IOTDB-627
> 
> 
> Thanks,
> Wei Shao