测试用例编号 dml_350 测试语句 select count(ln1) from root.sg1.dev1 cluster结果 +------------------------+ |count(root.sg1.dev1.ln1)| +------------------------+ | 100| +------------------------+ Total line number = 1 It costs 0.119s 测试用例编号 dml_353 测试语句 select count(ln1) from root.sg1.dev1 cluster结果 +------------------------+ |count(root.sg1.dev1.ln1)| +------------------------+ | 100| +------------------------+ Total line number = 1 It costs 0.608s 测试用例编号 dml_359 测试语句 set storage group to root.ln create timeseries root.ln.dev.ch with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values (5,t); insert into root.ln.dev(timestamp,ch) values (6,f); cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:48 mismatched input 't' expecting {NOW, TRUE, FALSE, '-', '.', 'NaN', INT, EXPONENT, DATETIME, DOUBLE_QUOTE_STRING_LITERAL, SINGLE_QUOTE_STRING_LITERAL} Msg: 401: line 1:48 mismatched input 'f' expecting {NOW, TRUE, FALSE, '-', '.', 'NaN', INT, EXPONENT, DATETIME, DOUBLE_QUOTE_STRING_LITERAL, SINGLE_QUOTE_STRING_LITERAL} 测试用例编号 dml_427-1 测试语句 create timeseries root.ln.dev.ch with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,true) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| true| +-----------------------------+--------------+ Total line number = 1 It costs 0.512s 测试用例编号 dml_427-10 测试语句 create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,1.1) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 1.1| +-----------------------------+--------------+ Total line number = 1 It costs 0.399s 测试用例编号 dml_427-11 测试语句 create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,1.3) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 1.3| +-----------------------------+--------------+ Total line number = 1 It costs 1.181s 测试用例编号 dml_427-12 测试语句 create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,1.3) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 1.3| +-----------------------------+--------------+ Total line number = 1 It costs 1.016s 测试用例编号 dml_427-13 测试语句 create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,2.1) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 2.1| +-----------------------------+--------------+ Total line number = 1 It costs 0.389s 测试用例编号 dml_427-14 测试语句 create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,2.1) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 2.1| +-----------------------------+--------------+ Total line number = 1 It costs 0.112s 测试用例编号 dml_427-15 测试语句 create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,2.1) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 2.1| +-----------------------------+--------------+ Total line number = 1 It costs 0.885s 测试用例编号 dml_427-16 测试语句 create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,2.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 2.2| +-----------------------------+--------------+ Total line number = 1 It costs 0.563s 测试用例编号 dml_427-17 测试语句 create timeseries root.ln.dev.ch with datatype=text,encoding=plain,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,"f") select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| f| +-----------------------------+--------------+ Total line number = 1 It costs 0.697s 测试用例编号 dml_427-18 测试语句 create timeseries root.ln.dev.ch with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=BOOLEAN,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch with datatype=text,encoding=plain,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch,ch,ch,ch,ch,ch,ch,ch,ch,ch,ch,ch,ch,ch,ch,ch,ch) values(1,true,true,1,1,1,1,1,1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,"f") select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 300: Path [root.ln.dev.ch] already exist Msg: 313: failed to insert measurements [ch, ch, ch, ch, ch, ch, ch, ch, ch] +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| true| +-----------------------------+--------------+ Total line number = 1 It costs 0.335s 测试用例编号 dml_427-19 测试语句 create timeseries root.ln.dev.ch1 with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch2 with datatype=BOOLEAN,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch3 with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch4 with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch5 with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch6 with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch7 with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch8 with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch9 with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch10 with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch11 with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch12 with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch13 with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch14 with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch15 with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch16 with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch17 with datatype=text,encoding=plain,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch1,ch2,ch3,ch4,ch5,ch6,ch7,ch8,ch9,ch10,ch11,ch12,ch13,ch14,ch15,ch16,ch17) values(1,true,true,1,1,1,1,1,1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,"f") select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ | Time|root.ln.dev.ch16|root.ln.dev.ch17|root.ln.dev.ch14|root.ln.dev.ch15|root.ln.dev.ch12|root.ln.dev.ch13|root.ln.dev.ch10|root.ln.dev.ch11|root.ln.dev.ch2|root.ln.dev.ch1|root.ln.dev.ch4|root.ln.dev.ch3|root.ln.dev.ch6|root.ln.dev.ch5|root.ln.dev.ch8|root.ln.dev.ch7|root.ln.dev.ch9| +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ |1970-01-01T08:00:00.001+08:00| 1.1| f| 1.1| 1.1| 1.1| 1.1| 1.1| 1.1| true| true| 1| 1| 1| 1| 1| 1| 1.1| +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ Total line number = 1 It costs 0.977s 测试用例编号 dml_427-2 测试语句 create timeseries root.ln.dev.ch with datatype=BOOLEAN,encoding=RLE,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,true) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| true| +-----------------------------+--------------+ Total line number = 1 It costs 1.168s 测试用例编号 dml_427-3 测试语句 create timeseries root.ln.dev.ch with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,1) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 1| +-----------------------------+--------------+ Total line number = 1 It costs 0.146s 测试用例编号 dml_427-4 测试语句 create timeseries root.ln.dev.ch with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,1) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 1| +-----------------------------+--------------+ Total line number = 1 It costs 0.502s 测试用例编号 dml_427-5 测试语句 create timeseries root.ln.dev.ch with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,1) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 1| +-----------------------------+--------------+ Total line number = 1 It costs 0.563s 测试用例编号 dml_427-6 测试语句 create timeseries root.ln.dev.ch with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,22) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 22| +-----------------------------+--------------+ Total line number = 1 It costs 0.548s 测试用例编号 dml_427-7 测试语句 create timeseries root.ln.dev.ch with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,22) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 22| +-----------------------------+--------------+ Total line number = 1 It costs 0.385s 测试用例编号 dml_427-8 测试语句 create timeseries root.ln.dev.ch with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,22) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 22| +-----------------------------+--------------+ Total line number = 1 It costs 0.141s 测试用例编号 dml_427-9 测试语句 create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch) values(1,1.1) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.001+08:00| 1.1| +-----------------------------+--------------+ Total line number = 1 It costs 0.298s 测试用例编号 dml_428-1 测试语句 create timeseries root.ln.dev.ch with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,true) insert into root.ln1.dev(timestamp,ch) values(2,true) insert into root.ln.dev1(timestamp,ch) values(3,true) insert into root.ln.dev.dev1(timestamp,ch) values(4,true) insert into root.ln.dev(timestamp,ch1) values(5,true) insert into root.ln.dev(timestamp,ch) values(6,1) insert into root.ln.dev(timestamp,ch) values(7,true) insert into root.ln.dev(timestamp,ch) values(7,true) insert into root.ln.dev(timestamp,ch) values(0.1,true) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.006+08:00| true| |1970-01-01T08:00:00.007+08:00| true| +-----------------------------+--------------+ Total line number = 2 It costs 0.950s 测试用例编号 dml_428-10 测试语句 create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,1.2) insert into root.ln1.dev(timestamp,ch) values(2,1.2) insert into root.ln.dev1(timestamp,ch) values(3,1.2) insert into root.ln.dev.dev1(timestamp,ch) values(4,1.2) insert into root.ln.dev(timestamp,ch1) values(5,1.2) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(0.1,1.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 1.2| +-----------------------------+--------------+ Total line number = 1 It costs 0.743s 测试用例编号 dml_428-11 测试语句 create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,1.2) insert into root.ln1.dev(timestamp,ch) values(2,1.2) insert into root.ln.dev1(timestamp,ch) values(3,1.2) insert into root.ln.dev.dev1(timestamp,ch) values(4,1.2) insert into root.ln.dev(timestamp,ch1) values(5,1.2) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(0.1,1.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 1.2| +-----------------------------+--------------+ Total line number = 1 It costs 0.323s 测试用例编号 dml_428-12 测试语句 create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,1.2) insert into root.ln1.dev(timestamp,ch) values(2,1.2) insert into root.ln.dev1(timestamp,ch) values(3,1.2) insert into root.ln.dev.dev1(timestamp,ch) values(4,1.2) insert into root.ln.dev(timestamp,ch1) values(5,1.2) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(0.1,1.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 1.2| +-----------------------------+--------------+ Total line number = 1 It costs 0.900s 测试用例编号 dml_428-13 测试语句 create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,1.2) insert into root.ln1.dev(timestamp,ch) values(2,1.2) insert into root.ln.dev1(timestamp,ch) values(3,1.2) insert into root.ln.dev.dev1(timestamp,ch) values(4,1.2) insert into root.ln.dev(timestamp,ch1) values(5,1.2) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(0.1,1.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 1.2| +-----------------------------+--------------+ Total line number = 1 It costs 0.806s 测试用例编号 dml_428-14 测试语句 create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,1.2) insert into root.ln1.dev(timestamp,ch) values(2,1.2) insert into root.ln.dev1(timestamp,ch) values(3,1.2) insert into root.ln.dev.dev1(timestamp,ch) values(4,1.2) insert into root.ln.dev(timestamp,ch1) values(5,1.2) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(0.1,1.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +----+--------------+ |Time|root.ln.dev.ch| +----+--------------+ +----+--------------+ Empty set. It costs 0.528s 测试用例编号 dml_428-15 测试语句 create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,1.2) insert into root.ln1.dev(timestamp,ch) values(2,1.2) insert into root.ln.dev1(timestamp,ch) values(3,1.2) insert into root.ln.dev.dev1(timestamp,ch) values(4,1.2) insert into root.ln.dev(timestamp,ch1) values(5,1.2) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(0.1,1.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 1.2| +-----------------------------+--------------+ Total line number = 1 It costs 0.801s 测试用例编号 dml_428-16 测试语句 create timeseries root.ln.dev.ch with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,1.2) insert into root.ln1.dev(timestamp,ch) values(2,1.2) insert into root.ln.dev1(timestamp,ch) values(3,1.2) insert into root.ln.dev.dev1(timestamp,ch) values(4,1.2) insert into root.ln.dev(timestamp,ch1) values(5,1.2) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(0.1,1.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 1.2| +-----------------------------+--------------+ Total line number = 1 It costs 1.030s 测试用例编号 dml_428-17 测试语句 create timeseries root.ln.dev.ch with datatype=text,encoding=plain,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,"f") insert into root.ln1.dev(timestamp,ch) values(2,"f") insert into root.ln.dev1(timestamp,ch) values(3,"f") insert into root.ln.dev.dev1(timestamp,ch) values(4,"f") insert into root.ln.dev(timestamp,ch1) values(5,"f") insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,"f") insert into root.ln.dev(timestamp,ch) values(7,"f") insert into root.ln.dev(timestamp,ch) values(0.1,"f") select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.006+08:00| true| |1970-01-01T08:00:00.007+08:00| f| +-----------------------------+--------------+ Total line number = 2 It costs 0.755s 测试用例编号 dml_428-18 测试语句 create timeseries root.ln.dev.ch1 with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch2 with datatype=BOOLEAN,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch3 with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch4 with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch5 with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch6 with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch7 with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch8 with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch9 with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch10 with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch11 with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch12 with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch13 with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch14 with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch15 with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch16 with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch17 with datatype=text,encoding=plain,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch1,ch1,ch3,ch4,ch5,ch6,ch7,ch8,ch9,ch10,ch11,ch12,ch13,ch14,ch15,ch16,ch17) values(1,true,true,1,1,1,1,1,1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,"f") select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ | Time|root.ln.dev.ch16|root.ln.dev.ch17|root.ln.dev.ch14|root.ln.dev.ch15|root.ln.dev.ch12|root.ln.dev.ch13|root.ln.dev.ch10|root.ln.dev.ch11|root.ln.dev.ch2|root.ln.dev.ch1|root.ln.dev.ch4|root.ln.dev.ch3|root.ln.dev.ch6|root.ln.dev.ch5|root.ln.dev.ch8|root.ln.dev.ch7|root.ln.dev.ch9| +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ |1970-01-01T08:00:00.001+08:00| 1.1| f| 1.1| 1.1| 1.1| 1.1| 1.1| 1.1| null| true| 1| 1| 1| 1| 1| 1| 1.1| +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ Total line number = 1 It costs 0.560s 测试用例编号 dml_428-19 测试语句 create timeseries root.ln.dev.ch1 with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch2 with datatype=BOOLEAN,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch3 with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch4 with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch5 with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch6 with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch7 with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch8 with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch9 with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch10 with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch11 with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch12 with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch13 with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch14 with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch15 with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch16 with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch17 with datatype=text,encoding=plain,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch1,ch3,ch4,ch5,ch6,ch7,ch8,ch9,ch10,ch11,ch12,ch13,ch14,ch15,ch16,ch17) values(1,true,true,1,1,1,1,1,1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,"f") select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 303: check metadata error: the measurementList's size 16 is not consistent with the valueList's size 17 +----+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ |Time|root.ln.dev.ch16|root.ln.dev.ch17|root.ln.dev.ch14|root.ln.dev.ch15|root.ln.dev.ch12|root.ln.dev.ch13|root.ln.dev.ch10|root.ln.dev.ch11|root.ln.dev.ch2|root.ln.dev.ch1|root.ln.dev.ch4|root.ln.dev.ch3|root.ln.dev.ch6|root.ln.dev.ch5|root.ln.dev.ch8|root.ln.dev.ch7|root.ln.dev.ch9| +----+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ +----+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ Empty set. It costs 0.521s 测试用例编号 dml_428-2 测试语句 create timeseries root.ln.dev.ch with datatype=BOOLEAN,encoding=RLE,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,true) insert into root.ln1.dev(timestamp,ch) values(2,true) insert into root.ln.dev1(timestamp,ch) values(3,true) insert into root.ln.dev.dev1(timestamp,ch) values(4,true) insert into root.ln.dev(timestamp,ch1) values(5,true) insert into root.ln.dev(timestamp,ch) values(6,1) insert into root.ln.dev(timestamp,ch) values(7,true) insert into root.ln.dev(timestamp,ch) values(7,true) insert into root.ln.dev(timestamp,ch) values(0.1,true) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.006+08:00| true| |1970-01-01T08:00:00.007+08:00| true| +-----------------------------+--------------+ Total line number = 2 It costs 0.746s 测试用例编号 dml_428-20 测试语句 create timeseries root.ln.dev.ch1 with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch2 with datatype=BOOLEAN,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch3 with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch4 with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch5 with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch6 with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch7 with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch8 with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch9 with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch10 with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch11 with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch12 with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch13 with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch14 with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch15 with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch16 with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch17 with datatype=text,encoding=plain,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch1,ch2,ch3,ch4,ch5,ch6,ch7,ch8,ch9,ch10,ch11,ch12,ch13,ch14,ch15,ch16,ch17) values(1,true,true,1,1,1,1,1,1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,"f") select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 303: encoding BOOLEAN does not support TS_2DIFF Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ | Time|root.ln.dev.ch16|root.ln.dev.ch17|root.ln.dev.ch14|root.ln.dev.ch15|root.ln.dev.ch12|root.ln.dev.ch13|root.ln.dev.ch10|root.ln.dev.ch11|root.ln.dev.ch1|root.ln.dev.ch4|root.ln.dev.ch3|root.ln.dev.ch6|root.ln.dev.ch5|root.ln.dev.ch8|root.ln.dev.ch7|root.ln.dev.ch9| +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ |1970-01-01T08:00:00.001+08:00| 1.1| f| 1.1| 1.1| 1.1| 1.1| 1.1| 1.1| true| 1| 1| 1| 1| 1| 1| 1.1| +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ Total line number = 1 It costs 1.065s 测试用例编号 dml_428-21 测试语句 create timeseries root.ln.dev.ch1 with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch2 with datatype=BOOLEAN,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch3 with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch4 with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch5 with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch6 with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch7 with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch8 with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch9 with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch10 with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch11 with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch12 with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch13 with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch14 with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch15 with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch16 with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch17 with datatype=text,encoding=plain,COMPRESSOR=SNAPPY insert into root.ln.dev(timestamp,ch1,ch2,ch3,ch4,ch5,ch6,ch7,ch8,ch9,ch10,ch11,ch12,ch13,ch14,ch15,ch16,ch17) values(1,22,true,1,1,1,1,1,1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,"f") select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch1] +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ | Time|root.ln.dev.ch16|root.ln.dev.ch17|root.ln.dev.ch14|root.ln.dev.ch15|root.ln.dev.ch12|root.ln.dev.ch13|root.ln.dev.ch10|root.ln.dev.ch11|root.ln.dev.ch2|root.ln.dev.ch1|root.ln.dev.ch4|root.ln.dev.ch3|root.ln.dev.ch6|root.ln.dev.ch5|root.ln.dev.ch8|root.ln.dev.ch7|root.ln.dev.ch9| +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ |1970-01-01T08:00:00.001+08:00| 1.1| f| 1.1| 1.1| 1.1| 1.1| 1.1| 1.1| true| null| 1| 1| 1| 1| 1| 1| 1.1| +-----------------------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ Total line number = 1 It costs 2.023s 测试用例编号 dml_428-3 测试语句 create timeseries root.ln.dev.ch with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,23) insert into root.ln1.dev(timestamp,ch) values(2,23) insert into root.ln.dev1(timestamp,ch) values(3,23) insert into root.ln.dev.dev1(timestamp,ch) values(4,23) insert into root.ln.dev(timestamp,ch1) values(5,23) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(0.1,23) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 23| +-----------------------------+--------------+ Total line number = 1 It costs 1.042s 测试用例编号 dml_428-4 测试语句 create timeseries root.ln.dev.ch with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,23) insert into root.ln1.dev(timestamp,ch) values(2,23) insert into root.ln.dev1(timestamp,ch) values(3,23) insert into root.ln.dev.dev1(timestamp,ch) values(4,23) insert into root.ln.dev(timestamp,ch1) values(5,23) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(0.1,23) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+-------------------+--------------+ | Time|root.ln.dev.dev1.ch|root.ln.dev.ch| +-----------------------------+-------------------+--------------+ |1970-01-01T08:00:00.004+08:00| 23.0| null| |1970-01-01T08:00:00.007+08:00| null| 23| +-----------------------------+-------------------+--------------+ Total line number = 2 It costs 1.022s 测试用例编号 dml_428-5 测试语句 create timeseries root.ln.dev.ch with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,23) insert into root.ln1.dev(timestamp,ch) values(2,23) insert into root.ln.dev1(timestamp,ch) values(3,23) insert into root.ln.dev.dev1(timestamp,ch) values(4,23) insert into root.ln.dev(timestamp,ch1) values(5,23) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(0.1,23) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 23| +-----------------------------+--------------+ Total line number = 1 It costs 0.373s 测试用例编号 dml_428-6 测试语句 create timeseries root.ln.dev.ch with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,23) insert into root.ln1.dev(timestamp,ch) values(2,23) insert into root.ln.dev1(timestamp,ch) values(3,23) insert into root.ln.dev.dev1(timestamp,ch) values(4,23) insert into root.ln.dev(timestamp,ch1) values(5,23) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(0.1,23) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 23| +-----------------------------+--------------+ Total line number = 1 It costs 1.019s 测试用例编号 dml_428-7 测试语句 create timeseries root.ln.dev.ch with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,23) insert into root.ln1.dev(timestamp,ch) values(2,23) insert into root.ln.dev1(timestamp,ch) values(3,23) insert into root.ln.dev.dev1(timestamp,ch) values(4,23) insert into root.ln.dev(timestamp,ch1) values(5,23) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(0.1,23) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 23| +-----------------------------+--------------+ Total line number = 1 It costs 0.397s 测试用例编号 dml_428-8 测试语句 create timeseries root.ln.dev.ch with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,23) insert into root.ln1.dev(timestamp,ch) values(2,23) insert into root.ln.dev1(timestamp,ch) values(3,23) insert into root.ln.dev.dev1(timestamp,ch) values(4,23) insert into root.ln.dev(timestamp,ch1) values(5,23) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(7,23) insert into root.ln.dev(timestamp,ch) values(0.1,23) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +----+--------------+ |Time|root.ln.dev.ch| +----+--------------+ +----+--------------+ Empty set. It costs 0.268s 测试用例编号 dml_428-9 测试语句 create timeseries root.ln.dev.ch with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY insert1 into root.ln.dev(timestamp,ch) values(1,1.2) insert into root.ln1.dev(timestamp,ch) values(2,1.2) insert into root.ln.dev1(timestamp,ch) values(3,1.2) insert into root.ln.dev.dev1(timestamp,ch) values(4,1.2) insert into root.ln.dev(timestamp,ch1) values(5,1.2) insert into root.ln.dev(timestamp,ch) values(6,true) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(7,1.2) insert into root.ln.dev(timestamp,ch) values(0.1,1.2) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input 'insert1' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 313: failed to insert measurements [ch] Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:46 mismatched input '.' expecting ',' +-----------------------------+--------------+ | Time|root.ln.dev.ch| +-----------------------------+--------------+ |1970-01-01T08:00:00.007+08:00| 1.2| +-----------------------------+--------------+ Total line number = 1 It costs 0.366s 测试用例编号 dml_429 测试语句 create timeseries root.ln.dev.ch1 with datatype=BOOLEAN,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch2 with datatype=BOOLEAN,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch3 with datatype=INT32,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch4 with datatype=INT32,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch5 with datatype=INT32,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch6 with datatype=INT64,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch7 with datatype=INT64,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch8 with datatype=INT64,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch9 with datatype=FLOAT,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch10 with datatype=FLOAT,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch11 with datatype=FLOAT,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch12 with datatype=FLOAT,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch13 with datatype=DOUBLE,encoding=PLAIN,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch14 with datatype=DOUBLE,encoding=RLE,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch15 with datatype=DOUBLE,encoding=TS_2DIFF,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch16 with datatype=DOUBLE,encoding=GORILLA,COMPRESSOR=SNAPPY create timeseries root.ln.dev.ch17 with datatype=text,encoding=plain,COMPRESSOR=SNAPPY @root.ln.dev(timestamp,ch1,ch2,ch3,ch4,ch5,ch6,ch7,ch8,ch9,ch10,ch11,ch12,ch13,ch14,ch15,ch16,ch17) select * from root.ln.dev cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:0 mismatched input '@root' expecting {CREATE, INSERT, UPDATE, DELETE, SELECT, SHOW, GRANT, SET, DESCRIBE, TRACING, DROP, MERGE, LIST, ALTER, REVOKE, LOAD, UNSET, FLUSH, REMOVE, MOVE, COUNT, FULL, CLEAR} +----+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ |Time|root.ln.dev.ch16|root.ln.dev.ch17|root.ln.dev.ch14|root.ln.dev.ch15|root.ln.dev.ch12|root.ln.dev.ch13|root.ln.dev.ch10|root.ln.dev.ch11|root.ln.dev.ch2|root.ln.dev.ch1|root.ln.dev.ch4|root.ln.dev.ch3|root.ln.dev.ch6|root.ln.dev.ch5|root.ln.dev.ch8|root.ln.dev.ch7|root.ln.dev.ch9| +----+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ +----+----------------+----------------+----------------+----------------+----------------+----------------+----------------+----------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+---------------+ Empty set. It costs 0.349s 测试用例编号 dml_430-1 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) select temperature from root.ln.wf01.wt01 where time < 2017-11-01T00:08:00.000 select temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:08:00.000 cluster结果 Msg: The statement is executed successfully. +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2017-11-01T00:00:00.000+08:00| 15| |2017-11-01T00:01:00.000+08:00| 15| |2017-11-01T00:02:00.000+08:00| 15| |2017-11-01T00:03:00.000+08:00| 15| |2017-11-01T00:04:00.000+08:00| 15| |2017-11-01T00:05:00.000+08:00| 15| |2017-11-01T00:06:00.000+08:00| 15| |2017-11-01T00:07:00.000+08:00| 15| +-----------------------------+-----------------------------+ Total line number = 8 It costs 0.175s +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2017-11-01T00:09:00.000+08:00| 15| |2017-11-01T00:10:00.000+08:00| 15| |2017-11-01T00:11:00.000+08:00| 15| |2017-11-01T00:12:00.000+08:00| 15| |2017-11-01T00:13:00.000+08:00| 15| |2017-11-01T00:14:00.000+08:00| 15| |2017-11-01T00:15:00.000+08:00| 15| |2017-11-01T00:16:00.000+08:00| 15| |2017-11-01T00:17:00.000+08:00| 15| |2017-11-01T00:18:00.000+08:00| 15| |2017-11-01T00:19:00.000+08:00| 15| |2017-11-01T00:20:00.000+08:00| 15| |2017-11-01T00:21:00.000+08:00| 15| |2017-11-01T00:22:00.000+08:00| 15| |2017-11-01T00:23:00.000+08:00| 15| |2017-11-02T00:00:00.000+08:00| 15| |2017-11-02T00:01:00.000+08:00| 15| |2017-11-02T00:02:00.000+08:00| 15| |2017-11-02T00:03:00.000+08:00| 15| |2017-11-02T00:04:00.000+08:00| 15| |2017-11-02T00:05:00.000+08:00| 15| |2017-11-02T00:06:00.000+08:00| 15| |2017-11-02T00:07:00.000+08:00| 15| |2017-11-02T00:08:00.000+08:00| 15| |2017-11-02T00:09:00.000+08:00| 15| |2017-11-02T00:10:00.000+08:00| 15| |2017-11-02T00:11:00.000+08:00| 15| |2017-11-02T00:12:00.000+08:00| 15| |2017-11-02T00:13:00.000+08:00| 15| |2017-11-02T00:14:00.000+08:00| 15| |2017-11-02T00:15:00.000+08:00| 15| |2017-11-02T00:16:00.000+08:00| 15| |2017-11-02T00:17:00.000+08:00| 15| |2017-11-02T00:18:00.000+08:00| 15| |2017-11-02T00:19:00.000+08:00| 15| |2017-11-02T00:20:00.000+08:00| 15| |2017-11-02T00:21:00.000+08:00| 15| |2017-11-02T00:22:00.000+08:00| 15| |2017-11-02T00:23:00.000+08:00| 15| |2017-11-03T00:00:00.000+08:00| 15| |2017-11-03T00:01:00.000+08:00| 15| |2017-11-03T00:02:00.000+08:00| 15| |2017-11-03T00:03:00.000+08:00| 15| |2017-11-03T00:04:00.000+08:00| 15| |2017-11-03T00:05:00.000+08:00| 15| |2017-11-03T00:06:00.000+08:00| 15| |2017-11-03T00:07:00.000+08:00| 15| |2017-11-03T00:08:00.000+08:00| 15| |2017-11-03T00:09:00.000+08:00| 15| |2017-11-03T00:10:00.000+08:00| 15| |2017-11-03T00:11:00.000+08:00| 15| |2017-11-03T00:12:00.000+08:00| 15| |2017-11-03T00:13:00.000+08:00| 15| |2017-11-03T00:14:00.000+08:00| 15| |2017-11-03T00:15:00.000+08:00| 15| |2017-11-03T00:16:00.000+08:00| 15| |2017-11-03T00:17:00.000+08:00| 15| |2017-11-03T00:18:00.000+08:00| 15| |2017-11-03T00:19:00.000+08:00| 15| |2017-11-03T00:20:00.000+08:00| 15| |2017-11-03T00:21:00.000+08:00| 15| |2017-11-03T00:22:00.000+08:00| 15| |2017-11-03T00:23:00.000+08:00| 15| |2017-11-04T00:00:00.000+08:00| 15| |2017-11-04T00:01:00.000+08:00| 15| |2017-11-04T00:02:00.000+08:00| 15| |2017-11-04T00:03:00.000+08:00| 15| |2017-11-04T00:04:00.000+08:00| 15| |2017-11-04T00:05:00.000+08:00| 15| |2017-11-04T00:06:00.000+08:00| 15| |2017-11-04T00:07:00.000+08:00| 15| |2017-11-04T00:08:00.000+08:00| 15| |2017-11-04T00:09:00.000+08:00| 15| |2017-11-04T00:10:00.000+08:00| 15| |2017-11-04T00:11:00.000+08:00| 15| |2017-11-04T00:12:00.000+08:00| 15| |2017-11-04T00:13:00.000+08:00| 15| |2017-11-04T00:14:00.000+08:00| 15| |2017-11-04T00:15:00.000+08:00| 15| |2017-11-04T00:16:00.000+08:00| 15| |2017-11-04T00:17:00.000+08:00| 15| |2017-11-04T00:18:00.000+08:00| 15| |2017-11-04T00:19:00.000+08:00| 15| |2017-11-04T00:20:00.000+08:00| 15| |2017-11-04T00:21:00.000+08:00| 15| |2017-11-04T00:22:00.000+08:00| 15| |2017-11-04T00:23:00.000+08:00| 15| |2017-11-05T00:00:00.000+08:00| 15| |2017-11-05T00:01:00.000+08:00| 15| |2017-11-05T00:02:00.000+08:00| 15| |2017-11-05T00:03:00.000+08:00| 15| |2017-11-05T00:04:00.000+08:00| 15| |2017-11-05T00:05:00.000+08:00| 15| |2017-11-05T00:06:00.000+08:00| 15| |2017-11-05T00:07:00.000+08:00| 15| |2017-11-05T00:08:00.000+08:00| 15| |2017-11-05T00:09:00.000+08:00| 15| |2017-11-05T00:10:00.000+08:00| 15| |2017-11-05T00:11:00.000+08:00| 15| |2017-11-05T00:12:00.000+08:00| 15| |2017-11-05T00:13:00.000+08:00| 15| |2017-11-05T00:14:00.000+08:00| 15| |2017-11-05T00:15:00.000+08:00| 15| |2017-11-05T00:16:00.000+08:00| 15| |2017-11-05T00:17:00.000+08:00| 15| |2017-11-05T00:18:00.000+08:00| 15| |2017-11-05T00:19:00.000+08:00| 15| |2017-11-05T00:20:00.000+08:00| 15| |2017-11-05T00:21:00.000+08:00| 15| |2017-11-05T00:22:00.000+08:00| 15| |2017-11-05T00:23:00.000+08:00| 15| |2017-11-06T00:00:00.000+08:00| 15| |2017-11-06T00:01:00.000+08:00| 15| |2017-11-06T00:02:00.000+08:00| 15| |2017-11-06T00:03:00.000+08:00| 15| |2017-11-06T00:04:00.000+08:00| 15| |2017-11-06T00:05:00.000+08:00| 15| |2017-11-06T00:06:00.000+08:00| 15| |2017-11-06T00:07:00.000+08:00| 15| |2017-11-06T00:08:00.000+08:00| 15| |2017-11-06T00:09:00.000+08:00| 15| |2017-11-06T00:10:00.000+08:00| 15| |2017-11-06T00:11:00.000+08:00| 15| |2017-11-06T00:12:00.000+08:00| 15| |2017-11-06T00:13:00.000+08:00| 15| |2017-11-06T00:14:00.000+08:00| 15| |2017-11-06T00:15:00.000+08:00| 15| |2017-11-06T00:16:00.000+08:00| 15| |2017-11-06T00:17:00.000+08:00| 15| |2017-11-06T00:18:00.000+08:00| 15| |2017-11-06T00:19:00.000+08:00| 15| |2017-11-06T00:20:00.000+08:00| 15| |2017-11-06T00:21:00.000+08:00| 15| |2017-11-06T00:22:00.000+08:00| 15| |2017-11-06T00:23:00.000+08:00| 15| |2017-11-07T00:00:00.000+08:00| 15| |2017-11-07T00:01:00.000+08:00| 15| |2017-11-07T00:02:00.000+08:00| 15| |2017-11-07T00:03:00.000+08:00| 15| |2017-11-07T00:04:00.000+08:00| 15| |2017-11-07T00:05:00.000+08:00| 15| |2017-11-07T00:06:00.000+08:00| 15| |2017-11-07T00:07:00.000+08:00| 15| |2017-11-07T00:08:00.000+08:00| 15| |2017-11-07T00:09:00.000+08:00| 15| |2017-11-07T00:10:00.000+08:00| 15| |2017-11-07T00:11:00.000+08:00| 15| |2017-11-07T00:12:00.000+08:00| 15| |2017-11-07T00:13:00.000+08:00| 15| |2017-11-07T00:14:00.000+08:00| 15| |2017-11-07T00:15:00.000+08:00| 15| |2017-11-07T00:16:00.000+08:00| 15| |2017-11-07T00:17:00.000+08:00| 15| |2017-11-07T00:18:00.000+08:00| 15| |2017-11-07T00:19:00.000+08:00| 15| |2017-11-07T00:20:00.000+08:00| 15| |2017-11-07T00:21:00.000+08:00| 15| |2017-11-07T00:22:00.000+08:00| 15| |2017-11-07T00:23:00.000+08:00| 15| |2017-11-08T00:00:00.000+08:00| 15| |2017-11-08T00:01:00.000+08:00| 15| |2017-11-08T00:02:00.000+08:00| 15| |2017-11-08T00:03:00.000+08:00| 15| |2017-11-08T00:04:00.000+08:00| 15| |2017-11-08T00:05:00.000+08:00| 15| |2017-11-08T00:06:00.000+08:00| 15| |2017-11-08T00:07:00.000+08:00| 15| |2017-11-08T00:08:00.000+08:00| 15| |2017-11-08T00:09:00.000+08:00| 15| |2017-11-08T00:10:00.000+08:00| 15| |2017-11-08T00:11:00.000+08:00| 15| |2017-11-08T00:12:00.000+08:00| 15| |2017-11-08T00:13:00.000+08:00| 15| |2017-11-08T00:14:00.000+08:00| 15| |2017-11-08T00:15:00.000+08:00| 15| |2017-11-08T00:16:00.000+08:00| 15| |2017-11-08T00:17:00.000+08:00| 15| |2017-11-08T00:18:00.000+08:00| 15| |2017-11-08T00:19:00.000+08:00| 15| |2017-11-08T00:20:00.000+08:00| 15| |2017-11-08T00:21:00.000+08:00| 15| |2017-11-08T00:22:00.000+08:00| 15| |2017-11-08T00:23:00.000+08:00| 15| |2017-11-09T00:00:00.000+08:00| 15| |2017-11-09T00:01:00.000+08:00| 15| |2017-11-09T00:02:00.000+08:00| 15| |2017-11-09T00:03:00.000+08:00| 15| |2017-11-09T00:04:00.000+08:00| 15| |2017-11-09T00:05:00.000+08:00| 15| |2017-11-09T00:06:00.000+08:00| 15| |2017-11-09T00:07:00.000+08:00| 15| |2017-11-09T00:08:00.000+08:00| 15| |2017-11-09T00:09:00.000+08:00| 15| |2017-11-09T00:10:00.000+08:00| 15| |2017-11-09T00:11:00.000+08:00| 15| |2017-11-09T00:12:00.000+08:00| 15| |2017-11-09T00:13:00.000+08:00| 15| |2017-11-09T00:14:00.000+08:00| 15| |2017-11-09T00:15:00.000+08:00| 15| |2017-11-09T00:16:00.000+08:00| 15| |2017-11-09T00:17:00.000+08:00| 15| |2017-11-09T00:18:00.000+08:00| 15| |2017-11-09T00:19:00.000+08:00| 15| |2017-11-09T00:20:00.000+08:00| 15| |2017-11-09T00:21:00.000+08:00| 15| |2017-11-09T00:22:00.000+08:00| 15| |2017-11-09T00:23:00.000+08:00| 15| +-----------------------------+-----------------------------+ Total line number = 207 It costs 0.114s 测试用例编号 dml_430-2 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status, temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 select status, temperature from root.ln.wf01.wt01 where time < 2017-11-01T00:05:00.000 and time > 2017-11-01T00:12:00.000 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +-----------------------------+------------------------+-----------------------------+ |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| |2017-11-01T00:11:00.000+08:00| 15| 15| +-----------------------------+------------------------+-----------------------------+ Total line number = 6 It costs 0.191s +----+------------------------+-----------------------------+ |Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +----+------------------------+-----------------------------+ +----+------------------------+-----------------------------+ Empty set. It costs 0.092s 测试用例编号 dml_430-3 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status,temperature from root.ln.wf01.wt01 where (time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000) or (time >= 2017-11-01T16:35:00.000 and time <= 2017-11-01T16:37:00.000) cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +-----------------------------+------------------------+-----------------------------+ |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| |2017-11-01T00:11:00.000+08:00| 15| 15| +-----------------------------+------------------------+-----------------------------+ Total line number = 6 It costs 0.217s 测试用例编号 dml_430-4 测试语句 create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf02.wt02.hardware with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, status) #root.ln.wf02.wt02(timestamp, hardware) select wf01.wt01.status,wf02.wt02.hardware from root.ln where (time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000) or (time >= 2017-11-01T16:35:00.000 and time <= 2017-11-01T16:37:00.000) cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+------------------------+--------------------------+ | Time|root.ln.wf01.wt01.status|root.ln.wf02.wt02.hardware| +-----------------------------+------------------------+--------------------------+ |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| |2017-11-01T00:11:00.000+08:00| 15| 15| +-----------------------------+------------------------+--------------------------+ Total line number = 6 It costs 0.217s 测试用例编号 dml_431-1 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select count(status), max_value(temperature) from root.ln.wf01.wt01 group by ([2017-11-01T00:00:00, 2017-11-07T23:00:00),1d); cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+-------------------------------+----------------------------------------+ | Time|count(root.ln.wf01.wt01.status)|max_value(root.ln.wf01.wt01.temperature)| +-----------------------------+-------------------------------+----------------------------------------+ |2017-11-01T00:00:00.000+08:00| 24| 15| |2017-11-02T00:00:00.000+08:00| 24| 15| |2017-11-03T00:00:00.000+08:00| 24| 15| |2017-11-04T00:00:00.000+08:00| 24| 15| |2017-11-05T00:00:00.000+08:00| 24| 15| |2017-11-06T00:00:00.000+08:00| 24| 15| |2017-11-07T00:00:00.000+08:00| 24| 15| +-----------------------------+-------------------------------+----------------------------------------+ Total line number = 7 It costs 0.216s 测试用例编号 dml_431-2 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select count(status), max_value(temperature) from root.ln.wf01.wt01 group by ([2017-11-01 00:00:00, 2017-11-07 23:00:00), 3h, 1d); cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+-------------------------------+----------------------------------------+ | Time|count(root.ln.wf01.wt01.status)|max_value(root.ln.wf01.wt01.temperature)| +-----------------------------+-------------------------------+----------------------------------------+ |2017-11-01T00:00:00.000+08:00| 24| 15| |2017-11-02T00:00:00.000+08:00| 24| 15| |2017-11-03T00:00:00.000+08:00| 24| 15| |2017-11-04T00:00:00.000+08:00| 24| 15| |2017-11-05T00:00:00.000+08:00| 24| 15| |2017-11-06T00:00:00.000+08:00| 24| 15| |2017-11-07T00:00:00.000+08:00| 24| 15| +-----------------------------+-------------------------------+----------------------------------------+ Total line number = 7 It costs 0.214s 测试用例编号 dml_431-3 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select count(status), max_value(temperature) from root.ln.wf01.wt01 where time > 2017-11-01T01:00:00 and temperature > 20 group by([2017-11-01T00:00:00, 2017-11-07T23:00:00), 3h, 1d); cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+-------------------------------+----------------------------------------+ | Time|count(root.ln.wf01.wt01.status)|max_value(root.ln.wf01.wt01.temperature)| +-----------------------------+-------------------------------+----------------------------------------+ |2017-11-01T00:00:00.000+08:00| 0| null| |2017-11-02T00:00:00.000+08:00| 0| null| |2017-11-03T00:00:00.000+08:00| 0| null| |2017-11-04T00:00:00.000+08:00| 0| null| |2017-11-05T00:00:00.000+08:00| 0| null| |2017-11-06T00:00:00.000+08:00| 0| null| |2017-11-07T00:00:00.000+08:00| 0| null| +-----------------------------+-------------------------------+----------------------------------------+ Total line number = 7 It costs 0.162s 测试用例编号 dml_431-4 测试语句 create timeseries root.ln.wf01.wt01.status datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, status) select count(status) from root.ln.wf01.wt01 group by((1970-01-01T07:00:00.000, 1970-01-01T08:00:00.000], 1h); cluster结果 Msg: 401: line 1:43 mismatched input 'datatype' expecting {WITH, '('} +-----------------------------+-------------------------------+ | Time|count(root.ln.wf01.wt01.status)| +-----------------------------+-------------------------------+ |1970-01-01T08:00:00.000+08:00| 0| +-----------------------------+-------------------------------+ Total line number = 1 It costs 0.156s 测试用例编号 dml_431-5 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) SELECT last_value(temperature) as last_temperature FROM root.ln.wf01.wt01 GROUP BY([1970-01-01T07:00:00.000, 1970-01-01T08:00:00.000), 1h) FILL (int32[PREVIOUSUNTILLAST]) cluster结果 Msg: The statement is executed successfully. +-----------------------------+----------------+ | Time|last_temperature| +-----------------------------+----------------+ |1970-01-01T07:00:00.000+08:00| null| +-----------------------------+----------------+ Total line number = 1 It costs 0.148s 测试用例编号 dml_431-6 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) select last temperature from root.ln.wf01.wt01 cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] +-----------------------------+-----------------------------+-----+ | Time| timeseries|value| +-----------------------------+-----------------------------+-----+ |2017-11-09T00:23:00.000+08:00|root.ln.wf01.wt01.temperature| 15| +-----------------------------+-----------------------------+-----+ Total line number = 1 It costs 0.091s 测试用例编号 dml_431-7 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) select temperature from root.ln.wf01.wt01 where time = 2017-11-01T16:37:50.000 fill(int32[previous, 1m]) cluster结果 Msg: The statement is executed successfully. +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2017-11-01T16:37:50.000+08:00| null| +-----------------------------+-----------------------------+ Total line number = 1 It costs 0.146s 测试用例编号 dml_431-8 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) select temperature from root.ln.wf01.wt01 where time = 2017-11-01T16:37:50.000 fill(int32 [linear, 1m, 1m]) cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2017-11-01T16:37:50.000+08:00| null| +-----------------------------+-----------------------------+ Total line number = 1 It costs 0.141s 测试用例编号 dml_432-1 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status, temperature from root.ln.wf01.wt01 limit 10 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +-----------------------------+------------------------+-----------------------------+ |2017-11-01T00:00:00.000+08:00| 15| 15| |2017-11-01T00:01:00.000+08:00| 15| 15| |2017-11-01T00:02:00.000+08:00| 15| 15| |2017-11-01T00:03:00.000+08:00| 15| 15| |2017-11-01T00:04:00.000+08:00| 15| 15| |2017-11-01T00:05:00.000+08:00| 15| 15| |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| +-----------------------------+------------------------+-----------------------------+ Total line number = 10 It costs 0.211s 测试用例编号 dml_432-10 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +-----------------------------+------------------------+-----------------------------+ |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| |2017-11-01T00:11:00.000+08:00| 15| 15| +-----------------------------+------------------------+-----------------------------+ Total line number = 6 It costs 0.138s 测试用例编号 dml_432-11 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select * from root.ln.wf01.wt01 limit 10 offset 100 slimit 2 soffset 0 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status| +-----------------------------+-----------------------------+------------------------+ |2017-11-05T00:04:00.000+08:00| 15| 15| |2017-11-05T00:05:00.000+08:00| 15| 15| |2017-11-05T00:06:00.000+08:00| 15| 15| |2017-11-05T00:07:00.000+08:00| 15| 15| |2017-11-05T00:08:00.000+08:00| 15| 15| |2017-11-05T00:09:00.000+08:00| 15| 15| |2017-11-05T00:10:00.000+08:00| 15| 15| |2017-11-05T00:11:00.000+08:00| 15| 15| |2017-11-05T00:12:00.000+08:00| 15| 15| |2017-11-05T00:13:00.000+08:00| 15| 15| +-----------------------------+-----------------------------+------------------------+ Total line number = 10 It costs 0.172s 测试用例编号 dml_432-12 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select temperature,status from root.ln.wf01.wt01 GROUP BY DEVICE cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+-----------------+-----------+------+ | Time| Device|temperature|status| +-----------------------------+-----------------+-----------+------+ |2017-11-01T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-01T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-02T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-03T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-04T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-05T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-06T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-07T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-08T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:00:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:01:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:02:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:03:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:04:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:05:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:06:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:07:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:08:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:09:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:10:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:11:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:12:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:13:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:14:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:15:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:16:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:17:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:18:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:19:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:20:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:21:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:22:00.000+08:00|root.ln.wf01.wt01| 15| 15| |2017-11-09T00:23:00.000+08:00|root.ln.wf01.wt01| 15| 15| +-----------------------------+-----------------+-----------+------+ Total line number = 216 It costs 0.302s 测试用例编号 dml_432-13 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 limit 100 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +-----------------------------+------------------------+-----------------------------+ |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| |2017-11-01T00:11:00.000+08:00| 15| 15| +-----------------------------+------------------------+-----------------------------+ Total line number = 6 It costs 0.137s 测试用例编号 dml_432-14 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 limit 1234567890123456789 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 303: check metadata error: Out of range. LIMIT : N should be Int32. 测试用例编号 dml_432-15 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 limit 13.1 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:129 mismatched input '.' expecting {, SLIMIT, OFFSET, SOFFSET, GROUP, DISABLE, ALIGN} 测试用例编号 dml_432-16 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 limit 2 offset 6 cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] Msg: The statement is executed successfully. +----+------------------------+-----------------------------+ |Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +----+------------------------+-----------------------------+ +----+------------------------+-----------------------------+ Empty set. It costs 0.122s 测试用例编号 dml_432-17 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 soffset 2 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 411: Meet error in query process: SOFFSET : SOFFSETValue exceeds the range. 测试用例编号 dml_432-18 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 soffset 0 cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] Msg: The statement is executed successfully. +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2017-11-01T00:06:00.000+08:00| 15| |2017-11-01T00:07:00.000+08:00| 15| |2017-11-01T00:08:00.000+08:00| 15| |2017-11-01T00:09:00.000+08:00| 15| |2017-11-01T00:10:00.000+08:00| 15| |2017-11-01T00:11:00.000+08:00| 15| +-----------------------------+-----------------------------+ Total line number = 6 It costs 0.239s 测试用例编号 dml_432-19 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit -2 soffset -1 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:112 no viable alternative at input 'slimit -' 测试用例编号 dml_432-2 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status, temperature from root.ln.wf01.wt01 limit 5 offset 3 cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] Msg: The statement is executed successfully. +-----------------------------+------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +-----------------------------+------------------------+-----------------------------+ |2017-11-01T00:03:00.000+08:00| 15| 15| |2017-11-01T00:04:00.000+08:00| 15| 15| |2017-11-01T00:05:00.000+08:00| 15| 15| |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| +-----------------------------+------------------------+-----------------------------+ Total line number = 5 It costs 0.135s 测试用例编号 dml_432-20 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 soffset 500 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 411: Meet error in query process: SOFFSET : SOFFSETValue exceeds the range. 测试用例编号 dml_432-3 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select status,temperature from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time< 2017-11-01T00:12:00.000 limit 2 offset 3 cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.status] +-----------------------------+------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.status|root.ln.wf01.wt01.temperature| +-----------------------------+------------------------+-----------------------------+ |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| +-----------------------------+------------------------+-----------------------------+ Total line number = 2 It costs 0.192s 测试用例编号 dml_432-4 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select count(status), max_value(temperature) from root.ln.wf01.wt01 group by (1d,[2017-11-01T00:00:00, 2017-11-07T23:00:00]) limit 5 offset 3 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 401: line 1:78 no viable alternative at input 'group by (1d' 测试用例编号 dml_432-5 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select temperature from root.sgcc.wf03.wt01 where time = 2017-11-01T16:37:50.000 fill(int32[previous, 1m]) cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] Msg: The statement is executed successfully. +----+ |Time| +----+ +----+ Empty set. It costs 0.070s 测试用例编号 dml_432-6 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+-----------------------------+ | Time|root.ln.wf01.wt01.temperature| +-----------------------------+-----------------------------+ |2017-11-01T00:06:00.000+08:00| 15| |2017-11-01T00:07:00.000+08:00| 15| |2017-11-01T00:08:00.000+08:00| 15| |2017-11-01T00:09:00.000+08:00| 15| |2017-11-01T00:10:00.000+08:00| 15| |2017-11-01T00:11:00.000+08:00| 15| +-----------------------------+-----------------------------+ Total line number = 6 It costs 0.262s 测试用例编号 dml_432-7 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select * from root.ln.wf01.wt01 where time > 2017-11-01T00:05:00.000 and time < 2017-11-01T00:12:00.000 slimit 1 soffset 1 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.status| +-----------------------------+------------------------+ |2017-11-01T00:06:00.000+08:00| 15| |2017-11-01T00:07:00.000+08:00| 15| |2017-11-01T00:08:00.000+08:00| 15| |2017-11-01T00:09:00.000+08:00| 15| |2017-11-01T00:10:00.000+08:00| 15| |2017-11-01T00:11:00.000+08:00| 15| +-----------------------------+------------------------+ Total line number = 6 It costs 0.164s 测试用例编号 dml_432-8 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select max_value(*) from root.ln.wf01.wt01 group by (1d, [2017-11-01T00:00:00, 2017-11-07T23:00:00]) slimit 1 soffset 1 cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] Msg: The statement is executed successfully. Msg: 401: line 1:54 no viable alternative at input 'group by (1d' 测试用例编号 dml_432-9 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) select * from root.ln.wf01.wt01 where time = 2017-11-01T16:37:50.000 fill(float[previous, 1m]) slimit 1 soffset 1 cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.status| +-----------------------------+------------------------+ |2017-11-01T16:37:50.000+08:00| 15| +-----------------------------+------------------------+ Total line number = 1 It costs 0.168s 测试用例编号 dml_433-1 测试语句 create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, status) delete from root.ln.wf02.wt02.status where time=2017-11-01T00:05:00.000; select * from root.ln cluster结果 Msg: The statement is executed successfully. Msg: 304: Path [root.ln.wf02.wt02.status] does not exist +-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.status| +-----------------------------+------------------------+ |2017-11-01T00:00:00.000+08:00| 15| |2017-11-01T00:01:00.000+08:00| 15| |2017-11-01T00:02:00.000+08:00| 15| |2017-11-01T00:03:00.000+08:00| 15| |2017-11-01T00:04:00.000+08:00| 15| |2017-11-01T00:05:00.000+08:00| 15| |2017-11-01T00:06:00.000+08:00| 15| |2017-11-01T00:07:00.000+08:00| 15| |2017-11-01T00:08:00.000+08:00| 15| |2017-11-01T00:09:00.000+08:00| 15| |2017-11-01T00:10:00.000+08:00| 15| |2017-11-01T00:11:00.000+08:00| 15| |2017-11-01T00:12:00.000+08:00| 15| |2017-11-01T00:13:00.000+08:00| 15| |2017-11-01T00:14:00.000+08:00| 15| |2017-11-01T00:15:00.000+08:00| 15| |2017-11-01T00:16:00.000+08:00| 15| |2017-11-01T00:17:00.000+08:00| 15| |2017-11-01T00:18:00.000+08:00| 15| |2017-11-01T00:19:00.000+08:00| 15| |2017-11-01T00:20:00.000+08:00| 15| |2017-11-01T00:21:00.000+08:00| 15| |2017-11-01T00:22:00.000+08:00| 15| |2017-11-01T00:23:00.000+08:00| 15| |2017-11-02T00:00:00.000+08:00| 15| |2017-11-02T00:01:00.000+08:00| 15| |2017-11-02T00:02:00.000+08:00| 15| |2017-11-02T00:03:00.000+08:00| 15| |2017-11-02T00:04:00.000+08:00| 15| |2017-11-02T00:05:00.000+08:00| 15| |2017-11-02T00:06:00.000+08:00| 15| |2017-11-02T00:07:00.000+08:00| 15| |2017-11-02T00:08:00.000+08:00| 15| |2017-11-02T00:09:00.000+08:00| 15| |2017-11-02T00:10:00.000+08:00| 15| |2017-11-02T00:11:00.000+08:00| 15| |2017-11-02T00:12:00.000+08:00| 15| |2017-11-02T00:13:00.000+08:00| 15| |2017-11-02T00:14:00.000+08:00| 15| |2017-11-02T00:15:00.000+08:00| 15| |2017-11-02T00:16:00.000+08:00| 15| |2017-11-02T00:17:00.000+08:00| 15| |2017-11-02T00:18:00.000+08:00| 15| |2017-11-02T00:19:00.000+08:00| 15| |2017-11-02T00:20:00.000+08:00| 15| |2017-11-02T00:21:00.000+08:00| 15| |2017-11-02T00:22:00.000+08:00| 15| |2017-11-02T00:23:00.000+08:00| 15| |2017-11-03T00:00:00.000+08:00| 15| |2017-11-03T00:01:00.000+08:00| 15| |2017-11-03T00:02:00.000+08:00| 15| |2017-11-03T00:03:00.000+08:00| 15| |2017-11-03T00:04:00.000+08:00| 15| |2017-11-03T00:05:00.000+08:00| 15| |2017-11-03T00:06:00.000+08:00| 15| |2017-11-03T00:07:00.000+08:00| 15| |2017-11-03T00:08:00.000+08:00| 15| |2017-11-03T00:09:00.000+08:00| 15| |2017-11-03T00:10:00.000+08:00| 15| |2017-11-03T00:11:00.000+08:00| 15| |2017-11-03T00:12:00.000+08:00| 15| |2017-11-03T00:13:00.000+08:00| 15| |2017-11-03T00:14:00.000+08:00| 15| |2017-11-03T00:15:00.000+08:00| 15| |2017-11-03T00:16:00.000+08:00| 15| |2017-11-03T00:17:00.000+08:00| 15| |2017-11-03T00:18:00.000+08:00| 15| |2017-11-03T00:19:00.000+08:00| 15| |2017-11-03T00:20:00.000+08:00| 15| |2017-11-03T00:21:00.000+08:00| 15| |2017-11-03T00:22:00.000+08:00| 15| |2017-11-03T00:23:00.000+08:00| 15| |2017-11-04T00:00:00.000+08:00| 15| |2017-11-04T00:01:00.000+08:00| 15| |2017-11-04T00:02:00.000+08:00| 15| |2017-11-04T00:03:00.000+08:00| 15| |2017-11-04T00:04:00.000+08:00| 15| |2017-11-04T00:05:00.000+08:00| 15| |2017-11-04T00:06:00.000+08:00| 15| |2017-11-04T00:07:00.000+08:00| 15| |2017-11-04T00:08:00.000+08:00| 15| |2017-11-04T00:09:00.000+08:00| 15| |2017-11-04T00:10:00.000+08:00| 15| |2017-11-04T00:11:00.000+08:00| 15| |2017-11-04T00:12:00.000+08:00| 15| |2017-11-04T00:13:00.000+08:00| 15| |2017-11-04T00:14:00.000+08:00| 15| |2017-11-04T00:15:00.000+08:00| 15| |2017-11-04T00:16:00.000+08:00| 15| |2017-11-04T00:17:00.000+08:00| 15| |2017-11-04T00:18:00.000+08:00| 15| |2017-11-04T00:19:00.000+08:00| 15| |2017-11-04T00:20:00.000+08:00| 15| |2017-11-04T00:21:00.000+08:00| 15| |2017-11-04T00:22:00.000+08:00| 15| |2017-11-04T00:23:00.000+08:00| 15| |2017-11-05T00:00:00.000+08:00| 15| |2017-11-05T00:01:00.000+08:00| 15| |2017-11-05T00:02:00.000+08:00| 15| |2017-11-05T00:03:00.000+08:00| 15| |2017-11-05T00:04:00.000+08:00| 15| |2017-11-05T00:05:00.000+08:00| 15| |2017-11-05T00:06:00.000+08:00| 15| |2017-11-05T00:07:00.000+08:00| 15| |2017-11-05T00:08:00.000+08:00| 15| |2017-11-05T00:09:00.000+08:00| 15| |2017-11-05T00:10:00.000+08:00| 15| |2017-11-05T00:11:00.000+08:00| 15| |2017-11-05T00:12:00.000+08:00| 15| |2017-11-05T00:13:00.000+08:00| 15| |2017-11-05T00:14:00.000+08:00| 15| |2017-11-05T00:15:00.000+08:00| 15| |2017-11-05T00:16:00.000+08:00| 15| |2017-11-05T00:17:00.000+08:00| 15| |2017-11-05T00:18:00.000+08:00| 15| |2017-11-05T00:19:00.000+08:00| 15| |2017-11-05T00:20:00.000+08:00| 15| |2017-11-05T00:21:00.000+08:00| 15| |2017-11-05T00:22:00.000+08:00| 15| |2017-11-05T00:23:00.000+08:00| 15| |2017-11-06T00:00:00.000+08:00| 15| |2017-11-06T00:01:00.000+08:00| 15| |2017-11-06T00:02:00.000+08:00| 15| |2017-11-06T00:03:00.000+08:00| 15| |2017-11-06T00:04:00.000+08:00| 15| |2017-11-06T00:05:00.000+08:00| 15| |2017-11-06T00:06:00.000+08:00| 15| |2017-11-06T00:07:00.000+08:00| 15| |2017-11-06T00:08:00.000+08:00| 15| |2017-11-06T00:09:00.000+08:00| 15| |2017-11-06T00:10:00.000+08:00| 15| |2017-11-06T00:11:00.000+08:00| 15| |2017-11-06T00:12:00.000+08:00| 15| |2017-11-06T00:13:00.000+08:00| 15| |2017-11-06T00:14:00.000+08:00| 15| |2017-11-06T00:15:00.000+08:00| 15| |2017-11-06T00:16:00.000+08:00| 15| |2017-11-06T00:17:00.000+08:00| 15| |2017-11-06T00:18:00.000+08:00| 15| |2017-11-06T00:19:00.000+08:00| 15| |2017-11-06T00:20:00.000+08:00| 15| |2017-11-06T00:21:00.000+08:00| 15| |2017-11-06T00:22:00.000+08:00| 15| |2017-11-06T00:23:00.000+08:00| 15| |2017-11-07T00:00:00.000+08:00| 15| |2017-11-07T00:01:00.000+08:00| 15| |2017-11-07T00:02:00.000+08:00| 15| |2017-11-07T00:03:00.000+08:00| 15| |2017-11-07T00:04:00.000+08:00| 15| |2017-11-07T00:05:00.000+08:00| 15| |2017-11-07T00:06:00.000+08:00| 15| |2017-11-07T00:07:00.000+08:00| 15| |2017-11-07T00:08:00.000+08:00| 15| |2017-11-07T00:09:00.000+08:00| 15| |2017-11-07T00:10:00.000+08:00| 15| |2017-11-07T00:11:00.000+08:00| 15| |2017-11-07T00:12:00.000+08:00| 15| |2017-11-07T00:13:00.000+08:00| 15| |2017-11-07T00:14:00.000+08:00| 15| |2017-11-07T00:15:00.000+08:00| 15| |2017-11-07T00:16:00.000+08:00| 15| |2017-11-07T00:17:00.000+08:00| 15| |2017-11-07T00:18:00.000+08:00| 15| |2017-11-07T00:19:00.000+08:00| 15| |2017-11-07T00:20:00.000+08:00| 15| |2017-11-07T00:21:00.000+08:00| 15| |2017-11-07T00:22:00.000+08:00| 15| |2017-11-07T00:23:00.000+08:00| 15| |2017-11-08T00:00:00.000+08:00| 15| |2017-11-08T00:01:00.000+08:00| 15| |2017-11-08T00:02:00.000+08:00| 15| |2017-11-08T00:03:00.000+08:00| 15| |2017-11-08T00:04:00.000+08:00| 15| |2017-11-08T00:05:00.000+08:00| 15| |2017-11-08T00:06:00.000+08:00| 15| |2017-11-08T00:07:00.000+08:00| 15| |2017-11-08T00:08:00.000+08:00| 15| |2017-11-08T00:09:00.000+08:00| 15| |2017-11-08T00:10:00.000+08:00| 15| |2017-11-08T00:11:00.000+08:00| 15| |2017-11-08T00:12:00.000+08:00| 15| |2017-11-08T00:13:00.000+08:00| 15| |2017-11-08T00:14:00.000+08:00| 15| |2017-11-08T00:15:00.000+08:00| 15| |2017-11-08T00:16:00.000+08:00| 15| |2017-11-08T00:17:00.000+08:00| 15| |2017-11-08T00:18:00.000+08:00| 15| |2017-11-08T00:19:00.000+08:00| 15| |2017-11-08T00:20:00.000+08:00| 15| |2017-11-08T00:21:00.000+08:00| 15| |2017-11-08T00:22:00.000+08:00| 15| |2017-11-08T00:23:00.000+08:00| 15| |2017-11-09T00:00:00.000+08:00| 15| |2017-11-09T00:01:00.000+08:00| 15| |2017-11-09T00:02:00.000+08:00| 15| |2017-11-09T00:03:00.000+08:00| 15| |2017-11-09T00:04:00.000+08:00| 15| |2017-11-09T00:05:00.000+08:00| 15| |2017-11-09T00:06:00.000+08:00| 15| |2017-11-09T00:07:00.000+08:00| 15| |2017-11-09T00:08:00.000+08:00| 15| |2017-11-09T00:09:00.000+08:00| 15| |2017-11-09T00:10:00.000+08:00| 15| |2017-11-09T00:11:00.000+08:00| 15| |2017-11-09T00:12:00.000+08:00| 15| |2017-11-09T00:13:00.000+08:00| 15| |2017-11-09T00:14:00.000+08:00| 15| |2017-11-09T00:15:00.000+08:00| 15| |2017-11-09T00:16:00.000+08:00| 15| |2017-11-09T00:17:00.000+08:00| 15| |2017-11-09T00:18:00.000+08:00| 15| |2017-11-09T00:19:00.000+08:00| 15| |2017-11-09T00:20:00.000+08:00| 15| |2017-11-09T00:21:00.000+08:00| 15| |2017-11-09T00:22:00.000+08:00| 15| |2017-11-09T00:23:00.000+08:00| 15| +-----------------------------+------------------------+ Total line number = 216 It costs 0.170s 测试用例编号 dml_433-2 测试语句 create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, status) delete from root.ln.wf02.wt02.status where time>2017-11-07T00:05:00.000 delete from root.ln.wf02.wt02.status where time<2017-11-01T00:05:00.000 delete from root.ln.wf02.wt02.status where time>=2017-11-02T00:05:00.000 and time<=2017-11-03T00:05:00.000 select * from root.ln cluster结果 Msg: The statement is executed successfully. Msg: 304: Path [root.ln.wf02.wt02.status] does not exist Msg: 304: Path [root.ln.wf02.wt02.status] does not exist Msg: 304: Path [root.ln.wf02.wt02.status] does not exist +-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.status| +-----------------------------+------------------------+ |2017-11-01T00:00:00.000+08:00| 15| |2017-11-01T00:01:00.000+08:00| 15| |2017-11-01T00:02:00.000+08:00| 15| |2017-11-01T00:03:00.000+08:00| 15| |2017-11-01T00:04:00.000+08:00| 15| |2017-11-01T00:05:00.000+08:00| 15| |2017-11-01T00:06:00.000+08:00| 15| |2017-11-01T00:07:00.000+08:00| 15| |2017-11-01T00:08:00.000+08:00| 15| |2017-11-01T00:09:00.000+08:00| 15| |2017-11-01T00:10:00.000+08:00| 15| |2017-11-01T00:11:00.000+08:00| 15| |2017-11-01T00:12:00.000+08:00| 15| |2017-11-01T00:13:00.000+08:00| 15| |2017-11-01T00:14:00.000+08:00| 15| |2017-11-01T00:15:00.000+08:00| 15| |2017-11-01T00:16:00.000+08:00| 15| |2017-11-01T00:17:00.000+08:00| 15| |2017-11-01T00:18:00.000+08:00| 15| |2017-11-01T00:19:00.000+08:00| 15| |2017-11-01T00:20:00.000+08:00| 15| |2017-11-01T00:21:00.000+08:00| 15| |2017-11-01T00:22:00.000+08:00| 15| |2017-11-01T00:23:00.000+08:00| 15| |2017-11-02T00:00:00.000+08:00| 15| |2017-11-02T00:01:00.000+08:00| 15| |2017-11-02T00:02:00.000+08:00| 15| |2017-11-02T00:03:00.000+08:00| 15| |2017-11-02T00:04:00.000+08:00| 15| |2017-11-02T00:05:00.000+08:00| 15| |2017-11-02T00:06:00.000+08:00| 15| |2017-11-02T00:07:00.000+08:00| 15| |2017-11-02T00:08:00.000+08:00| 15| |2017-11-02T00:09:00.000+08:00| 15| |2017-11-02T00:10:00.000+08:00| 15| |2017-11-02T00:11:00.000+08:00| 15| |2017-11-02T00:12:00.000+08:00| 15| |2017-11-02T00:13:00.000+08:00| 15| |2017-11-02T00:14:00.000+08:00| 15| |2017-11-02T00:15:00.000+08:00| 15| |2017-11-02T00:16:00.000+08:00| 15| |2017-11-02T00:17:00.000+08:00| 15| |2017-11-02T00:18:00.000+08:00| 15| |2017-11-02T00:19:00.000+08:00| 15| |2017-11-02T00:20:00.000+08:00| 15| |2017-11-02T00:21:00.000+08:00| 15| |2017-11-02T00:22:00.000+08:00| 15| |2017-11-02T00:23:00.000+08:00| 15| |2017-11-03T00:00:00.000+08:00| 15| |2017-11-03T00:01:00.000+08:00| 15| |2017-11-03T00:02:00.000+08:00| 15| |2017-11-03T00:03:00.000+08:00| 15| |2017-11-03T00:04:00.000+08:00| 15| |2017-11-03T00:05:00.000+08:00| 15| |2017-11-03T00:06:00.000+08:00| 15| |2017-11-03T00:07:00.000+08:00| 15| |2017-11-03T00:08:00.000+08:00| 15| |2017-11-03T00:09:00.000+08:00| 15| |2017-11-03T00:10:00.000+08:00| 15| |2017-11-03T00:11:00.000+08:00| 15| |2017-11-03T00:12:00.000+08:00| 15| |2017-11-03T00:13:00.000+08:00| 15| |2017-11-03T00:14:00.000+08:00| 15| |2017-11-03T00:15:00.000+08:00| 15| |2017-11-03T00:16:00.000+08:00| 15| |2017-11-03T00:17:00.000+08:00| 15| |2017-11-03T00:18:00.000+08:00| 15| |2017-11-03T00:19:00.000+08:00| 15| |2017-11-03T00:20:00.000+08:00| 15| |2017-11-03T00:21:00.000+08:00| 15| |2017-11-03T00:22:00.000+08:00| 15| |2017-11-03T00:23:00.000+08:00| 15| |2017-11-04T00:00:00.000+08:00| 15| |2017-11-04T00:01:00.000+08:00| 15| |2017-11-04T00:02:00.000+08:00| 15| |2017-11-04T00:03:00.000+08:00| 15| |2017-11-04T00:04:00.000+08:00| 15| |2017-11-04T00:05:00.000+08:00| 15| |2017-11-04T00:06:00.000+08:00| 15| |2017-11-04T00:07:00.000+08:00| 15| |2017-11-04T00:08:00.000+08:00| 15| |2017-11-04T00:09:00.000+08:00| 15| |2017-11-04T00:10:00.000+08:00| 15| |2017-11-04T00:11:00.000+08:00| 15| |2017-11-04T00:12:00.000+08:00| 15| |2017-11-04T00:13:00.000+08:00| 15| |2017-11-04T00:14:00.000+08:00| 15| |2017-11-04T00:15:00.000+08:00| 15| |2017-11-04T00:16:00.000+08:00| 15| |2017-11-04T00:17:00.000+08:00| 15| |2017-11-04T00:18:00.000+08:00| 15| |2017-11-04T00:19:00.000+08:00| 15| |2017-11-04T00:20:00.000+08:00| 15| |2017-11-04T00:21:00.000+08:00| 15| |2017-11-04T00:22:00.000+08:00| 15| |2017-11-04T00:23:00.000+08:00| 15| |2017-11-05T00:00:00.000+08:00| 15| |2017-11-05T00:01:00.000+08:00| 15| |2017-11-05T00:02:00.000+08:00| 15| |2017-11-05T00:03:00.000+08:00| 15| |2017-11-05T00:04:00.000+08:00| 15| |2017-11-05T00:05:00.000+08:00| 15| |2017-11-05T00:06:00.000+08:00| 15| |2017-11-05T00:07:00.000+08:00| 15| |2017-11-05T00:08:00.000+08:00| 15| |2017-11-05T00:09:00.000+08:00| 15| |2017-11-05T00:10:00.000+08:00| 15| |2017-11-05T00:11:00.000+08:00| 15| |2017-11-05T00:12:00.000+08:00| 15| |2017-11-05T00:13:00.000+08:00| 15| |2017-11-05T00:14:00.000+08:00| 15| |2017-11-05T00:15:00.000+08:00| 15| |2017-11-05T00:16:00.000+08:00| 15| |2017-11-05T00:17:00.000+08:00| 15| |2017-11-05T00:18:00.000+08:00| 15| |2017-11-05T00:19:00.000+08:00| 15| |2017-11-05T00:20:00.000+08:00| 15| |2017-11-05T00:21:00.000+08:00| 15| |2017-11-05T00:22:00.000+08:00| 15| |2017-11-05T00:23:00.000+08:00| 15| |2017-11-06T00:00:00.000+08:00| 15| |2017-11-06T00:01:00.000+08:00| 15| |2017-11-06T00:02:00.000+08:00| 15| |2017-11-06T00:03:00.000+08:00| 15| |2017-11-06T00:04:00.000+08:00| 15| |2017-11-06T00:05:00.000+08:00| 15| |2017-11-06T00:06:00.000+08:00| 15| |2017-11-06T00:07:00.000+08:00| 15| |2017-11-06T00:08:00.000+08:00| 15| |2017-11-06T00:09:00.000+08:00| 15| |2017-11-06T00:10:00.000+08:00| 15| |2017-11-06T00:11:00.000+08:00| 15| |2017-11-06T00:12:00.000+08:00| 15| |2017-11-06T00:13:00.000+08:00| 15| |2017-11-06T00:14:00.000+08:00| 15| |2017-11-06T00:15:00.000+08:00| 15| |2017-11-06T00:16:00.000+08:00| 15| |2017-11-06T00:17:00.000+08:00| 15| |2017-11-06T00:18:00.000+08:00| 15| |2017-11-06T00:19:00.000+08:00| 15| |2017-11-06T00:20:00.000+08:00| 15| |2017-11-06T00:21:00.000+08:00| 15| |2017-11-06T00:22:00.000+08:00| 15| |2017-11-06T00:23:00.000+08:00| 15| |2017-11-07T00:00:00.000+08:00| 15| |2017-11-07T00:01:00.000+08:00| 15| |2017-11-07T00:02:00.000+08:00| 15| |2017-11-07T00:03:00.000+08:00| 15| |2017-11-07T00:04:00.000+08:00| 15| |2017-11-07T00:05:00.000+08:00| 15| |2017-11-07T00:06:00.000+08:00| 15| |2017-11-07T00:07:00.000+08:00| 15| |2017-11-07T00:08:00.000+08:00| 15| |2017-11-07T00:09:00.000+08:00| 15| |2017-11-07T00:10:00.000+08:00| 15| |2017-11-07T00:11:00.000+08:00| 15| |2017-11-07T00:12:00.000+08:00| 15| |2017-11-07T00:13:00.000+08:00| 15| |2017-11-07T00:14:00.000+08:00| 15| |2017-11-07T00:15:00.000+08:00| 15| |2017-11-07T00:16:00.000+08:00| 15| |2017-11-07T00:17:00.000+08:00| 15| |2017-11-07T00:18:00.000+08:00| 15| |2017-11-07T00:19:00.000+08:00| 15| |2017-11-07T00:20:00.000+08:00| 15| |2017-11-07T00:21:00.000+08:00| 15| |2017-11-07T00:22:00.000+08:00| 15| |2017-11-07T00:23:00.000+08:00| 15| |2017-11-08T00:00:00.000+08:00| 15| |2017-11-08T00:01:00.000+08:00| 15| |2017-11-08T00:02:00.000+08:00| 15| |2017-11-08T00:03:00.000+08:00| 15| |2017-11-08T00:04:00.000+08:00| 15| |2017-11-08T00:05:00.000+08:00| 15| |2017-11-08T00:06:00.000+08:00| 15| |2017-11-08T00:07:00.000+08:00| 15| |2017-11-08T00:08:00.000+08:00| 15| |2017-11-08T00:09:00.000+08:00| 15| |2017-11-08T00:10:00.000+08:00| 15| |2017-11-08T00:11:00.000+08:00| 15| |2017-11-08T00:12:00.000+08:00| 15| |2017-11-08T00:13:00.000+08:00| 15| |2017-11-08T00:14:00.000+08:00| 15| |2017-11-08T00:15:00.000+08:00| 15| |2017-11-08T00:16:00.000+08:00| 15| |2017-11-08T00:17:00.000+08:00| 15| |2017-11-08T00:18:00.000+08:00| 15| |2017-11-08T00:19:00.000+08:00| 15| |2017-11-08T00:20:00.000+08:00| 15| |2017-11-08T00:21:00.000+08:00| 15| |2017-11-08T00:22:00.000+08:00| 15| |2017-11-08T00:23:00.000+08:00| 15| |2017-11-09T00:00:00.000+08:00| 15| |2017-11-09T00:01:00.000+08:00| 15| |2017-11-09T00:02:00.000+08:00| 15| |2017-11-09T00:03:00.000+08:00| 15| |2017-11-09T00:04:00.000+08:00| 15| |2017-11-09T00:05:00.000+08:00| 15| |2017-11-09T00:06:00.000+08:00| 15| |2017-11-09T00:07:00.000+08:00| 15| |2017-11-09T00:08:00.000+08:00| 15| |2017-11-09T00:09:00.000+08:00| 15| |2017-11-09T00:10:00.000+08:00| 15| |2017-11-09T00:11:00.000+08:00| 15| |2017-11-09T00:12:00.000+08:00| 15| |2017-11-09T00:13:00.000+08:00| 15| |2017-11-09T00:14:00.000+08:00| 15| |2017-11-09T00:15:00.000+08:00| 15| |2017-11-09T00:16:00.000+08:00| 15| |2017-11-09T00:17:00.000+08:00| 15| |2017-11-09T00:18:00.000+08:00| 15| |2017-11-09T00:19:00.000+08:00| 15| |2017-11-09T00:20:00.000+08:00| 15| |2017-11-09T00:21:00.000+08:00| 15| |2017-11-09T00:22:00.000+08:00| 15| |2017-11-09T00:23:00.000+08:00| 15| +-----------------------------+------------------------+ Total line number = 216 It costs 0.141s 测试用例编号 dml_433-3 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) delete from root.ln.wf01.wt01 where time=2017-11-01T00:05:00.000; select * from root.ln cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: The statement is executed successfully. +-----------------------------+-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status| +-----------------------------+-----------------------------+------------------------+ |2017-11-01T00:00:00.000+08:00| 15| 15| |2017-11-01T00:01:00.000+08:00| 15| 15| |2017-11-01T00:02:00.000+08:00| 15| 15| |2017-11-01T00:03:00.000+08:00| 15| 15| |2017-11-01T00:04:00.000+08:00| 15| 15| |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| |2017-11-01T00:11:00.000+08:00| 15| 15| |2017-11-01T00:12:00.000+08:00| 15| 15| |2017-11-01T00:13:00.000+08:00| 15| 15| |2017-11-01T00:14:00.000+08:00| 15| 15| |2017-11-01T00:15:00.000+08:00| 15| 15| |2017-11-01T00:16:00.000+08:00| 15| 15| |2017-11-01T00:17:00.000+08:00| 15| 15| |2017-11-01T00:18:00.000+08:00| 15| 15| |2017-11-01T00:19:00.000+08:00| 15| 15| |2017-11-01T00:20:00.000+08:00| 15| 15| |2017-11-01T00:21:00.000+08:00| 15| 15| |2017-11-01T00:22:00.000+08:00| 15| 15| |2017-11-01T00:23:00.000+08:00| 15| 15| |2017-11-02T00:00:00.000+08:00| 15| 15| |2017-11-02T00:01:00.000+08:00| 15| 15| |2017-11-02T00:02:00.000+08:00| 15| 15| |2017-11-02T00:03:00.000+08:00| 15| 15| |2017-11-02T00:04:00.000+08:00| 15| 15| |2017-11-02T00:05:00.000+08:00| 15| 15| |2017-11-02T00:06:00.000+08:00| 15| 15| |2017-11-02T00:07:00.000+08:00| 15| 15| |2017-11-02T00:08:00.000+08:00| 15| 15| |2017-11-02T00:09:00.000+08:00| 15| 15| |2017-11-02T00:10:00.000+08:00| 15| 15| |2017-11-02T00:11:00.000+08:00| 15| 15| |2017-11-02T00:12:00.000+08:00| 15| 15| |2017-11-02T00:13:00.000+08:00| 15| 15| |2017-11-02T00:14:00.000+08:00| 15| 15| |2017-11-02T00:15:00.000+08:00| 15| 15| |2017-11-02T00:16:00.000+08:00| 15| 15| |2017-11-02T00:17:00.000+08:00| 15| 15| |2017-11-02T00:18:00.000+08:00| 15| 15| |2017-11-02T00:19:00.000+08:00| 15| 15| |2017-11-02T00:20:00.000+08:00| 15| 15| |2017-11-02T00:21:00.000+08:00| 15| 15| |2017-11-02T00:22:00.000+08:00| 15| 15| |2017-11-02T00:23:00.000+08:00| 15| 15| |2017-11-03T00:00:00.000+08:00| 15| 15| |2017-11-03T00:01:00.000+08:00| 15| 15| |2017-11-03T00:02:00.000+08:00| 15| 15| |2017-11-03T00:03:00.000+08:00| 15| 15| |2017-11-03T00:04:00.000+08:00| 15| 15| |2017-11-03T00:05:00.000+08:00| 15| 15| |2017-11-03T00:06:00.000+08:00| 15| 15| |2017-11-03T00:07:00.000+08:00| 15| 15| |2017-11-03T00:08:00.000+08:00| 15| 15| |2017-11-03T00:09:00.000+08:00| 15| 15| |2017-11-03T00:10:00.000+08:00| 15| 15| |2017-11-03T00:11:00.000+08:00| 15| 15| |2017-11-03T00:12:00.000+08:00| 15| 15| |2017-11-03T00:13:00.000+08:00| 15| 15| |2017-11-03T00:14:00.000+08:00| 15| 15| |2017-11-03T00:15:00.000+08:00| 15| 15| |2017-11-03T00:16:00.000+08:00| 15| 15| |2017-11-03T00:17:00.000+08:00| 15| 15| |2017-11-03T00:18:00.000+08:00| 15| 15| |2017-11-03T00:19:00.000+08:00| 15| 15| |2017-11-03T00:20:00.000+08:00| 15| 15| |2017-11-03T00:21:00.000+08:00| 15| 15| |2017-11-03T00:22:00.000+08:00| 15| 15| |2017-11-03T00:23:00.000+08:00| 15| 15| |2017-11-04T00:00:00.000+08:00| 15| 15| |2017-11-04T00:01:00.000+08:00| 15| 15| |2017-11-04T00:02:00.000+08:00| 15| 15| |2017-11-04T00:03:00.000+08:00| 15| 15| |2017-11-04T00:04:00.000+08:00| 15| 15| |2017-11-04T00:05:00.000+08:00| 15| 15| |2017-11-04T00:06:00.000+08:00| 15| 15| |2017-11-04T00:07:00.000+08:00| 15| 15| |2017-11-04T00:08:00.000+08:00| 15| 15| |2017-11-04T00:09:00.000+08:00| 15| 15| |2017-11-04T00:10:00.000+08:00| 15| 15| |2017-11-04T00:11:00.000+08:00| 15| 15| |2017-11-04T00:12:00.000+08:00| 15| 15| |2017-11-04T00:13:00.000+08:00| 15| 15| |2017-11-04T00:14:00.000+08:00| 15| 15| |2017-11-04T00:15:00.000+08:00| 15| 15| |2017-11-04T00:16:00.000+08:00| 15| 15| |2017-11-04T00:17:00.000+08:00| 15| 15| |2017-11-04T00:18:00.000+08:00| 15| 15| |2017-11-04T00:19:00.000+08:00| 15| 15| |2017-11-04T00:20:00.000+08:00| 15| 15| |2017-11-04T00:21:00.000+08:00| 15| 15| |2017-11-04T00:22:00.000+08:00| 15| 15| |2017-11-04T00:23:00.000+08:00| 15| 15| |2017-11-05T00:00:00.000+08:00| 15| 15| |2017-11-05T00:01:00.000+08:00| 15| 15| |2017-11-05T00:02:00.000+08:00| 15| 15| |2017-11-05T00:03:00.000+08:00| 15| 15| |2017-11-05T00:04:00.000+08:00| 15| 15| |2017-11-05T00:05:00.000+08:00| 15| 15| |2017-11-05T00:06:00.000+08:00| 15| 15| |2017-11-05T00:07:00.000+08:00| 15| 15| |2017-11-05T00:08:00.000+08:00| 15| 15| |2017-11-05T00:09:00.000+08:00| 15| 15| |2017-11-05T00:10:00.000+08:00| 15| 15| |2017-11-05T00:11:00.000+08:00| 15| 15| |2017-11-05T00:12:00.000+08:00| 15| 15| |2017-11-05T00:13:00.000+08:00| 15| 15| |2017-11-05T00:14:00.000+08:00| 15| 15| |2017-11-05T00:15:00.000+08:00| 15| 15| |2017-11-05T00:16:00.000+08:00| 15| 15| |2017-11-05T00:17:00.000+08:00| 15| 15| |2017-11-05T00:18:00.000+08:00| 15| 15| |2017-11-05T00:19:00.000+08:00| 15| 15| |2017-11-05T00:20:00.000+08:00| 15| 15| |2017-11-05T00:21:00.000+08:00| 15| 15| |2017-11-05T00:22:00.000+08:00| 15| 15| |2017-11-05T00:23:00.000+08:00| 15| 15| |2017-11-06T00:00:00.000+08:00| 15| 15| |2017-11-06T00:01:00.000+08:00| 15| 15| |2017-11-06T00:02:00.000+08:00| 15| 15| |2017-11-06T00:03:00.000+08:00| 15| 15| |2017-11-06T00:04:00.000+08:00| 15| 15| |2017-11-06T00:05:00.000+08:00| 15| 15| |2017-11-06T00:06:00.000+08:00| 15| 15| |2017-11-06T00:07:00.000+08:00| 15| 15| |2017-11-06T00:08:00.000+08:00| 15| 15| |2017-11-06T00:09:00.000+08:00| 15| 15| |2017-11-06T00:10:00.000+08:00| 15| 15| |2017-11-06T00:11:00.000+08:00| 15| 15| |2017-11-06T00:12:00.000+08:00| 15| 15| |2017-11-06T00:13:00.000+08:00| 15| 15| |2017-11-06T00:14:00.000+08:00| 15| 15| |2017-11-06T00:15:00.000+08:00| 15| 15| |2017-11-06T00:16:00.000+08:00| 15| 15| |2017-11-06T00:17:00.000+08:00| 15| 15| |2017-11-06T00:18:00.000+08:00| 15| 15| |2017-11-06T00:19:00.000+08:00| 15| 15| |2017-11-06T00:20:00.000+08:00| 15| 15| |2017-11-06T00:21:00.000+08:00| 15| 15| |2017-11-06T00:22:00.000+08:00| 15| 15| |2017-11-06T00:23:00.000+08:00| 15| 15| |2017-11-07T00:00:00.000+08:00| 15| 15| |2017-11-07T00:01:00.000+08:00| 15| 15| |2017-11-07T00:02:00.000+08:00| 15| 15| |2017-11-07T00:03:00.000+08:00| 15| 15| |2017-11-07T00:04:00.000+08:00| 15| 15| |2017-11-07T00:05:00.000+08:00| 15| 15| |2017-11-07T00:06:00.000+08:00| 15| 15| |2017-11-07T00:07:00.000+08:00| 15| 15| |2017-11-07T00:08:00.000+08:00| 15| 15| |2017-11-07T00:09:00.000+08:00| 15| 15| |2017-11-07T00:10:00.000+08:00| 15| 15| |2017-11-07T00:11:00.000+08:00| 15| 15| |2017-11-07T00:12:00.000+08:00| 15| 15| |2017-11-07T00:13:00.000+08:00| 15| 15| |2017-11-07T00:14:00.000+08:00| 15| 15| |2017-11-07T00:15:00.000+08:00| 15| 15| |2017-11-07T00:16:00.000+08:00| 15| 15| |2017-11-07T00:17:00.000+08:00| 15| 15| |2017-11-07T00:18:00.000+08:00| 15| 15| |2017-11-07T00:19:00.000+08:00| 15| 15| |2017-11-07T00:20:00.000+08:00| 15| 15| |2017-11-07T00:21:00.000+08:00| 15| 15| |2017-11-07T00:22:00.000+08:00| 15| 15| |2017-11-07T00:23:00.000+08:00| 15| 15| |2017-11-08T00:00:00.000+08:00| 15| 15| |2017-11-08T00:01:00.000+08:00| 15| 15| |2017-11-08T00:02:00.000+08:00| 15| 15| |2017-11-08T00:03:00.000+08:00| 15| 15| |2017-11-08T00:04:00.000+08:00| 15| 15| |2017-11-08T00:05:00.000+08:00| 15| 15| |2017-11-08T00:06:00.000+08:00| 15| 15| |2017-11-08T00:07:00.000+08:00| 15| 15| |2017-11-08T00:08:00.000+08:00| 15| 15| |2017-11-08T00:09:00.000+08:00| 15| 15| |2017-11-08T00:10:00.000+08:00| 15| 15| |2017-11-08T00:11:00.000+08:00| 15| 15| |2017-11-08T00:12:00.000+08:00| 15| 15| |2017-11-08T00:13:00.000+08:00| 15| 15| |2017-11-08T00:14:00.000+08:00| 15| 15| |2017-11-08T00:15:00.000+08:00| 15| 15| |2017-11-08T00:16:00.000+08:00| 15| 15| |2017-11-08T00:17:00.000+08:00| 15| 15| |2017-11-08T00:18:00.000+08:00| 15| 15| |2017-11-08T00:19:00.000+08:00| 15| 15| |2017-11-08T00:20:00.000+08:00| 15| 15| |2017-11-08T00:21:00.000+08:00| 15| 15| |2017-11-08T00:22:00.000+08:00| 15| 15| |2017-11-08T00:23:00.000+08:00| 15| 15| |2017-11-09T00:00:00.000+08:00| 15| 15| |2017-11-09T00:01:00.000+08:00| 15| 15| |2017-11-09T00:02:00.000+08:00| 15| 15| |2017-11-09T00:03:00.000+08:00| 15| 15| |2017-11-09T00:04:00.000+08:00| 15| 15| |2017-11-09T00:05:00.000+08:00| 15| 15| |2017-11-09T00:06:00.000+08:00| 15| 15| |2017-11-09T00:07:00.000+08:00| 15| 15| |2017-11-09T00:08:00.000+08:00| 15| 15| |2017-11-09T00:09:00.000+08:00| 15| 15| |2017-11-09T00:10:00.000+08:00| 15| 15| |2017-11-09T00:11:00.000+08:00| 15| 15| |2017-11-09T00:12:00.000+08:00| 15| 15| |2017-11-09T00:13:00.000+08:00| 15| 15| |2017-11-09T00:14:00.000+08:00| 15| 15| |2017-11-09T00:15:00.000+08:00| 15| 15| |2017-11-09T00:16:00.000+08:00| 15| 15| |2017-11-09T00:17:00.000+08:00| 15| 15| |2017-11-09T00:18:00.000+08:00| 15| 15| |2017-11-09T00:19:00.000+08:00| 15| 15| |2017-11-09T00:20:00.000+08:00| 15| 15| |2017-11-09T00:21:00.000+08:00| 15| 15| |2017-11-09T00:22:00.000+08:00| 15| 15| |2017-11-09T00:23:00.000+08:00| 15| 15| +-----------------------------+-----------------------------+------------------------+ Total line number = 215 It costs 0.200s 测试用例编号 dml_433-4 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) delete from root.ln.wf02.wt02 where time>2017-11-07T00:05:00.000 delete from root.ln.wf02.wt02 where time<2017-11-01T00:05:00.000 delete from root.ln.wf02.wt02 where time>=2017-11-02T00:05:00.000 and time<=2017-11-03T00:05:00.000 select * from root.ln cluster结果 Msg: 303: Storage group is not set for current seriesPath: [root.ln.wf01.wt01.temperature] Msg: The statement is executed successfully. Msg: 304: Path [root.ln.wf02.wt02] does not exist Msg: 304: Path [root.ln.wf02.wt02] does not exist Msg: 304: Path [root.ln.wf02.wt02] does not exist +-----------------------------+-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status| +-----------------------------+-----------------------------+------------------------+ |2017-11-01T00:00:00.000+08:00| 15| 15| |2017-11-01T00:01:00.000+08:00| 15| 15| |2017-11-01T00:02:00.000+08:00| 15| 15| |2017-11-01T00:03:00.000+08:00| 15| 15| |2017-11-01T00:04:00.000+08:00| 15| 15| |2017-11-01T00:05:00.000+08:00| 15| 15| |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| |2017-11-01T00:11:00.000+08:00| 15| 15| |2017-11-01T00:12:00.000+08:00| 15| 15| |2017-11-01T00:13:00.000+08:00| 15| 15| |2017-11-01T00:14:00.000+08:00| 15| 15| |2017-11-01T00:15:00.000+08:00| 15| 15| |2017-11-01T00:16:00.000+08:00| 15| 15| |2017-11-01T00:17:00.000+08:00| 15| 15| |2017-11-01T00:18:00.000+08:00| 15| 15| |2017-11-01T00:19:00.000+08:00| 15| 15| |2017-11-01T00:20:00.000+08:00| 15| 15| |2017-11-01T00:21:00.000+08:00| 15| 15| |2017-11-01T00:22:00.000+08:00| 15| 15| |2017-11-01T00:23:00.000+08:00| 15| 15| |2017-11-02T00:00:00.000+08:00| 15| 15| |2017-11-02T00:01:00.000+08:00| 15| 15| |2017-11-02T00:02:00.000+08:00| 15| 15| |2017-11-02T00:03:00.000+08:00| 15| 15| |2017-11-02T00:04:00.000+08:00| 15| 15| |2017-11-02T00:05:00.000+08:00| 15| 15| |2017-11-02T00:06:00.000+08:00| 15| 15| |2017-11-02T00:07:00.000+08:00| 15| 15| |2017-11-02T00:08:00.000+08:00| 15| 15| |2017-11-02T00:09:00.000+08:00| 15| 15| |2017-11-02T00:10:00.000+08:00| 15| 15| |2017-11-02T00:11:00.000+08:00| 15| 15| |2017-11-02T00:12:00.000+08:00| 15| 15| |2017-11-02T00:13:00.000+08:00| 15| 15| |2017-11-02T00:14:00.000+08:00| null| 15| |2017-11-02T00:15:00.000+08:00| 15| 15| |2017-11-02T00:16:00.000+08:00| 15| 15| |2017-11-02T00:17:00.000+08:00| 15| 15| |2017-11-02T00:18:00.000+08:00| 15| 15| |2017-11-02T00:19:00.000+08:00| 15| 15| |2017-11-02T00:20:00.000+08:00| 15| 15| |2017-11-02T00:21:00.000+08:00| 15| 15| |2017-11-02T00:22:00.000+08:00| 15| 15| |2017-11-02T00:23:00.000+08:00| 15| 15| |2017-11-03T00:00:00.000+08:00| 15| 15| |2017-11-03T00:01:00.000+08:00| 15| 15| |2017-11-03T00:02:00.000+08:00| 15| 15| |2017-11-03T00:03:00.000+08:00| 15| 15| |2017-11-03T00:04:00.000+08:00| 15| 15| |2017-11-03T00:05:00.000+08:00| 15| 15| |2017-11-03T00:06:00.000+08:00| 15| 15| |2017-11-03T00:07:00.000+08:00| 15| 15| |2017-11-03T00:08:00.000+08:00| 15| 15| |2017-11-03T00:09:00.000+08:00| 15| 15| |2017-11-03T00:10:00.000+08:00| 15| 15| |2017-11-03T00:11:00.000+08:00| null| 15| |2017-11-03T00:12:00.000+08:00| 15| 15| |2017-11-03T00:13:00.000+08:00| 15| 15| |2017-11-03T00:14:00.000+08:00| 15| 15| |2017-11-03T00:15:00.000+08:00| 15| 15| |2017-11-03T00:16:00.000+08:00| 15| 15| |2017-11-03T00:17:00.000+08:00| 15| 15| |2017-11-03T00:18:00.000+08:00| 15| 15| |2017-11-03T00:19:00.000+08:00| 15| 15| |2017-11-03T00:20:00.000+08:00| 15| 15| |2017-11-03T00:21:00.000+08:00| 15| 15| |2017-11-03T00:22:00.000+08:00| 15| 15| |2017-11-03T00:23:00.000+08:00| 15| 15| |2017-11-04T00:00:00.000+08:00| 15| 15| |2017-11-04T00:01:00.000+08:00| 15| 15| |2017-11-04T00:02:00.000+08:00| 15| 15| |2017-11-04T00:03:00.000+08:00| 15| 15| |2017-11-04T00:04:00.000+08:00| 15| 15| |2017-11-04T00:05:00.000+08:00| 15| 15| |2017-11-04T00:06:00.000+08:00| 15| 15| |2017-11-04T00:07:00.000+08:00| 15| 15| |2017-11-04T00:08:00.000+08:00| 15| 15| |2017-11-04T00:09:00.000+08:00| 15| 15| |2017-11-04T00:10:00.000+08:00| 15| 15| |2017-11-04T00:11:00.000+08:00| 15| 15| |2017-11-04T00:12:00.000+08:00| 15| 15| |2017-11-04T00:13:00.000+08:00| 15| 15| |2017-11-04T00:14:00.000+08:00| 15| 15| |2017-11-04T00:15:00.000+08:00| 15| 15| |2017-11-04T00:16:00.000+08:00| 15| 15| |2017-11-04T00:17:00.000+08:00| 15| 15| |2017-11-04T00:18:00.000+08:00| 15| 15| |2017-11-04T00:19:00.000+08:00| 15| 15| |2017-11-04T00:20:00.000+08:00| 15| 15| |2017-11-04T00:21:00.000+08:00| 15| 15| |2017-11-04T00:22:00.000+08:00| 15| 15| |2017-11-04T00:23:00.000+08:00| 15| 15| |2017-11-05T00:00:00.000+08:00| 15| 15| |2017-11-05T00:01:00.000+08:00| 15| 15| |2017-11-05T00:02:00.000+08:00| 15| 15| |2017-11-05T00:03:00.000+08:00| 15| 15| |2017-11-05T00:04:00.000+08:00| 15| 15| |2017-11-05T00:05:00.000+08:00| 15| 15| |2017-11-05T00:06:00.000+08:00| 15| 15| |2017-11-05T00:07:00.000+08:00| 15| 15| |2017-11-05T00:08:00.000+08:00| 15| 15| |2017-11-05T00:09:00.000+08:00| 15| 15| |2017-11-05T00:10:00.000+08:00| 15| 15| |2017-11-05T00:11:00.000+08:00| 15| 15| |2017-11-05T00:12:00.000+08:00| 15| 15| |2017-11-05T00:13:00.000+08:00| 15| 15| |2017-11-05T00:14:00.000+08:00| 15| 15| |2017-11-05T00:15:00.000+08:00| 15| 15| |2017-11-05T00:16:00.000+08:00| 15| 15| |2017-11-05T00:17:00.000+08:00| 15| 15| |2017-11-05T00:18:00.000+08:00| 15| 15| |2017-11-05T00:19:00.000+08:00| 15| 15| |2017-11-05T00:20:00.000+08:00| 15| 15| |2017-11-05T00:21:00.000+08:00| 15| 15| |2017-11-05T00:22:00.000+08:00| 15| 15| |2017-11-05T00:23:00.000+08:00| 15| 15| |2017-11-06T00:00:00.000+08:00| 15| 15| |2017-11-06T00:01:00.000+08:00| 15| 15| |2017-11-06T00:02:00.000+08:00| 15| 15| |2017-11-06T00:03:00.000+08:00| 15| 15| |2017-11-06T00:04:00.000+08:00| 15| 15| |2017-11-06T00:05:00.000+08:00| 15| 15| |2017-11-06T00:06:00.000+08:00| 15| 15| |2017-11-06T00:07:00.000+08:00| 15| 15| |2017-11-06T00:08:00.000+08:00| 15| 15| |2017-11-06T00:09:00.000+08:00| 15| 15| |2017-11-06T00:10:00.000+08:00| 15| 15| |2017-11-06T00:11:00.000+08:00| 15| 15| |2017-11-06T00:12:00.000+08:00| 15| 15| |2017-11-06T00:13:00.000+08:00| 15| 15| |2017-11-06T00:14:00.000+08:00| 15| 15| |2017-11-06T00:15:00.000+08:00| 15| 15| |2017-11-06T00:16:00.000+08:00| 15| 15| |2017-11-06T00:17:00.000+08:00| 15| 15| |2017-11-06T00:18:00.000+08:00| 15| 15| |2017-11-06T00:19:00.000+08:00| 15| 15| |2017-11-06T00:20:00.000+08:00| 15| 15| |2017-11-06T00:21:00.000+08:00| 15| 15| |2017-11-06T00:22:00.000+08:00| 15| 15| |2017-11-06T00:23:00.000+08:00| 15| 15| |2017-11-07T00:00:00.000+08:00| 15| 15| |2017-11-07T00:01:00.000+08:00| 15| 15| |2017-11-07T00:02:00.000+08:00| 15| 15| |2017-11-07T00:03:00.000+08:00| 15| 15| |2017-11-07T00:04:00.000+08:00| 15| 15| |2017-11-07T00:05:00.000+08:00| 15| 15| |2017-11-07T00:06:00.000+08:00| 15| 15| |2017-11-07T00:07:00.000+08:00| 15| 15| |2017-11-07T00:08:00.000+08:00| 15| 15| |2017-11-07T00:09:00.000+08:00| 15| 15| |2017-11-07T00:10:00.000+08:00| 15| 15| |2017-11-07T00:11:00.000+08:00| 15| 15| |2017-11-07T00:12:00.000+08:00| 15| 15| |2017-11-07T00:13:00.000+08:00| 15| 15| |2017-11-07T00:14:00.000+08:00| 15| 15| |2017-11-07T00:15:00.000+08:00| 15| 15| |2017-11-07T00:16:00.000+08:00| 15| 15| |2017-11-07T00:17:00.000+08:00| 15| 15| |2017-11-07T00:18:00.000+08:00| 15| 15| |2017-11-07T00:19:00.000+08:00| 15| 15| |2017-11-07T00:20:00.000+08:00| 15| 15| |2017-11-07T00:21:00.000+08:00| 15| 15| |2017-11-07T00:22:00.000+08:00| 15| 15| |2017-11-07T00:23:00.000+08:00| 15| 15| |2017-11-08T00:00:00.000+08:00| 15| 15| |2017-11-08T00:01:00.000+08:00| 15| 15| |2017-11-08T00:02:00.000+08:00| 15| 15| |2017-11-08T00:03:00.000+08:00| 15| 15| |2017-11-08T00:04:00.000+08:00| 15| 15| |2017-11-08T00:05:00.000+08:00| 15| 15| |2017-11-08T00:06:00.000+08:00| 15| 15| |2017-11-08T00:07:00.000+08:00| 15| 15| |2017-11-08T00:08:00.000+08:00| 15| 15| |2017-11-08T00:09:00.000+08:00| 15| 15| |2017-11-08T00:10:00.000+08:00| 15| 15| |2017-11-08T00:11:00.000+08:00| 15| 15| |2017-11-08T00:12:00.000+08:00| 15| 15| |2017-11-08T00:13:00.000+08:00| 15| 15| |2017-11-08T00:14:00.000+08:00| 15| 15| |2017-11-08T00:15:00.000+08:00| 15| 15| |2017-11-08T00:16:00.000+08:00| 15| 15| |2017-11-08T00:17:00.000+08:00| 15| 15| |2017-11-08T00:18:00.000+08:00| 15| 15| |2017-11-08T00:19:00.000+08:00| 15| 15| |2017-11-08T00:20:00.000+08:00| 15| 15| |2017-11-08T00:21:00.000+08:00| 15| 15| |2017-11-08T00:22:00.000+08:00| 15| 15| |2017-11-08T00:23:00.000+08:00| 15| 15| |2017-11-09T00:00:00.000+08:00| 15| 15| |2017-11-09T00:01:00.000+08:00| 15| 15| |2017-11-09T00:02:00.000+08:00| 15| 15| |2017-11-09T00:03:00.000+08:00| 15| 15| |2017-11-09T00:04:00.000+08:00| 15| 15| |2017-11-09T00:05:00.000+08:00| 15| 15| |2017-11-09T00:06:00.000+08:00| 15| 15| |2017-11-09T00:07:00.000+08:00| 15| 15| |2017-11-09T00:08:00.000+08:00| 15| 15| |2017-11-09T00:09:00.000+08:00| 15| 15| |2017-11-09T00:10:00.000+08:00| 15| 15| |2017-11-09T00:11:00.000+08:00| 15| 15| |2017-11-09T00:12:00.000+08:00| 15| 15| |2017-11-09T00:13:00.000+08:00| 15| 15| |2017-11-09T00:14:00.000+08:00| 15| 15| |2017-11-09T00:15:00.000+08:00| 15| 15| |2017-11-09T00:16:00.000+08:00| 15| 15| |2017-11-09T00:17:00.000+08:00| 15| 15| |2017-11-09T00:18:00.000+08:00| 15| 15| |2017-11-09T00:19:00.000+08:00| 15| 15| |2017-11-09T00:20:00.000+08:00| 15| 15| |2017-11-09T00:21:00.000+08:00| 15| 15| |2017-11-09T00:22:00.000+08:00| 15| 15| |2017-11-09T00:23:00.000+08:00| 15| 15| +-----------------------------+-----------------------------+------------------------+ Total line number = 216 It costs 0.140s 测试用例编号 dml_434-1 测试语句 create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, status) delete from root.ln.wf01.wt02.status where time<=2017-11-01T16:26:00; select * from root.ln cluster结果 Msg: The statement is executed successfully. Msg: 304: Path [root.ln.wf01.wt02.status] does not exist +-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.status| +-----------------------------+------------------------+ |2017-11-01T00:00:00.000+08:00| 15| |2017-11-01T00:01:00.000+08:00| 15| |2017-11-01T00:02:00.000+08:00| 15| |2017-11-01T00:03:00.000+08:00| 15| |2017-11-01T00:04:00.000+08:00| 15| |2017-11-01T00:05:00.000+08:00| 15| |2017-11-01T00:06:00.000+08:00| 15| |2017-11-01T00:07:00.000+08:00| 15| |2017-11-01T00:08:00.000+08:00| 15| |2017-11-01T00:09:00.000+08:00| 15| |2017-11-01T00:10:00.000+08:00| 15| |2017-11-01T00:11:00.000+08:00| 15| |2017-11-01T00:12:00.000+08:00| 15| |2017-11-01T00:13:00.000+08:00| 15| |2017-11-01T00:14:00.000+08:00| 15| |2017-11-01T00:15:00.000+08:00| 15| |2017-11-01T00:16:00.000+08:00| 15| |2017-11-01T00:17:00.000+08:00| 15| |2017-11-01T00:18:00.000+08:00| 15| |2017-11-01T00:19:00.000+08:00| 15| |2017-11-01T00:20:00.000+08:00| 15| |2017-11-01T00:21:00.000+08:00| 15| |2017-11-01T00:22:00.000+08:00| 15| |2017-11-01T00:23:00.000+08:00| 15| |2017-11-02T00:00:00.000+08:00| 15| |2017-11-02T00:01:00.000+08:00| 15| |2017-11-02T00:02:00.000+08:00| 15| |2017-11-02T00:03:00.000+08:00| 15| |2017-11-02T00:04:00.000+08:00| 15| |2017-11-02T00:05:00.000+08:00| 15| |2017-11-02T00:06:00.000+08:00| 15| |2017-11-02T00:07:00.000+08:00| 15| |2017-11-02T00:08:00.000+08:00| 15| |2017-11-02T00:09:00.000+08:00| 15| |2017-11-02T00:10:00.000+08:00| 15| |2017-11-02T00:11:00.000+08:00| 15| |2017-11-02T00:12:00.000+08:00| 15| |2017-11-02T00:13:00.000+08:00| 15| |2017-11-02T00:14:00.000+08:00| 15| |2017-11-02T00:15:00.000+08:00| 15| |2017-11-02T00:16:00.000+08:00| 15| |2017-11-02T00:17:00.000+08:00| 15| |2017-11-02T00:18:00.000+08:00| 15| |2017-11-02T00:19:00.000+08:00| 15| |2017-11-02T00:20:00.000+08:00| 15| |2017-11-02T00:21:00.000+08:00| 15| |2017-11-02T00:22:00.000+08:00| 15| |2017-11-02T00:23:00.000+08:00| 15| |2017-11-03T00:00:00.000+08:00| 15| |2017-11-03T00:01:00.000+08:00| 15| |2017-11-03T00:02:00.000+08:00| 15| |2017-11-03T00:03:00.000+08:00| 15| |2017-11-03T00:04:00.000+08:00| 15| |2017-11-03T00:05:00.000+08:00| 15| |2017-11-03T00:06:00.000+08:00| 15| |2017-11-03T00:07:00.000+08:00| 15| |2017-11-03T00:08:00.000+08:00| 15| |2017-11-03T00:09:00.000+08:00| 15| |2017-11-03T00:10:00.000+08:00| 15| |2017-11-03T00:11:00.000+08:00| 15| |2017-11-03T00:12:00.000+08:00| 15| |2017-11-03T00:13:00.000+08:00| 15| |2017-11-03T00:14:00.000+08:00| 15| |2017-11-03T00:15:00.000+08:00| 15| |2017-11-03T00:16:00.000+08:00| 15| |2017-11-03T00:17:00.000+08:00| 15| |2017-11-03T00:18:00.000+08:00| 15| |2017-11-03T00:19:00.000+08:00| 15| |2017-11-03T00:20:00.000+08:00| 15| |2017-11-03T00:21:00.000+08:00| 15| |2017-11-03T00:22:00.000+08:00| 15| |2017-11-03T00:23:00.000+08:00| 15| |2017-11-04T00:00:00.000+08:00| 15| |2017-11-04T00:01:00.000+08:00| 15| |2017-11-04T00:02:00.000+08:00| 15| |2017-11-04T00:03:00.000+08:00| 15| |2017-11-04T00:04:00.000+08:00| 15| |2017-11-04T00:05:00.000+08:00| 15| |2017-11-04T00:06:00.000+08:00| 15| |2017-11-04T00:07:00.000+08:00| 15| |2017-11-04T00:08:00.000+08:00| 15| |2017-11-04T00:09:00.000+08:00| 15| |2017-11-04T00:10:00.000+08:00| 15| |2017-11-04T00:11:00.000+08:00| 15| |2017-11-04T00:12:00.000+08:00| 15| |2017-11-04T00:13:00.000+08:00| 15| |2017-11-04T00:14:00.000+08:00| 15| |2017-11-04T00:15:00.000+08:00| 15| |2017-11-04T00:16:00.000+08:00| 15| |2017-11-04T00:17:00.000+08:00| 15| |2017-11-04T00:18:00.000+08:00| 15| |2017-11-04T00:19:00.000+08:00| 15| |2017-11-04T00:20:00.000+08:00| 15| |2017-11-04T00:21:00.000+08:00| 15| |2017-11-04T00:22:00.000+08:00| 15| |2017-11-04T00:23:00.000+08:00| 15| |2017-11-05T00:00:00.000+08:00| 15| |2017-11-05T00:01:00.000+08:00| 15| |2017-11-05T00:02:00.000+08:00| 15| |2017-11-05T00:03:00.000+08:00| 15| |2017-11-05T00:04:00.000+08:00| 15| |2017-11-05T00:05:00.000+08:00| 15| |2017-11-05T00:06:00.000+08:00| 15| |2017-11-05T00:07:00.000+08:00| 15| |2017-11-05T00:08:00.000+08:00| 15| |2017-11-05T00:09:00.000+08:00| 15| |2017-11-05T00:10:00.000+08:00| 15| |2017-11-05T00:11:00.000+08:00| 15| |2017-11-05T00:12:00.000+08:00| 15| |2017-11-05T00:13:00.000+08:00| 15| |2017-11-05T00:14:00.000+08:00| 15| |2017-11-05T00:15:00.000+08:00| 15| |2017-11-05T00:16:00.000+08:00| 15| |2017-11-05T00:17:00.000+08:00| 15| |2017-11-05T00:18:00.000+08:00| 15| |2017-11-05T00:19:00.000+08:00| 15| |2017-11-05T00:20:00.000+08:00| 15| |2017-11-05T00:21:00.000+08:00| 15| |2017-11-05T00:22:00.000+08:00| 15| |2017-11-05T00:23:00.000+08:00| 15| |2017-11-06T00:00:00.000+08:00| 15| |2017-11-06T00:01:00.000+08:00| 15| |2017-11-06T00:02:00.000+08:00| 15| |2017-11-06T00:03:00.000+08:00| 15| |2017-11-06T00:04:00.000+08:00| 15| |2017-11-06T00:05:00.000+08:00| 15| |2017-11-06T00:06:00.000+08:00| 15| |2017-11-06T00:07:00.000+08:00| 15| |2017-11-06T00:08:00.000+08:00| 15| |2017-11-06T00:09:00.000+08:00| 15| |2017-11-06T00:10:00.000+08:00| 15| |2017-11-06T00:11:00.000+08:00| 15| |2017-11-06T00:12:00.000+08:00| 15| |2017-11-06T00:13:00.000+08:00| 15| |2017-11-06T00:14:00.000+08:00| 15| |2017-11-06T00:15:00.000+08:00| 15| |2017-11-06T00:16:00.000+08:00| 15| |2017-11-06T00:17:00.000+08:00| 15| |2017-11-06T00:18:00.000+08:00| 15| |2017-11-06T00:19:00.000+08:00| 15| |2017-11-06T00:20:00.000+08:00| 15| |2017-11-06T00:21:00.000+08:00| 15| |2017-11-06T00:22:00.000+08:00| 15| |2017-11-06T00:23:00.000+08:00| 15| |2017-11-07T00:00:00.000+08:00| 15| |2017-11-07T00:01:00.000+08:00| 15| |2017-11-07T00:02:00.000+08:00| 15| |2017-11-07T00:03:00.000+08:00| 15| |2017-11-07T00:04:00.000+08:00| 15| |2017-11-07T00:05:00.000+08:00| 15| |2017-11-07T00:06:00.000+08:00| 15| |2017-11-07T00:07:00.000+08:00| 15| |2017-11-07T00:08:00.000+08:00| 15| |2017-11-07T00:09:00.000+08:00| 15| |2017-11-07T00:10:00.000+08:00| 15| |2017-11-07T00:11:00.000+08:00| 15| |2017-11-07T00:12:00.000+08:00| 15| |2017-11-07T00:13:00.000+08:00| 15| |2017-11-07T00:14:00.000+08:00| 15| |2017-11-07T00:15:00.000+08:00| 15| |2017-11-07T00:16:00.000+08:00| 15| |2017-11-07T00:17:00.000+08:00| 15| |2017-11-07T00:18:00.000+08:00| 15| |2017-11-07T00:19:00.000+08:00| 15| |2017-11-07T00:20:00.000+08:00| 15| |2017-11-07T00:21:00.000+08:00| 15| |2017-11-07T00:22:00.000+08:00| 15| |2017-11-07T00:23:00.000+08:00| 15| |2017-11-08T00:00:00.000+08:00| 15| |2017-11-08T00:01:00.000+08:00| 15| |2017-11-08T00:02:00.000+08:00| 15| |2017-11-08T00:03:00.000+08:00| 15| |2017-11-08T00:04:00.000+08:00| 15| |2017-11-08T00:05:00.000+08:00| 15| |2017-11-08T00:06:00.000+08:00| 15| |2017-11-08T00:07:00.000+08:00| 15| |2017-11-08T00:08:00.000+08:00| 15| |2017-11-08T00:09:00.000+08:00| 15| |2017-11-08T00:10:00.000+08:00| 15| |2017-11-08T00:11:00.000+08:00| 15| |2017-11-08T00:12:00.000+08:00| 15| |2017-11-08T00:13:00.000+08:00| 15| |2017-11-08T00:14:00.000+08:00| 15| |2017-11-08T00:15:00.000+08:00| 15| |2017-11-08T00:16:00.000+08:00| 15| |2017-11-08T00:17:00.000+08:00| 15| |2017-11-08T00:18:00.000+08:00| 15| |2017-11-08T00:19:00.000+08:00| 15| |2017-11-08T00:20:00.000+08:00| 15| |2017-11-08T00:21:00.000+08:00| 15| |2017-11-08T00:22:00.000+08:00| 15| |2017-11-08T00:23:00.000+08:00| 15| |2017-11-09T00:00:00.000+08:00| 15| |2017-11-09T00:01:00.000+08:00| 15| |2017-11-09T00:02:00.000+08:00| 15| |2017-11-09T00:03:00.000+08:00| 15| |2017-11-09T00:04:00.000+08:00| 15| |2017-11-09T00:05:00.000+08:00| 15| |2017-11-09T00:06:00.000+08:00| 15| |2017-11-09T00:07:00.000+08:00| 15| |2017-11-09T00:08:00.000+08:00| 15| |2017-11-09T00:09:00.000+08:00| 15| |2017-11-09T00:10:00.000+08:00| 15| |2017-11-09T00:11:00.000+08:00| 15| |2017-11-09T00:12:00.000+08:00| 15| |2017-11-09T00:13:00.000+08:00| 15| |2017-11-09T00:14:00.000+08:00| 15| |2017-11-09T00:15:00.000+08:00| 15| |2017-11-09T00:16:00.000+08:00| 15| |2017-11-09T00:17:00.000+08:00| 15| |2017-11-09T00:18:00.000+08:00| 15| |2017-11-09T00:19:00.000+08:00| 15| |2017-11-09T00:20:00.000+08:00| 15| |2017-11-09T00:21:00.000+08:00| 15| |2017-11-09T00:22:00.000+08:00| 15| |2017-11-09T00:23:00.000+08:00| 15| +-----------------------------+------------------------+ Total line number = 216 It costs 0.173s 测试用例编号 dml_434-2 测试语句 create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, status) delete from root.ln.wf01.wt01.status1 where time<=2017-11-01T16:26:00; select * from root.ln cluster结果 Msg: The statement is executed successfully. Msg: 304: Path [root.ln.wf01.wt01.status1] does not exist +-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.status| +-----------------------------+------------------------+ |2017-11-01T00:00:00.000+08:00| 15| |2017-11-01T00:01:00.000+08:00| 15| |2017-11-01T00:02:00.000+08:00| 15| |2017-11-01T00:03:00.000+08:00| 15| |2017-11-01T00:04:00.000+08:00| 15| |2017-11-01T00:05:00.000+08:00| 15| |2017-11-01T00:06:00.000+08:00| 15| |2017-11-01T00:07:00.000+08:00| 15| |2017-11-01T00:08:00.000+08:00| 15| |2017-11-01T00:09:00.000+08:00| 15| |2017-11-01T00:10:00.000+08:00| 15| |2017-11-01T00:11:00.000+08:00| 15| |2017-11-01T00:12:00.000+08:00| 15| |2017-11-01T00:13:00.000+08:00| 15| |2017-11-01T00:14:00.000+08:00| 15| |2017-11-01T00:15:00.000+08:00| 15| |2017-11-01T00:16:00.000+08:00| 15| |2017-11-01T00:17:00.000+08:00| 15| |2017-11-01T00:18:00.000+08:00| 15| |2017-11-01T00:19:00.000+08:00| 15| |2017-11-01T00:20:00.000+08:00| 15| |2017-11-01T00:21:00.000+08:00| 15| |2017-11-01T00:22:00.000+08:00| 15| |2017-11-01T00:23:00.000+08:00| 15| |2017-11-02T00:00:00.000+08:00| 15| |2017-11-02T00:01:00.000+08:00| 15| |2017-11-02T00:02:00.000+08:00| 15| |2017-11-02T00:03:00.000+08:00| 15| |2017-11-02T00:04:00.000+08:00| 15| |2017-11-02T00:05:00.000+08:00| 15| |2017-11-02T00:06:00.000+08:00| 15| |2017-11-02T00:07:00.000+08:00| 15| |2017-11-02T00:08:00.000+08:00| 15| |2017-11-02T00:09:00.000+08:00| 15| |2017-11-02T00:10:00.000+08:00| 15| |2017-11-02T00:11:00.000+08:00| 15| |2017-11-02T00:12:00.000+08:00| 15| |2017-11-02T00:13:00.000+08:00| 15| |2017-11-02T00:14:00.000+08:00| 15| |2017-11-02T00:15:00.000+08:00| 15| |2017-11-02T00:16:00.000+08:00| 15| |2017-11-02T00:17:00.000+08:00| 15| |2017-11-02T00:18:00.000+08:00| 15| |2017-11-02T00:19:00.000+08:00| 15| |2017-11-02T00:20:00.000+08:00| 15| |2017-11-02T00:21:00.000+08:00| 15| |2017-11-02T00:22:00.000+08:00| 15| |2017-11-02T00:23:00.000+08:00| 15| |2017-11-03T00:00:00.000+08:00| 15| |2017-11-03T00:01:00.000+08:00| 15| |2017-11-03T00:02:00.000+08:00| 15| |2017-11-03T00:03:00.000+08:00| 15| |2017-11-03T00:04:00.000+08:00| 15| |2017-11-03T00:05:00.000+08:00| 15| |2017-11-03T00:06:00.000+08:00| 15| |2017-11-03T00:07:00.000+08:00| 15| |2017-11-03T00:08:00.000+08:00| 15| |2017-11-03T00:09:00.000+08:00| 15| |2017-11-03T00:10:00.000+08:00| 15| |2017-11-03T00:11:00.000+08:00| 15| |2017-11-03T00:12:00.000+08:00| 15| |2017-11-03T00:13:00.000+08:00| 15| |2017-11-03T00:14:00.000+08:00| 15| |2017-11-03T00:15:00.000+08:00| 15| |2017-11-03T00:16:00.000+08:00| 15| |2017-11-03T00:17:00.000+08:00| 15| |2017-11-03T00:18:00.000+08:00| 15| |2017-11-03T00:19:00.000+08:00| 15| |2017-11-03T00:20:00.000+08:00| 15| |2017-11-03T00:21:00.000+08:00| 15| |2017-11-03T00:22:00.000+08:00| 15| |2017-11-03T00:23:00.000+08:00| 15| |2017-11-04T00:00:00.000+08:00| 15| |2017-11-04T00:01:00.000+08:00| 15| |2017-11-04T00:02:00.000+08:00| 15| |2017-11-04T00:03:00.000+08:00| 15| |2017-11-04T00:04:00.000+08:00| 15| |2017-11-04T00:05:00.000+08:00| 15| |2017-11-04T00:06:00.000+08:00| 15| |2017-11-04T00:07:00.000+08:00| 15| |2017-11-04T00:08:00.000+08:00| 15| |2017-11-04T00:09:00.000+08:00| 15| |2017-11-04T00:10:00.000+08:00| 15| |2017-11-04T00:11:00.000+08:00| 15| |2017-11-04T00:12:00.000+08:00| 15| |2017-11-04T00:13:00.000+08:00| 15| |2017-11-04T00:14:00.000+08:00| 15| |2017-11-04T00:15:00.000+08:00| 15| |2017-11-04T00:16:00.000+08:00| 15| |2017-11-04T00:17:00.000+08:00| 15| |2017-11-04T00:18:00.000+08:00| 15| |2017-11-04T00:19:00.000+08:00| 15| |2017-11-04T00:20:00.000+08:00| 15| |2017-11-04T00:21:00.000+08:00| 15| |2017-11-04T00:22:00.000+08:00| 15| |2017-11-04T00:23:00.000+08:00| 15| |2017-11-05T00:00:00.000+08:00| 15| |2017-11-05T00:01:00.000+08:00| 15| |2017-11-05T00:02:00.000+08:00| 15| |2017-11-05T00:03:00.000+08:00| 15| |2017-11-05T00:04:00.000+08:00| 15| |2017-11-05T00:05:00.000+08:00| 15| |2017-11-05T00:06:00.000+08:00| 15| |2017-11-05T00:07:00.000+08:00| 15| |2017-11-05T00:08:00.000+08:00| 15| |2017-11-05T00:09:00.000+08:00| 15| |2017-11-05T00:10:00.000+08:00| 15| |2017-11-05T00:11:00.000+08:00| 15| |2017-11-05T00:12:00.000+08:00| 15| |2017-11-05T00:13:00.000+08:00| 15| |2017-11-05T00:14:00.000+08:00| 15| |2017-11-05T00:15:00.000+08:00| 15| |2017-11-05T00:16:00.000+08:00| 15| |2017-11-05T00:17:00.000+08:00| 15| |2017-11-05T00:18:00.000+08:00| 15| |2017-11-05T00:19:00.000+08:00| 15| |2017-11-05T00:20:00.000+08:00| 15| |2017-11-05T00:21:00.000+08:00| 15| |2017-11-05T00:22:00.000+08:00| 15| |2017-11-05T00:23:00.000+08:00| 15| |2017-11-06T00:00:00.000+08:00| 15| |2017-11-06T00:01:00.000+08:00| 15| |2017-11-06T00:02:00.000+08:00| 15| |2017-11-06T00:03:00.000+08:00| 15| |2017-11-06T00:04:00.000+08:00| 15| |2017-11-06T00:05:00.000+08:00| 15| |2017-11-06T00:06:00.000+08:00| 15| |2017-11-06T00:07:00.000+08:00| 15| |2017-11-06T00:08:00.000+08:00| 15| |2017-11-06T00:09:00.000+08:00| 15| |2017-11-06T00:10:00.000+08:00| 15| |2017-11-06T00:11:00.000+08:00| 15| |2017-11-06T00:12:00.000+08:00| 15| |2017-11-06T00:13:00.000+08:00| 15| |2017-11-06T00:14:00.000+08:00| 15| |2017-11-06T00:15:00.000+08:00| 15| |2017-11-06T00:16:00.000+08:00| 15| |2017-11-06T00:17:00.000+08:00| 15| |2017-11-06T00:18:00.000+08:00| 15| |2017-11-06T00:19:00.000+08:00| 15| |2017-11-06T00:20:00.000+08:00| 15| |2017-11-06T00:21:00.000+08:00| 15| |2017-11-06T00:22:00.000+08:00| 15| |2017-11-06T00:23:00.000+08:00| 15| |2017-11-07T00:00:00.000+08:00| 15| |2017-11-07T00:01:00.000+08:00| 15| |2017-11-07T00:02:00.000+08:00| 15| |2017-11-07T00:03:00.000+08:00| 15| |2017-11-07T00:04:00.000+08:00| 15| |2017-11-07T00:05:00.000+08:00| 15| |2017-11-07T00:06:00.000+08:00| 15| |2017-11-07T00:07:00.000+08:00| 15| |2017-11-07T00:08:00.000+08:00| 15| |2017-11-07T00:09:00.000+08:00| 15| |2017-11-07T00:10:00.000+08:00| 15| |2017-11-07T00:11:00.000+08:00| 15| |2017-11-07T00:12:00.000+08:00| 15| |2017-11-07T00:13:00.000+08:00| 15| |2017-11-07T00:14:00.000+08:00| 15| |2017-11-07T00:15:00.000+08:00| 15| |2017-11-07T00:16:00.000+08:00| 15| |2017-11-07T00:17:00.000+08:00| 15| |2017-11-07T00:18:00.000+08:00| 15| |2017-11-07T00:19:00.000+08:00| 15| |2017-11-07T00:20:00.000+08:00| 15| |2017-11-07T00:21:00.000+08:00| 15| |2017-11-07T00:22:00.000+08:00| 15| |2017-11-07T00:23:00.000+08:00| 15| |2017-11-08T00:00:00.000+08:00| 15| |2017-11-08T00:01:00.000+08:00| 15| |2017-11-08T00:02:00.000+08:00| 15| |2017-11-08T00:03:00.000+08:00| 15| |2017-11-08T00:04:00.000+08:00| 15| |2017-11-08T00:05:00.000+08:00| 15| |2017-11-08T00:06:00.000+08:00| 15| |2017-11-08T00:07:00.000+08:00| 15| |2017-11-08T00:08:00.000+08:00| 15| |2017-11-08T00:09:00.000+08:00| 15| |2017-11-08T00:10:00.000+08:00| 15| |2017-11-08T00:11:00.000+08:00| 15| |2017-11-08T00:12:00.000+08:00| 15| |2017-11-08T00:13:00.000+08:00| 15| |2017-11-08T00:14:00.000+08:00| 15| |2017-11-08T00:15:00.000+08:00| 15| |2017-11-08T00:16:00.000+08:00| 15| |2017-11-08T00:17:00.000+08:00| 15| |2017-11-08T00:18:00.000+08:00| 15| |2017-11-08T00:19:00.000+08:00| 15| |2017-11-08T00:20:00.000+08:00| 15| |2017-11-08T00:21:00.000+08:00| 15| |2017-11-08T00:22:00.000+08:00| 15| |2017-11-08T00:23:00.000+08:00| 15| |2017-11-09T00:00:00.000+08:00| 15| |2017-11-09T00:01:00.000+08:00| 15| |2017-11-09T00:02:00.000+08:00| 15| |2017-11-09T00:03:00.000+08:00| 15| |2017-11-09T00:04:00.000+08:00| 15| |2017-11-09T00:05:00.000+08:00| 15| |2017-11-09T00:06:00.000+08:00| 15| |2017-11-09T00:07:00.000+08:00| 15| |2017-11-09T00:08:00.000+08:00| 15| |2017-11-09T00:09:00.000+08:00| 15| |2017-11-09T00:10:00.000+08:00| 15| |2017-11-09T00:11:00.000+08:00| 15| |2017-11-09T00:12:00.000+08:00| 15| |2017-11-09T00:13:00.000+08:00| 15| |2017-11-09T00:14:00.000+08:00| 15| |2017-11-09T00:15:00.000+08:00| 15| |2017-11-09T00:16:00.000+08:00| 15| |2017-11-09T00:17:00.000+08:00| 15| |2017-11-09T00:18:00.000+08:00| 15| |2017-11-09T00:19:00.000+08:00| 15| |2017-11-09T00:20:00.000+08:00| 15| |2017-11-09T00:21:00.000+08:00| 15| |2017-11-09T00:22:00.000+08:00| 15| |2017-11-09T00:23:00.000+08:00| 15| +-----------------------------+------------------------+ Total line number = 216 It costs 0.262s 测试用例编号 dml_434-3 测试语句 create timeseries root.ln.wf01.wt01.temperature with datatype=INT32,encoding=PLAIN create timeseries root.ln.wf01.wt01.status with datatype=INT32,encoding=PLAIN #root.ln.wf01.wt01(timestamp, temperature) #root.ln.wf01.wt01(timestamp, status) delete from root.ln.wf01.wt02 where time<=2017-11-01T16:26:00 select * from root.ln cluster结果 Msg: The statement is executed successfully. Msg: The statement is executed successfully. Msg: 304: Path [root.ln.wf01.wt02] does not exist +-----------------------------+-----------------------------+------------------------+ | Time|root.ln.wf01.wt01.temperature|root.ln.wf01.wt01.status| +-----------------------------+-----------------------------+------------------------+ |2017-11-01T00:00:00.000+08:00| 15| 15| |2017-11-01T00:01:00.000+08:00| 15| 15| |2017-11-01T00:02:00.000+08:00| 15| 15| |2017-11-01T00:03:00.000+08:00| 15| 15| |2017-11-01T00:04:00.000+08:00| 15| 15| |2017-11-01T00:05:00.000+08:00| 15| 15| |2017-11-01T00:06:00.000+08:00| 15| 15| |2017-11-01T00:07:00.000+08:00| 15| 15| |2017-11-01T00:08:00.000+08:00| 15| 15| |2017-11-01T00:09:00.000+08:00| 15| 15| |2017-11-01T00:10:00.000+08:00| 15| 15| |2017-11-01T00:11:00.000+08:00| 15| 15| |2017-11-01T00:12:00.000+08:00| 15| 15| |2017-11-01T00:13:00.000+08:00| 15| 15| |2017-11-01T00:14:00.000+08:00| 15| 15| |2017-11-01T00:15:00.000+08:00| 15| 15| |2017-11-01T00:16:00.000+08:00| 15| 15| |2017-11-01T00:17:00.000+08:00| 15| 15| |2017-11-01T00:18:00.000+08:00| 15| 15| |2017-11-01T00:19:00.000+08:00| 15| 15| |2017-11-01T00:20:00.000+08:00| 15| 15| |2017-11-01T00:21:00.000+08:00| 15| 15| |2017-11-01T00:22:00.000+08:00| 15| 15| |2017-11-01T00:23:00.000+08:00| 15| 15| |2017-11-02T00:00:00.000+08:00| 15| 15| |2017-11-02T00:01:00.000+08:00| 15| 15| |2017-11-02T00:02:00.000+08:00| 15| 15| |2017-11-02T00:03:00.000+08:00| 15| 15| |2017-11-02T00:04:00.000+08:00| 15| 15| |2017-11-02T00:05:00.000+08:00| 15| 15| |2017-11-02T00:06:00.000+08:00| 15| 15| |2017-11-02T00:07:00.000+08:00| 15| 15| |2017-11-02T00:08:00.000+08:00| 15| 15| |2017-11-02T00:09:00.000+08:00| 15| 15| |2017-11-02T00:10:00.000+08:00| 15| 15| |2017-11-02T00:11:00.000+08:00| 15| 15| |2017-11-02T00:12:00.000+08:00| 15| 15| |2017-11-02T00:13:00.000+08:00| 15| 15| |2017-11-02T00:14:00.000+08:00| 15| 15| |2017-11-02T00:15:00.000+08:00| 15| 15| |2017-11-02T00:16:00.000+08:00| 15| 15| |2017-11-02T00:17:00.000+08:00| 15| 15| |2017-11-02T00:18:00.000+08:00| 15| 15| |2017-11-02T00:19:00.000+08:00| 15| 15| |2017-11-02T00:20:00.000+08:00| 15| 15| |2017-11-02T00:21:00.000+08:00| 15| 15| |2017-11-02T00:22:00.000+08:00| 15| 15| |2017-11-02T00:23:00.000+08:00| 15| 15| |2017-11-03T00:00:00.000+08:00| 15| 15| |2017-11-03T00:01:00.000+08:00| 15| 15| |2017-11-03T00:02:00.000+08:00| 15| 15| |2017-11-03T00:03:00.000+08:00| 15| 15| |2017-11-03T00:04:00.000+08:00| 15| 15| |2017-11-03T00:05:00.000+08:00| 15| 15| |2017-11-03T00:06:00.000+08:00| 15| 15| |2017-11-03T00:07:00.000+08:00| 15| 15| |2017-11-03T00:08:00.000+08:00| 15| 15| |2017-11-03T00:09:00.000+08:00| 15| 15| |2017-11-03T00:10:00.000+08:00| 15| 15| |2017-11-03T00:11:00.000+08:00| 15| 15| |2017-11-03T00:12:00.000+08:00| 15| 15| |2017-11-03T00:13:00.000+08:00| 15| 15| |2017-11-03T00:14:00.000+08:00| 15| 15| |2017-11-03T00:15:00.000+08:00| 15| 15| |2017-11-03T00:16:00.000+08:00| 15| 15| |2017-11-03T00:17:00.000+08:00| 15| 15| |2017-11-03T00:18:00.000+08:00| 15| 15| |2017-11-03T00:19:00.000+08:00| 15| 15| |2017-11-03T00:20:00.000+08:00| 15| 15| |2017-11-03T00:21:00.000+08:00| 15| 15| |2017-11-03T00:22:00.000+08:00| 15| 15| |2017-11-03T00:23:00.000+08:00| 15| 15| |2017-11-04T00:00:00.000+08:00| 15| 15| |2017-11-04T00:01:00.000+08:00| 15| 15| |2017-11-04T00:02:00.000+08:00| 15| 15| |2017-11-04T00:03:00.000+08:00| 15| 15| |2017-11-04T00:04:00.000+08:00| 15| 15| |2017-11-04T00:05:00.000+08:00| 15| 15| |2017-11-04T00:06:00.000+08:00| 15| 15| |2017-11-04T00:07:00.000+08:00| 15| 15| |2017-11-04T00:08:00.000+08:00| 15| 15| |2017-11-04T00:09:00.000+08:00| 15| 15| |2017-11-04T00:10:00.000+08:00| 15| 15| |2017-11-04T00:11:00.000+08:00| 15| 15| |2017-11-04T00:12:00.000+08:00| 15| 15| |2017-11-04T00:13:00.000+08:00| 15| 15| |2017-11-04T00:14:00.000+08:00| 15| 15| |2017-11-04T00:15:00.000+08:00| 15| 15| |2017-11-04T00:16:00.000+08:00| 15| 15| |2017-11-04T00:17:00.000+08:00| 15| 15| |2017-11-04T00:18:00.000+08:00| 15| 15| |2017-11-04T00:19:00.000+08:00| 15| 15| |2017-11-04T00:20:00.000+08:00| 15| 15| |2017-11-04T00:21:00.000+08:00| 15| 15| |2017-11-04T00:22:00.000+08:00| 15| 15| |2017-11-04T00:23:00.000+08:00| 15| 15| |2017-11-05T00:00:00.000+08:00| 15| 15| |2017-11-05T00:01:00.000+08:00| 15| 15| |2017-11-05T00:02:00.000+08:00| 15| 15| |2017-11-05T00:03:00.000+08:00| 15| 15| |2017-11-05T00:04:00.000+08:00| 15| 15| |2017-11-05T00:05:00.000+08:00| 15| 15| |2017-11-05T00:06:00.000+08:00| 15| 15| |2017-11-05T00:07:00.000+08:00| 15| 15| |2017-11-05T00:08:00.000+08:00| 15| 15| |2017-11-05T00:09:00.000+08:00| 15| 15| |2017-11-05T00:10:00.000+08:00| 15| 15| |2017-11-05T00:11:00.000+08:00| 15| 15| |2017-11-05T00:12:00.000+08:00| 15| 15| |2017-11-05T00:13:00.000+08:00| 15| 15| |2017-11-05T00:14:00.000+08:00| 15| 15| |2017-11-05T00:15:00.000+08:00| 15| 15| |2017-11-05T00:16:00.000+08:00| 15| 15| |2017-11-05T00:17:00.000+08:00| 15| 15| |2017-11-05T00:18:00.000+08:00| 15| 15| |2017-11-05T00:19:00.000+08:00| 15| 15| |2017-11-05T00:20:00.000+08:00| 15| 15| |2017-11-05T00:21:00.000+08:00| 15| 15| |2017-11-05T00:22:00.000+08:00| 15| 15| |2017-11-05T00:23:00.000+08:00| 15| 15| |2017-11-06T00:00:00.000+08:00| 15| 15| |2017-11-06T00:01:00.000+08:00| 15| 15| |2017-11-06T00:02:00.000+08:00| 15| 15| |2017-11-06T00:03:00.000+08:00| 15| 15| |2017-11-06T00:04:00.000+08:00| 15| 15| |2017-11-06T00:05:00.000+08:00| 15| 15| |2017-11-06T00:06:00.000+08:00| 15| 15| |2017-11-06T00:07:00.000+08:00| 15| 15| |2017-11-06T00:08:00.000+08:00| 15| 15| |2017-11-06T00:09:00.000+08:00| 15| 15| |2017-11-06T00:10:00.000+08:00| 15| 15| |2017-11-06T00:11:00.000+08:00| 15| 15| |2017-11-06T00:12:00.000+08:00| 15| 15| |2017-11-06T00:13:00.000+08:00| 15| 15| |2017-11-06T00:14:00.000+08:00| 15| 15| |2017-11-06T00:15:00.000+08:00| 15| 15| |2017-11-06T00:16:00.000+08:00| 15| 15| |2017-11-06T00:17:00.000+08:00| 15| 15| |2017-11-06T00:18:00.000+08:00| 15| 15| |2017-11-06T00:19:00.000+08:00| 15| 15| |2017-11-06T00:20:00.000+08:00| 15| 15| |2017-11-06T00:21:00.000+08:00| 15| 15| |2017-11-06T00:22:00.000+08:00| 15| 15| |2017-11-06T00:23:00.000+08:00| 15| 15| |2017-11-07T00:00:00.000+08:00| 15| 15| |2017-11-07T00:01:00.000+08:00| 15| 15| |2017-11-07T00:02:00.000+08:00| 15| 15| |2017-11-07T00:03:00.000+08:00| 15| 15| |2017-11-07T00:04:00.000+08:00| 15| 15| |2017-11-07T00:05:00.000+08:00| 15| 15| |2017-11-07T00:06:00.000+08:00| 15| 15| |2017-11-07T00:07:00.000+08:00| 15| 15| |2017-11-07T00:08:00.000+08:00| 15| 15| |2017-11-07T00:09:00.000+08:00| 15| 15| |2017-11-07T00:10:00.000+08:00| 15| 15| |2017-11-07T00:11:00.000+08:00| 15| 15| |2017-11-07T00:12:00.000+08:00| 15| 15| |2017-11-07T00:13:00.000+08:00| 15| 15| |2017-11-07T00:14:00.000+08:00| 15| 15| |2017-11-07T00:15:00.000+08:00| 15| 15| |2017-11-07T00:16:00.000+08:00| 15| 15| |2017-11-07T00:17:00.000+08:00| 15| 15| |2017-11-07T00:18:00.000+08:00| 15| 15| |2017-11-07T00:19:00.000+08:00| 15| 15| |2017-11-07T00:20:00.000+08:00| 15| 15| |2017-11-07T00:21:00.000+08:00| 15| 15| |2017-11-07T00:22:00.000+08:00| 15| 15| |2017-11-07T00:23:00.000+08:00| 15| 15| |2017-11-08T00:00:00.000+08:00| 15| 15| |2017-11-08T00:01:00.000+08:00| 15| 15| |2017-11-08T00:02:00.000+08:00| 15| 15| |2017-11-08T00:03:00.000+08:00| 15| 15| |2017-11-08T00:04:00.000+08:00| 15| 15| |2017-11-08T00:05:00.000+08:00| 15| 15| |2017-11-08T00:06:00.000+08:00| 15| 15| |2017-11-08T00:07:00.000+08:00| 15| 15| |2017-11-08T00:08:00.000+08:00| 15| 15| |2017-11-08T00:09:00.000+08:00| 15| 15| |2017-11-08T00:10:00.000+08:00| 15| 15| |2017-11-08T00:11:00.000+08:00| 15| 15| |2017-11-08T00:12:00.000+08:00| 15| 15| |2017-11-08T00:13:00.000+08:00| 15| 15| |2017-11-08T00:14:00.000+08:00| 15| 15| |2017-11-08T00:15:00.000+08:00| 15| 15| |2017-11-08T00:16:00.000+08:00| 15| 15| |2017-11-08T00:17:00.000+08:00| 15| 15| |2017-11-08T00:18:00.000+08:00| 15| 15| |2017-11-08T00:19:00.000+08:00| 15| 15| |2017-11-08T00:20:00.000+08:00| 15| 15| |2017-11-08T00:21:00.000+08:00| 15| 15| |2017-11-08T00:22:00.000+08:00| 15| 15| |2017-11-08T00:23:00.000+08:00| 15| 15| |2017-11-09T00:00:00.000+08:00| 15| 15| |2017-11-09T00:01:00.000+08:00| 15| 15| |2017-11-09T00:02:00.000+08:00| 15| 15| |2017-11-09T00:03:00.000+08:00| 15| 15| |2017-11-09T00:04:00.000+08:00| 15| 15| |2017-11-09T00:05:00.000+08:00| 15| 15| |2017-11-09T00:06:00.000+08:00| 15| 15| |2017-11-09T00:07:00.000+08:00| 15| 15| |2017-11-09T00:08:00.000+08:00| 15| 15| |2017-11-09T00:09:00.000+08:00| 15| 15| |2017-11-09T00:10:00.000+08:00| 15| 15| |2017-11-09T00:11:00.000+08:00| 15| 15| |2017-11-09T00:12:00.000+08:00| 15| 15| |2017-11-09T00:13:00.000+08:00| 15| 15| |2017-11-09T00:14:00.000+08:00| 15| 15| |2017-11-09T00:15:00.000+08:00| 15| 15| |2017-11-09T00:16:00.000+08:00| 15| 15| |2017-11-09T00:17:00.000+08:00| 15| 15| |2017-11-09T00:18:00.000+08:00| 15| 15| |2017-11-09T00:19:00.000+08:00| 15| 15| |2017-11-09T00:20:00.000+08:00| 15| 15| |2017-11-09T00:21:00.000+08:00| 15| 15| |2017-11-09T00:22:00.000+08:00| 15| 15| |2017-11-09T00:23:00.000+08:00| 15| 15| +-----------------------------+-----------------------------+------------------------+ Total line number = 216 It costs 0.176s