Hi,
I tried with two different CSV files but still the error persists, all the
properties are getting updated in the vertices:
I'm attaching both the Json etl files for your reference :
{
"source": { "file": { "path":
"/home/OrientDB/orientdb-community-2.2.0/bin/only_ip_05.csv" } },
"extractor": { "csv": {"columnsOnFirstLine": false,
"columns":["ip:string"] } },
"transformers": [
{ "vertex": { "class": "IpAddress" } }
],
"loader": {
"orientdb": {
"dbURL":
"plocal:/home/OrientDB/orientdb-community-2.2.0/Bulk_Transfer_Test2",
"dbType": "graph",
"dbUser": "admin",
"dbPassword": "admin",
"serverUser": "admin",
"wal": false,
"tx":false,
"batchCommit":100000,
"serverPassword":"admin",
"classes": [
{"name": "IpAddress", "extends": "V"}
],
"indexes": [
{"class":"IpAddress", "fields":["ip:string"], "type":"UNIQUE" }
]
}
}
}
---------------------------------
{
"source": { "file": { "path": "/home/labvolume1/orientdb/bin/edge5.csv" }
},
"extractor": { "csv": {"columnsOnFirstLine": false,
"columns":["ip:string", "loc:string",
"dpbc:string","address:string","prob:string"] } },
"transformers": [
{ "merge": { "joinFieldName":"ip", "lookup":"IpAddress.ip" } },
{ "vertex": { "class" : "IpAddress", "skipDuplicates" : true }},
{ "edge": { "class": "Located",
"joinFieldName": "loc",
"lookup": "PhyLocation.loc",
"direction": "out",
"edgeFields": { "probability": "${input.prob}" },
"targetVertexFields": { "geo_address": "${input.address}",
"dpbc": "${input.dpbc}"},
"unresolvedLinkAction": "CREATE"
}
}
],
"loader": {
"orientdb": {
"dbURL":
"plocal:/ubuntu/labvolume1/orientdb/databases/Bulk_Transfer_Test7",
"dbType": "graph",
"dbUser": "admin",
"dbPassword": "admin",
"serverUser": "admin",
"wal": false,
"tx":false,
"batchCommit":10000,
"serverPassword":"admin",
"classes": [
{"name": "IpAddress", "extends": "V"},
{"name": "PhyLocation", "extends": "V"},
{"name": "Located", "extends": "E"}
],
"indexes": [
{"class":"IpAddress", "fields":["ip:string"], "type":"UNIQUE" },
{"class":"PhyLocation", "fields":["loc:string"], "type":"UNIQUE" }
]
}
}
}
On Monday, August 29, 2016 at 7:11:21 AM UTC+5:30,
[email protected] wrote:
>
> Yes, This worked. Thanks
>
> On Friday, August 26, 2016 at 3:11:26 AM UTC+5:30, [email protected]
> wrote:
>>
>> Hi,
>>
>> have you tried with two different csv files? Where in one there is only
>> the IpAddress and in the other one the lastest colums.
>>
>> Hope it helps.
>>
>> Regards,
>> Michela
>>
>
--
---
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.
