does the id property actually exists in Server class? Il giorno martedì 3 gennaio 2017 10:42:05 UTC+1, Anthony Wong ha scritto: > > Thanks Ivan. > > I updated the type to String. It prompts that can't create the property > 'id' inside a transaction. Here the id means the wrong name in my server > class? or I should create the column of my index? > > ETL process has problem: >> com.orientechnologies.orient.core.exception.OSchemaException: Cannot create >> property 'id' inside a transaction > > DB name="GratefulDeadConcerts" > > END ETL PROCESSOR > > > > Ivan Mainetti於 2017年1月2日星期一 UTC+8下午3時42分15秒寫道： >> >> this error >> >> ETL process has problem: java.lang.IllegalArgumentException: No enum >> constant com.orientechnologies.orient.core.metadata.schema.OType.NAME >> <http://com.orientechnologies.orient.core.metadata.schema.otype.name/> >> >> means that name isn't a valid type. you should use String >> >> "indexes": [{ >> "class": "Server", >> "fields": ["id:string"], >> "type": "UNIQUE" >> }] >> >> ref: http://orientdb.com/docs/2.2.x/Loader.html#orientdb >> >> >> *PS* >> *you firstly declared the index as NOTUNIQUE but in etl you declare it as >> UNIQUE, that doesn't feel very correct..* >> >> >> >> Il giorno giovedì 29 dicembre 2016 11:22:10 UTC+1, Anthony Wong ha >> scritto: >>> >>> I would like to upload the data in OrientDB, but have errors. Here is >>> the json file: Try to upload the data in csv file and make the linkage with >>> server and virtualmachine >>> >>> { >>> "source": { >>> "file": { >>> "path": "/root/Orientdb/bin/temp/datasets/server.csv" >>> } >>> }, >>> "extractor": { >>> "row": {} >>> }, >>> "transformers": [{ >>> "csv": { >>> "separator": ",", >>> "columnsOnFirstLine": false, >>> "columns": ["name", "description", "servercategory", >>> "primarysupport", "secondarysupport", "powersource", "serialnumber", >>> "brand", "model", "serverlocation", "osfamily", "osversion", "cpuspeed", >>> "ram", "numberofprocessor", "cpucorecount", "leftpowersource", >>> "rightpowersource"] >>> } >>> }, { >>> "vertex": { >>> "class": "Server" >>> } >>> }, { >>> "merge": { >>> "joinFieldName": "virtualhost", >>> "lookup": "Server.name" >>> } >>> }, { >>> "edge": { >>> "class": "VirtualMachine", >>> "joinFieldName": "to", >>> "lookup": "Server.name", >>> "unresolvedLinkAction": "CREATE" >>> } >>> }], >>> "loader": { >>> "orientdb": { >>> "dbURL": "plocal:/databases/GratefulDeadConcerts", >>> "dbType": "graph", >>> "wal": false, >>> "batchCommit": 1000, >>> "tx": true, >>> "txUseLog": false, >>> "useLightweightEdges": true, >>> "classes": [{ >>> "name": "Server", >>> "extends": "V" >>> }, { >>> "name": "VirtualMachine", >>> "extends": "E" >>> }], >>> "indexes": [{ >>> "class": "Server", >>> "fields": ["id:name"], >>> "type": "UNIQUE" >>> }] >>> } >>> } >>> } >>> >>> However, there are errors after run the command (./oetl.sh server.json) . >>> What should I do to fix the issue? Or i should not create the class (Server >>> and VirtualMachine) before run the script? Thanks. >>> >>> The error message is >>> >>> BEGIN ETL PROCESSOR >>> [file] INFO Reading from file /root/Orientdb/bin/temp/datasets/server.csv >>> with encoding UTF-8 >>> Started execution with 1 worker threads >>> ETL process has problem: java.lang.IllegalArgumentException: No enum >>> constant com.orientechnologies.orient.core.metadata.schema.OType.NAME >>> END ETL PROCESSOR >>> + extracted 0 rows (0 rows/sec) - 0 rows -> loaded 0 vertices (0 >>> vertices/sec) Total time: 5ms [0 warnings, 0 errors] >>> >>>
-- --- 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.
