Hi,
I'm using the latest OrientDB version 2.1.9 to upload data with the ETL
tool. I have a CSV file like this:
id;title
100;"Title 1"
100;"Title 2"
I want to embed all titles for each unique "id" into an array. This is my
json configuration file:
{
"source": { "file": { "path": "data.csv" } },
"extractor": {
"csv": {
"separator": ";",
"columnsOnFirstLine": true,
"skipFrom": 1,
"skipTo": 1,
"columns": [
"id:integer",
"title:embeddedlist"
]
}
},
"transformers": [
{ "merge": { "joinFieldName":"id", "lookup":"MyClass.id" } },
{ "vertex": { "class": "MyClass"} }
],
"loader": {
"orientdb": {
"dbURL": "remote:localhost/DB1",
"dbUser": "admin",
"dbPassword": "admin",
"dbAutoCreate": true,
"dbAutoCreateProperties": true,
"dbType": "graph",
"classes": [
{"name":"MyClass", "extends": "V" }
],
"indexes": [
{"class":"MyClass", "fields":["id:integer"], "type":"UNIQUE" }
]
}
}
}
It somehow works, but it only gives me the last title value:
id | title
100 | ["My Title 2"]
What I really want is this:
id | title
100 | ["My Title 1","My Title 2"]
Any directions?
Thanks,
Rodrigo
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
