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 2021/04/19 09:39:00 UTC

[jira] [Created] (IOTDB-1315) export-csv.sh -tf yyyy-MM-dd\'T\'HH:mm:ss.SSSZ error: is not supported

刘珍 created IOTDB-1315:
-------------------------

             Summary: export-csv.sh   -tf  yyyy-MM-dd\'T\'HH:mm:ss.SSSZ  error:   is not supported
                 Key: IOTDB-1315
                 URL: https://issues.apache.org/jira/browse/IOTDB-1315
             Project: Apache IoTDB
          Issue Type: Bug
            Reporter: 刘珍
         Attachments: image-2021-04-19-17-33-31-547.png, image-2021-04-19-17-34-40-690.png, image-2021-04-19-17-36-01-620.png

release 0.12.0

cli execute :

CREATE TIMESERIES [root.db1.tab1.id|http://root.db1.tab1.id/] WITH DATATYPE=INT32, ENCODING=PLAIN

CREATE TIMESERIES [root.db1.tab1.name|http://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 {color:#FF0000}yyyy-MM-dd\'T\'HH:mm:ss.SSSZ{color} -td ./ -f dump_ts4 -s select

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

SimpleDateFormat中支持了,但是

!image-2021-04-19-17-33-31-547.png!

 

这个里面没有加:

!image-2021-04-19-17-36-01-620.png!

 



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