Hi,
try this json:
{
"source": { "file": { "path":
"/home/ivan/Scrivania/etl/comm18-04/data.csv" } },
"extractor": { "csv": {} },
"loader": {
"orientdb": {
"dbURL":
"plocal:/home/ivan/OrientDB/db_installati/enterprise/orientdb-enterprise-2.1.15/databases/comm1804",
"dbType": "document",
"class": "test",
"classes": [{"name": "test"}],
"indexes": [{"class":"test", "fields":["zip:STRING"],
"type":"NOTUNIQUE" }]
}
}
}
I've added the "class" parameter in the loader, like explained here
<http://orientdb.com/docs/last/Loader.html> and it's working for me.
Hope it helps, bye
Il giorno lunedì 18 aprile 2016 16:16:08 UTC+2, Luc Evers ha scritto:
>
> testdata: https://support.spatialkey.com/spatialkey-sample-csv-data/
>
> test.json file :
>
> {
> "config":{
> "log": "debug"
> },
> "begin": [
> ],
> "source" : {
> "file": { "path": "./test.csv", "lock" : false }
> },
> "extractor" : {
> "row": {}
> },
> "transformers" : [
> { "csv": { "separator": ",", "nullValue": "NULL", "skipFrom": 1,
> "skipTo": 2 } }
> ],
> "loader" : {
> "orientdb": {
> "dbURL": "remote:localhost/test",
> "dbUser": "admin",
> "dbPassword": "admin",
> "dbAutoCreate": true,
> "tx": false,
> "dbType": "document",
> "classes":[{"name": "test" }],
> "indexes": [{"class":"test", "fields":["zip:STRING"],
> "type":"NOTUNIQUE" }]
> }
> }
> }
>
> Error MSG:
> Cannot check the existance of a database in a remote server. Please use
> the console or the OServerAdmin class.
> Why NOT? This tool is useless if remote is not working.
>
> Change to local
>
> {
> "config":{
> "log": "debug"
> },
> "begin": [
> ],
> "source" : {
> "file": { "path": "./test.csv", "lock" : false }
> },
> "extractor" : {
> "row": {}
> },
> "transformers" : [
> { "csv": { "separator": ",", "nullValue": "NULL" } }
> ],
> "loader" : {
> "orientdb": {
> "dbURL":
> "plocal:/home/master/Downloads/orientdb/orientdb-community-2.1.15/databases/test",
> "dbUser": "admin",
> "dbPassword": "admin",
> "dbAutoCreate": true,
> "tx": false,
> "dbType": "document",
> "classes":[{"name": "test" }],
> "indexes": [{"class":"test", "fields":["zip:STRING"],
> "type":"NOTUNIQUE" }]
> }
> }
> }
>
> Only works if I shutdown the OrientDB server.
> Result:
> END ETL PROCESSOR
> + extracted 986 rows (0 rows/sec) - 986 rows -> loaded 985 documents (0
> documents/sec) Total time: 965ms [0 warnings, 0 errors]
>
>
> *But there is no data in the database, I think because the server is not
> running.*
>
> *Question?*
> How can I load the CSV data via the ETL tool?
> Why remote is not working?
>
>
>
>
>
>
--
---
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.
