[orientdb] Asynchronous Hooks and Server Functions

Hello, Is it possible to create an Asynchronous Hook for a particular class? My requirement is to invoke a function AFTER a new record is inserted without blocking the INSERT command. I tried the following code with some long operation inside HOOK_test function, but when i tried to insert wit

Re: [orientdb] Trouble using In-memory DB and distributed mode ..

> > > > On Monday, October 13, 2014 at 7:58:02 PM UTC+5:30, Lvc@ wrote: > > Hi, > In-Memory database + Distributed works only in 2.0. Please could you try > with 2.0-SNAPSHOT? > > Lvc@ > > ᐧ > > Hi luca , Are you talking about plocal database with cache . Is it correct ? I am confuse i

Re: [orientdb] How fast should OrientGraph.query() be?

Nick ... Much like you told the SQL engine to use an index (select * from INDEX:V.testProperty ...), you need to explicitly use indexes from the graph API, as follows: *Java:* OrientVertex result = g.getVertices( "V.testProperty", " cbc6b219-9df3-44c5-90b2-ab7a6bd9bf7e" ).iterator().next(); *G

[orientdb] Re: Questions about ODB

Ok. Been looking around Github and there is quite a lot of activity both from users and devs. That is good and answers my second question 2. It looks a bit chaotic though, which is I think an issue of a busy Github repo and not necessarily the management. So, maybe a better tracking system coul

[orientdb] Trying to emulate a directory structure

I'm hoping that someone can help recommend the correct configuration of classes to achieve this goal in OrientDB (running 2.1-rc3 at the moment). My interface is through the Java Graph API. I want to have a vertex that is a directory. I want to have multiple edge relationships between a directo

[orientdb] Re: CSV etl using oetl.sh keep throw "User or password not valid"

this is a bug, reported to github etl On Monday, June 1, 2015 at 5:39:11 PM UTC-4, Zhuo Bao wrote: > > version: 2.0.10 > function: csv etl > module: oetl.sh > problem: csv etl works before password change, but does not work after > system: centos 7, redhat > data: [openbeer] categories.csv + categ

[orientdb] Re: Complex query

I come up with a two steps solution, query first outgoing connection and then incoming, something like this select out.name, count from RELATED where in=<@rid> and select in.name, count from RELATED where out=<@rid> but this approach is very inconvenient, as it requires merging these two result

[orientdb] Traverse and retrieve edges

OrientDB noob, having trouble with traverse and can't see any answers. Lets say you have a vertex called 'Account' and a Edge called 'Link'. Account has just a 'name' property. Link has a link_quality property and in/out both reference the Account. I can successfully traverse an account, b

[orientdb] Complex query

Hi there, I need help with a query. My schema is pretty simple. Vertices are connected with Edges of type RELATED which have property count. 2 vertices can have connection in both ways at the same time. V1--RELATED(count=17)-->V2 V2--RELATED(count=3)-->V1 I need to build a query that for verte

[orientdb] possible to create a class extends from multiple classes?

when creating complicated objects (class), a logically plausible method is to create them from multiple classes: an event class is composed by: 1, datetime class 2, geolocation class 3, weather class 4, people class could this be possible in orientdb? -- --- You received this message bec

[orientdb] CSV etl using oetl.sh keep throw "User or password not valid"

version: 2.0.10 function: csv etl module: oetl.sh problem: csv etl works before password change, but does not work after system: centos 7, redhat data: [openbeer] categories.csv + categories.json (similiar with that in manual) components running: server (on), console (on/off) event trigger: chan

[orientdb] How fast should OrientGraph.query() be?

I have an orient db 2.0.10 community server up and running I have created a simple test where I have placed 300,000 vertices in an orient database each with a property "testProperty" with a value - UUID.randomUUID().toString I have created an index on the property graph.createKeyIndex("testPro

[orientdb] Re: Is it possible to specify class in WHERE clause?

Yes, it would be like this SELECT name FROM (SELECT OUT("Child") FROM Parent WHERE name = 'Parent-1') AS child WHERE @class='MyChild' On Monday, June 1, 2015 at 2:33:08 PM UTC-4, isobretatel wrote: > > Is it possible to specify class in WHERE clause? > I need the results to have instances of My

[orientdb] How do I run multiple queries in Studio?

I have many CREATE queries. How do I run multiple queries in Studio? -- --- 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.

[orientdb] Select distinct vertices according to edge filter

Hi, two small questions from an OrientDB beginner... I have a graph with one type of Vertices - "Person" - and one type of Edges - "Called". The graph describes phone conversations between people, with each edge having a "start_time" and "end_time" properties which describe the call's start a

[orientdb] Is it possible to specify class in WHERE clause?

Is it possible to specify class in WHERE clause? I need the results to have instances of MyChild class only: SELECT name FROM (SELECT OUT("Child") FROM Parent WHERE name = 'Parent-1') AS child WHERE child instanceof MyChild -- --- You received this message because you are subscribed to the G

[orientdb] Re: Questions about ODB

Ok, I've been looking around and this ODB limit answers the first #3 question. >- *Concurrency level*: in order to guarantee atomicity and >consistency, OrientDB acquire an exclusive lock on the storage during >transaction commit. This means transactions are serialized. Giving thi

[orientdb] First time OrientDB user regarding security in REST api

Hello Guys, I am new to OrientDB. I am going thorugh the REST apis and I am not able to understand the security of the apis. I dont have much experience with backend development (i am a front end developer) so please help me clarify some points here : - As I can see all the GET requests are op

[orientdb] Re: Recommender Engine

It didn't work. 0 item(s) found. It also took a very long time (9 seconds). On Monday, May 25, 2015 at 2:26:13 AM UTC-7, Giulia Brignoli wrote: > > Hi, > > Try this SQL query to see if it's the result you were looking for: > > select username, count(*) from (select expand(out("Friendship")) from

[orientdb] Re: Traverse all Vertecies without removing duplicates (orientdb-community-2.0)

Is there an example of the JS script function embedded in the SQL that you can point me too? Thank you! On Monday, June 1, 2015 at 8:58:04 AM UTC-4, Emin Agassi wrote: > > Hello All > I am traversing a Graph that has some common Vertices. When I execute > traverse, I only see one instance of the

[orientdb] Re: HowTo - Record Level Security with ODocument

I played with this for a couple more days and figured out how to get this working. Just in case anyone else wants to see it, I posted my answer on StackOverflow. OrientDB - How To - Record Level Security with ODocument

Re: [orientdb] Re: Traverse all Vertecies without removing duplicates (orientdb-community-2.0)

yes, Java Blueprints lets you manage this manually. As an alternative, you can define a Javascript function, based on your use case, and use it in your queries Luigi 2015-06-01 17:56 GMT+02:00 Emin Agassi : > Ok, thank you. > What alternatives do I have now since this feature is not supported b

[orientdb] Re: Traverse all Vertecies without removing duplicates (orientdb-community-2.0)

Ok, thank you. What alternatives do I have now since this feature is not supported by SQL? Can I use Java Blueprints api to manually traverse? The Java Blueprints API seems to work fine. On Monday, June 1, 2015 at 8:58:04 AM UTC-4, Emin Agassi wrote: > > Hello All > I am traversing a Graph that ha

[orientdb] Using a very large number of databases

In the docs it says: "There is no limit to the number of databases per server or embedded. Users reported no problem with 1000 databases open" Has the upper limit actually been tested? Would do you forsee a problem with having, say, 1 million databases? Asked another way -- is there any overhead

Re: [orientdb] Traverse all Vertecies without removing duplicates (orientdb-community-2.0)

Hi Emil, Traverse was implemented this way to avoid infinite loops, but now we know it's a limitation and we are thinking about a finer strategy, where the user can define (per single query) how traversed nodes have to be considered: - skip traversed nodes globally - skip traversed nodes in curren

Re: [orientdb] Re: Interesting edge handling

Hi, how did you modify the in/out? Did you manually edit the edge document? In this case now you have dirty data on the vertices. There are two open issues on this: https://github.com/orientechnologies/orientdb/issues/4024 https://github.com/orientechnologies/orientdb/issues/1114 Luigi 2015-06

[orientdb] Variable length paths in OrientDb?

Neo4J has syntax for variable length paths: http://neo4j.com/docs/stable/cypher-refcard/ (n)-[*1..5]->(m) How do I express the following in OrientDb: [:CHILD*0..] ? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from

[orientdb] Semantic Database within OrientDB?

Is there a way to create a semantic database within OrientDB? Are there any semantic reasoners that work with Orient? If these are not currently supported, are there plans to implement semantic features natively in Orient? -- --- You received this message because you are subscribed to the

[orientdb] Re: How do I show the whole graph?

Hi there - Please try adding "limit -1" to the end of your select queries. OrientDB has a pretty low default limit, and the -1 makes the limit infinite. Be careful, though - trying to view huge graphs in Studio can cause a lot of slowdown. On Monday, June 1, 2015 at 8:11:55 AM UTC-7, isobre

[orientdb] How do I show the whole graph?

I created some vertices and edges, using classes: create class County extends V create class City extends V create class Child extends E create vertex City set name = 'City-11' create vertex County set name = 'County-1' create edge Child from (select from County where name = 'County-1') to (

[orientdb] Re: Interesting edge handling

I think I got it. For the first time I created the edge with a wrong direction, then I edited it, change the in and out vertices. The changes showed up on the frontend (studio) but not elsewhere. Can it be a bug? On Monday, 1 June 2015 16:44:30 UTC+2, kova...@gmail.com wrote: > > Hello! > > What

[orientdb] Re: SQL commands for bulk database manipulation

Thanks very much, Luigi and SavioL. That should get me on the right track. On Monday, June 1, 2015 at 6:59:30 AM UTC-4, SavioL wrote: > > Hi Ropel, > > try this function, should be the solution you are looking for. > > First you should create a User class with name, nameschool > and then paste thi

[orientdb] Re: Interesting edge handling

Hello! Whatever query I'm running, it doesn't really matter. Let's say I'm just running a traverse * from node like query. If I have a look at all the vertices and edges the in, out rids indicate that all the directions are set up correctly. But when I'm trying to traverse the nodes, for the tra

[orientdb] Re: What is the recommended way to manage OrientDB connections in Express.js or any web application

Hi, You can also use the connection pool: var server = Oriento({ host: 'localhost', port: 2424, username: 'root', password: 'yourpassword', pool: { max: 10 } }); On Friday, May 29, 2015 at 4:12:27 AM UTC-3, Samuel Goldenbaum wrote: > > What is the recommended way to manage Orien

[orientdb] Re: Interesting edge handling

Hi, you can explain better, because I don't understand what you want to achieve from the query. Bye, Alessandro Il giorno lunedì 1 giugno 2015 15:50:36 UTC+2, kova...@gmail.com ha scritto: > > > Hello! > > I would like to ask you a question, or at least if you have seen similar: > I have the fol

Re: [orientdb] Data distribution among extended classes

Hi Matus, every document/vertex/edge is stored in a cluster that directly belongs to its class. So Project documents will be stored in project cluster and Team documents will be stored in team cluster by default. When you execute a query, the result is the union of all the class and subclasses and

[orientdb] Where's the github repository for the docs?

https://github.com/orientechnologies/orientdb-docs is empty. -- --- 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

[orientdb] Re: [Problem] [First Try] reloading objects java

Hi Alessandro, Thanks a lot for this. Should I understand that the accessors only are instrumented ? When are the variables actually bound to the values? Isn't it a problem when trying to take a system and use OrientDB on existing classes that use variables internally and not accessors direct

[orientdb] Interesting edge handling

Hello! I would like to ask you a question, or at least if you have seen similar: I have the following structure: User --OwnsGroup--> Group --HasSubGroup--> Group Consider this example: User1 --OwnsGroup--> Group1 Group1--HasSubGroup-->Group2 Group1--HasSubGroup-->Group3 At least that's what I c

Re: [orientdb] Re: ORestricted / onRecordBeforeRead performance implication

Perfect, thanks a lot Luigi 2015-06-01 14:19 GMT+02:00 Matus Zeman : > Thanks Luigi, > I opened the issue: > https://github.com/orientechnologies/orientdb/issues/4261 > > Matus. > > On Monday, 1 June 2015 13:45:03 UTC+2, Luigi Dell'Aquila wrote: >> >> Hi Matus, >> >> current behavior is exactly

[orientdb] Re: Create edge from the same class data

Hi, Thank you so much for your help. I wrote a java method to do this: Details are at http://stackoverflow.com/questions/30507054/orientdb-create-edge-using-kind-of-self-join/30571722?noredirect=1#comment49219620_30571722 OrientGraph graph = new OrientGraph("remote:localhost/testNode", "root

[orientdb] Data distribution among extended classes

Hi there! How data distribution works among extended classes? Imagine I extend Project and Team from V. When I create two Project docs and two Team docs - are these docs stored in appropriate clusters for both classes Project, Team? What data is actually stored in V cluster? When I `SELECT FROM V

[orientdb] Traverse all Vertecies without removing duplicates (orientdb-community-2.0)

Hello All I am traversing a Graph that has some common Vertices. When I execute traverse, I only see one instance of the common Vertix versus several. For example, A -> B C -> B After traverse, I only see the following result: A C B (common and pointed to by A and C) I would like to see the du

[orientdb] Re: [Problem] [First Try] reloading objects java

Hi Jean, try this code in the class ObjectStorer OObjectIteratorClass i = tx.browseClass(Order.class) ; for (Order or : i){ or.getName(); List listOrderItem=or.getItems(); for(OrderItem it:listOrderItem){ it.getName(); it.getId(); it.getValue(); } System.out.println (or); } Bye, Alessandro Il g

[orientdb] Re: How does cluster selection work?

Same problem here with distributed mode (same thing with non-distributed mode). There are some problems with the studio plugin too : - I've set the global property "cluster selection" to "round-robin" (DB > Configuration > Cluster Selection > Save) - But when I look at the "Schema" part, all cla

Re: [orientdb] Re: ORestricted / onRecordBeforeRead performance implication

Thanks Luigi, I opened the issue: https://github.com/orientechnologies/orientdb/issues/4261 Matus. On Monday, 1 June 2015 13:45:03 UTC+2, Luigi Dell'Aquila wrote: > > Hi Matus, > > current behavior is exactly what you described, records that have to be > excluded are just skipped during evaluat

Re: [orientdb] Re: ORestricted / onRecordBeforeRead performance implication

Hi Matus, current behavior is exactly what you described, records that have to be excluded are just skipped during evaluation. It's not a bad idea to optimize the select statement to act in a more efficient way, I suggest you to open an issue about this, so that it can be addressed in next release

[orientdb] Re: SQL commands for bulk database manipulation

Hi Ropel, try this function, should be the solution you are looking for. First you should create a User class with name, nameschool and then paste this code into functions tab and choose how j

Re: [orientdb] SQL commands for bulk database manipulation

Hi answers below: 2015-06-01 1:11 GMT+02:00 : > I imported a lot of data in a pretty messy format thinking it would be > easy to edit the records later. It hasn't been and I think it's because I'm > struggling to understand the Orient SQL syntax. I'm using oriento but raw > queries are fine. > >

Re: [orientdb] Re: OrientDB ETL tool

Hi James, graph and document db internally are exactly the same, the only difference is the presence of V and E classes (this may be the reason of your failing ETL). I suggest you to go with that configuration and then, if you want, you can use your db as a normal document db. Luigi 2015-06-01

[orientdb] Using gremlin query in JS function

Hello! I'm facing the following problem: I should use complex traversal queries through the HTTP API. Since these queries could be saved, I was thinking about writing a JS function so it can be called remotely. I saw that db.command can accept gremlin queries as well, but when I try it, it alwa

[orientdb] Re: OrientDB ETL tool

Hi All, If I change dbType=graph in the custoemr.json, I managed to import CSV file New question: can I import CSV file to a document database? If not ETL, is there another tool please? Thanks a lot James On Friday, 29 May 2015 12:18:31 UTC+1, James Wang wrote: > > Hi All, > > I am new to Or

[orientdb] Re: Querying based on an attribute

Hi, try this query select expand(in('Accepts').in('Specializes')) from (select expand(out('Specializes').out('Accepts')[name= 'aetna']) from Specialty) Bye, Alessandro Il giorno venerdì 8 maggio 2015 22:35:58 UTC+2, Topping Bowers ha scritto: > > Hello! I'm trying to do a query that says "selec

[orientdb] Re: Create edge from the same class data

Hi Kapil, try this function var g=orient.getGraph(); var b=g.command('sql','select from Nodex') for(i=0;i > I have imported hierarchical data into OrientDB from RDMBS using OETL. > > In RDBMS we used to store parentId in the same row. e.g. the table > structure is something like this: > > ID - N