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

Wow, that's easy :-) For those interested, I added a 'calculation' field using the functions part of Orientdb to get a score (x * y). I guess that's the way to go for calculated fields. (love it!) thanks for your fast reply, Luigi

[orientdb] Re: Issue with Adding Edge. OSerializationException

Hello, This issue has now been resolved. The problem was not the edges, it was actually an issue with an embedded list which was wrongly reported by my debugger as an issue with the edges. I have fixed the problem by converting into a list of vertices and embedding that. Thank you On Friday,

[orientdb] Re: Update en embedded list of string field by adding another string value

Hi, thank you for your replies, apparently this was a bug in the previous OrientDB community version 2.09 that I was using. Now, I have downloaded the latest community version 2.010 and tested again the same SQL command. It works, I presume the bug is fixed. On Friday, 12 June 2015 00:03:54 UTC

[orientdb] Re: HTTP-PUT on index - strange behaviour

Hi, don't know which language you use. Did some development with the REST-HTTP-Api using ruby recently ( https://github.com/topofocus/orientdb-rest ) Update...upsert did not work and due to the lack of documentation, I realized a much more comfortable solution. Instead of responding to an D

[orientdb] Re: distributed chat for orientdb

Actually, yes - HazelCast can also be accessed from Native Clients (Java , C++ , .NET

[orientdb] Re: distributed chat for orientdb

Can that be accessed over a non-Java API? Scott -- --- 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

[orientdb] Re: distributed chat for orientdb

> > I just wanted to add that apparently HazelCast also has IAtomicLong that > works as a distributed counter: > http://docs.hazelcast.org/docs/latest/manual/html/iatomiclong.html OrientDB even uses it once here: https://github.com/orientechnologies/orientdb/search?q=IAtomicLong -- --- Y

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

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 : > Hi Marteen, > > the easiest thing you can do is this: > > select outV().name as personName, inV().name as taskName, score from > P

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

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 : > How do I join person.name, performs.score, task.name into one query > result that displa

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

How do I join person.name, performs.score, task.name into one query result that displays the top 10 scores? Or should I assemble the list with multiple queries? (Vertex) Person.name (Edge) Performs.score (Vertex) Task.name -- --- You received this message because you are subscribed to the Goo

[orientdb] Re: A Hint for the IN-Operator needed

On Thursday, June 11, 2015 at 3:32:35 PM UTC+2, alessand...@gmail.com wrote: > > > In the field category 2 the are only the contracts from OpenInterest where > the fetch_date is 2015-06-02. > > Let me know if that is what you wanted. > > > > Hi, interesting: you came to the same solution, I fig

[orientdb] Re: case insensiti index

Yes, this is the behaviour I see. But, if I look in scheme: db.getMetadata().getSchema().getClass('Test').getProperty('foo').getCollate() There will be default collate. For me, it seems as an inconsistent state. That's why I'm asking what is expected behaviour (by design). Is it a bug or not.

[orientdb] Error creating edges when doing massive import and WAL disabled

I have the following: - OrientDB version 2.0.10 - Java application - creating a plocal database with OrientGraphNoTx - massive insert intent declared - WAL disabled The import runs fine until the code starts to create edges and then I get the following error: WAL mode is not active. Transaction

Re: [orientdb] Re: New benchmarks from Arango

I have a machine with 16GB RAM. Here are some numbers. I moved the shortest path test to the end for Orient because it won't run on 2.1rc3 due to a parsing bug and because it crashes 2.0.10. No connection pooling for Orient. Since the database doesn't fit in RAM, ArangoDB's numbers are not th

Re: [orientdb] Re: Index on RIDs

Luigi, Is the file with the 'directory' a candidate for caching within OrientDB or is that handled by the OS? On Thursday, June 11, 2015 at 10:57:42 PM UTC-7, Luigi Dell'Aquila wrote: > > Hi guys, > > I'd like to shed some light on this "magic" :-) > > a RID is made of two numbers (a short and

[orientdb] Re: HTTP-PUT on index - strange behaviour

hi Fadanner, you should create a unique constraint not only on IP, but both of ip that the new property "text", so is taken as a unique pair "ip-text" regards, Savio L. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this

[orientdb] Does the binary interface perform faster than the REST interface?

Hi, I would imagine it does, but I'd like to hear it from someone who has experience or the ODB team themselves. I'd like to know too, so I can move forward with our project and the right driver. Scott -- --- You received this message because you are subscribed to the Google Groups "Orien

[orientdb] HTTP-PUT on index - strange behaviour

Hi, i'm new to OrientDB and try to learn a bit more about it with a simple example project. For the project i use orientdb-enterprise-2.0.10. The project uses the http-api and is schema-hybrid. But now i'm in trouble with inserting into an class using the index method described in http://orientd

[orientdb] Re: How should time and spatial data be managed in OrientDB 2.0.10 ?

hi, Your problem is to use geospatial data or create the database from scratch ?? regards, Savio L. -- --- 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-da

[orientdb] Re: case insensiti index

Hi, I think that the property and the index are dependent. If you create a property foo not ci and you create an index ci when you run the query "select from Test where foo='test' you get both records with 'test' and 'Test' Regards, Alessandro -- --- You received this message because you are s

Re: [orientdb] Re: New benchmarks from Arango

Cool! I hope the results speak much better for OrientDB. I don't expect blowing the socks off of Arango, but I'd be happy with results comparable to Arango's. I'd also suggest you run the tests on your own too or maybe someone from the community could do it, just to validate the results as fact

[orientdb] case insensiti index

Hello, I want to understand the correlation between ci property and ci index. According to documentation ci property will lead to case insensitive comparation in sql: alter property Test.foo collate ci select from Test where foo = 'test' will select all 'test', 'Test' etc. Case insensitive in

[orientdb] Re: Orientdb graph database storing objects in vertices

Though it did not work, I figured out the solution. Serialization error will go only if the Json Object is converted to Json string before storing, and then retrieving the Json string and converting back to Json obejct. Thanks anyways. Cheers. On Monday, 8 June 2015 20:30:43 UTC+5:30, alessand

Re: [orientdb] Storing JSON objects in Java

I figured out the solution , the solution to storing JSON Object is as follows: I converted the Json object to json string. I stored the string in one of the vertex as its property. Then when i wanted the value, i got back the value from the vertex in the form of a string. Then i converted it

Re: [orientdb] Embed the Server

Thanks a lot . Great news On Friday, 12 June 2015 06:38:13 UTC+1, Luigi Dell'Aquila wrote: > > 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 >: >

[orientdb] Re: Issue with Adding Edge. OSerializationException

> > Hi, > the method getTags() is undefined for the type Object. Can you post all code ? Regards, Alessandro -- --- 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, se

[orientdb] Re: How should time and spatial data be managed in OrientDB 2.0.10 ?

Hi, which version are you using? the data you insert are names of location or latitude and longitude? Bye, Giulia -- --- 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 ema

Re: [orientdb] Re: New benchmarks from Arango

Hey guys, I wish somebody from ArangoDB asked for help on using OrientDB properly for such benchmark before posting results. But I can also understand a minor vendor tries to get attention in that way ;-) We had the chance to look at the code and it doesn't use OrientDB properly. We'll send a Pu