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

2021-05-08 Thread Jira 


[ 
https://issues.apache.org/jira/browse/IOTDB-1315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17341242#comment-17341242
 ] 

刘珍 commented on IOTDB-1315:
---

commit e9ada637017068ad9adb2e956f07288b1d44f60b
Author: Haonan 
Date:   Sat May 8 15:19:54 2021 +0800

[IOTDB-1232][IOTDB-1313] Fix lossing time precision when import csv with 
unsupported timestamp format (#3142)
已解决。

> export-csv.sh   -tf  -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: 刘珍
>Priority: Minor
>  Labels: pull-request-available
> 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.77,false);
>  
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),0,'lily0',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),1,'lily1',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),2,'lily2',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),3,'lily3',25,'usa',5678.34,7.77,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:#FF}-MM-dd\'T\'HH:mm:ss.SSSZ{color} -td ./ -f dump_ts4 -s 
> select
> --
> Starting IoTDB Client Export Script
> --
> Input time format -MM-dd'T'HH:mm:ss.SSSZ {color:#FF}is not 
> supported{color}, please input like -MM-dd\ HH:mm:ss.SSS or 
> -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)

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

2021-05-06 Thread Haonan Hou (Jira) 


[ 
https://issues.apache.org/jira/browse/IOTDB-1315?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17340526#comment-17340526
 ] 

Haonan Hou commented on IOTDB-1315:
---

ImportCsv supports -MM-dd'T'HH:mm:ss.SSSZ,

exportCsv should supports -MM-dd'T'HH:mm:ss.SSSZ as well.

> export-csv.sh   -tf  -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: 刘珍
>Priority: Minor
>  Labels: pull-request-available
> 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.77,false);
>  
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),0,'lily0',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),1,'lily1',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),2,'lily2',25,'usa',5678.34,7.77,false);
> insert into root.db1.tab1(time,id,name,age,country,salary,other ,student ) 
> values(now(),3,'lily3',25,'usa',5678.34,7.77,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:#FF}-MM-dd\'T\'HH:mm:ss.SSSZ{color} -td ./ -f dump_ts4 -s 
> select
> --
> Starting IoTDB Client Export Script
> --
> Input time format -MM-dd'T'HH:mm:ss.SSSZ {color:#FF}is not 
> supported{color}, please input like -MM-dd\ HH:mm:ss.SSS or 
> -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)