Re: [orientdb] Re: list() function in distributed mode

2015-04-20 Thread Luigi Dell'Aquila
Hi, no, it's not the expected behavior, query execution is supposed to return the same results in single node and in distributed. Could you please open an issue and (if you can) provide a simple test case? Thanks 2015-04-17 11:41 GMT+02:00 ccasen...@axway.com: Anyone to help ? -- ---

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
much *F*aster of course, not *m*aster... 2015-04-21 17:10 GMT+02:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Ok, I saw the remote only now. If you want to go much master you should use plocal (this avoids network overhead). If you need other clients to connect to the db in remote mode

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
Hi Sven, how are you connected to the db (remote or plocal)? Could you post the details of your db schema, in terms of classes, properties and index definitions? Thanks Luigi 2015-04-21 17:03 GMT+02:00 Sven Hodapp sven.hod...@gmail.com: Hi together, for my project I want to import a lot

Re: [orientdb] De-duplication is very slow?

2015-04-21 Thread Luigi Dell'Aquila
Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Sven, how are you connected to the db (remote or plocal)? Could you post the details of your db schema, in terms of classes, properties and index definitions? Thanks Luigi 2015-04-21 17:03 GMT+02:00 Sven Hodapp sven.hod...@gmail.com

Re: [orientdb] How to speed up queries

2015-04-21 Thread Luigi Dell'Aquila
Hi cr0xfyre, how are you measuring these times? Are you reading the query EXPLAIN? I ask because this could be just the time Studio takes to render the results, a query like this should take a few tens milliseconds to execute. Luigi 2015-04-21 13:01 GMT+02:00 cr0xfyre achi...@gmail.com: Hi

Re: [orientdb] DB created on console not visible in studio

2015-04-24 Thread Luigi Dell'Aquila
Hi, do you still have console connected to the db in plocal while you try to access the db via studio? This could be a reason (a database can be open locally only by a single OrientDB instance, while you can access remotely from as many clients as you want). Could you please also check that the

Re: [orientdb] sql command parsing issue with space

2015-04-24 Thread Luigi Dell'Aquila
: com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on parsing command at position #47: Invalid keyword '0' Command: select $x from A let $x = out() where $x.size()0 let me know if I can help with some other tests or verifications. On Thursday, April 23, 2015 at 3:11:13 PM UTC+3, Luigi Dell'Aquila wrote: Hi Adrian

Re: [orientdb] Conditional traverse

2015-04-24 Thread Luigi Dell'Aquila
behaviour. I can try to replicate the behaviour with a synthetic network created using pyorient that I can share later. Regards, j. On Thursday, April 23, 2015 at 3:01:27 PM UTC+3, Luigi Dell'Aquila wrote: Hi Jani, could you provide a simple test case (eg. the exported db)? The problem

Re: [orientdb] How to speed up queries

2015-04-24 Thread Luigi Dell'Aquila
UTC+1, Luigi Dell'Aquila wrote: Hi cr0xfyre, how are you measuring these times? Are you reading the query EXPLAIN? I ask because this could be just the time Studio takes to render the results, a query like this should take a few tens milliseconds to execute. Luigi 2015-04-21 13:01 GMT+02

Re: [orientdb] How do I efficiently search for data whose schema is not known in advance

2015-04-24 Thread Luigi Dell'Aquila
Hi Mukta take a look at this http://orientdb.com/docs/last/Indexes.html https://groups.google.com/forum/#!msg/orient-database/OlIJygtDcHw/-1KKDEAQ5qUJ I think it's what you are looking for. The first one is the official documentation page, there is also an example on how to create and query an

Re: [orientdb] Do named parameters work with UPDATE ADD

2015-04-26 Thread Luigi Dell'Aquila
Hi Michael, which OrientDB version are you using? Support for named parameters is limited in v 2.0.x but in 2.1 (rc1 was already released) it is supposed to work well Luigi 2015-04-26 19:47 GMT+02:00 Michael MacFadden michael.macfad...@gmail.com: I have a case where I am adding an element to

Re: [orientdb] Server side functions

2015-04-22 Thread Luigi Dell'Aquila
Hi Diaa, if you are implementing your functions in Javascript you can refer to this http://orientdb.com/docs/last/Functions.html To implement functions in Java, instead, you have to implement OSQLFunction interface and register functions in the database using

Re: [orientdb] sql command parsing issue with space

2015-04-23 Thread Luigi Dell'Aquila
Hi Adrian, v 2.0 suffers from a lot of these problems with the SQL parser. In 2.1 we rewrote it from scratch, so all these problems will be fixed in that release. RC1 is already available and final release will be ready in a few weeks. Regards Luigi 2015-04-23 14:03 GMT+02:00 Adrian Mihalcea

Re: [orientdb] De-duplication is very slow?

2015-04-22 Thread Luigi Dell'Aquila
the less, it should be possible to do such transactions also on remote. So that it is possible for multiple worker to upload data to the database. Any ideas how to make this faster? Regards, Sven Am Dienstag, 21. April 2015 17:11:19 UTC+2 schrieb Luigi Dell'Aquila: much *F*aster of course

Re: [orientdb] Re: Performance issue when enabled SSL in DigitalOcean cloud

2015-04-28 Thread Luigi Dell'Aquila
Hi Kamen, is this problem only related to DigitalCloud service or you can also reproduce it on a local server? I will try it on my local instances in next hours and I'll let you know. Thanks Luigi 2015-04-26 14:14 GMT+02:00 Kamen Ivanov kamenivanov1...@gmail.com: I've debugged it and saw

Re: [orientdb] How to speed up queries

2015-04-29 Thread Luigi Dell'Aquila
, 24 April 2015 09:58:44 UTC+1, Luigi Dell'Aquila wrote: Hi, sorry for late answer, could you try an EXPLAIN? Just explain select * from Leaf it will give you more accurate information about query execution time and execution plan Thanks Luigi 2015-04-23 17:57 GMT+02:00 cr0xfyre

Re: [orientdb] Re: Performance issue when enabled SSL in DigitalOcean cloud

2015-04-28 Thread Luigi Dell'Aquila
Hi Kamen, thank you, this is an important information. I created an issue on GitHub about this, so that we can track it better https://github.com/orientechnologies/orientdb/issues/4048 Luigi 2015-04-28 14:14 GMT+02:00 Kamen Ivanov kamenivanov1...@gmail.com: Hi Luigi, I was unable to

Re: [orientdb] Re: want to know about workbanch .

2015-04-30 Thread Luigi Dell'Aquila
Hi Mahesh, Workbench is a separate application that can control multiple servers and manage their configuration. It can also control in-memory instances Luigi 2015-04-30 8:23 GMT+02:00 Mahesh Wabale maheshd7...@gmail.com: That means workbench is only for enterprse edition . Can we use

Re: [orientdb] Is there a way to save your javascript server side functions elsewhere? Export functions feature?

2015-04-30 Thread Luigi Dell'Aquila
Hi Jordan, you could export them in json, as you can see here http://orientdb.com/docs/last/Console-Command-Export.html you can also export a single class (OFunction in this case) Luigi 2015-04-30 13:24 GMT+02:00 Jordan Osier osier@gmail.com: I would really like to save my javascript

Re: [orientdb] Maybe A method to select in and out vertex from edge wil be useful some cases ...

2015-04-27 Thread Luigi Dell'Aquila
Hi, there is a bothV() method for this, but it seems to be broken, I'm verifying it right now Thanks Luigi 2015-04-27 2:25 GMT+02:00 Saltık Buğra Avcı buzzyst...@gmail.com: Here are graph example logics..

Re: [orientdb] Maybe A method to select in and out vertex from edge wil be useful some cases ...

2015-04-27 Thread Luigi Dell'Aquila
Hi, fixed in 2.0.x and develop branches, thank you very much for reporting Luigi 2015-04-27 9:36 GMT+02:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi, there is a bothV() method for this, but it seems to be broken, I'm verifying it right now Thanks Luigi 2015-04-27 2:25 GMT+02

Re: [orientdb] UNWIND/UNNEST with OrientDB

2015-04-27 Thread Luigi Dell'Aquila
Hi Mahmood, in OrientDB v 2.1 and UNWIND operator will be available (it will be officially released in RC2, but you can try it now just building from sources, develop branch). The syntax is this SELECT f1, f2, f3 from Foo UNWIND f2 Regards Luigi 2015-04-27 2:58 GMT+02:00 retrography

Re: [orientdb] How to speed up queries

2015-04-29 Thread Luigi Dell'Aquila
no, it's in milliseconds ;-) 2015-04-29 13:42 GMT+02:00 cr0xfyre achi...@gmail.com: But it can't be in seconds right? It didn't took 51 seconds for me to see the result of this query... On Wednesday, 29 April 2015 12:32:09 UTC+1, Luigi Dell'Aquila wrote: yes, exactly. What you see

Re: [orientdb] want to know about workbanch .

2015-04-29 Thread Luigi Dell'Aquila
Hi Mahesh, Workbench is a component of OrientDB Enterprise, you can download it from here http://orientdb.com/orientdb-enterprise/ It's a commercial tool, but it's free for development Luigi 2015-04-29 15:52 GMT+02:00 Mahesh Wabale maheshd7...@gmail.com: Hi everyone , I dont have any idia

Re: [orientdb] Re: want to know about workbanch .

2015-04-29 Thread Luigi Dell'Aquila
Hi Johan, actually the application you are referring to is called OrientDB Studio ;-) Workbench is another tool, that is intended to manage enterprise features, like monitoring, configured alerts, hot changes on distributed configuration and so on. Workbench is not available in the community

Re: [orientdb] Insert Document without using SQL via JavaScript API

2015-05-07 Thread Luigi Dell'Aquila
Hi Omega, where are you executing this javascript code? Is it in a web page, in Node.js or inside OrientDB (eg. an OFunction)? 2015-05-07 5:59 GMT+02:00 Omega Silva omegasi...@gmail.com: Hi all, The Java API facilitates creating documents in the following style; ODocument newEmployee =

Re: [orientdb] Using SELECT WHERE IN (sub query)

2015-05-07 Thread Luigi Dell'Aquila
Hi Omega, could you please try with expand() function? SELECT FROM A WHERE externalId IN (SELECT expand(list(externalId)) FROM B) this should fix the problem Luigi 2015-05-07 9:43 GMT+02:00 Omega Silva omegasi...@gmail.com: Hi All, I'm working with a document db where I have two classes

Re: [orientdb] Parse error for SQL UPDATE on 2.1-rc2 for EMBEDDEDMAP

2015-05-08 Thread Luigi Dell'Aquila
Hi Michael, I just created an issue about this, you can track here https://github.com/orientechnologies/orientdb/issues/4109 This problem is flagged as high priority, so it will be quickly addressed Luigi 2015-05-08 0:37 GMT+02:00 Michael MacFadden michael.macfad...@gmail.com: We are

Re: [orientdb] How to use Disk cache

2015-05-05 Thread Luigi Dell'Aquila
Hi Mahesh, you can change the storage.diskCache.bufferSize parameter, here you will find all the information about that http://orientdb.com/docs/last/Performance-Tuning.html Thanks Luigi 2015-05-05 14:55 GMT+02:00 Mahesh Wabale maheshd7...@gmail.com: Hello every one , If i have 16 gb ram

Re: [orientdb] Help with a Simple SELECT Query

2015-05-08 Thread Luigi Dell'Aquila
Hi Khaled, in OrientDB 2.0.x you can just do select userID, out(Likes).movieID from User but you will obtain userID |movieID 1 | [2, 10] 2 | 5 In OrientDB 2.1 there is a new function called UNWIND that will give you exactly

Re: [orientdb] Graphi API and LINKLISTs

2015-05-11 Thread Luigi Dell'Aquila
Hi Scott a link is a unidirectional reference, so it cannot be used for backward traversal. If you need bi-directional traversal you have two alternatives: - create and maintain two links (from A to B and from B to A) - use edges (Graph API) Just consider that: - an edge, under the hood, is

Re: [orientdb] Parse error for SQL UPDATE on 2.1-rc2 for EMBEDDEDMAP

2015-05-12 Thread Luigi Dell'Aquila
MacFadden michael.macfad...@gmail.com: Thanks for the quick response. For issues like this, does the team prefer a post to the google group or an issue to be created in github? ~Michael On Friday, May 8, 2015 at 12:05:27 AM UTC-7, Luigi Dell'Aquila wrote: Hi Michael, I just created an issue

Re: [orientdb] Re: [2.1-rc2] Problem with orient.getGraph() in javascript function.

2015-05-14 Thread Luigi Dell'Aquila
Hi guys, it's a regression, I fixed it yesterday and I'll push it to develop branch in short Luigi 2015-05-13 7:24 GMT+02:00 retrography mahm...@gmail.com: No, that is not your mistake. I have the exact same issue here with a function that used to work on 2.0.8. Either API has changed and

Re: [orientdb] orientdb warn message for authentication

2015-05-14 Thread Luigi Dell'Aquila
Hi Martin, IMHO it's wrongly flagged as a warning. That message just states that you have (default) plugins installed to run SQL queries and Javascript functions in the db. Luigi 2015-05-13 6:10 GMT+02:00 Martin gan mgg8...@gmail.com: anyone who have any idea how to solve the following

Re: [orientdb] Graph limits

2015-05-14 Thread Luigi Dell'Aquila
Hi Fabio, OrientDB limitations are listed here http://orientdb.com/docs/last/Limits.html I think they will perfectly fit all your needs ;-) Luigi 2015-05-14 10:44 GMT+02:00 Fabio Ricci fabio.fr.ri...@gmail.com: Hi all is there a limit in loading RDF statements into the orientDB graph?

Re: [orientdb] Graph Api Async Query null pointer exception

2015-05-18 Thread Luigi Dell'Aquila
Hi, could you provide a simple test case for this? Thanks Luigi 2015-05-14 22:35 GMT+02:00 Saltık Buğra Avcı buzzyst...@gmail.com: OrientGraph graph = factory.getTx(); ListObject dataList = new LinkedList(); graph.command( new OSQLAsynchQueryOrientVertex(select from

Re: [orientdb] Insert Document without using SQL via JavaScript API

2015-05-18 Thread Luigi Dell'Aquila
(OFunction). On Thursday, May 7, 2015 at 2:43:43 PM UTC+5:30, Luigi Dell'Aquila wrote: Hi Omega, where are you executing this javascript code? Is it in a web page, in Node.js or inside OrientDB (eg. an OFunction)? 2015-05-07 5:59 GMT+02:00 Omega Silva omega...@gmail.com: Hi all, The Java

Re: [orientdb] Using local orientdb database inside studio ?

2015-05-18 Thread Luigi Dell'Aquila
Hi Fabio, you have two choices: 1) if you want to keep on working in embedded mode you have to start a full server from your application ( http://orientdb.com/docs/last/Embedded-Server.html) 2) if you have finished with embedded mode and you want to start running client-server you can just copy

Re: [orientdb] Scaling graph loading when very little space left?

2015-05-18 Thread Luigi Dell'Aquila
Hi Fabio, the easiest thing you can do is add one or more hard drives and spread your cluster files on them (if you are on Linux you can just move them from databases/yourDb folder and create symbolic links). Of course if you need scaling also on read/write operation rate you have to think about

Re: [orientdb] Would you like to share some SQL statements to test compatibility between AlaSQL and OrientDB?

2015-05-18 Thread Luigi Dell'Aquila
much! You can paste SQLs below or directly to Github issue https://github.com/agershun/alasql/issues/194. Personally, I would like learn more about Time series and Chase in Luigi Dell'Aquila http://www.slideshare.net/LuigiDellAquila/orientdb-time-representation's slides http

Re: [orientdb] How delete list of selected edges with sql?

2015-05-19 Thread Luigi Dell'Aquila
Hi Oles, how do you select them? With a query? If it's the case, you can just use a DELETE EDGE around it, eg. DELETE EDGE FROM (SELECT outE(MyEdgeClass) FROM MyVertexClass) Luigi 2015-05-18 17:41 GMT+02:00 Oles Berezhetsky llole...@gmail.com: How delete list of selected edges with sql?

Re: [orientdb] getting an error while starting workbench

2015-05-13 Thread Luigi Dell'Aquila
Hi Mahesh, could you just post all the logs you see in the console? Thanks Luigi 2015-05-11 12:26 GMT+02:00 Mahesh Wabale maheshd7...@gmail.com: Hi Enrico , Thanks for reply , I have not any idea about startup stacktrace . Please tell me How to see stacktrace ? So i can send you this

Re: [orientdb] Problem with traverse vertice sample in Document ?

2015-05-18 Thread Luigi Dell'Aquila
Hi, attribute names are case sensitive, try with *SELECT name FROM...* Regards Luigi 2015-05-14 12:13 GMT+02:00 Tu Pham Phuong pham...@gmail.com: Hi guys, I am a newbie with OrientDB, my OrientDB is 2.0.8. At this post:

Re: [orientdb] orientdb warn message for authentication

2015-05-18 Thread Luigi Dell'Aquila
Yes, you can live with it without any problems ;-) Luigi 2015-05-14 15:53 GMT+02:00 Martin gan mgg8...@gmail.com: So, it means there is no harm for this? On Thursday, May 14, 2015 at 9:40:33 PM UTC+8, Luigi Dell'Aquila wrote: Hi Martin, IMHO it's wrongly flagged as a warning

Re: [orientdb] Re: Is $current not working with traverse?

2015-04-15 Thread Luigi Dell'Aquila
Hi Vitor, I'm looking at that (actually thanks to this I found a regression on 2.1-snapshot and I'm fixing it too). I'll give you a feedback ASAP Luigi 2015-04-14 21:08 GMT+02:00 Vitor Enes Duarte vitorenesdua...@gmail.com: Sorry to push this. Is this an issue or am I missing something?

Re: [orientdb] Graph API and Indices on Edge Properties

2015-04-15 Thread Luigi Dell'Aquila
Hi Stefano, this cannot work, because the document structure you have under the hood is this: (dataset vertex record) --(lives edge record)-- (collection vertex record) so the out_lives will not contain a collectionid, but one or more record ids of edges that then point to the collection. I

Re: [orientdb] Select if multiple paths are fullfilled

2015-04-15 Thread Luigi Dell'Aquila
Hi Patrick a way to do this is the following SELECT FROM (SELECT expand(out(Owns)) from #16:1) where out(Located) contains #17:0 another way is with the intersect, that is supposed to work... I see that at the beginning of main select there is a spare parenthesis, maybe that's the problem. If

Re: [orientdb] Is it possible to filter on multiple indexed properties in one query

2015-04-07 Thread Luigi Dell'Aquila
Hi, current query executor cannot handle multiple indexes for multiple AND clauses. To do this you have to use a simple trick: execute two subqueries with LET assignment and then use intersect() function. eg. select intersect($a, $b) let $a = (subquery1), $b = (subquery2) 2015-04-04 14:10

Re: [orientdb] InstantiationException when using traversedElement

2015-04-07 Thread Luigi Dell'Aquila
Hi Elliot, I noticed that in some cases traversedElement() acts in a strange way when used in outer queries (referring to inner query traversal). I'd like to go deeper into this, could you please: 1) try with select traversedElement(-2) ... and let me know what happens 2) post the full stack

Re: [orientdb] evaluating OrientDB

2015-04-07 Thread Luigi Dell'Aquila
Hi Mihai, This use case is typical for a graph database, so I think OrientDB is a perfect fit. You already have Dijkstra function, so you can use it or modify it to create your own custom logic. About connected subgraphs, you will be able to find what you need with very simple TRAVERSE queries

Re: [orientdb] Re: Get access to OrientDB through Matlab, possible?

2015-04-07 Thread Luigi Dell'Aquila
Hi Kun, MATLAB also supports HTTP/REST http://it.mathworks.com/help/matlab/ref/webread.html You can use it to query OrientDB http://www.orientechnologies.com/docs/last/OrientDB-REST.html Regards Luigi 2015-04-04 22:01 GMT+02:00 Mattox Beckman mattoxbeck...@gmail.com: Matlab seems to have a

Re: [orientdb] Getting an error while searching for a string containing a single quote from java

2015-04-07 Thread Luigi Dell'Aquila
Hi, which OrientDB version? Thanks Luigi 2015-04-06 14:24 GMT+02:00 Muley savi.mu...@gmail.com: HI, I'm trying to search for a string from java application.My search string is for ex : abc's and my search query is select * from ( select expand( out('ProfileMasterTagEdge') ) from

Re: [orientdb] In memory distributed graph database .

2015-04-07 Thread Luigi Dell'Aquila
Hi Mahesh, an embedded database has a physical representation of data in files (clusters) and a partial memory copy of them (disk cache). When you read data, if they are not in memory, cluster pages are loaded from files to disk cache. When you insert/update records, they are written in disk

Re: [orientdb] schema-less index support

2015-04-08 Thread Luigi Dell'Aquila
Hi Jeff, this functionality is not currently in our roadmap. You could open a feature request on OrientDB issue tracker, we will take it into consideration Regards Luigi 2015-04-07 19:44 GMT+02:00 jwcarp...@gmail.com: Hi, I don't believe it is currently possible in OrientDB to create

Re: [orientdb] Re: Getting an error while searching for a string containing a single quote from java

2015-04-08 Thread Luigi Dell'Aquila
Hi Muley, could you please try it with 2.1-SNAPSHOT or develop branch? I think it was fixed it this release. Luigi 2015-04-08 8:13 GMT+02:00 Muley savi.mu...@gmail.com: Hi, The problem is with single quote only. The same query is working properly for normal string searching full error

Re: [orientdb] Re: A taste of OrientDB 2.1

2015-05-20 Thread Luigi Dell'Aquila
+02:00 machak superh...@gmail.com: On Monday, February 16, 2015 at 10:54:10 AM UTC+1, Luigi Dell'Aquila wrote: Hi, OrientDB 2.0 was released just a few week ago, but we are already working hard to the next release. You know that two of the oldest pieces of code inside OrientDB core

Re: [orientdb] Re: How delete list of selected edges with sql?

2015-05-20 Thread Luigi Dell'Aquila
Hi Oles, I think I understood the problem: the DELETE EDGE is trying to remove all the edges that start FROM the result of your query (that FROM is being interpreted as the FROM/TO of the edge). You can try a work-around like DELETE EDGE YourEdgeClass where @rid in (SELECT

Re: [orientdb] Bug? - 'from' word in server-side function calls

2015-05-20 Thread Luigi Dell'Aquila
Hi cr0xfyre, which version? I remember I worked on this some time ago... Luigi 2015-05-20 13:03 GMT+02:00 cr0xfyre achi...@gmail.com: Hi everyone! I've found an annoying problem when using server-sided functions: Function *printText *is a server-side function that receives a text and

Re: [orientdb] Re: A taste of OrientDB 2.1

2015-05-20 Thread Luigi Dell'Aquila
Thank you very much for the details. I'll work on this soon and let you know Luigi 2015-05-20 15:38 GMT+02:00 machak superh...@gmail.com: On Wednesday, May 20, 2015 at 2:52:26 PM UTC+2, machak wrote: Hi Luigi, On Wednesday, May 20, 2015 at 9:24:59 AM UTC+2, Luigi Dell'Aquila wrote: Hi

Re: [orientdb] Time Series Last Node Link

2015-06-05 Thread Luigi Dell'Aquila
with graph api triggered by vertex creation? i think this is a common pattern thank you Il giorno mercoledì 3 giugno 2015 15:55:43 UTC+2, Luigi Dell'Aquila ha scritto: Hi Thomas, it depends on following factors: - do you need bi-directional traversal? In case an edge is better - do you

Re: [orientdb] A slow query

2015-06-05 Thread Luigi Dell'Aquila
Hi James, traverse in() from #12:0 does not only return John's friends, but also his friends of friends, friends of friends of friends and so on, maybe that's the problem. You could try replacing it with select in() from #12:0 Luigi 2015-06-04 10:06 GMT+02:00 James Wang jwang25...@gmail.com:

Re: [orientdb] Re: new document inside a transaction

2015-06-05 Thread Luigi Dell'Aquila
Hi Cristian, if you use Java API this is transparent, you can just create the document and connect it to the rest of your data, OrientDB will replace temporary RIDs with final values at commit time Luigi 2015-06-05 12:32 GMT+02:00 Cristian Lorenzetto cristian.lorenze...@gmail.com: I thought

Re: [orientdb] Re: What is the difference between plocal and remote ?!!!

2015-06-08 Thread Luigi Dell'Aquila
ops, sorry, I read it too fast :) There is no difference in terms of stored data structures. Distributed engine is just a layer on top of plocal, that hides all the replication logic Luigi 2015-06-08 19:11 GMT+02:00 Chaitanya chaitanya9...@gmail.com: Yes. I know that, plocal creates a

Re: [orientdb] Re: OrientDB Profiler

2015-06-06 Thread Luigi Dell'Aquila
Hi James, the profiler is an enterprise component, in the community edition there is a mock implementation that just returns null, so that is the expected behavior Luigi 2015-06-05 13:02 GMT+02:00 James Wang jwang25...@gmail.com: I could issue (in community edition): orientdb PROFILER ON

Re: [orientdb] Geo Spatial queries

2015-06-07 Thread Luigi Dell'Aquila
Hi Chaitanya, there is no built-in support for this kind of queries in OrientDB right now. It is in the roadmap for next release (2.2). For now you have to define your own functions to do this. Thanks Luigi 2015-06-08 6:44 GMT+02:00 Chaitanya chaitanya9...@gmail.com: Can any one provide

Re: [orientdb] Understanding the basic database types and how vertices and edges work

2015-06-07 Thread Luigi Dell'Aquila
Hi Scott, I definitely suggest you to go with Lucene. At this stage the potential of Lucene is not completely exploited in OrientDB, but this is one of our main focuses in the roadmap. Lucene does not have big requirements in terms of memory, but it has its own data files and their size depends

Re: [orientdb] Re: new document inside a transaction

2015-06-08 Thread Luigi Dell'Aquila
('A'); a.save(); ODocument b= db.load(b_id); b.field('a',a); b.save(); db.commit();- throws exception because b.field is saving a ORID with -1:10 Il giorno venerdì 5 giugno 2015 12:33:35 UTC+2, Luigi Dell'Aquila ha scritto: Hi Cristian, if you use Java API this is transparent, you

Re: [orientdb] Datetime fields in embedded records

2015-06-08 Thread Luigi Dell'Aquila
Hi Scott, answers below: 2015-06-06 11:07 GMT+02:00 scott molinari scottamolin...@googlemail.com: Hi, Someone just mentioned that datetime fields can't be worked on within a embedded document/ record in OrientDB. Is this true? I can't imagine it is. a datetime field is just a normal

Re: [orientdb] Re: OrientDB Profiler

2015-06-08 Thread Luigi Dell'Aquila
пользователь Luigi Dell'Aquila написал: Hi James, the profiler is an enterprise component, in the community edition there is a mock implementation that just returns null, so that is the expected behavior Luigi 2015-06-05 13:02 GMT+02:00 James Wang jwang...@gmail.com: I could issue (in community

Re: [orientdb] Trying to emulate a directory structure

2015-06-03 Thread Luigi Dell'Aquila
Hi David, I'm not sure I understood your problem... are you having problems in defining 1..N relationships with edges? If it's the case, you can just avoid to define schema for edge links and the graph engine will do the job for you. Eg. CREATE VERTEX Directory set name = 'ParentDir' #12:0

Re: [orientdb] addEdge() to a 'remote' vertex introduces OTransactionException?

2015-06-03 Thread Luigi Dell'Aquila
Hi Clark, yes, creating edges that involve different shards is supposed to work fine. Could you please open an issue and provide a simple test case? Thanks Luigi 2015-06-02 10:40 GMT+02:00 Clark Peng htc.clark.p...@gmail.com: Hi all, I'm having issue while using OrientVertex.addEdge()

Re: [orientdb] Re: OrientDB ETL tool

2015-06-03 Thread Luigi Dell'Aquila
Hi James, there is a lot of improvement in the roadmap of OETL, we know that right now it is not optimized. If you are doing a one-shot import I suggest you to go with embedded and after that start the server. If you need very high performance you should consider Java API or OGraphBatchInsert

Re: [orientdb] Time Series Last Node Link

2015-06-03 Thread Luigi Dell'Aquila
Hi Thomas, it depends on following factors: - do you need bi-directional traversal? In case an edge is better - do you plan to store information on the links? in case an edge is better; in case not, with linkset you will save some space and performance - do you plan to delete events? In case you

Re: [orientdb] Understanding the basic database types and how vertices and edges work

2015-06-04 Thread Luigi Dell'Aquila
Hi Scott, document and graph database types are just a legacy setting, right now this distinction does not make sense anymore. You can use a graph database as both a document and a graph one. Graph structures are based on document structures under the hood, so the efficiency in the traversal is

Re: [orientdb] Re: OrientDB ETL tool

2015-06-04 Thread Luigi Dell'Aquila
Hi James, no problem, your questions will be useful for many users ;-) If you need community suppor this is the best channel you can use. Thanks Luigi 2015-06-03 15:03 GMT+02:00 James Wang jwang25...@gmail.com: Just wanna to share: If run in stand alone (i.e. server.sh), I managed to

Re: [orientdb] Re: select all vertices with no incoming edges

2015-06-04 Thread Luigi Dell'Aquila
sorry, typo there ;-) select from V WHERE in().size() = 0 2015-06-04 12:19 GMT+02:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi David, you can also do this: select from V were in().size() = 0 2015-06-03 14:20 GMT+02:00 Giulia Brignoli giulia.brign...@gmail.com: Hi David, try

Re: [orientdb] Re: select all vertices with no incoming edges

2015-06-04 Thread Luigi Dell'Aquila
Hi David, you can also do this: select from V were in().size() = 0 2015-06-03 14:20 GMT+02:00 Giulia Brignoli giulia.brign...@gmail.com: Hi David, try this query: select from V where @rid not in (select expand(out()) from V) in this way you should find all the vertices that have no

Re: [orientdb] ODatabaseRecordThreadLocal.INSTANCE.get() for GraphDB

2015-06-09 Thread Luigi Dell'Aquila
Hi, yes, and it's much more readable: it's OrientGraph.getActiveGraph() 2015-06-07 3:59 GMT+02:00 loadedlux id.publicsp...@gmail.com: Greetings, Is there a call in the Graph API that is equivalent to ODatabaseRecordThreadLocal.INSTANCE.get()? We are trying to get the existing/active

Re: [orientdb] select from property

2015-06-22 Thread Luigi Dell'Aquila
Ciao Marco, could you please post your schema and the statements you used for the insert? All the three statements seem to be OK, so the problem must be somewhere else Thanks Luigi 2015-06-22 19:38 GMT+02:00 marco mdwalter computerecon...@gmail.com: Hi Sorry for my english! I'm new in

Re: [orientdb] Roadmap

2015-06-22 Thread Luigi Dell'Aquila
Hi Valeri, it is a consequence of how we mark fixes on GitHub. The big majority of issues on 2.1 GA was marked on releases 2.1 RC1-4, so they do not appear on 2.1 GA anymore. Don't worry, the 2.1 GA is not so far ;-) Anyway I agree with you, we should find a more consistent way to mark milestone

Re: [orientdb] Re: LET statement does not work in a basic scenario

2015-06-18 Thread Luigi Dell'Aquila
Hi, Do you have any constraints in using 1.7? I'd suggest to update to 2.0.10 and try it there Thanks Luigi 2015-06-18 17:22 GMT+02:00 Hung Tran tdhun...@gmail.com: Hi Giulia Brignoli, I don't know how to extract the schema only, but the schema is very simple. There is a Plan class with

Re: [orientdb] Can OrientDB handle hundreds of concurrent users

2015-06-18 Thread Luigi Dell'Aquila
Hi Steve, queries like that are very common, I'd say all of our customers use them on millions (sometimes billions) of records. Here you can see the list of some of our customers http://orientdb.com/customers/ (not all, the biggest ones often have NDAs with us, so we cannot publish their logo).

Re: [orientdb] OGraphBatchInsert (orientdb-community-2.0-SNAPSHOT)

2015-06-19 Thread Luigi Dell'Aquila
Hi Emin, the batch insert is very fast because it does a lot of operations in RAM and then flushes raw data to disk all together. The maximum value of vertex IDs counts a lot, because OrientDB will create (and in some cases destroy, during import process) as many records as that number, so if you

Re: [orientdb] OGraphBatchInsert (orientdb-community-2.0-SNAPSHOT)

2015-06-22 Thread Luigi Dell'Aquila
()); record.save(); doc.field(BLOB, record); properties.remove(BLOB); } This makes the bulk slower but not extremely slow. Does this look ok to you is there a better method? Grazie! Emin On Friday, June 19, 2015 at 12:24:50 PM UTC-4, Luigi Dell'Aquila

Re: [orientdb] Class not found exeption in turkish system

2015-06-22 Thread Luigi Dell'Aquila
Hi, there is already an open issue about this, you can track it from this URL https://github.com/orientechnologies/orientdb/issues/3878 Thanks Luigi 2015-06-20 12:00 GMT+02:00 umut toker umt.to...@gmail.com: Hi all, i am new in orientDb and i faced this problem. my steps like that;

Re: [orientdb] Re: Creating edge between non-vertex classes

2015-06-16 Thread Luigi Dell'Aquila
Hi Anthony, I agree with you, that statement should result in an error. Could you please open an issue about that? Thanks Luigi 2015-06-16 14:36 GMT+02:00 Anthony Hebig anthony.he...@gmail.com: In the topic Another question on basic concepts it is said that when using Graph API your

Re: [orientdb] Re: new document inside a transaction

2015-06-11 Thread Luigi Dell'Aquila
in github issues Il giorno martedì 9 giugno 2015 18:29:07 UTC+2, Cristian Lorenzetto ha scritto: i used 2.1.rc2 Il giorno lunedì 8 giugno 2015 08:00:03 UTC+2, Luigi Dell'Aquila ha scritto: Hi Cristian I forgot to ask, which OrientDB version are you using? 2.0.x does not support parameters

Re: [orientdb] Embed the Server

2015-06-11 Thread Luigi Dell'Aquila
Hi James, all you find in the community edition is released under Apache 2.0 license, so no worries, you can use it in your project ;-) Luigi 2015-06-10 13:28 GMT+02:00 James Wang jwang25...@gmail.com: Hi All, We need - orientdb-enterprise-**.jar Does it mean that this feature is

Re: [orientdb] Re: Index on RIDs

2015-06-11 Thread Luigi Dell'Aquila
Hi guys, I'd like to shed some light on this magic :-) a RID is made of two numbers (a short and a long, at this stage, but the first one will become a long too in next releases, it's in the radmap). Say the RID is #xxx:yyy xxx is the cluster ID, it identifies the cluster where the record is

Re: [orientdb] Help about ressources managment

2015-06-11 Thread Luigi Dell'Aquila
Hi Antoine, I suggest you to use the factory, it is much faster than manually acquiring connections. If you are doing only read operations OrientGraphNoTx is ok, just make sure that every actor has its own connection, the main constraint you have here is that OrientDB connections are not thread

Re: [orientdb] Re: A question on the overall concept of OrientDB

2015-06-15 Thread Luigi Dell'Aquila
Hi Scott, the term kept is not the one I'd use. If you think about data in an Object Oriented way, it's correct to say that all the graph entities in OrientDB are instances of V and E classes (but take into consideration that you can use document classes that do not extend E or V). This is like

Re: [orientdb] Question regarding RID

2015-06-17 Thread Luigi Dell'Aquila
Hi Scott, yes, of course, I wrote allows instead of avoids Thanks Luigi 2015-06-17 8:18 GMT+02:00 scott molinari scottamolin...@googlemail.com: In this way OrientDB allows conflicts in RID assignment Did you mean In this way OrientDB allows *no* conflicts in RID assignment. or

Re: [orientdb] Re: Create Edge Using Index Query

2015-06-16 Thread Luigi Dell'Aquila
Hi Scott, that kind of problem are you experiencing? Is it a parsing issue or is it at query execution time? If you had a stacktrace it would help a lot. Thanks Luigi 2015-06-16 21:58 GMT+02:00 Scott Orr prof@gmail.com: Oh, I should add that this is OrientDB 2.0.6--the version on Amazon

Re: [orientdb] Another question on basic concepts

2015-06-15 Thread Luigi Dell'Aquila
Hi Scott, the answer is yes, when using Graph API your elements have to be instances of V and E. If you work with may graph models, you have to create you own sub-classes and sub-hierarchies under V and E and then query your own classes. OrientDB v. 2.1 also supports multiple inheritance (a class

Re: [orientdb] Re: A question on the overall concept of OrientDB

2015-06-15 Thread Luigi Dell'Aquila
Hi Scott, yes, exactly, you can define your own class hierarchies in OrientDB. There is no need for a common superclass (like Object in Java), so two classes can not have a common superclass at all. V and E are just two conventional classes used for Graph representation Luigi 2015-06-15 8:52

Re: [orientdb] Re: How to embed a OrientDB server into a Java application

2015-06-15 Thread Luigi Dell'Aquila
Hi Mohammad, using a DB in embedded mode is slightly different than starting an embedded server. When you connect with plocal:/ url you just open a single DB from your local VM, but you do not actually start a server, eg. you do not open server ports (binary and HTTP, so other clients will not be

Re: [orientdb] Get the longest path in a graph

2015-06-15 Thread Luigi Dell'Aquila
Hi Luis, there is no such a function in OrientDB right now. If you are a Java developer you can take a look at these classes https://github.com/orientechnologies/orientdb/blob/develop/graphdb/src/main/java/com/orientechnologies/orient/graph/sql/functions/OSQLFunctionShortestPath.java

Re: [orientdb] Question regarding RID

2015-06-15 Thread Luigi Dell'Aquila
Hi Chaitanya, RIDs are unique even in distributed environment. If the same record is present in two different db nodes, then both copies of the record will have the same RID of course. OrientDB has a particular strategy to guarantee that RIDs are uniquely assigned in distributed mode: the

Re: [orientdb] join fields between vertex Person, edge Performs, vertex Task

2015-06-12 Thread Luigi Dell'Aquila
ah, I suggest you to define an index (NOTUNIQUE) on the score property, this query will become extremely fast Luigi 2015-06-12 18:43 GMT+02:00 Luigi Dell'Aquila luigi.dellaqu...@gmail.com: Hi Marteen, the easiest thing you can do is this: select outV().name as personName, inV().name

Re: [orientdb] join fields between vertex Person, edge Performs, vertex Task

2015-06-12 Thread Luigi Dell'Aquila
Hi Marteen, the easiest thing you can do is this: select outV().name as personName, inV().name as taskName, score from Performs order by score DESC Luigi 2015-06-12 18:16 GMT+02:00 Maarten Berkenbosch maar...@beebase.nl: How do I join person.name, performs.score, task.name into one query

<    1   2   3   4   5   6   7   >