You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2021/09/09 09:23:00 UTC

[jira] [Commented] (IOTDB-1618) The datetime-input format of the imported data is yyyy/MM/dd HH:mm:ss.SSS reports a null pointer

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

xiaozhihong commented on IOTDB-1618:
------------------------------------

!image-2021-09-09-17-21-48-402.png!

输入不正确的时间格式,给出报错提示,故验证通过

> The datetime-input format of the imported data is yyyy/MM/dd HH:mm:ss.SSS reports a null pointer
> ------------------------------------------------------------------------------------------------
>
>                 Key: IOTDB-1618
>                 URL: https://issues.apache.org/jira/browse/IOTDB-1618
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Tools/Others
>    Affects Versions: master branch
>            Reporter: xiaozhihong
>            Assignee: Xuan Ronaldo
>            Priority: Major
>         Attachments: image-2021-09-09-17-21-48-402.png
>
>
> data4.csv:
> Time,Device,s1,s2,s3
> 2021/08/01/ 12:12:12.800,root.sg.d1,100,"M2",1000
> 2021/08/02/ 12:12:12.800,root.sg.d1,200,"M2",2000
> 2021/08/03/ 12:12:12.800,root.sg.d1,300,"M3",3000
>  
> The operation is as follows:
> [xzh@i-s9p350bm apache-iotdb-0.13.0-SNAPSHOT-all-bin]$ ./tools/import-csv.sh -h localhost -p 6667 -u root -pw root -f /home/xzh/import-export/data/data4.csv
> ------------------------------------------
> Starting IoTDB Client Import Script
> ------------------------------------------
> 16:53:09.818 [main] DEBUG org.apache.iotdb.session.Session - EndPoint(ip:localhost, port:6667) execute sql select * from root.sg.d1 limit 1
> Exception in thread "main" java.lang.NullPointerException
>  at org.apache.iotdb.tool.ImportCsv.lambda$null$5(ImportCsv.java:441)
>  at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(ForEachOps.java:184)
>  at java.util.stream.ReferencePipeline$2$1.accept(ReferencePipeline.java:175)
>  at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1382)
>  at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
>  at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
>  at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(ForEachOps.java:151)
>  at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(ForEachOps.java:174)
>  at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
>  at java.util.stream.ReferencePipeline.forEach(ReferencePipeline.java:418)
>  at org.apache.iotdb.tool.ImportCsv.lambda$writeDataAlignedByDevice$6(ImportCsv.java:399)
>  at java.util.HashMap$KeySpliterator.forEachRemaining(HashMap.java:1553)
>  at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580)
>  at org.apache.iotdb.tool.ImportCsv.writeDataAlignedByDevice(ImportCsv.java:389)
>  at org.apache.iotdb.tool.ImportCsv.importFromSingleFile(ImportCsv.java:253)
>  at org.apache.iotdb.tool.ImportCsv.importFromTargetPath(ImportCsv.java:197)
>  at org.apache.iotdb.tool.ImportCsv.main(ImportCsv.java:171)



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