Re: [orientdb] ETL for professional import to OrientDB

2014-10-21 Thread Bojan Vukotić
This is my code (I didn't use actually Book and Author tables, I used my domain specific tables, but here I illustrated problem with these common names to make it easier to understand). This works, but my question is could this be done using just ETL without any coding. MapInteger,

Re: [orientdb] OGlobalConfiguration.CACHE_LOCAL_ENABLED

2014-10-21 Thread Andrey Lomakin
Hi, By design instance of document database should be treated as lightweight connection to database storage which adds data unmarshaling features, so it means that open/close should be lightweight operation. But now it is not true, we are going to change it, which means that open/close operation

Re: [orientdb] ETL for professional import to OrientDB

2014-10-21 Thread Bojan Vukotić
I tried to use ETL as described here http://www.orientechnologies.com/docs/last/orientdb-etl.wiki/Import-from-DBMS.html I used slightly modified approach (I don't know is it a correct one). I tried to import BookAuthor as vertex first (went fast and with no problems), than I tried to import

Re: [orientdb] Inserting a large file into OrientDB

2014-10-21 Thread NewUser
Hey Andrey just sent you the code I am posting it again since it only got sent privately it seems public class Test { static Sail sail; public void testAll(File f) throws Exception { KeyIndexableGraph og = new OrientGraphNoTx(plocal:server7/test, admin, admin); Sail sail =

Re: [orientdb] SQL query performance with OR in the WHERE clause

2014-10-21 Thread Luigi Dell'Aquila
Hi, what version of OrientDB are you using? We had two issues related to OR operators and index usage: https://github.com/orientechnologies/orientdb/issues/2898 https://github.com/orientechnologies/orientdb/issues/2893 and we fixed them some days ago. Could you try again on latest SNAPSHOT?

Re: [orientdb] Re: Repairing security structures ?

2014-10-21 Thread stefan
I will. Thank you On Monday, 20 October 2014 08:08:07 UTC, Andrey Lomakin wrote: Hi Stefan, It is fixed in 2.0-SNAPSHOT could you try ? On Sat, Oct 18, 2014 at 11:42 PM, ste...@activitystream.com javascript: wrote: btw. this is 2.M2 and embedded server becomes unresponsive. Currently

[orientdb] Multiple vertex objects referring to the same database record are not in sync

2014-10-21 Thread Emanuele Milani
Hi all! I am in the process of debugging an application based on OrientDB (2.0M2). The problem I am facing are some OConcurrentModificationException. The issue appears with both the memory and the plocal storage engines (I did not try remote). It looks they are caused by the fact that multiple

Re: [orientdb] Multiple vertex objects referring to the same database record are not in sync

2014-10-21 Thread Andrey Lomakin
Hi, Do you have local cache enabled ? It explicitly created to avoid such problems. On Tue, Oct 21, 2014 at 12:48 PM, Emanuele Milani milani.emanuele...@gmail.com wrote: Hi all! I am in the process of debugging an application based on OrientDB (2.0M2). The problem I am facing are some

Re: [orientdb] Multiple vertex objects referring to the same database record are not in sync

2014-10-21 Thread Andrey Lomakin
Hi I got reason of your issue, could you try 2.0-SNAPSHOT. Problem should be fixed there. On Tue, Oct 21, 2014 at 1:59 PM, Andrey Lomakin lomakin.and...@gmail.com wrote: Hi, Do you have local cache enabled ? It explicitly created to avoid such problems. On Tue, Oct 21, 2014 at 12:48 PM,

[orientdb] OCommandExecutorNotFoundException creating OrientDB database via jar file

2014-10-21 Thread 'Curtis Mosters' via OrientDB
We want to import data on a Linux system. So we have 2 Java files for the import. One (*OrientDBMain.java*) is for creating an object that is doing all the work. The other (*OrientDB.java*) contains all the database functions like setting an index and so on. The second files starts with:

Re: [orientdb] SQL query performance with OR in the WHERE clause

2014-10-21 Thread Kanak Agarwal
Hi Thanks for the response. I am seeing the issue in the OrientDB 2.0-M2 community edition. Is this the latest SNAPSHOT? On Tuesday, October 21, 2014 2:23:04 AM UTC-5, Luigi Dell'Aquila wrote: Hi, what version of OrientDB are you using? We had two issues related to OR operators and

[orientdb] Lucene in Neo4j has some misbehaviours in terms of reliable search querys - compared to OrientDB

2014-10-21 Thread 'Curtis Mosters' via OrientDB
I'm still in the evaluation of *Neo4j *vs. *OrientDB*. Most importantly I need Lucene as full-text index engine. So I created on both databases the same schema with the same data (300Mio lines). I'm also experienced with querying different things in both systems. I used the Standard Analyzer on

[orientdb] lucene spatial - import 1.7.4 db to 1.7.9 throws error

2014-10-21 Thread Jonathan Rosen
Here is an error that is thrown when I try to import the 1.7.4 db that has a spatial index to 1.7.9: - Index 'stores.latlong'...Error on database import happened just before line 0, column 1582755 com.orientechnologies.orient.core.index.OIndexException: Index type: SPATIAL is not supported.