You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@iotdb.apache.org by Gaofei Cao <ti...@gmail.com> on 2022/07/01 16:33:49 UTC
Re: [VOTE] Apache IoTDB 0.14.0-preview1 RC1 release
+1 (binding)
The source release:
apache headers [ok]
signatures and hashes [ok]
LICENSE and NOTICE [ok]
no jar files [ok]
could compile from source: ./mvnw.sh clean install [minor issue with
a target file not ignored by apache-rat]
The binary distribution:
version number in CLI [ok]
signatures and hashes [ok]
start in mac M1 pro, jdk1.8 [ok]
statements executed successfully: [ok]
SET STORAGE GROUP TO root.sg1;
create aligned timeseries root.sg1.d1(s1 FLOAT encoding=RLE, s2 INT32
encoding=Gorilla compression=SNAPPY, s3 INT64, s4 BOOLEAN, s5 TEXT);
create timeseries root.sg1.d2.s1 WITH DATATYPE=FLOAT, encoding=RLE;
create timeseries root.sg1.d2.s2 WITH DATATYPE=INT32, encoding=Gorilla;
create timeseries root.sg1.d2.s3 WITH DATATYPE=INT64;
create timeseries root.sg1.d2.s4 WITH DATATYPE=BOOLEAN;
create timeseries root.sg1.d2.s5 WITH DATATYPE=TEXT;
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(1,
1.0, 1, 1, TRUE, 'aligned_test1');
insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(2, 2.0,
2, 2, 'aligned_test2');
insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3, 3.0,
3, FALSE, 'aligned_test3');
insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(4, 4.0,
4, TRUE, 'aligned_test4');
insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(5, 5.0,
5, TRUE, 'aligned_test5');
insert into root.sg1.d1(time, s1, s2, s3, s4) aligned values(6, 6.0,
6, 6, TRUE);
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(7,
7.0, 7, 7, FALSE, 'aligned_test7');
insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(8, 8.0,
8, 8, 'aligned_test8');
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(9,
9.0, 9, 9, FALSE, 'aligned_test9');
insert into root.sg1.d1(time, s2, s3, s4, s5) aligned values(10, 10,
10, TRUE, 'aligned_test10');
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(1, 1.0, 1, 1,
TRUE, 'non_aligned_test1');
insert into root.sg1.d2(time, s1, s2, s3, s5) values(2, 2.0, 2, 2,
'non_aligned_test2');
insert into root.sg1.d2(time, s1, s3, s4, s5) values(3, 3.0, 3, FALSE,
'non_aligned_test3');
insert into root.sg1.d2(time, s1, s2, s4, s5) values(4, 4.0, 4, TRUE,
'non_aligned_test4');
insert into root.sg1.d2(time, s1, s2, s4, s5) values(5, 5.0, 5, TRUE,
'non_aligned_test5');
insert into root.sg1.d2(time, s1, s2, s3, s4) values(6, 6.0, 6, 6, TRUE);
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(7, 7.0, 7, 7,
FALSE, 'non_aligned_test7');
insert into root.sg1.d2(time, s1, s2, s3, s5) values(8, 8.0, 8, 8,
'non_aligned_test8');
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(9, 9.0, 9, 9,
FALSE, 'non_aligned_test9');
insert into root.sg1.d2(time, s2, s3, s4, s5) values(10, 10, 10, TRUE,
'non_aligned_test10');
flush
insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3,
30000.0, 30000, TRUE, 'aligned_unseq_test3');
insert into root.sg1.d1(time, s1, s2, s3) aligned values(11, 11.0, 11, 11);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(12, 12.0, 12, 12);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(13, 13.0, 13, 13);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(14, 14.0, 14, 14);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(15, 15.0, 15, 15);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(16, 16.0, 16, 16);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(17, 17.0, 17, 17);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(18, 18.0, 18, 18);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(19, 19.0, 19, 19);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(20, 20.0, 20, 20);
insert into root.sg1.d2(time, s1, s2, s3) values(11, 11.0, 11, 11);
insert into root.sg1.d2(time, s1, s2, s3) values(12, 12.0, 12, 12);
insert into root.sg1.d2(time, s1, s2, s3) values(13, 13.0, 13, 13);
insert into root.sg1.d2(time, s1, s2, s3) values(14, 14.0, 14, 14);
insert into root.sg1.d2(time, s1, s2, s3) values(15, 15.0, 15, 15);
insert into root.sg1.d2(time, s1, s2, s3) values(16, 16.0, 16, 16);
insert into root.sg1.d2(time, s1, s2, s3) values(17, 17.0, 17, 17);
insert into root.sg1.d2(time, s1, s2, s3) values(18, 18.0, 18, 18);
insert into root.sg1.d2(time, s1, s2, s3) values(19, 19.0, 19, 19);
insert into root.sg1.d2(time, s1, s2, s3) values(20, 20.0, 20, 20);
flush;
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(13,
130000.0, 130000, 130000, TRUE, 'aligned_unseq_test13');
insert into root.sg1.d1(time, s3, s4) aligned values(21, 21, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(22, 22, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(23, 23, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(24, 24, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(25, 25, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(26, 26, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(27, 27, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(28, 28, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(29, 29, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(30, 30, FALSE);
insert into root.sg1.d2(time, s3, s4) values(21, 21, TRUE);
insert into root.sg1.d2(time, s3, s4) values(22, 22, TRUE);
insert into root.sg1.d2(time, s3, s4) values(23, 23, TRUE);
insert into root.sg1.d2(time, s3, s4) values(24, 24, TRUE);
insert into root.sg1.d2(time, s3, s4) values(25, 25, TRUE);
insert into root.sg1.d2(time, s3, s4) values(26, 26, FALSE);
insert into root.sg1.d2(time, s3, s4) values(27, 27, FALSE);
insert into root.sg1.d2(time, s3, s4) values(28, 28, FALSE);
insert into root.sg1.d2(time, s3, s4) values(29, 29, FALSE);
insert into root.sg1.d2(time, s3, s4) values(30, 30, FALSE);
flush;
insert into root.sg1.d1(time, s1, s3, s4) aligned values(23, 230000.0,
230000, FALSE);
insert into root.sg1.d1(time, s2, s5) aligned values(31, 31, 'aligned_test31');
insert into root.sg1.d1(time, s2, s5) aligned values(32, 32, 'aligned_test32');
insert into root.sg1.d1(time, s2, s5) aligned values(33, 33, 'aligned_test33');
insert into root.sg1.d1(time, s2, s5) aligned values(34, 34, 'aligned_test34');
insert into root.sg1.d1(time, s2, s5) aligned values(35, 35, 'aligned_test35');
insert into root.sg1.d1(time, s2, s5) aligned values(36, 36, 'aligned_test36');
insert into root.sg1.d1(time, s2, s5) aligned values(37, 37, 'aligned_test37');
insert into root.sg1.d1(time, s2, s5) aligned values(38, 38, 'aligned_test38');
insert into root.sg1.d1(time, s2, s5) aligned values(39, 39, 'aligned_test39');
insert into root.sg1.d1(time, s2, s5) aligned values(40, 40, 'aligned_test40');
insert into root.sg1.d2(time, s2, s5) values(31, 31, 'non_aligned_test31');
insert into root.sg1.d2(time, s2, s5) values(32, 32, 'non_aligned_test32');
insert into root.sg1.d2(time, s2, s5) values(33, 33, 'non_aligned_test33');
insert into root.sg1.d2(time, s2, s5) values(34, 34, 'non_aligned_test34');
insert into root.sg1.d2(time, s2, s5) values(35, 35, 'non_aligned_test35');
insert into root.sg1.d2(time, s2, s5) values(36, 36, 'non_aligned_test36');
insert into root.sg1.d2(time, s2, s5) values(37, 37, 'non_aligned_test37');
insert into root.sg1.d2(time, s2, s5) values(38, 38, 'non_aligned_test38');
insert into root.sg1.d2(time, s2, s5) values(39, 39, 'non_aligned_test39');
insert into root.sg1.d2(time, s2, s5) values(40, 40, 'non_aligned_test40');
select * from root;
select last * from root.sg1.*;
select * from root.sg1.d1 where time >= 9 and time <= 33 and s1 < 19
align by device;
select max_value(s3), min_value(s1), max_time(s2), min_time(s3) from
root.sg1.d1 where time > 5 GROUP BY ([1, 41), 10ms) order by time
desc;
Best,
————————
Gaofei Cao
Apache IoTDB PMC
Re: [VOTE] Apache IoTDB 0.14.0-preview1 RC1 release
Posted by Xiangdong Huang <sa...@gmail.com>.
Hi,
How our website will look like once the version is released?
especially the "document" tag. Will we open a v0.14.x tag?
BTW, some documents should be updated, e.g., the start script command
on QuickStart page is incorrect.
-----------------------------------
Xiangdong Huang
School of Software, Tsinghua University
JT <jt...@163.com> 于2022年7月2日周六 09:15写道：
>
> Hi,
>
> +1 (binding)
>
> The source release:
> apache headers [ok]
> signatures and hashes [ok]
> LICENSE and NOTICE [ok]
> no jar files [ok]
> could compile from source: ./mvnw.sh clean install [minor issue with
> a target file not ignored by apache-rat]
>
>
> The binary distribution:
> version number in CLI [ok]
> signatures and hashes [ok]
> start in Win11, jdk8 [ok]
> statements executed successfully: [ok]
>
> SET STORAGE GROUP TO root.sg1;
> create aligned timeseries root.sg1.d1(s1 FLOAT encoding=RLE, s2 INT32
> encoding=Gorilla compression=SNAPPY, s3 INT64, s4 BOOLEAN, s5 TEXT);
> create timeseries root.sg1.d2.s1 WITH DATATYPE=FLOAT, encoding=RLE;
> create timeseries root.sg1.d2.s2 WITH DATATYPE=INT32, encoding=Gorilla;
> create timeseries root.sg1.d2.s3 WITH DATATYPE=INT64;
> create timeseries root.sg1.d2.s4 WITH DATATYPE=BOOLEAN;
> create timeseries root.sg1.d2.s5 WITH DATATYPE=TEXT;
> insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(1,
> 1.0, 1, 1, TRUE, 'aligned_test1');
> insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(2, 2.0,
> 2, 2, 'aligned_test2');
> insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3, 3.0,
> 3, FALSE, 'aligned_test3');
> insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(4, 4.0,
> 4, TRUE, 'aligned_test4');
> insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(5, 5.0,
> 5, TRUE, 'aligned_test5');
> insert into root.sg1.d1(time, s1, s2, s3, s4) aligned values(6, 6.0,
> 6, 6, TRUE);
> insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(7,
> 7.0, 7, 7, FALSE, 'aligned_test7');
> insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(8, 8.0,
> 8, 8, 'aligned_test8');
> insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(9,
> 9.0, 9, 9, FALSE, 'aligned_test9');
> insert into root.sg1.d1(time, s2, s3, s4, s5) aligned values(10, 10,
> 10, TRUE, 'aligned_test10');
> insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(1, 1.0, 1, 1,
> TRUE, 'non_aligned_test1');
> insert into root.sg1.d2(time, s1, s2, s3, s5) values(2, 2.0, 2, 2,
> 'non_aligned_test2');
> insert into root.sg1.d2(time, s1, s3, s4, s5) values(3, 3.0, 3, FALSE,
> 'non_aligned_test3');
> insert into root.sg1.d2(time, s1, s2, s4, s5) values(4, 4.0, 4, TRUE,
> 'non_aligned_test4');
> insert into root.sg1.d2(time, s1, s2, s4, s5) values(5, 5.0, 5, TRUE,
> 'non_aligned_test5');
> insert into root.sg1.d2(time, s1, s2, s3, s4) values(6, 6.0, 6, 6, TRUE);
> insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(7, 7.0, 7, 7,
> FALSE, 'non_aligned_test7');
> insert into root.sg1.d2(time, s1, s2, s3, s5) values(8, 8.0, 8, 8,
> 'non_aligned_test8');
> insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(9, 9.0, 9, 9,
> FALSE, 'non_aligned_test9');
> insert into root.sg1.d2(time, s2, s3, s4, s5) values(10, 10, 10, TRUE,
> 'non_aligned_test10');
> flush
> insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3,
> 30000.0, 30000, TRUE, 'aligned_unseq_test3');
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(11, 11.0, 11, 11);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(12, 12.0, 12, 12);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(13, 13.0, 13, 13);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(14, 14.0, 14, 14);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(15, 15.0, 15, 15);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(16, 16.0, 16, 16);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(17, 17.0, 17, 17);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(18, 18.0, 18, 18);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(19, 19.0, 19, 19);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(20, 20.0, 20, 20);
> insert into root.sg1.d2(time, s1, s2, s3) values(11, 11.0, 11, 11);
> insert into root.sg1.d2(time, s1, s2, s3) values(12, 12.0, 12, 12);
> insert into root.sg1.d2(time, s1, s2, s3) values(13, 13.0, 13, 13);
> insert into root.sg1.d2(time, s1, s2, s3) values(14, 14.0, 14, 14);
> insert into root.sg1.d2(time, s1, s2, s3) values(15, 15.0, 15, 15);
> insert into root.sg1.d2(time, s1, s2, s3) values(16, 16.0, 16, 16);
> insert into root.sg1.d2(time, s1, s2, s3) values(17, 17.0, 17, 17);
> insert into root.sg1.d2(time, s1, s2, s3) values(18, 18.0, 18, 18);
> insert into root.sg1.d2(time, s1, s2, s3) values(19, 19.0, 19, 19);
> insert into root.sg1.d2(time, s1, s2, s3) values(20, 20.0, 20, 20);
> flush;
> insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(13,
> 130000.0, 130000, 130000, TRUE, 'aligned_unseq_test13');
> insert into root.sg1.d1(time, s3, s4) aligned values(21, 21, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(22, 22, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(23, 23, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(24, 24, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(25, 25, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(26, 26, FALSE);
> insert into root.sg1.d1(time, s3, s4) aligned values(27, 27, FALSE);
> insert into root.sg1.d1(time, s3, s4) aligned values(28, 28, FALSE);
> insert into root.sg1.d1(time, s3, s4) aligned values(29, 29, FALSE);
> insert into root.sg1.d1(time, s3, s4) aligned values(30, 30, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(21, 21, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(22, 22, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(23, 23, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(24, 24, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(25, 25, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(26, 26, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(27, 27, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(28, 28, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(29, 29, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(30, 30, FALSE);
> flush;
> insert into root.sg1.d1(time, s1, s3, s4) aligned values(23, 230000.0,
> 230000, FALSE);
> insert into root.sg1.d1(time, s2, s5) aligned values(31, 31, 'aligned_test31');
> insert into root.sg1.d1(time, s2, s5) aligned values(32, 32, 'aligned_test32');
> insert into root.sg1.d1(time, s2, s5) aligned values(33, 33, 'aligned_test33');
> insert into root.sg1.d1(time, s2, s5) aligned values(34, 34, 'aligned_test34');
> insert into root.sg1.d1(time, s2, s5) aligned values(35, 35, 'aligned_test35');
> insert into root.sg1.d1(time, s2, s5) aligned values(36, 36, 'aligned_test36');
> insert into root.sg1.d1(time, s2, s5) aligned values(37, 37, 'aligned_test37');
> insert into root.sg1.d1(time, s2, s5) aligned values(38, 38, 'aligned_test38');
> insert into root.sg1.d1(time, s2, s5) aligned values(39, 39, 'aligned_test39');
> insert into root.sg1.d1(time, s2, s5) aligned values(40, 40, 'aligned_test40');
> insert into root.sg1.d2(time, s2, s5) values(31, 31, 'non_aligned_test31');
> insert into root.sg1.d2(time, s2, s5) values(32, 32, 'non_aligned_test32');
> insert into root.sg1.d2(time, s2, s5) values(33, 33, 'non_aligned_test33');
> insert into root.sg1.d2(time, s2, s5) values(34, 34, 'non_aligned_test34');
> insert into root.sg1.d2(time, s2, s5) values(35, 35, 'non_aligned_test35');
> insert into root.sg1.d2(time, s2, s5) values(36, 36, 'non_aligned_test36');
> insert into root.sg1.d2(time, s2, s5) values(37, 37, 'non_aligned_test37');
> insert into root.sg1.d2(time, s2, s5) values(38, 38, 'non_aligned_test38');
> insert into root.sg1.d2(time, s2, s5) values(39, 39, 'non_aligned_test39');
> insert into root.sg1.d2(time, s2, s5) values(40, 40, 'non_aligned_test40');
>
> select * from root;
> select last * from root.sg1.*;
> select * from root.sg1.d1 where time >= 9 and time <= 33 and s1 < 19
> align by device;
> select max_value(s3), min_value(s1), max_time(s2), min_time(s3) from
> root.sg1.d1 where time > 5 GROUP BY ([1, 41), 10ms) order by time
> desc;
>
>
> Best
> Tian Jiang
>
> 发件人: Gaofei Cao
> 发送时间: 2022年7月2日 0:43
> 收件人: dev@iotdb.apache.org
> 主题: Re: [VOTE] Apache IoTDB 0.14.0-preview1 RC1 release
>
> +1 (binding)
>
> The source release:
> apache headers [ok]
> signatures and hashes [ok]
> LICENSE and NOTICE [ok]
> no jar files [ok]
> could compile from source: ./mvnw.sh clean install [minor issue with
> a target file not ignored by apache-rat]
>
>
> The binary distribution:
> version number in CLI [ok]
> signatures and hashes [ok]
> start in mac M1 pro, jdk1.8 [ok]
> statements executed successfully: [ok]
>
> SET STORAGE GROUP TO root.sg1;
> create aligned timeseries root.sg1.d1(s1 FLOAT encoding=RLE, s2 INT32
> encoding=Gorilla compression=SNAPPY, s3 INT64, s4 BOOLEAN, s5 TEXT);
> create timeseries root.sg1.d2.s1 WITH DATATYPE=FLOAT, encoding=RLE;
> create timeseries root.sg1.d2.s2 WITH DATATYPE=INT32, encoding=Gorilla;
> create timeseries root.sg1.d2.s3 WITH DATATYPE=INT64;
> create timeseries root.sg1.d2.s4 WITH DATATYPE=BOOLEAN;
> create timeseries root.sg1.d2.s5 WITH DATATYPE=TEXT;
> insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(1,
> 1.0, 1, 1, TRUE, 'aligned_test1');
> insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(2, 2.0,
> 2, 2, 'aligned_test2');
> insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3, 3.0,
> 3, FALSE, 'aligned_test3');
> insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(4, 4.0,
> 4, TRUE, 'aligned_test4');
> insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(5, 5.0,
> 5, TRUE, 'aligned_test5');
> insert into root.sg1.d1(time, s1, s2, s3, s4) aligned values(6, 6.0,
> 6, 6, TRUE);
> insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(7,
> 7.0, 7, 7, FALSE, 'aligned_test7');
> insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(8, 8.0,
> 8, 8, 'aligned_test8');
> insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(9,
> 9.0, 9, 9, FALSE, 'aligned_test9');
> insert into root.sg1.d1(time, s2, s3, s4, s5) aligned values(10, 10,
> 10, TRUE, 'aligned_test10');
> insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(1, 1.0, 1, 1,
> TRUE, 'non_aligned_test1');
> insert into root.sg1.d2(time, s1, s2, s3, s5) values(2, 2.0, 2, 2,
> 'non_aligned_test2');
> insert into root.sg1.d2(time, s1, s3, s4, s5) values(3, 3.0, 3, FALSE,
> 'non_aligned_test3');
> insert into root.sg1.d2(time, s1, s2, s4, s5) values(4, 4.0, 4, TRUE,
> 'non_aligned_test4');
> insert into root.sg1.d2(time, s1, s2, s4, s5) values(5, 5.0, 5, TRUE,
> 'non_aligned_test5');
> insert into root.sg1.d2(time, s1, s2, s3, s4) values(6, 6.0, 6, 6, TRUE);
> insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(7, 7.0, 7, 7,
> FALSE, 'non_aligned_test7');
> insert into root.sg1.d2(time, s1, s2, s3, s5) values(8, 8.0, 8, 8,
> 'non_aligned_test8');
> insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(9, 9.0, 9, 9,
> FALSE, 'non_aligned_test9');
> insert into root.sg1.d2(time, s2, s3, s4, s5) values(10, 10, 10, TRUE,
> 'non_aligned_test10');
> flush
> insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3,
> 30000.0, 30000, TRUE, 'aligned_unseq_test3');
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(11, 11.0, 11, 11);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(12, 12.0, 12, 12);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(13, 13.0, 13, 13);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(14, 14.0, 14, 14);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(15, 15.0, 15, 15);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(16, 16.0, 16, 16);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(17, 17.0, 17, 17);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(18, 18.0, 18, 18);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(19, 19.0, 19, 19);
> insert into root.sg1.d1(time, s1, s2, s3) aligned values(20, 20.0, 20, 20);
> insert into root.sg1.d2(time, s1, s2, s3) values(11, 11.0, 11, 11);
> insert into root.sg1.d2(time, s1, s2, s3) values(12, 12.0, 12, 12);
> insert into root.sg1.d2(time, s1, s2, s3) values(13, 13.0, 13, 13);
> insert into root.sg1.d2(time, s1, s2, s3) values(14, 14.0, 14, 14);
> insert into root.sg1.d2(time, s1, s2, s3) values(15, 15.0, 15, 15);
> insert into root.sg1.d2(time, s1, s2, s3) values(16, 16.0, 16, 16);
> insert into root.sg1.d2(time, s1, s2, s3) values(17, 17.0, 17, 17);
> insert into root.sg1.d2(time, s1, s2, s3) values(18, 18.0, 18, 18);
> insert into root.sg1.d2(time, s1, s2, s3) values(19, 19.0, 19, 19);
> insert into root.sg1.d2(time, s1, s2, s3) values(20, 20.0, 20, 20);
> flush;
> insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(13,
> 130000.0, 130000, 130000, TRUE, 'aligned_unseq_test13');
> insert into root.sg1.d1(time, s3, s4) aligned values(21, 21, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(22, 22, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(23, 23, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(24, 24, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(25, 25, TRUE);
> insert into root.sg1.d1(time, s3, s4) aligned values(26, 26, FALSE);
> insert into root.sg1.d1(time, s3, s4) aligned values(27, 27, FALSE);
> insert into root.sg1.d1(time, s3, s4) aligned values(28, 28, FALSE);
> insert into root.sg1.d1(time, s3, s4) aligned values(29, 29, FALSE);
> insert into root.sg1.d1(time, s3, s4) aligned values(30, 30, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(21, 21, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(22, 22, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(23, 23, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(24, 24, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(25, 25, TRUE);
> insert into root.sg1.d2(time, s3, s4) values(26, 26, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(27, 27, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(28, 28, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(29, 29, FALSE);
> insert into root.sg1.d2(time, s3, s4) values(30, 30, FALSE);
> flush;
> insert into root.sg1.d1(time, s1, s3, s4) aligned values(23, 230000.0,
> 230000, FALSE);
> insert into root.sg1.d1(time, s2, s5) aligned values(31, 31, 'aligned_test31');
> insert into root.sg1.d1(time, s2, s5) aligned values(32, 32, 'aligned_test32');
> insert into root.sg1.d1(time, s2, s5) aligned values(33, 33, 'aligned_test33');
> insert into root.sg1.d1(time, s2, s5) aligned values(34, 34, 'aligned_test34');
> insert into root.sg1.d1(time, s2, s5) aligned values(35, 35, 'aligned_test35');
> insert into root.sg1.d1(time, s2, s5) aligned values(36, 36, 'aligned_test36');
> insert into root.sg1.d1(time, s2, s5) aligned values(37, 37, 'aligned_test37');
> insert into root.sg1.d1(time, s2, s5) aligned values(38, 38, 'aligned_test38');
> insert into root.sg1.d1(time, s2, s5) aligned values(39, 39, 'aligned_test39');
> insert into root.sg1.d1(time, s2, s5) aligned values(40, 40, 'aligned_test40');
> insert into root.sg1.d2(time, s2, s5) values(31, 31, 'non_aligned_test31');
> insert into root.sg1.d2(time, s2, s5) values(32, 32, 'non_aligned_test32');
> insert into root.sg1.d2(time, s2, s5) values(33, 33, 'non_aligned_test33');
> insert into root.sg1.d2(time, s2, s5) values(34, 34, 'non_aligned_test34');
> insert into root.sg1.d2(time, s2, s5) values(35, 35, 'non_aligned_test35');
> insert into root.sg1.d2(time, s2, s5) values(36, 36, 'non_aligned_test36');
> insert into root.sg1.d2(time, s2, s5) values(37, 37, 'non_aligned_test37');
> insert into root.sg1.d2(time, s2, s5) values(38, 38, 'non_aligned_test38');
> insert into root.sg1.d2(time, s2, s5) values(39, 39, 'non_aligned_test39');
> insert into root.sg1.d2(time, s2, s5) values(40, 40, 'non_aligned_test40');
>
> select * from root;
> select last * from root.sg1.*;
> select * from root.sg1.d1 where time >= 9 and time <= 33 and s1 < 19
> align by device;
> select max_value(s3), min_value(s1), max_time(s2), min_time(s3) from
> root.sg1.d1 where time > 5 GROUP BY ([1, 41), 10ms) order by time
> desc;
>
>
> Best,
> ————————
>
> Gaofei Cao
> Apache IoTDB PMC
>
回复: [VOTE] Apache IoTDB 0.14.0-preview1 RC1 release
Posted by JT <jt...@163.com>.
Hi,
+1 (binding)
The source release:
apache headers [ok]
signatures and hashes [ok]
LICENSE and NOTICE [ok]
no jar files [ok]
could compile from source: ./mvnw.sh clean install [minor issue with
a target file not ignored by apache-rat]
The binary distribution:
version number in CLI [ok]
signatures and hashes [ok]
start in Win11, jdk8 [ok]
statements executed successfully: [ok]
SET STORAGE GROUP TO root.sg1;
create aligned timeseries root.sg1.d1(s1 FLOAT encoding=RLE, s2 INT32
encoding=Gorilla compression=SNAPPY, s3 INT64, s4 BOOLEAN, s5 TEXT);
create timeseries root.sg1.d2.s1 WITH DATATYPE=FLOAT, encoding=RLE;
create timeseries root.sg1.d2.s2 WITH DATATYPE=INT32, encoding=Gorilla;
create timeseries root.sg1.d2.s3 WITH DATATYPE=INT64;
create timeseries root.sg1.d2.s4 WITH DATATYPE=BOOLEAN;
create timeseries root.sg1.d2.s5 WITH DATATYPE=TEXT;
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(1,
1.0, 1, 1, TRUE, 'aligned_test1');
insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(2, 2.0,
2, 2, 'aligned_test2');
insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3, 3.0,
3, FALSE, 'aligned_test3');
insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(4, 4.0,
4, TRUE, 'aligned_test4');
insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(5, 5.0,
5, TRUE, 'aligned_test5');
insert into root.sg1.d1(time, s1, s2, s3, s4) aligned values(6, 6.0,
6, 6, TRUE);
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(7,
7.0, 7, 7, FALSE, 'aligned_test7');
insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(8, 8.0,
8, 8, 'aligned_test8');
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(9,
9.0, 9, 9, FALSE, 'aligned_test9');
insert into root.sg1.d1(time, s2, s3, s4, s5) aligned values(10, 10,
10, TRUE, 'aligned_test10');
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(1, 1.0, 1, 1,
TRUE, 'non_aligned_test1');
insert into root.sg1.d2(time, s1, s2, s3, s5) values(2, 2.0, 2, 2,
'non_aligned_test2');
insert into root.sg1.d2(time, s1, s3, s4, s5) values(3, 3.0, 3, FALSE,
'non_aligned_test3');
insert into root.sg1.d2(time, s1, s2, s4, s5) values(4, 4.0, 4, TRUE,
'non_aligned_test4');
insert into root.sg1.d2(time, s1, s2, s4, s5) values(5, 5.0, 5, TRUE,
'non_aligned_test5');
insert into root.sg1.d2(time, s1, s2, s3, s4) values(6, 6.0, 6, 6, TRUE);
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(7, 7.0, 7, 7,
FALSE, 'non_aligned_test7');
insert into root.sg1.d2(time, s1, s2, s3, s5) values(8, 8.0, 8, 8,
'non_aligned_test8');
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(9, 9.0, 9, 9,
FALSE, 'non_aligned_test9');
insert into root.sg1.d2(time, s2, s3, s4, s5) values(10, 10, 10, TRUE,
'non_aligned_test10');
flush
insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3,
30000.0, 30000, TRUE, 'aligned_unseq_test3');
insert into root.sg1.d1(time, s1, s2, s3) aligned values(11, 11.0, 11, 11);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(12, 12.0, 12, 12);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(13, 13.0, 13, 13);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(14, 14.0, 14, 14);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(15, 15.0, 15, 15);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(16, 16.0, 16, 16);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(17, 17.0, 17, 17);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(18, 18.0, 18, 18);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(19, 19.0, 19, 19);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(20, 20.0, 20, 20);
insert into root.sg1.d2(time, s1, s2, s3) values(11, 11.0, 11, 11);
insert into root.sg1.d2(time, s1, s2, s3) values(12, 12.0, 12, 12);
insert into root.sg1.d2(time, s1, s2, s3) values(13, 13.0, 13, 13);
insert into root.sg1.d2(time, s1, s2, s3) values(14, 14.0, 14, 14);
insert into root.sg1.d2(time, s1, s2, s3) values(15, 15.0, 15, 15);
insert into root.sg1.d2(time, s1, s2, s3) values(16, 16.0, 16, 16);
insert into root.sg1.d2(time, s1, s2, s3) values(17, 17.0, 17, 17);
insert into root.sg1.d2(time, s1, s2, s3) values(18, 18.0, 18, 18);
insert into root.sg1.d2(time, s1, s2, s3) values(19, 19.0, 19, 19);
insert into root.sg1.d2(time, s1, s2, s3) values(20, 20.0, 20, 20);
flush;
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(13,
130000.0, 130000, 130000, TRUE, 'aligned_unseq_test13');
insert into root.sg1.d1(time, s3, s4) aligned values(21, 21, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(22, 22, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(23, 23, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(24, 24, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(25, 25, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(26, 26, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(27, 27, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(28, 28, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(29, 29, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(30, 30, FALSE);
insert into root.sg1.d2(time, s3, s4) values(21, 21, TRUE);
insert into root.sg1.d2(time, s3, s4) values(22, 22, TRUE);
insert into root.sg1.d2(time, s3, s4) values(23, 23, TRUE);
insert into root.sg1.d2(time, s3, s4) values(24, 24, TRUE);
insert into root.sg1.d2(time, s3, s4) values(25, 25, TRUE);
insert into root.sg1.d2(time, s3, s4) values(26, 26, FALSE);
insert into root.sg1.d2(time, s3, s4) values(27, 27, FALSE);
insert into root.sg1.d2(time, s3, s4) values(28, 28, FALSE);
insert into root.sg1.d2(time, s3, s4) values(29, 29, FALSE);
insert into root.sg1.d2(time, s3, s4) values(30, 30, FALSE);
flush;
insert into root.sg1.d1(time, s1, s3, s4) aligned values(23, 230000.0,
230000, FALSE);
insert into root.sg1.d1(time, s2, s5) aligned values(31, 31, 'aligned_test31');
insert into root.sg1.d1(time, s2, s5) aligned values(32, 32, 'aligned_test32');
insert into root.sg1.d1(time, s2, s5) aligned values(33, 33, 'aligned_test33');
insert into root.sg1.d1(time, s2, s5) aligned values(34, 34, 'aligned_test34');
insert into root.sg1.d1(time, s2, s5) aligned values(35, 35, 'aligned_test35');
insert into root.sg1.d1(time, s2, s5) aligned values(36, 36, 'aligned_test36');
insert into root.sg1.d1(time, s2, s5) aligned values(37, 37, 'aligned_test37');
insert into root.sg1.d1(time, s2, s5) aligned values(38, 38, 'aligned_test38');
insert into root.sg1.d1(time, s2, s5) aligned values(39, 39, 'aligned_test39');
insert into root.sg1.d1(time, s2, s5) aligned values(40, 40, 'aligned_test40');
insert into root.sg1.d2(time, s2, s5) values(31, 31, 'non_aligned_test31');
insert into root.sg1.d2(time, s2, s5) values(32, 32, 'non_aligned_test32');
insert into root.sg1.d2(time, s2, s5) values(33, 33, 'non_aligned_test33');
insert into root.sg1.d2(time, s2, s5) values(34, 34, 'non_aligned_test34');
insert into root.sg1.d2(time, s2, s5) values(35, 35, 'non_aligned_test35');
insert into root.sg1.d2(time, s2, s5) values(36, 36, 'non_aligned_test36');
insert into root.sg1.d2(time, s2, s5) values(37, 37, 'non_aligned_test37');
insert into root.sg1.d2(time, s2, s5) values(38, 38, 'non_aligned_test38');
insert into root.sg1.d2(time, s2, s5) values(39, 39, 'non_aligned_test39');
insert into root.sg1.d2(time, s2, s5) values(40, 40, 'non_aligned_test40');
select * from root;
select last * from root.sg1.*;
select * from root.sg1.d1 where time >= 9 and time <= 33 and s1 < 19
align by device;
select max_value(s3), min_value(s1), max_time(s2), min_time(s3) from
root.sg1.d1 where time > 5 GROUP BY ([1, 41), 10ms) order by time
desc;
Best
Tian Jiang
发件人: Gaofei Cao
发送时间: 2022年7月2日 0:43
收件人: dev@iotdb.apache.org
主题: Re: [VOTE] Apache IoTDB 0.14.0-preview1 RC1 release
+1 (binding)
The source release:
apache headers [ok]
signatures and hashes [ok]
LICENSE and NOTICE [ok]
no jar files [ok]
could compile from source: ./mvnw.sh clean install [minor issue with
a target file not ignored by apache-rat]
The binary distribution:
version number in CLI [ok]
signatures and hashes [ok]
start in mac M1 pro, jdk1.8 [ok]
statements executed successfully: [ok]
SET STORAGE GROUP TO root.sg1;
create aligned timeseries root.sg1.d1(s1 FLOAT encoding=RLE, s2 INT32
encoding=Gorilla compression=SNAPPY, s3 INT64, s4 BOOLEAN, s5 TEXT);
create timeseries root.sg1.d2.s1 WITH DATATYPE=FLOAT, encoding=RLE;
create timeseries root.sg1.d2.s2 WITH DATATYPE=INT32, encoding=Gorilla;
create timeseries root.sg1.d2.s3 WITH DATATYPE=INT64;
create timeseries root.sg1.d2.s4 WITH DATATYPE=BOOLEAN;
create timeseries root.sg1.d2.s5 WITH DATATYPE=TEXT;
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(1,
1.0, 1, 1, TRUE, 'aligned_test1');
insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(2, 2.0,
2, 2, 'aligned_test2');
insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3, 3.0,
3, FALSE, 'aligned_test3');
insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(4, 4.0,
4, TRUE, 'aligned_test4');
insert into root.sg1.d1(time, s1, s2, s4, s5) aligned values(5, 5.0,
5, TRUE, 'aligned_test5');
insert into root.sg1.d1(time, s1, s2, s3, s4) aligned values(6, 6.0,
6, 6, TRUE);
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(7,
7.0, 7, 7, FALSE, 'aligned_test7');
insert into root.sg1.d1(time, s1, s2, s3, s5) aligned values(8, 8.0,
8, 8, 'aligned_test8');
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(9,
9.0, 9, 9, FALSE, 'aligned_test9');
insert into root.sg1.d1(time, s2, s3, s4, s5) aligned values(10, 10,
10, TRUE, 'aligned_test10');
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(1, 1.0, 1, 1,
TRUE, 'non_aligned_test1');
insert into root.sg1.d2(time, s1, s2, s3, s5) values(2, 2.0, 2, 2,
'non_aligned_test2');
insert into root.sg1.d2(time, s1, s3, s4, s5) values(3, 3.0, 3, FALSE,
'non_aligned_test3');
insert into root.sg1.d2(time, s1, s2, s4, s5) values(4, 4.0, 4, TRUE,
'non_aligned_test4');
insert into root.sg1.d2(time, s1, s2, s4, s5) values(5, 5.0, 5, TRUE,
'non_aligned_test5');
insert into root.sg1.d2(time, s1, s2, s3, s4) values(6, 6.0, 6, 6, TRUE);
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(7, 7.0, 7, 7,
FALSE, 'non_aligned_test7');
insert into root.sg1.d2(time, s1, s2, s3, s5) values(8, 8.0, 8, 8,
'non_aligned_test8');
insert into root.sg1.d2(time, s1, s2, s3, s4, s5) values(9, 9.0, 9, 9,
FALSE, 'non_aligned_test9');
insert into root.sg1.d2(time, s2, s3, s4, s5) values(10, 10, 10, TRUE,
'non_aligned_test10');
flush
insert into root.sg1.d1(time, s1, s3, s4, s5) aligned values(3,
30000.0, 30000, TRUE, 'aligned_unseq_test3');
insert into root.sg1.d1(time, s1, s2, s3) aligned values(11, 11.0, 11, 11);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(12, 12.0, 12, 12);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(13, 13.0, 13, 13);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(14, 14.0, 14, 14);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(15, 15.0, 15, 15);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(16, 16.0, 16, 16);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(17, 17.0, 17, 17);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(18, 18.0, 18, 18);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(19, 19.0, 19, 19);
insert into root.sg1.d1(time, s1, s2, s3) aligned values(20, 20.0, 20, 20);
insert into root.sg1.d2(time, s1, s2, s3) values(11, 11.0, 11, 11);
insert into root.sg1.d2(time, s1, s2, s3) values(12, 12.0, 12, 12);
insert into root.sg1.d2(time, s1, s2, s3) values(13, 13.0, 13, 13);
insert into root.sg1.d2(time, s1, s2, s3) values(14, 14.0, 14, 14);
insert into root.sg1.d2(time, s1, s2, s3) values(15, 15.0, 15, 15);
insert into root.sg1.d2(time, s1, s2, s3) values(16, 16.0, 16, 16);
insert into root.sg1.d2(time, s1, s2, s3) values(17, 17.0, 17, 17);
insert into root.sg1.d2(time, s1, s2, s3) values(18, 18.0, 18, 18);
insert into root.sg1.d2(time, s1, s2, s3) values(19, 19.0, 19, 19);
insert into root.sg1.d2(time, s1, s2, s3) values(20, 20.0, 20, 20);
flush;
insert into root.sg1.d1(time, s1, s2, s3, s4, s5) aligned values(13,
130000.0, 130000, 130000, TRUE, 'aligned_unseq_test13');
insert into root.sg1.d1(time, s3, s4) aligned values(21, 21, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(22, 22, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(23, 23, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(24, 24, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(25, 25, TRUE);
insert into root.sg1.d1(time, s3, s4) aligned values(26, 26, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(27, 27, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(28, 28, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(29, 29, FALSE);
insert into root.sg1.d1(time, s3, s4) aligned values(30, 30, FALSE);
insert into root.sg1.d2(time, s3, s4) values(21, 21, TRUE);
insert into root.sg1.d2(time, s3, s4) values(22, 22, TRUE);
insert into root.sg1.d2(time, s3, s4) values(23, 23, TRUE);
insert into root.sg1.d2(time, s3, s4) values(24, 24, TRUE);
insert into root.sg1.d2(time, s3, s4) values(25, 25, TRUE);
insert into root.sg1.d2(time, s3, s4) values(26, 26, FALSE);
insert into root.sg1.d2(time, s3, s4) values(27, 27, FALSE);
insert into root.sg1.d2(time, s3, s4) values(28, 28, FALSE);
insert into root.sg1.d2(time, s3, s4) values(29, 29, FALSE);
insert into root.sg1.d2(time, s3, s4) values(30, 30, FALSE);
flush;
insert into root.sg1.d1(time, s1, s3, s4) aligned values(23, 230000.0,
230000, FALSE);
insert into root.sg1.d1(time, s2, s5) aligned values(31, 31, 'aligned_test31');
insert into root.sg1.d1(time, s2, s5) aligned values(32, 32, 'aligned_test32');
insert into root.sg1.d1(time, s2, s5) aligned values(33, 33, 'aligned_test33');
insert into root.sg1.d1(time, s2, s5) aligned values(34, 34, 'aligned_test34');
insert into root.sg1.d1(time, s2, s5) aligned values(35, 35, 'aligned_test35');
insert into root.sg1.d1(time, s2, s5) aligned values(36, 36, 'aligned_test36');
insert into root.sg1.d1(time, s2, s5) aligned values(37, 37, 'aligned_test37');
insert into root.sg1.d1(time, s2, s5) aligned values(38, 38, 'aligned_test38');
insert into root.sg1.d1(time, s2, s5) aligned values(39, 39, 'aligned_test39');
insert into root.sg1.d1(time, s2, s5) aligned values(40, 40, 'aligned_test40');
insert into root.sg1.d2(time, s2, s5) values(31, 31, 'non_aligned_test31');
insert into root.sg1.d2(time, s2, s5) values(32, 32, 'non_aligned_test32');
insert into root.sg1.d2(time, s2, s5) values(33, 33, 'non_aligned_test33');
insert into root.sg1.d2(time, s2, s5) values(34, 34, 'non_aligned_test34');
insert into root.sg1.d2(time, s2, s5) values(35, 35, 'non_aligned_test35');
insert into root.sg1.d2(time, s2, s5) values(36, 36, 'non_aligned_test36');
insert into root.sg1.d2(time, s2, s5) values(37, 37, 'non_aligned_test37');
insert into root.sg1.d2(time, s2, s5) values(38, 38, 'non_aligned_test38');
insert into root.sg1.d2(time, s2, s5) values(39, 39, 'non_aligned_test39');
insert into root.sg1.d2(time, s2, s5) values(40, 40, 'non_aligned_test40');
select * from root;
select last * from root.sg1.*;
select * from root.sg1.d1 where time >= 9 and time <= 33 and s1 < 19
align by device;
select max_value(s3), min_value(s1), max_time(s2), min_time(s3) from
root.sg1.d1 where time > 5 GROUP BY ([1, 41), 10ms) order by time
desc;
Best,
————————
Gaofei Cao
Apache IoTDB PMC