[orientdb] Group relations

2017-04-13 Thread nicolas treiber
Hi. I have a problem with a query which consumes a lot of memory. Let's imagine I have the following data : I have a Type class with two vertices: Vegetal, Animal I have a class Species: Tree, Flower, Firefox, Panda, Elephant A class Color: Brown, Yellow, Orange, White, Black, Green, Gray those

Re: [orientdb] Run OrientDB HA from Java

2017-04-13 Thread Luca Garulli
Hi Ray, Any errors in the logs? Can you post one of server's log? Best Regards, Luca Garulli Founder & CEO OrientDB LTD On 12 April 2017 at 20:28, Ray Neiheiser wrote: > I am trying o figure out how I can run OrientDB HA from java and then

Re: [orientdb] Limit on specific vertex of a match query

2017-04-13 Thread nicolas treiber
Is there no way to use use the MATCH command ? the thing is that i can end up with very complex queries (with multiple relations, with different depth) which can fast become unreadble with select Le jeudi 13 avril 2017 14:57:34 UTC+2, Luigi Dell'Aquila a écrit : > > Hi Nicolas, > > You can try

Re: [orientdb] Limit on specific vertex of a match query

2017-04-13 Thread Luigi Dell'Aquila
Hi Nicolas, You can try the following query: SELECT @rid as student, out("has") as mark from ( SELECT FROM Student ORDER BY avg_mark DESC LIMIT 3 ) UNWIND mark Thanks Luigi 2017-04-13 14:15 GMT+02:00 nicolas treiber : > Hi. > I'm pretty sure that what i want

Re: [orientdb] Get optional relationship data on match

2017-04-13 Thread Luigi Dell'Aquila
Hi Nicolas, The work-around for this is to use a SELECT as follows: SELECT parent, child, child.out("contains") as file FROM ( MATCH {class: Folder, as: parent}-parent_of->{class: Folder, as: child, optional: true} RETURN parent, child ) UNWIND file Thanks Luigi 2017-04-13 14:09

[orientdb] Where can I find the document or tutorial on latest release

2017-04-13 Thread Ayush Kumar
I am looking for some tutorial or documentation to know how to configure the config files available in the latest release. I tried the document on the website, but it is more related to usage of API and DB. -- --- You received this message because you are subscribed to the Google Groups

[orientdb] Limit on specific vertex of a match query

2017-04-13 Thread nicolas treiber
Hi. I'm pretty sure that what i want to do is not possible but maybe someone has a workaround (or it may give ideas to implement in future versions). Imagine you have a class Student with their average mark, and a class Mark. Every student a multiple marks. What I would like to do is get the

Re: [orientdb] Get optional relationship data on match

2017-04-13 Thread nicolas treiber
Thanks Luigi, that works. Also I have another question about optionals. Starting with the same example, let's say that Folders may contain Files and I want to get the files of the children folders (not the current folder (of course that's just an example, it's pretty useless because we would

[orientdb] Edge @rid on IN property of Vertex appears as document in stead of #xx:x on OrientJS transaction

2017-04-13 Thread Krishnaraj H
Hi, We are using OrientJS transaction mechanism in our coding to create vertex and edge. Currently facing an issue while creating edges. Sometimes, when we create edge e1 of sampleEdge from V1 to V2 edge rid (in_sampleEdge on V2) is loaded as