Re: [orientdb] Re: Problems with first steps in using graphs (performance)
Alright, got oetl to run with: - Clone the repository on your computer, by executing: - git clone https://github.com/orientechnologies/orientdb-etl.git - Compile the module, by executing: - mvn clean install - Copy script/oetl.sh (or .bat under Windows) to $ORIENTDB_HOME/bin - Copy target/orientdb-etl-2.0-SNAPSHOT.jar to $ORIENTDB_HOME/lib and my json looks like: { config: { verbose: true }, extractor : { jdbc: { driver: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost/phpmyadmin, userName: root, userPassword: , query: select * from pma_recent } }, transformers : [ { vertex: { class: Test} } ], loader : { orientdb: { dbURL: plocal:127.0.0.1/Test, dbAutoCreate: true } } } But here I get: D:\Eclipse LaTeX\DB - orientdb\binoetl.bat config-test.json OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com BEGIN ETL PROCESSOR Exception in thread main java.lang.NullPointerException at com.orientechnologies.orient.etl.transformer.OVertexTransformer. execu teTransform(OVertexTransformer.java:57) at com.orientechnologies.orient.etl.transformer.OAbstractTransformer .tra nsform(OAbstractTransformer.java:37) at com.orientechnologies.orient.etl.OETLPipeline.execute( OETLPipeline.ja va:97) at com.orientechnologies.orient.etl.OETLProcessor. executeSequentially(OE TLProcessor.java:459) at com.orientechnologies.orient.etl.OETLProcessor.execute( OETLProcessor. java:253) at com.orientechnologies.orient.etl.OETLProcessor.main(OETLProcessor .jav a:221) - Table exists - DB access is successful - OrientDB url should also be fine (but I always use *connect remote:127.0.0.1/Test root root* to connect and do anything else in the database) What is my problem/how to solve this? Am Donnerstag, 14. August 2014 18:45:21 UTC+2 schrieb Lvc@: Hi Curtis, What's the problem? You cannot start it, you have errors on connection, or what? About the config file you can put it everywhere and then call the etl as: oetl.sh your-config-file Lvc@ On 14 August 2014 14:48, 'Curtis Mosters' via OrientDB orient-...@googlegroups.com javascript: wrote: I don't get it to work. Also searched for some more information already. I included the JDBC driver https://code.google.com/p/find-ur-pal/downloads/detail?name=mysql-connector-java-5.1.18-bin.jar; into the lib folder. But where shall I put the config now? Am Donnerstag, 14. August 2014 14:03:13 UTC+2 schrieb Curtis Mosters: Hey Luca, yeah it's just MySQL. God damn I did not find your link before. Sounds great and instantly testing this awesome stuff thanks =) Am Donnerstag, 14. August 2014 13:34:57 UTC+2 schrieb Lvc@: Hi Curtis, unfortunately that syntax was a proposal, but in the wiki seems has been removed the fundamental word proposal. If you want to import something in OrientDB the easier way is using the ETL: just one JSON for configuration and that's all. What's your source? A RDBMS? https://github.com/orientechnologies/orientdb-etl/wiki/Import-from-DBMS Lvc@ On 14 August 2014 13:05, 'Curtis Mosters' via OrientDB orient-...@googlegroups.com wrote: Hi, just found it here: https://github.com/orientechnologies/orientdb/ wiki/Import-RDBMS-to-Graph-Model Scroll a bit down. Mine is just copied from there. To your link: I want to import a 100 gb database into OrientDB, I don't think that the SQL Batch is the thing I'm looking for? Am Donnerstag, 14. August 2014 11:12:42 UTC+2 schrieb Enrico Risa: Hi Curtis where did you find this syntax? *CREATE EDGE E TRANSFORM comment.postId TO **post.id http://post.id* *INVERSE* I do not see it in the documentation. You could use SQL Batch for your case https://github.com/orientechnologies/orientdb/wiki/SQL-batch 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB orient-...@googlegroups.com: Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- 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 orient-databa...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-databa...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-databa...@googlegroups.com javascript:. For more options, visit https://groups.google.com/d/optout. -- --- You received this message because
Re: [orientdb] Re: Problems with first steps in using graphs (performance)
Sorry it was a mistake of the phpmyadmin database. Created a db test and tested it there, here it works well: D:\Eclipse LaTeX\DB - orientdb\binoetl.bat config-test.json OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com BEGIN ETL PROCESSOR END ETL PROCESSOR + extracted 1 records (0 records/sec) - 1 records - loaded 0 documents (0 docum ents/sec) Total time: 24ms [0 warnings, 0 errors] But now comes another problem. My class is not filled with the entry from the MySQL db. How it comes? Am Freitag, 15. August 2014 20:59:00 UTC+2 schrieb Curtis Mosters: Alright, got oetl to run with: - Clone the repository on your computer, by executing: - git clone https://github.com/orientechnologies/orientdb-etl.git - Compile the module, by executing: - mvn clean install - Copy script/oetl.sh (or .bat under Windows) to $ORIENTDB_HOME/bin - Copy target/orientdb-etl-2.0-SNAPSHOT.jar to $ORIENTDB_HOME/lib and my json looks like: { config: { verbose: true }, extractor : { jdbc: { driver: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost/phpmyadmin, userName: root, userPassword: , query: select * from pma_recent } }, transformers : [ { vertex: { class: Test} } ], loader : { orientdb: { dbURL: plocal:127.0.0.1/Test, dbAutoCreate: true } } } But here I get: D:\Eclipse LaTeX\DB - orientdb\binoetl.bat config-test.json OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com BEGIN ETL PROCESSOR Exception in thread main java.lang.NullPointerException at com.orientechnologies.orient.etl.transformer.OVertexTransformer .execu teTransform(OVertexTransformer.java:57) at com.orientechnologies.orient.etl.transformer. OAbstractTransformer.tra nsform(OAbstractTransformer.java:37) at com.orientechnologies.orient.etl.OETLPipeline.execute( OETLPipeline.ja va:97) at com.orientechnologies.orient.etl.OETLProcessor. executeSequentially(OE TLProcessor.java:459) at com.orientechnologies.orient.etl.OETLProcessor.execute( OETLProcessor. java:253) at com.orientechnologies.orient.etl.OETLProcessor.main( OETLProcessor.jav a:221) - Table exists - DB access is successful - OrientDB url should also be fine (but I always use *connect remote:127.0.0.1/Test http://127.0.0.1/Test root root* to connect and do anything else in the database) What is my problem/how to solve this? Am Donnerstag, 14. August 2014 18:45:21 UTC+2 schrieb Lvc@: Hi Curtis, What's the problem? You cannot start it, you have errors on connection, or what? About the config file you can put it everywhere and then call the etl as: oetl.sh your-config-file Lvc@ On 14 August 2014 14:48, 'Curtis Mosters' via OrientDB orient-...@googlegroups.com wrote: I don't get it to work. Also searched for some more information already. I included the JDBC driver https://code.google.com/p/find-ur-pal/downloads/detail?name=mysql-connector-java-5.1.18-bin.jar; into the lib folder. But where shall I put the config now? Am Donnerstag, 14. August 2014 14:03:13 UTC+2 schrieb Curtis Mosters: Hey Luca, yeah it's just MySQL. God damn I did not find your link before. Sounds great and instantly testing this awesome stuff thanks =) Am Donnerstag, 14. August 2014 13:34:57 UTC+2 schrieb Lvc@: Hi Curtis, unfortunately that syntax was a proposal, but in the wiki seems has been removed the fundamental word proposal. If you want to import something in OrientDB the easier way is using the ETL: just one JSON for configuration and that's all. What's your source? A RDBMS? https://github.com/orientechnologies/orientdb- etl/wiki/Import-from-DBMS Lvc@ On 14 August 2014 13:05, 'Curtis Mosters' via OrientDB orient-...@googlegroups.com wrote: Hi, just found it here: https://github.com/ orientechnologies/orientdb/wiki/Import-RDBMS-to-Graph-Model Scroll a bit down. Mine is just copied from there. To your link: I want to import a 100 gb database into OrientDB, I don't think that the SQL Batch is the thing I'm looking for? Am Donnerstag, 14. August 2014 11:12:42 UTC+2 schrieb Enrico Risa: Hi Curtis where did you find this syntax? *CREATE EDGE E TRANSFORM comment.postId TO **post.id http://post.id* *INVERSE* I do not see it in the documentation. You could use SQL Batch for your case https://github.com/orientechnologies/orientdb/wiki/SQL-batch 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB orient-...@googlegroups.com: Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- 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 orient-databa...@googlegroups.com. For more options, visit
Re: [orientdb] Re: Problems with first steps in using graphs (performance)
New thread for this problem: https://groups.google.com/forum/#!topic/orient-database/JbMrhqSGXGM Am Freitag, 15. August 2014 21:16:27 UTC+2 schrieb Curtis Mosters: Sorry it was a mistake of the phpmyadmin database. Created a db test and tested it there, here it works well: D:\Eclipse LaTeX\DB - orientdb\binoetl.bat config-test.json OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com BEGIN ETL PROCESSOR END ETL PROCESSOR + extracted 1 records (0 records/sec) - 1 records - loaded 0 documents (0 docum ents/sec) Total time: 24ms [0 warnings, 0 errors] But now comes another problem. My class is not filled with the entry from the MySQL db. How it comes? Am Freitag, 15. August 2014 20:59:00 UTC+2 schrieb Curtis Mosters: Alright, got oetl to run with: - Clone the repository on your computer, by executing: - git clone https://github.com/orientechnologies/orientdb-etl.git - Compile the module, by executing: - mvn clean install - Copy script/oetl.sh (or .bat under Windows) to $ORIENTDB_HOME/bin - Copy target/orientdb-etl-2.0-SNAPSHOT.jar to $ORIENTDB_HOME/lib and my json looks like: { config: { verbose: true }, extractor : { jdbc: { driver: com.mysql.jdbc.Driver, url: jdbc:mysql://localhost/phpmyadmin, userName: root, userPassword: , query: select * from pma_recent } }, transformers : [ { vertex: { class: Test} } ], loader : { orientdb: { dbURL: plocal:127.0.0.1/Test, dbAutoCreate: true } } } But here I get: D:\Eclipse LaTeX\DB - orientdb\binoetl.bat config-test.json OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com BEGIN ETL PROCESSOR Exception in thread main java.lang.NullPointerException at com.orientechnologies.orient.etl.transformer. OVertexTransformer.execu teTransform(OVertexTransformer.java:57) at com.orientechnologies.orient.etl.transformer. OAbstractTransformer.tra nsform(OAbstractTransformer.java:37) at com.orientechnologies.orient.etl.OETLPipeline.execute( OETLPipeline.ja va:97) at com.orientechnologies.orient.etl.OETLProcessor. executeSequentially(OE TLProcessor.java:459) at com.orientechnologies.orient.etl.OETLProcessor.execute( OETLProcessor. java:253) at com.orientechnologies.orient.etl.OETLProcessor.main( OETLProcessor.jav a:221) - Table exists - DB access is successful - OrientDB url should also be fine (but I always use *connect remote:127.0.0.1/Test http://127.0.0.1/Test root root* to connect and do anything else in the database) What is my problem/how to solve this? Am Donnerstag, 14. August 2014 18:45:21 UTC+2 schrieb Lvc@: Hi Curtis, What's the problem? You cannot start it, you have errors on connection, or what? About the config file you can put it everywhere and then call the etl as: oetl.sh your-config-file Lvc@ On 14 August 2014 14:48, 'Curtis Mosters' via OrientDB orient-...@googlegroups.com wrote: I don't get it to work. Also searched for some more information already. I included the JDBC driver https://code.google.com/p/find-ur-pal/downloads/detail?name=mysql-connector-java-5.1.18-bin.jar; into the lib folder. But where shall I put the config now? Am Donnerstag, 14. August 2014 14:03:13 UTC+2 schrieb Curtis Mosters: Hey Luca, yeah it's just MySQL. God damn I did not find your link before. Sounds great and instantly testing this awesome stuff thanks =) Am Donnerstag, 14. August 2014 13:34:57 UTC+2 schrieb Lvc@: Hi Curtis, unfortunately that syntax was a proposal, but in the wiki seems has been removed the fundamental word proposal. If you want to import something in OrientDB the easier way is using the ETL: just one JSON for configuration and that's all. What's your source? A RDBMS? https://github.com/orientechnologies/orientdb- etl/wiki/Import-from-DBMS Lvc@ On 14 August 2014 13:05, 'Curtis Mosters' via OrientDB orient-...@googlegroups.com wrote: Hi, just found it here: https://github.com/ orientechnologies/orientdb/wiki/Import-RDBMS-to-Graph-Model Scroll a bit down. Mine is just copied from there. To your link: I want to import a 100 gb database into OrientDB, I don't think that the SQL Batch is the thing I'm looking for? Am Donnerstag, 14. August 2014 11:12:42 UTC+2 schrieb Enrico Risa: Hi Curtis where did you find this syntax? *CREATE EDGE E TRANSFORM comment.postId TO **post.id http://post.id* *INVERSE* I do not see it in the documentation. You could use SQL Batch for your case https://github.com/orientechnologies/orientdb/wiki/SQL-batch 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB orient-...@googlegroups.com: Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- You received this message because you are subscribed to the Google Groups OrientDB
[orientdb] Re: Problems with first steps in using graphs (performance)
Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Re: Problems with first steps in using graphs (performance)
Hi Curtis where did you find this syntax? *CREATE EDGE E TRANSFORM comment.postId TO **post.id http://post.id* *INVERSE* I do not see it in the documentation. You could use SQL Batch for your case https://github.com/orientechnologies/orientdb/wiki/SQL-batch 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB orient-database@googlegroups.com: Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Re: Problems with first steps in using graphs (performance)
Hi, just found it here: https://github.com/orientechnologies/orientdb/wiki/Import-RDBMS-to-Graph-Model Scroll a bit down. Mine is just copied from there. To your link: I want to import a 100 gb database into OrientDB, I don't think that the SQL Batch is the thing I'm looking for? Am Donnerstag, 14. August 2014 11:12:42 UTC+2 schrieb Enrico Risa: Hi Curtis where did you find this syntax? *CREATE EDGE E TRANSFORM comment.postId TO **post.id http://post.id* *INVERSE* I do not see it in the documentation. You could use SQL Batch for your case https://github.com/orientechnologies/orientdb/wiki/SQL-batch 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB orient-...@googlegroups.com javascript:: Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- 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 orient-databa...@googlegroups.com javascript:. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Re: Problems with first steps in using graphs (performance)
Hi Curtis, unfortunately that syntax was a proposal, but in the wiki seems has been removed the fundamental word proposal. If you want to import something in OrientDB the easier way is using the ETL: just one JSON for configuration and that's all. What's your source? A RDBMS? https://github.com/orientechnologies/orientdb-etl/wiki/Import-from-DBMS Lvc@ On 14 August 2014 13:05, 'Curtis Mosters' via OrientDB orient-database@googlegroups.com wrote: Hi, just found it here: https://github.com/orientechnologies/orientdb/wiki/Import-RDBMS-to-Graph-Model Scroll a bit down. Mine is just copied from there. To your link: I want to import a 100 gb database into OrientDB, I don't think that the SQL Batch is the thing I'm looking for? Am Donnerstag, 14. August 2014 11:12:42 UTC+2 schrieb Enrico Risa: Hi Curtis where did you find this syntax? *CREATE EDGE E TRANSFORM comment.postId TO **post.id http://post.id* *INVERSE* I do not see it in the documentation. You could use SQL Batch for your case https://github.com/orientechnologies/orientdb/wiki/SQL-batch 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB orient-...@googlegroups.com: Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- 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 orient-databa...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Re: Problems with first steps in using graphs (performance)
Hey Luca, yeah it's just MySQL. God damn I did not find your link before. Sounds great and instantly testing this awesome stuff thanks =) Am Donnerstag, 14. August 2014 13:34:57 UTC+2 schrieb Lvc@: Hi Curtis, unfortunately that syntax was a proposal, but in the wiki seems has been removed the fundamental word proposal. If you want to import something in OrientDB the easier way is using the ETL: just one JSON for configuration and that's all. What's your source? A RDBMS? https://github.com/orientechnologies/orientdb-etl/wiki/Import-from-DBMS Lvc@ On 14 August 2014 13:05, 'Curtis Mosters' via OrientDB orient-...@googlegroups.com javascript: wrote: Hi, just found it here: https://github.com/orientechnologies/orientdb/wiki/Import-RDBMS-to-Graph-Model Scroll a bit down. Mine is just copied from there. To your link: I want to import a 100 gb database into OrientDB, I don't think that the SQL Batch is the thing I'm looking for? Am Donnerstag, 14. August 2014 11:12:42 UTC+2 schrieb Enrico Risa: Hi Curtis where did you find this syntax? *CREATE EDGE E TRANSFORM comment.postId TO **post.id http://post.id* *INVERSE* I do not see it in the documentation. You could use SQL Batch for your case https://github.com/orientechnologies/orientdb/wiki/SQL-batch 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB orient-...@googlegroups.com: Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- 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 orient-databa...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-databa...@googlegroups.com javascript:. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
Re: [orientdb] Re: Problems with first steps in using graphs (performance)
I don't get it to work. Also searched for some more information already. I included the JDBC driver https://code.google.com/p/find-ur-pal/downloads/detail?name=mysql-connector-java-5.1.18-bin.jar; into the lib folder. But where shall I put the config now? Am Donnerstag, 14. August 2014 14:03:13 UTC+2 schrieb Curtis Mosters: Hey Luca, yeah it's just MySQL. God damn I did not find your link before. Sounds great and instantly testing this awesome stuff thanks =) Am Donnerstag, 14. August 2014 13:34:57 UTC+2 schrieb Lvc@: Hi Curtis, unfortunately that syntax was a proposal, but in the wiki seems has been removed the fundamental word proposal. If you want to import something in OrientDB the easier way is using the ETL: just one JSON for configuration and that's all. What's your source? A RDBMS? https://github.com/orientechnologies/orientdb-etl/wiki/Import-from-DBMS Lvc@ On 14 August 2014 13:05, 'Curtis Mosters' via OrientDB orient-...@googlegroups.com wrote: Hi, just found it here: https://github.com/orientechnologies/orientdb/wiki/Import-RDBMS-to-Graph-Model Scroll a bit down. Mine is just copied from there. To your link: I want to import a 100 gb database into OrientDB, I don't think that the SQL Batch is the thing I'm looking for? Am Donnerstag, 14. August 2014 11:12:42 UTC+2 schrieb Enrico Risa: Hi Curtis where did you find this syntax? *CREATE EDGE E TRANSFORM comment.postId TO **post.id http://post.id* *INVERSE* I do not see it in the documentation. You could use SQL Batch for your case https://github.com/orientechnologies/orientdb/wiki/SQL-batch 2014-08-14 9:10 GMT+02:00 'Curtis Mosters' via OrientDB orient-...@googlegroups.com: Hey guys I really need some help here. Shall I ask maybe somewhere else? -- --- 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 orient-databa...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-databa...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- --- 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 orient-database+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.