You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "刘珍 (Jira)" <ji...@apache.org> on 2023/06/16 01:47:00 UTC
[jira] [Commented] (IOTDB-5937) Importing CSV data to the alias series ( view ) did not report error, but failed.
[ https://issues.apache.org/jira/browse/IOTDB-5937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17733276#comment-17733276 ]
刘珍 commented on IOTDB-5937:
---------------------------
!image-2023-06-16-09-45-38-684.png!
> Importing CSV data to the alias series ( view ) did not report error, but failed.
> ---------------------------------------------------------------------------------
>
> Key: IOTDB-5937
> URL: https://issues.apache.org/jira/browse/IOTDB-5937
> Project: Apache IoTDB
> Issue Type: Bug
> Components: mpp-cluster, Tools/Others
> Affects Versions: 1.2
> Reporter: 刘珍
> Assignee: Yukun Zhou
> Priority: Minor
> Labels: view
> Attachments: image-2023-05-30-11-44-39-754.png, image-2023-06-16-09-45-38-684.png
>
>
> 测试版本：iotdb master 0528_84780e2
> 向别名序列 import csv 数据，没有报错信息，但是import 失败。
> drop database root.db;
> create database root.db;
> create aligned timeseries root.db.t1(s_0 DOUBLE compressor=SNAPPY ,s_1 DOUBLE ENCODING=RLE compressor=LZ4 ,s_2 DOUBLE ENCODING=TS_2DIFF compressor=GZIP,s_3 DOUBLE ENCODING=GORILLA compressor=ZSTD,s_4 DOUBLE compressor=ZSTD,s_5 DOUBLE ENCODING=CHIMP compressor=UNCOMPRESSED,s_6 DOUBLE compressor=LZ4,s_7 DOUBLE compressor=GZIP,s_8 DOUBLE compressor=ZSTD,s_9 DOUBLE compressor=ZSTD,s_10 DOUBLE compressor=SNAPPY,s_11 DOUBLE compressor=UNCOMPRESSED);
> insert into root.db.t1(time,s_0,s_1,s_2,s_3,s_4,s_5,s_6,s_7,s_8,s_9,s_10,s_11)aligned values(1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1,1.1);
> insert into root.db.t1(time,s_0,s_1,s_2,s_3,s_4,s_5,s_6,s_7,s_8,s_9,s_10,s_11)aligned values(2,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1,2.1);
> insert into root.db.t1(time,s_0,s_1,s_2,s_3,s_4,s_5,s_6,s_7,s_8,s_9,s_10,s_11)aligned values(3,3.1,3.1,3.1,3.1,3.1,3.1,3.1,3.1,3.1,3.1,3.1,3.1);
> insert into root.db.t1(time,s_0,s_1,s_2,s_3,s_4,s_5,s_6,s_7,s_8,s_9,s_10,s_11)aligned values(4,4.1,4.1,4.1,4.1,4.1,4.1,4.1,4.1,4.1,4.1,4.1,4.1);
> create view root.db.view1.col0,root.db.view1.col1 as select s_0,s_1 from root.db.t1;
> select col0,col1 from root.db.view1; // 4条记录
> tools/export-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -td ./ -q "select col0,col1 from root.db.view1;" //导出成功
> cat dump0_0.csv
> Time,root.db.view1.col0,root.db.view1.col1
> 1970-01-01T08:00:00.001+08:00,1.1,1.1
> 1970-01-01T08:00:00.002+08:00,2.1,2.1
> 1970-01-01T08:00:00.003+08:00,3.1,3.1
> 1970-01-01T08:00:00.004+08:00,4.1,4.1
> 删除数据，对别名序列import csv数据
> ./sbin/start-cli.sh -e "delete from root.db.**;"
> ./sbin/start-cli.sh -e "select * from root.db.**"
> 可以看到查询出来的是空结果集
> tools/import-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -f dump0_0.csv -fd ./failed -aligned true
> ./sbin/start-cli.sh -e "select * from root.db.**" // import 没有成功
> !image-2023-05-30-11-44-39-754.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)