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