iotdb icon indicating copy to clipboard operation
iotdb copied to clipboard

Published 20 hours ago • verified publisher icon thulab

查询过滤条件里面如果有OR，那么不能包含时间过滤条件

Open MyXOF opened this issue 7 years ago • 3 comments

MyXOF avatar Dec 15 '17 10:12 MyXOF

SET STORAGE GROUP TO root.ln.wf01.wt01 CREATE TIMESERIES root.ln.wf01.wt01.status WITH DATATYPE=BOOLEAN, ENCODING=PLAIN CREATE TIMESERIES root.ln.wf01.wt01.temperature WITH DATATYPE=FLOAT, ENCODING=RLE insert into root.ln.wf01.wt01(timestamp,status) values(1509465600000,true) insert into root.ln.wf01.wt01(timestamp,status) values(1509465660000,true) insert into root.ln.wf01.wt01(timestamp,status) values(1509465720000,false) insert into root.ln.wf01.wt01(timestamp,temperature) values(1509465600000,25.957603) insert into root.ln.wf01.wt01(timestamp,temperature) values(1509465660000,24.359503) insert into root.ln.wf01.wt01(timestamp,temperature) values(1509465720000,20.092794)

MyXOF avatar Dec 22 '17 02:12 MyXOF

SELECT COUNT(temperature) FROM root.ln.wf01.wt01 WHERE temperature < 25 or time > 0

MyXOF avatar Dec 22 '17 02:12 MyXOF

image image

MyXOF avatar Dec 22 '17 02:12 MyXOF