You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@iotdb.apache.org by GitBox <gi...@apache.org> on 2022/08/27 07:30:06 UTC
[GitHub] [iotdb] cmlmakahts opened a new pull request, #7145: [IOTDB-4244] Optimize csv tool, add Options '-typeInfer' , '-linesPer…
cmlmakahts opened a new pull request, #7145:
URL: https://github.com/apache/iotdb/pull/7145
[PoC]
1. Prepare dataset
``` sql
create storage group root.ln;
create timeseries root.ln.wf01.wt01.temperature with datatype=FLOAT ,encoding=RLE;
create timeseries root.ln.wf01.wt01.status with datatype=BOOLEAN,encoding=RLE;
create timeseries root.ln.wf01.wt01.hardware with datatype=TEXT,encoding=PLAIN;
create timeseries root.ln.wf01.wt01.score with datatype=INT32,encoding=RLE;
insert into root.ln.wf01.wt01(time,status,temperature,hardware,score) values(1509525300000,TRUE,25.99,'V001',88);
insert into root.ln.wf01.wt01(time,status,temperature,hardware) values(1509525360000,TRUE,25.99,'V002');
insert into root.ln.wf01.wt01(time,status,temperature,hardware,score) values(1509525470000,TRUE,23.19,'V001',91);
insert into root.ln.wf01.wt01(time,status,temperature,hardware) values(1509525490000,FALSE,26.92,'V002');
insert into root.ln.wf01.wt01(time,status,hardware,score) values(1509580800000,FALSE,'V001',95);
insert into root.ln.wf01.wt01(time,status,temperature,score) values(1509559200000,FALSE,26.92,90);
insert into root.ln.wf01.wt01(time,status,temperature) values(1509638400000,TRUE,26.0);
insert into root.ln.wf01.wt01(time,temperature,hardware) values(1509724800000,23.29,'V001');
insert into root.ln.wf01.wt01(time,status,temperature,hardware) values(1509811200000,TRUE,24.19,'V002');
insert into root.ln.wf01.wt01(time,status,temperature,score) values(1509897600000,FALSE,20.19,88);
insert into root.ln.wf01.wt01(time,status,temperature) values(1509908400000,FALSE,20.19);
insert into root.ln.wf01.wt01(time,temperature,score) values(1509984000000,22.12,86);
insert into root.ln.wf01.wt01(time,status,temperature) values(1510069800000,FALSE,20.12);
insert into root.ln.wf01.wt01(time,status,temperature,hardware) values(1510069920000,FALSE,21.22,'V001');
insert into root.ln.wf01.wt01(time,status,temperature) values(1510070100000,TRUE,21.22);
insert into root.ln.wf01.wt01(time,status,hardware,score) values(1510070370000,TRUE,'V002',93);
insert into root.ln.wf01.wt01(time,status,temperature,hardware) values(1510070400000,TRUE,23.99,'V002');
insert into root.ln.wf01.wt01(time,temperature,hardware) values(1541174400000,20.99,'V002');
insert into root.ln.wf01.wt01(time,status,temperature,score) values(1541433600000,TRUE,25.99,89);
insert into root.ln.wf01.wt01(time,status,hardware,score) values(1572883200000,TRUE,'V002',90);
insert into root.ln.wf01.wt01(time,status,temperature,hardware) values(1573056000000,TRUE,24.19,'V001');
```
2. export with option '-linesPerFile 1'
``` shell
sh export-csv.sh -u root -pw root -h 192.168.42.102 -p 6667 -q "select * from root.**" -linesPerFile 2
```
3. 21 lines export to 11 file, abc0_[0-10].csv
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [iotdb] wangchao316 merged pull request #7145: [IOTDB-4244] Optimize csv tool, add Options '-typeInfer' , '-linesPer…
Posted by GitBox <gi...@apache.org>.
wangchao316 merged PR #7145:
URL: https://github.com/apache/iotdb/pull/7145
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: reviews-unsubscribe@iotdb.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org