Uploaded image for project: 'Apache IoTDB'
  1. Apache IoTDB
  2. IOTDB-1316

A sensor point value is invalid and this row can be imported successfully,but the following rows in this file are not executed

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 0.12.0
    • None
    • None

    Description

      release 0.12.0

      A sensor point value is invalid and this row can be imported successfully( the sensor point is null),but the following rows in this file are not executed。

      cli execute :

      CREATE TIMESERIES root.db1.tab1.id WITH DATATYPE=INT32, ENCODING=PLAIN

      CREATE TIMESERIES root.db1.tab1.name WITH DATATYPE=text, ENCODING=PLAIN

      CREATE TIMESERIES root.db1.tab1.age WITH DATATYPE=INT32, ENCODING=PLAIN

      CREATE TIMESERIES root.db1.tab1.country WITH DATATYPE=text, ENCODING=PLAIN

      CREATE TIMESERIES root.db1.tab1.salary WITH DATATYPE=float, ENCODING=PLAIN

      CREATE TIMESERIES root.db1.tab1.other WITH DATATYPE=double, ENCODING=PLAIN

      CREATE TIMESERIES root.db1.tab1.student WITH DATATYPE=boolean, ENCODING=PLAIN

       

      2 import files locate in csv_file directory :

      cat csv_file/dump_ts3.csv :
      Time,root.db1.tab1.country,root.db1.tab1.other,root.db1.tab1.student,root.db1.tab1.name,root.db1.tab1.id,root.db1.tab1.salary,root.db1.tab1.age
      2021-04-19T16:28:19,usa,china,false,丽丽,1.0,5678.34,25.0
      2021-04-19T16:28:29,usa,7.777777,false,支持,0.0,5678.34,25.0
      2021-04-19T16:28:39,usa,7.777777,false,lily,1.0,5678.34,25.0
      2021-04-19T16:28:49,usa,7.777777,false,lily2,2.0,5678.34,25.0
      2021-04-19T16:28:59,usa,7.777777,false,lily3,3.0,5678.34,25.0

       

      cat csv_file/dump_ts4.csv :
      Time,root.db1.tab1.country,root.db1.tab1.other,root.db1.tab1.student,root.db1.tab1.name,root.db1.tab1.id,root.db1.tab1.salary,root.db1.tab1.age
      2021-04-19T16:29:19,usa,7.777777,false,lily,1.0,5678.34,25.0
      2021-04-19T16:29:29,usa,7.777777,false,lily0,0.0,5678.34,25.0
      2021-04-19T16:29:39,usa,7.777777,false,lily1,1.0,5678.34,25.0
      2021-04-19T16:29:49,usa,7.777777,false,lily2,2.0,5678.34,25.0
      2021-04-19T16:29:59,usa,7.777777,false,lily3,3.0,5678.34,25.0

       

      import SQL:

      ./import-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -f ./csv_file
      ------------------------------------------
      Starting IoTDB Client Import Script
      ------------------------------------------
      Start to import data from: dump_ts3.csv
      Import from: dump_ts3.csv 0% │ │ 0/7 (0:00:00 / ?) Importing...
      Meet error when insert csv because org.apache.iotdb.db.exception.StorageEngineException: failed to insert measurements [other] caused by For input string: "china";
      Start to import data from: dump_ts4.csv
      Import from: dump_ts4.csv 0% │ │ 0/7 (0:00:00 / ?) Importing...
      Import from: dump_ts4.csv 100% │█████████████████████████████████████████████████████████│ 7/7 (0:00:00 / 0:00:00) Importing...

       

      cli:

      select * from root.db1.*;

      The last 4 rows in  dump_ts3.csv are not imported.

      Attachments

        1. image-2021-04-19-17-50-27-843.png
          33 kB
          刘珍
        2. image-2021-05-06-21-03-07-103.png
          290 kB
          Haonan Hou

        Issue Links

          Activity

            People

              Unassigned Unassigned
              刘珍 刘珍
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: