刘珍 created IOTDB-1232:
-------------------------

             Summary: import csv,the imported data is incompletely  and some 
imported time column is  wrong.
                 Key: IOTDB-1232
                 URL: https://issues.apache.org/jira/browse/IOTDB-1232
             Project: Apache IoTDB
          Issue Type: Bug
            Reporter: 刘珍
         Attachments: dump0.csv

master branch.

commit id : 5fcff40f2299caeb0c8a9ae42f68bc18ecf8fee7

iotdb cli :

SET STORAGE GROUP TO root.sg
CREATE TIMESERIES root.sg.d1.s1 WITH DATATYPE=DOUBLE, ENCODING=PLAIN
CREATE TIMESERIES root.sg.d1.s2 WITH DATATYPE=DOUBLE, ENCODING=PLAIN

dump0.csv:

[^dump0.csv]

 ./tools/import-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -f ./dump0.csv -tz 
+08:00
------------------------------------------
Starting IoTDB Client Import Script
------------------------------------------
14:45:08.786 [main] DEBUG org.apache.iotdb.rpc.AutoResizingBuffer - 
org.apache.iotdb.rpc.AutoResizingBuffer@cb5822 expand from 65536 to 16384000, 
request: 16384000
Start to import data from: dump0.csv
Import from: dump0.csv 0% │ │ 0/41 (0:00:00 / ?) Importing...
Import from: dump0.csv 100% 
│████████████████████████████████████████████████████│ 41/41 (0:00:00 / 
0:00:00) Importing...

 

IoTDB> select s1 from root.sg.d1;
+-----------------------------+-------------+
| Time|root.sg.d1.s1|
+-----------------------------+-------------+
|2021-03-12T11:52:50.000+08:00| 0.757181|
|2021-03-12T11:53:02.000+08:00| 0.130961|
|2021-03-12T11:59:42.000+08:00| 0.866891|
|2021-03-12T11:59:45.000+08:00| 0.371016|
|2021-03-12T11:59:53.000+08:00| 0.079831|
+-----------------------------+-------------+
Total line number = 5

*{color:#FF0000}expected :{color}*

Total line number = 39

 

*{color:#FF0000}and  "2021-03-12T11:59:53.000+08:00" is not exist in 
dump0.csv.{color}*

 

 

 

 

 

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to