Re: [orientdb] Re: Complex query

2015-06-05 Thread Andrey Yesyev
> On Friday, June 5, 2015 at 12:30:12 AM UTC+5:30, Andrey Yesyev wrote: >> >> This is the final version of the query I need >> >> select v.name, sum(count) as cnt from (select if(eval("in=#17:0"),out,in) >> as v,count from E where (in=#17:0 or out=#17:0)

[orientdb] Re: Complex query

2015-06-04 Thread Andrey Yesyev
This is the final version of the query I need select v.name, sum(count) as cnt from (select if(eval("in=#17:0"),out,in) as v,count from E where (in=#17:0 or out=#17:0)) order by cnt desc group by v Nagu, I greatly appreciate your help and time you spent on this! -- --- You received this mess

Re: [orientdb] Re: Complex query

2015-06-04 Thread Andrey Yesyev
Nagu, Frankly, I think this is it! I did some quick tests and looks like it works. Anyway, it's a very good starting point for me. Thank you very much! -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop re

[orientdb] Re: Complex query

2015-06-03 Thread Andrey Yesyev
Hi SavioL, It's not Ziink was asking it's me. Thanks a lot for your answer, I'll try it shortly. This is quite a work you've done right there, I do appreciate it. I have concerns regarding performance of this query on large sets of data... And I still need to add one tweak, I don't know how many

Re: [orientdb] Re: Complex query

2015-06-03 Thread Andrey Yesyev
Thanks Nagu! But I also need to group by vertices I related to. On 3 June 2015 at 07:02, nagaraja sosale ramaswamy wrote: > select sum(count) from RELATED where in = #11:0 or out = #11:0 > > > hope that helps... > ~nagu. > > > On Wednesday, June 3, 2015 at 2:26:24 PM UTC+5:30, SavioL wrote: >>

Re: [orientdb] Re: Complex query

2015-06-03 Thread Andrey Yesyev
ed --> V1 > V2 -->related --> V1 > > so i have 3 link from V1 to V2, and 2 link from V2 to V1. > > With this query: select count(*) FROM Related LET $c = in.size() > i get Count = 5. (five is number of total link with V1 and V2) > > i hope is this the answer you were

[orientdb] Re: Sources for orientdb community 2.0.10

2015-06-02 Thread Andrey Yesyev
Never mind, found them https://github.com/orientechnologies/orientdb/releases On Tuesday, June 2, 2015 at 4:19:36 PM UTC-4, Andrey Yesyev wrote: > > How to get sources for the latest stable release 2.0.10. > > I looked at git, there is no specific branch for 2.0.10, I ended up >

[orientdb] Sources for orientdb community 2.0.10

2015-06-02 Thread Andrey Yesyev
How to get sources for the latest stable release 2.0.10. I looked at git, there is no specific branch for 2.0.10, I ended up getting 2.0.x, which doesn't fit to binaries from 2.0.10. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubsc

[orientdb] Re: Exception "Cluster with id 5 already belongs to class OUser"

2015-06-02 Thread Andrey Yesyev
Version orientdb-community 2.0.10. Connection remote. -- --- 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 op

[orientdb] Exception "Cluster with id 5 already belongs to class OUser"

2015-06-02 Thread Andrey Yesyev
I'm creating DB this way if (url.startsWith("remote")) { OServerAdmin server = new OServerAdmin(url).connect(userName, password); if (!server.existsDatabase("plocal")){ server.createDatabase("graph", "plocal"); } server.close(); factory = new OrientGraphFactory(end

[orientdb] Re: Complex query

2015-06-02 Thread Andrey Yesyev
Someone!? Please? On Monday, June 1, 2015 at 6:10:15 PM UTC-4, Andrey Yesyev wrote: > > 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

Re: [orientdb] Re: Keep the database small?

2015-06-02 Thread Andrey Yesyev
to update that section. Any suggestions is welcome. > > Best Regards, > > Luca Garulli > CEO at Orient Technologies LTD > the Company behind OrientDB > http://about.me/luca.garulli > > > On 2 June 2015 at 14:02, Andrey Yesyev wrote: > >> I came across with th

[orientdb] Re: Keep the database small?

2015-06-02 Thread Andrey Yesyev
I came across with this performance "tip" too. I was also very surprised. On Tuesday, June 2, 2015 at 3:37:21 AM UTC-4, scott molinari wrote: > > I am not sure if it is because the person writing doesn't speak English as > the native language, but this can't be right >

[orientdb] Re: Complex query

2015-06-01 Thread Andrey Yesyev
ng these two results... On Monday, June 1, 2015 at 6:10:15 PM UTC-4, Andrey Yesyev wrote: > > 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 b

[orientdb] Complex query

2015-06-01 Thread Andrey Yesyev
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] Re: Is it possible to specify class in WHERE clause?

2015-06-01 Thread Andrey Yesyev
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

Re: [orientdb] Re: User/Password for plocal DB.

2015-05-29 Thread Andrey Yesyev
t; password, does it work as expected? > > (and, yes, shutdown() is a good practice.) > > Thanks, > > -Colin > > Orient Technologies > > The Company behind OrientDB > > > On Thursday, May 28, 2015 at 3:11:15 PM UTC-5, Andrey Yesyev wrote: >> >&

[orientdb] User/Password for plocal DB.

2015-05-28 Thread Andrey Yesyev
Hi there, I'm trying to create DB String url = "plocal:testdb"; String user = "root"; String pass = "root"; OrientGraphFactory graphFactory = new OrientGraphFactory(url, user, pass). setupPool(5, 1000); Setting DB up OrientGraphNoTx graph = graphFactory.getNoTx(); try { OrientVertexType vType =

[orientdb] Studio plugin small issue

2014-05-01 Thread Andrey Yesyev
Hi there, Just build the latest from develop branch. Ran the server. Constantly getting this message 2014-05-01 10:39:26:023 INFO Installing dynamic plugin > 'studio-1.7-snapshot.zip'... [OServerPluginManager]Error on installing > dynamic plugin 'studio' > Plugin 'studio' already registered > -

Re: [orientdb] Thread race?

2014-04-07 Thread Andrey Yesyev
Done https://github.com/orientechnologies/orientdb/issues/2198 -- --- 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. Fo

Re: [orientdb] Thread race?

2014-04-07 Thread Andrey Yesyev
Any updates on this? -- --- 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, visit https://groups.googl

[orientdb] Re: 14MB of text data expands to over 3.9 GB

2014-04-03 Thread Andrey Yesyev
That's okay! It won't grow significantly bigger then 4Gb. If you shutdown DB, the size will be a couple Mb at most. What you're seeing now, it's included disk cache. On Thursday, April 3, 2014 10:47:13 AM UTC-4, IQH wrote: > > Hello, I am new to using OrientDB. I am using version 1.7 rc2. I am

[orientdb] Thread race?

2014-04-03 Thread Andrey Yesyev
Hi there, My adventures with changing DB schema during populating it, are going on... I spotted 3 threads to deadlock when one of them tried to commit a transaction, another added index to newly created class property and the third one tried to get a DB connection from factory. Here is snapshot

Re: [orientdb] DB crash 1.7rc2

2014-04-01 Thread Andrey Yesyev
Done. https://github.com/orientechnologies/orientdb/issues/2181 -- --- 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. F

Re: [orientdb] DB crash 1.7rc2

2014-04-01 Thread Andrey Yesyev
Sure On Apr 1, 2014 10:54 AM, "Andrey Lomakin" wrote: > Hi Andrey, > > Could you create issue about it ? > > > On Tue, Apr 1, 2014 at 5:30 PM, Andrey Yesyev wrote: > >> Hi there, >> >> Trying to reproduce one issue, I created a test that

[orientdb] DB crash 1.7rc2

2014-04-01 Thread Andrey Yesyev
more options, visit https://groups.google.com/d/optout. package dejavu.indexer; import com.orientechnologies.common.exception.OException; import com.orientechnologies.orient.client.remote.OServerAdmin; import com.orientechnologies.orient.core.exception.OSchemaException; import com.oriente

Re: [orientdb] Re: Exception while creating new class

2014-04-01 Thread Andrey Yesyev
14 at 8:25 AM, Andrey Lomakin > wrote: > >> Hi, >> How do you get connection ? >> >> >> On Mon, Mar 31, 2014 at 8:43 PM, Andrey Yesyev >> wrote: >> >>> Okay, I changed the code to use OrientGraph instead of OrientGraphNoTx

Re: [orientdb] Re: Exception while creating new class

2014-04-01 Thread Andrey Yesyev
g; } On Tuesday, April 1, 2014 1:25:57 AM UTC-4, Andrey Lomakin wrote: > > Hi, > How do you get connection ? > > > On Mon, Mar 31, 2014 at 8:43 PM, Andrey Yesyev > > > wrote: > >> Okay, I changed the code to use OrientGraph instead of OrientG

Re: [orientdb] Re: Exception while creating new class

2014-03-31 Thread Andrey Yesyev
Okay, I changed the code to use OrientGraph instead of OrientGraphNoTx, now it looks like this OrientGraph graph = getConnection(); graph.setAutoStartTx(false); graph.commit(); try{ //Changing schema of DB } }catch (OSchemaExce

Re: [orientdb] Re: Exception while creating new class

2014-03-31 Thread Andrey Yesyev
otx/tx connections. It can be a problem. > > Just do as following. > setAutsoSrartTx to false. > commit tx. > Do changes. > setAutsoSrartTx to true. > > Sorry I can not put it simple, what this message means. > > > > > On Mon, Mar 31, 2014 at 6:45 PM, Andrey

Re: [orientdb] Re: Exception while creating new class

2014-03-31 Thread Andrey Yesyev
re I might try to insert vertices of the class I registered in the second NoTx connection. Could that be a problem? Will the opened TX connection see the changes made by NoTx connection? Thanks! -Andrey On 31 March 2014 10:00, Andrey Yesyev wrote: > Okay, I'll go through it once again.

Re: [orientdb] Re: Exception while creating new class

2014-03-31 Thread Andrey Yesyev
Okay, I'll go through it once again. On 31 March 2014 09:40, Andrey Lomakin wrote: > Hi Andrey, > It means that you probably have wrong connections management. > Probably I will find time to look at your project but no promise. > > > > On Fri, Mar 28, 2014 at 10:14

Re: [orientdb] Re: Exception while creating new class

2014-03-28 Thread Andrey Yesyev
28, 2014 3:59:57 PM com.orientechnologies.common.log.OLogManager log > WARNING: Update of collection pointer is received but collection is not > registered So, if you're interested in have a look at it, I'll gladly provide you my project adopted for convenient use. -Andrey On 28 March 2014 13:23, Andrey

[orientdb] Re: Exception while creating new class

2014-03-28 Thread Andrey Yesyev
This is how I acquire connection private OrientGraphFactory factory; ... public synchronized OrientGraphNoTx getNoTxConnection() { if(factory == null) { factory = new OrientGraphFactory(endpoint.get()); factory.setupPool(5, 100); } r

Re: [orientdb] Re: Exception while creating new class

2014-03-28 Thread Andrey Yesyev
Should it be something like this private void addType(String type){ OrientGraph graph = getConnection(); graph.setAutoStartTx(false); try{ if(graph.getVertexType(type) == null){ OrientVertexType vType = graph.createVertexType(type);

Re: [orientdb] Re: Exception while creating new class

2014-03-28 Thread Andrey Yesyev
Sure, just let me extract that from my project to a separate test case. On 28 March 2014 13:06, Andrey Lomakin wrote: > Interesting, > May I have full test case to reproduce it ? > > > On Fri, Mar 28, 2014 at 6:28 PM, Andrey Yesyev wrote: > >> Hi Andrey, >> >&

[orientdb] Re: Exception while creating new class

2014-03-28 Thread Andrey Yesyev
I guess I found an answer here https://groups.google.com/forum/#!msg/orient-database/x70dCwsTNEU/0YqHQ7AEwpAJ Does this mean that I can't create class during the work with DB? -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe fr

Re: [orientdb] Re: Exception while creating new class

2014-03-28 Thread Andrey Yesyev
. > Then you can create class. > Do not forget to revert this flag to true. > > > On Fri, Mar 28, 2014 at 6:11 PM, Andrey Yesyev wrote: > >> I guess I found an answer here >> https://groups.google.com/forum/#!msg/orient-database/x70dCwsTNEU/0YqHQ7AEwpAJ >> Does this

Re: [orientdb] Re: How to results fields from every nodes in a path with SQL?

2014-03-28 Thread Andrey Yesyev
ealtime recommender engine, although > the performance is pretty good :-) > > Thx! > L. > 2014.03.27. 14:03 ezt írta ("Andrey Yesyev" ): > > Hi László, >> >> I found this site is very useful http://gremlindocs.com/ >> >> This is how I look for all

[orientdb] Exception while creating new class

2014-03-28 Thread Andrey Yesyev
Hi there, I try to create a new Vertex class private void addType(String type){ OrientGraphNoTx graph = getNoTxConnection(); try{ if(graph.getVertexType(type) == null){ OrientVertexType vType = graph.createVertexType(type); //Root do

Re: [orientdb] Re: How to results fields from every nodes in a path with SQL?

2014-03-27 Thread Andrey Yesyev
mehow I need to make it with out of the box solution to > proof that it worth to spend time on it. So maybe javascript function can > be the answer somehow. > > @Andrey, could you please share your use case and solution with me? > Orientdb lacks of complete, step by step tutorial, or at

[orientdb] Re: How to results fields from every nodes in a path with SQL?

2014-03-26 Thread Andrey Yesyev
Hi there, I have the similar problems. I solved them using Gremlin-Groovy. I doubt you can do what you need using SQL. -Andrey On Tuesday, March 25, 2014 3:58:06 PM UTC-4, László Rékasi wrote: > > Hi, > > I have the following datastructure (every entity has its own class): > vertexes : vA, vB,

Re: [orientdb] Re: Hackaton!

2014-03-26 Thread Andrey Yesyev
I'd like to participate. What time are you planning to start? On Tuesday, March 25, 2014 1:05:50 PM UTC-4, Lvc@ wrote: > > Thanks to everybody. The next hackathon (but hack-a-ton sounds even > cooler) will be on April 1st. I'd say a perfect date ;-) > > *The draft rules are (please contribute to

Re: [orientdb] How to find paths between 2 vertices

2014-03-25 Thread Andrey Yesyev
In case someone's interested, found an answer for my question here https://groups.google.com/forum/#!msg/aureliusgraphs/d3jvgJeArOU/lMoObkk-If0J -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receivin

Re: [orientdb] Re: Groovy querying

2014-03-25 Thread Andrey Yesyev
h("RELATED").loop("person"){it.id.toString() > != "#16:10" && it.loops < 4}.has('@class','Name').path() > ? > > > On Tue, Mar 25, 2014 at 6:26 PM, Andrey Yesyev > > > wrote: > >> Okay, now I'm prett

[orientdb] Re: Groovy querying

2014-03-25 Thread Andrey Yesyev
Okay, now I'm pretty sure there is a bug here. I changed my queries, instead of checking 'id' value, I'm checking property '@class', it works this way. g.v("#21:7").as("person").both("RELATED").loop("person"){it.object.id != "#16:10" && it.loops < 4}.filter{it.getProperty('@class')=='Name'}.pat

[orientdb] Groovy querying

2014-03-25 Thread Andrey Yesyev
Hi there, Trying to find all paths between 2 vertices using Gremlin/Groovy This query returns many paths g.v("#21:7").as("person").both("RELATED").loop("person"){it.object.id != "#16:10" && it.loops < 4}.path so, I'm trying to filter out unwanted using filter or has g.v("#21:7").as("person").b

Re: [orientdb] How to find paths between 2 vertices

2014-03-25 Thread Andrey Yesyev
ou will always need to retrieve data > from remote connect to the client to process request. > > > On Mon, Mar 24, 2014 at 9:15 PM, Andrey Yesyev > > > wrote: > >> Hi there, >> >> I've come to the most interesting part of my project - traversing

Re: [orientdb] How to find paths between 2 vertices

2014-03-25 Thread Andrey Yesyev
n you should create select with gremlin query pass it on server side > and then see the result, otherwise you will always need to retrieve data > from remote connect to the client to process request. > > > On Mon, Mar 24, 2014 at 9:15 PM, Andrey Yesyev wrote: > >> Hi there, &

[orientdb] How to find paths between 2 vertices

2014-03-24 Thread Andrey Yesyev
Hi there, I've come to the most interesting part of my project - traversing graph. Now I'm investigating how I can find 1. All paths between 2 vertices 2. Shortest path between 2 vertices. If I can solve the first problem, this won't be an issue. 3. Get related vertices to vertex V with given d

[orientdb] Re: Bug fixes, new updates

2014-03-20 Thread Andrey Yesyev
Thanks! -- --- 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, visit https://groups.google.com/d/optou

[orientdb] Re: Bug fixes, new updates

2014-03-20 Thread Andrey Yesyev
king for me without any problems. > > Hope this helps. > > Regards, > -Stefán > > > On Thursday, 20 March 2014 15:32:43 UTC, Andrey Yesyev wrote: >> >> Well, this issue >> https://github.com/orientechnologies/orientdb/issues/2135 is claimed to >>

[orientdb] Re: Bug fixes, new updates

2014-03-20 Thread Andrey Yesyev
its version: "1.7-rc2-SNAPSHOT". > > Regards, > -Stefan > > On Thursday, 20 March 2014 13:34:21 UTC, Andrey Yesyev wrote: >> >> Hi there, >> >> Guys, where I can get the latest updates and bug fixes? >> I'm interested in 1.7rc2 >>

[orientdb] Bug fixes, new updates

2014-03-20 Thread Andrey Yesyev
Hi there, Guys, where I can get the latest updates and bug fixes? I'm interested in 1.7rc2 Thanks! -Andrey -- --- 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 o

Re: [orientdb] Querying in multi-thread environment issue

2014-03-18 Thread Andrey Yesyev
Issue is opened https://github.com/orientechnologies/orientdb/issues/2141 -- --- 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...@googlegro

Re: [orientdb] Querying in multi-thread environment issue

2014-03-18 Thread Andrey Yesyev
Hi Andrey, I guess I can :) On 18 March 2014 08:35, Andrey Lomakin wrote: > Hi Andrey, > Not yet, could you create issue in bug tracker, so you will track it and > will not ping me :-))) . > > > On Tue, Mar 18, 2014 at 2:33 PM, Andrey Yesyev wrote: > >> Any upda

Re: [orientdb] Querying in multi-thread environment issue

2014-03-18 Thread Andrey Yesyev
Any updates on this? On 17 March 2014 13:19, Andrey Yesyev wrote: > I can provide anything you need to fix it. > > > On 17 March 2014 13:19, Andrey Yesyev wrote: > >> Yes. >> >> >> On 17 March 2014 13:17, Andrey Lomakin wrote: >> >>>

Re: [orientdb] Querying in multi-thread environment issue

2014-03-17 Thread Andrey Yesyev
I can provide anything you need to fix it. On 17 March 2014 13:19, Andrey Yesyev wrote: > Yes. > > > On 17 March 2014 13:17, Andrey Lomakin wrote: > >> Aha, I was hunting this issue for a months. >> Is it reproducible ? >> >> >> On Mon, Mar

Re: [orientdb] Querying in multi-thread environment issue

2014-03-17 Thread Andrey Yesyev
Yes. On 17 March 2014 13:17, Andrey Lomakin wrote: > Aha, I was hunting this issue for a months. > Is it reproducible ? > > > On Mon, Mar 17, 2014 at 6:25 PM, Andrey Yesyev wrote: > >> O

Re: [orientdb] Querying in multi-thread environment issue

2014-03-17 Thread Andrey Yesyev
for it. > > > On Mon, Mar 17, 2014 at 6:00 PM, Andrey Yesyev wrote: > >> Hi Andrey, >> >> Unfortunately the stacktrace ends there. >> I'm trying now to get more information on this. >> >> -Andrey >> >> >> On 17 March 2014 1

Re: [orientdb] Querying in multi-thread environment issue

2014-03-17 Thread Andrey Yesyev
Hi Andrey, Unfortunately the stacktrace ends there. I'm trying now to get more information on this. -Andrey On 17 March 2014 11:55, Andrey Lomakin wrote: > > HI Andrey, > > I see last line is: > "Caused by: java.lang.NullPointerException" > > What is stackrace of this cause ? > > > > -- > Bes

[orientdb] Querying in multi-thread environment issue

2014-03-17 Thread Andrey Yesyev
Hi there, I'm issuing a number of queries to DB at the same time from different threads. Times to times I got this exception com.orientechnologies.orient.enterprise.channel.binary.OResponseProcessingException: Exception during response processing. at com.orientechnologies.orient.ente

Re: [orientdb] Re: The fastest way to query edges

2014-03-07 Thread Andrey Yesyev
Here is that topic https://groups.google.com/forum/#!msg/orient-database/BGEZjg8m2RE/3FrCWyamVIoJ On 6 March 2014 18:23, Andrey Yesyev wrote: > Hm, good question. I found a post here, where I saw how the author of that > post did, so I just copy/past it. I'll try to do this wit

Re: [orientdb] Re: The fastest way to query edges

2014-03-06 Thread Andrey Yesyev
ating a in/out property for the edge > manually? > > Regards, > -Stefan > > On Thursday, 6 March 2014 16:23:33 UTC, Andrey Yesyev wrote: >> >> Okay, looks like everything after OR was excessive. >> Query works in this shape >> >> select from index:relation

[orientdb] Re: The fastest way to query edges

2014-03-06 Thread Andrey Yesyev
Okay, looks like everything after OR was excessive. Query works in this shape select from index:relations where key = [ :target, :src ] Using index, performance improved 10 times. Not bad. On Thursday, March 6, 2014 10:41:55 AM UTC-5, Andrey Yesyev wrote: > > I'll proceed wit

[orientdb] Re: The fastest way to query edges

2014-03-06 Thread Andrey Yesyev
I'll proceed with my search. Now, I try to use index for edge, here is how I created it OrientEdgeType edgeType = graph.createEdgeType(RelationType.RELATED.name()); edgeType.createProperty("in", OType.LINK); edgeType.createProperty("out", OType.LINK); edgeType.createIndex("relations", OClass.INDE

Re: [orientdb] OIndexException: Error during loading of record with id : #14:1

2014-03-06 Thread Andrey Yesyev
> > On Wed, Mar 5, 2014 at 11:22 AM, Andrey Lomakin > > > wrote: > >> Hi, >> What is your stack trace and version of distribution ? >> Could you provide test case if possible ? >> >> >> >> On Tue, Mar 4, 2014 at 11:04 PM, Andrey Yesyev >

[orientdb] The fastest way to query edges

2014-03-06 Thread Andrey Yesyev
Hi there, I need to find an edge between 2 vertices. In my schema there can be only one edge between 2 vertices. I tried this 2 options 1. Using query select from RELATED where in = :target and out = :src RELATED is a class of the edge I'm looking for. 2. Using API vSrc.getEdges(vTarget, Di

[orientdb] OIndexException: Error during loading of record with id : #14:1

2014-03-04 Thread Andrey Yesyev
Hi there, I'm getting this exception trying to add an edge v1.addEdge("HAS", v2); This works fine in single thread mode, but it doesn't work in multi-thread mode. I know v1 and v2 can be changed at this point and I'm taking care of this situation, but why I'm getting OIndexException? Thanks!

Re: [orientdb] Query graph

2014-02-25 Thread Andrey Yesyev
Thanks Riccardo! On 25 February 2014 16:20, Riccardo Tasso wrote: > In OSQL I would ask for: > > SELECT > FROM Item > WHERE name == 'test' AND in('has').name contains 'name1' > > Riccardo > > > 2014-02-25 22:10 GMT+01:00 Andrey Yesyev

[orientdb] Query graph

2014-02-25 Thread Andrey Yesyev
Hi there, I have a simple graph https://drive.google.com/file/d/0B40PKGeiVlEFSmFfeHRtU2d6ZHM/edit?usp=sharing I need to find Item with name="test" which has in_HAS from Case with name="case1". How would you do this? Thanks! -Andrey -- --- You received this message because you are subscrib

Re: [orientdb] TRAVERSE logic

2014-02-25 Thread Andrey Yesyev
The only thing I want is to understand how it's supposed to work. For now, I have two answers, that contradicts each other First > > I *think* that Andrey's point is that he is expecting "while" to have > semantics like a "while" construct in Java - discontinue execution if the > condition is n

Re: [orientdb] TRAVERSE logic

2014-02-20 Thread Andrey Yesyev
Ok. Thanks anyway for your clarifications! -Andrey On 20 February 2014 13:44, Dexter Pratt wrote: > Sorry, this question hasn't come up in our application yet, so I don't > know. > > - Dexter > > On Thursday, February 20, 2014 at 10:16 AM, Andrey Yesyev wrote:

Re: [orientdb] TRAVERSE logic

2014-02-20 Thread Andrey Yesyev
t; Dexter Pratt > Director, NDEx project > Ideker Lab UCSD / Cytoscape Consortium > dep...@ucsd.edu - dex...@ndexbio.org > www.ndexbio.org > > On Wednesday, February 19, 2014 at 2:44 PM, Luca Garulli wrote: > > So is it ok, right? > > Lvc@ > > > On 19 February 2014

Re: [orientdb] TRAVERSE logic

2014-02-20 Thread Andrey Yesyev
-Traverse On 20 February 2014 09:43, Andrey Yesyev wrote: > Luca - no, it's not ok, from my point of view. > > Dexter - thanks, that's exactly what I'm expecting. My expectation is > based on this piece of documentation *while > <https://github.com/orientec

Re: [orientdb] TRAVERSE logic

2014-02-20 Thread Andrey Yesyev
Ideker Lab UCSD / Cytoscape Consortium > depr...@ucsd.edu - dex...@ndexbio.org > www.ndexbio.org > > On Wednesday, February 19, 2014 at 2:44 PM, Luca Garulli wrote: > > So is it ok, right? > > Lvc@ > > > On 19 February 2014 23:30, Andrey Yesyev wrote: > > Oh, yes

Re: [orientdb] TRAVERSE logic

2014-02-19 Thread Andrey Yesyev
#12:0 while $depth < 2 and > name<http://current.name/> <> > 'gmail_with_attachments.pcap') > > Lvc@ > > > > On 19 February 2014 19:12, Andrey Yesyev wrote: > >> Hi there, >> >> I was playing with traverse and couldn't

[orientdb] TRAVERSE logic

2014-02-19 Thread Andrey Yesyev
Hi there, I was playing with traverse and couldn't figure out the logic of WHILE. This is what I found in docs: *while * condition to continue the traversing while it's true. Usually it's used to limit the traversing depth by using

Re: [orientdb] Rexster and embedded mode

2014-02-18 Thread Andrey Yesyev
r + Your App in one JVM and connect > Rexster using remote: protocol. > > Lvc@ > > > > On 18 February 2014 00:56, Andrey Yesyev wrote: > >> I probably have to explaine what I mean in more details. I want to use >> orientdb in my app in embedded mode at the same time I

Re: [orientdb] Rexster and embedded mode

2014-02-17 Thread Andrey Yesyev
ot; wrote: > Hi, > yes. Just setup Rexster with plocal URL. In this way it will access to the > database in embedded mode and you could expose OrientDB graphs through > Rexster. > > Lvc@ > > > > On 17 February 2014 21:13, Andrey Yesyev wrote: > >> Hi there, &g

[orientdb] Rexster and embedded mode

2014-02-17 Thread Andrey Yesyev
Hi there, Can I setup orientdb to work in embedded mode and at the same time to expose it to Rexster server? -Andrey -- --- 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 e

[orientdb] Really poor performance on string fields filters???

2014-02-16 Thread Andrey Yesyev
I think index type in your case should be FULLTEXT -- --- 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 optio

Re: [orientdb] Re: Querying issue

2014-02-15 Thread Andrey Yesyev
Thanks Damian! Wow, it's a year old bug. Any plans on fixing it!? On Feb 15, 2014 2:02 AM, "Damian Bronecki" wrote: > This is known issue with parameters in nested queries. > > Take a look here: > https://github.com/orientechnologies/orientdb/issues/1069 > > -- > > --- > You received this message

[orientdb] Re: Querying issue

2014-02-14 Thread Andrey Yesyev
Trying to narrow the area of issue. I ran this query OSQLSynchQuery query = new OSQLSynchQuery<>("select from Case where name = :cname"); Map params = new HashMap<>(); params.put("cname", c.getCase().getName()); List docs = graph.getRawGraph().command(que

[orientdb] Re: Querying issue

2014-02-14 Thread Andrey Yesyev
entechnologies.orient.core.storage.OStorageEmbedded.executeCommand(OStorageEmbedded.java:96) ... 8 more This doesn't seem right to me. On Friday, February 14, 2014 3:33:55 PM UTC-5, Andrey Yesyev wrote: > > Hi there, > > Trying to query DB using this function > > public Iterabl

[orientdb] Querying issue

2014-02-14 Thread Andrey Yesyev
Hi there, Trying to query DB using this function public Iterable findCollectionVertex(Collection c){ OSQLSynchQuery query = new OSQLSynchQuery<>("select from (traverse out_HAS from (select from Case where name = :cname ) while $depth <= 1) where name = :name"); Map params =

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-13 Thread Andrey Yesyev
large use case scenarios. Complex selects, and high > inserts/updates. For example, 1 million users linked to an object and > traversing down a selected group. The same data between each database. > Which is fastest? Would also help developers in OrientDB see where > performance may be ne

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-13 Thread Andrey Yesyev
ere >> https://github.com/Morro/GraphDBBenchmark >> >> So if you publish your data using them I will very appreciate it. >> >> >> >> On Sun, Feb 9, 2014 at 10:23 PM, Milen Dyankov wrote: >> >>> Hello Andrey Lomakin, >>> >>> as I

Re: [orientdb] Distributed mode for embedded databases

2014-02-13 Thread Andrey Yesyev
Great Thanks! On Thursday, February 13, 2014 10:21:35 AM UTC-5, Lvc@ wrote: > > Sure, > Just start the embedded server with the $ > ORIENTDB_HOME/config/orientdb-dserver-config.xml. > > Lvc@ > > Sent from Mobile device > Il 13/feb/2014 16:09 "Andrey Yesyev

[orientdb] Distributed mode for embedded databases

2014-02-13 Thread Andrey Yesyev
Hi there, Is it possible to setup a replication for embedded databases? -Andrey -- --- 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...@g

[orientdb] Re: Populating DB in distributed mode v1.7rc1.

2014-02-10 Thread Andrey Yesyev
Still trying to figure out what's going on there. The same issue with GratefulDeadConcerts databse... On Thursday, February 6, 2014 6:35:24 PM UTC-5, Rob Gratz wrote: > > Seeing the same problems with rc1 and rc2-SNAPSHOT > >> >> -- --- You received this message because you are subscribed to t

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-09 Thread Andrey Yesyev
ven project and > because it is tinkerpop based you can test all dbs which you are interested > in. > Our load test does not have properties on vertexes only relations and > index by page key,but it is simple to add additional properties. > > What do you think ? > > &g

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-09 Thread Andrey Yesyev
ven project and > because it is tinkerpop based you can test all dbs which you are interested > in. > Our load test does not have properties on vertexes only relations and > index by page key,but it is simple to add additional properties. > > What do you think ? > > > >

[orientdb] Re: Create DB in distributed mode

2014-02-09 Thread Andrey Yesyev
Are there any news? -- --- 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, visit https://groups.google

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-09 Thread Andrey Yesyev
instructions how to run these tests to see statistic >>> results ? >>> >>> >>> On Sun, Feb 9, 2014 at 4:59 PM, Andrey Yesyev >>> >>> > wrote: >>> >>>> Ok, here we go! >>>> >>>> I added all

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-09 Thread Andrey Yesyev
> On Sun, Feb 9, 2014 at 5:47 PM, Andrey Lomakin > > > wrote: > >> Got it ! )) >> >> >> On Sun, Feb 9, 2014 at 5:44 PM, Andrey Lomakin >> >> > wrote: >> >>> Hi Andrey, >>> >>> Could you provide instructions

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-08 Thread Andrey Yesyev
rtex, final >>> String iClassName, final String iClusterName, final Object... fields)* >>> >>> Example: >>> >>> >>> *v1.addEdge( null, v2, "E", null, properties);* >>> >>> About usage of console to set parameters

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-08 Thread Andrey Yesyev
I figured out that I can set in console this parameter *config set storage.diskCache.bufferSize 14336* but after I reopen console, it sets to 4096 again. On Saturday, February 8, 2014 11:40:09 AM UTC-5, Andrey Yesyev wrote: > > The second problem is with this par

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-08 Thread Andrey Yesyev
The second problem is with this parameter storage.diskCache.bufferSize. I run tests on my Windows laptop. So I added to server.bat this parameter as *set ORIENTDB_SETTINGS=-Dprofiler.enabled=true -Dcache.level1.enabled=false -Dcache.level2.enabled=false -Dcache.level2.size=0 -Dstorage.diskCache.

Re: [orientdb] Re: 1.7rc2 performance results

2014-02-08 Thread Andrey Yesyev
e will provide multicore support > https://github.com/orientechnologies/orientdb/issues/1678 . > > BTW may I ask you to run the same tests not on remote but on plocal > storage and publish difference ? > > Could you change your benchmark according suggestions above a

  1   2   >