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" <[email protected]> > 发送时间: 2020-06-15 18:47:56 (星期一) > 收件人: "[email protected]" <[email protected]> > 抄送: > 主题: [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
