如何使用csv文件和Json解析器在Orientdb数据库中输入数据

Question

当我试着安排约会时间时，我遇到了一个问题。我用Json读取CSV，将数据放到Orientdb数据库中

csv：

id;id_tag;tag_name;date
1;1;tag1;"2014-3-24 6:49:2"
2;1;tag1;"2009-11-22 13:12:7"
3;1;tag1;"2014-10-18 14:47:6"
4;1;tag1;"2013-2-10 15:23:27"

杰森：

{
 "config": {
    "log": "debug"
  },
  "source": { "file": { "path": "/Users/jonathanmahe/Documents/OrientTest/GeospatialTest/bd1000/bd1000.csv" } },
  "extractor": { "csv": {
    "separator": ";",
    "columns": ["id:Integer","id_tag:Integer","tag_name:String","date:dateTime"] } },
  "transformers": [
    { "command": { "command": "INSERT INTO Tag(id,id_tag,tag_name,date) values('${input.id}','${input.id_tag}','${input.tag_name}','${input.date}')"} }
  ],            
  "loader": {
    "orientdb": {
        "dbURL": "remote:localhost/databases/bd1000",
        "dbUser": "admin",
        "dbPassword": "admin",
        "serverUser": "root",
        "serverPassword": "root",
        "dbType": "graph",
        "batchCommit": 1000
    }
  }
}

我得到的错误是：

使用格式:yyyy:mm:ss转换日期'Mon Mar24 06:49:00CET 2014‘时的错误exception=Error

有人有主意吗？

Answer 1

在启动etl导入之前，您需要修改datetime格式：

• 连接到db
• alter database DATETIMEFORMAT "EEE MMM dd HH:mm:ss zzz yyyy"
• 运行etl脚本

orientdb {db=bd1000}> select from tag

+----+-----+------+----+------+--------+-----------------------------+
|#   |@RID |@CLASS|id  |id_tag|tag_name|date                         |
+----+-----+------+----+------+--------+-----------------------------+
|0   |#21:0|Tag   |1   |1     |tag1    |Mon Mar 24 06:49:00 CET 2014 |
|1   |#22:0|Tag   |2   |1     |tag1    |Sun Nov 22 13:12:00 CET 2009 |
|2   |#23:0|Tag   |3   |1     |tag1    |Sat Oct 18 14:47:00 CEST 2014|
|3   |#24:0|Tag   |4   |1     |tag1    |Sun Feb 10 15:23:00 CET 2013 |
+----+-----+------+----+------+--------+-----------------------------+