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)