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

export-csv.sh -tf yyyy-MM-dd\'T\'HH:mm:ss.SSSZ error: is not supported

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      release 0.12.0

      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

       

      insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) values(now(),1,'lily',25,'usa',5678.34,7.777777,false);

       

      insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) values(now(),0,'lily0',25,'usa',5678.34,7.777777,false);

      insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) values(now(),1,'lily1',25,'usa',5678.34,7.777777,false);

      insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) values(now(),2,'lily2',25,'usa',5678.34,7.777777,false);

      insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) values(now(),3,'lily3',25,'usa',5678.34,7.777777,false);

       

      select file :

      select * from root.db1.*

      execute export indicate ts format :

      ./export-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -tf yyyy-MM-dd\'T\'HH:mm:ss.SSSZ -td ./ -f dump_ts4 -s select

      ------------------------------------------
      Starting IoTDB Client Export Script
      ------------------------------------------
      Input time format yyyy-MM-dd'T'HH:mm:ss.SSSZ is not supported, please input like yyyy-MM-dd\ HH:mm:ss.SSS or yyyy-MM-dd'T'HH:mm:ss.SSS

      SimpleDateFormat中支持了,但是

       

      这个里面没有加:

       

      Attachments

        1. image-2021-04-19-17-33-31-547.png
          30 kB
          刘珍
        2. image-2021-04-19-17-34-40-690.png
          283 kB
          刘珍
        3. image-2021-04-19-17-36-01-620.png
          283 kB
          刘珍

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: