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

[Jira]

刘珍 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)