Thanks Brian for quick reply, I'll wait till tomorrow for you to come back, I need some solution to overcome on this since I am facing lot of challenges.
On Wednesday, August 27, 2014 7:15:54 PM UTC+5:30, Brian O'Keefe wrote: > > I've seen this issue too. It isn't an easy problem to fix. I created my > own service that 1. Uses the API to perform the desired function, but > requires you to track visited nodes and depth to know when you reached the > desired hops, and 2. Streams back the results to improve performance. I > didn't commit it back because it relies on jax-rs, cxf and spring, but I'll > see if I can post the code tomorrow when I am back in the office. > On Aug 27, 2014 9:37 AM, "sachchidanand singh" <[email protected] > <javascript:>> wrote: > >> Hi Lvc@, >> >> Below is the query i am using - >> select from (traverse in('extracted_place') from (select from >> ExtractedLocation where name ='Gaza') while $depth <= 1) where not >> (isReTweet=true) limit 50 >> >> after encoding with gephi end point - >> >> http://localhost:2480/gephi/dbname/sql/select%20%20from%20(traverse%20in(%27extracted_place%27)%20from%20(select%20from%20ExtractedLocation%20where%20name%20%3D%27Gaza%27)%20while%20%24depth%20%3C%3D%201)%20where%20not%20(isReTweet%3Dtrue)%20limit%2050 >> >> if you break this query, it should give me the result of max 51 nodes (50 >> limit is given for outer query and 1 node for inner query) and connected 51 >> edges which shows their relationships. This limit is working fine for nodes >> and giving me expected nodes but it is giving those links also which are >> not the part of this traversal. >> Lets say if these 50 nodes (which are getting traversed through outer >> query and are connected with one node of inner wuery) are connected with >> some other 100 nodes, since i am traversing till these 50 nodes (restricted >> by depth) so I am expecting only 50 links which are connecting these nodes >> to the central nodes but it is giving the other 100 links also which is not >> required and have not been asked. >> >> Below is the result - >> >> {"an":{"#12:445320":{"content":" >> http://goo.gl/h5NfEI\u000ahttp://goo.gl/XZWrgW\u000aGaza\u000aIn this >> cold desolate hour\u000aKeep warm\u000aBurn a cere in Australia that is >> effectivee >> ...","sentiment":-0.10591847,"time":1408458600000,"content_id":"wbMdgQfUAGc","source":"youtube","relevance":5.795923,"contentURL":" >> http://www.youtube.com/watch?v=wbMdgQfUAGc"}}} >> {"an":{"#12:505677":{"content":"#Demonstration for #Gaza, 23 August, >> Saturday #DowningStreet #London #Westminster #palestine @antizio_ >> @yvonneridley http://t.co/nBdyNiUUpP >> ","sentiment":0.0,"time":1408554524000,"content_id":"502140188643319809","source":"Twitter","relevance":247.5,"language":"en","contentURL":" >> www.twitter.com/BarbiRashid/status/502140188643319809"}}} >> {"an":{"#12:387378":{"content":"\u25b6 Sid Ryan speaking at Protest for >> Gaza, August 9, 2014 \u2013 YouTube http://t.co/TIrgFH1PUH >> ","sentiment":-0.33333334,"time":1407759102000,"content_id":"498803943234076672","source":"Twitter","relevance":86.166664,"language":"en","contentURL":" >> www.twitter.com/QaisGhanem/status/498803943234076672"}}} >> {"an":{"#12:428264":{"content":" >> http://goo.gl/h5NfEI\u000ahttp://goo.gl/XZWrgW\u000aGaza\u000aIn this >> cold desolate hour\u000aKeep warm\u000aBurn a >> can","sentiment":-0.10591847,"time":1408409659000,"content_id":"6Z4DtoKy4YQ","source":"youtube","relevance":5.795923,"contentURL":" >> http://www.youtube.com/watch?v=6Z4DtoKy4YQ"}}} >> {"an":{"#12:515383":{"content":"#Demonstration for #Gaza, 23 August, >> Saturday #DowningStreet #boycott @BDSmovement @ReemKelani @YasinDin >> #ICC4Israel http://t.co/Xd3QeAt2Qi >> ","sentiment":0.0,"time":1408554939000,"content_id":"502141928448589824","source":"Twitter","relevance":102.5,"language":"en","contentURL":" >> www.twitter.com/BarbiRashid/status/502141928448589824"}}} >> {"an":{"#12:361554":{"content":"#Bangladesh #Jamaat-e islami >> demonstrations rally today in Dhaka, against the Israeli barbaric genocide >> on in #Gaza! http://t.co/3dc8hAx1gw >> ","sentiment":-0.5,"time":1407738652000,"content_id":"498718170019278848","source":"Twitter","relevance":142.0,"language":"en","contentURL":" >> www.twitter.com/kewshukhinoy/status/498718170019278848"}}} >> {"an":{"#12:512955":{"content":"#Demonstration for #Gaza, 23 August, >> Saturday #DowningStreet @georgegalloway @jvplive @TraditionalJews >> @TorahJews http://t.co/c1ecC5Ve0p >> ","sentiment":0.0,"time":1408554822000,"content_id":"502141435077222400","source":"Twitter","relevance":106.0,"language":"en","contentURL":" >> www.twitter.com/BarbiRashid/status/502141435077222400"}}} >> {"an":{"#16:2":{"name":"Gaza"}}} >> {"an":{"#12:519499":{"content":"#Demonstration for #Gaza, 23 August, >> Saturday #DowningStreet @benabyad @Remroum @MaxBlumenthal @SaveGazaProject >> http://t.co/jDTisPhYMM >> ","sentiment":0.0,"time":1408555183000,"content_id":"502142948973502464","source":"Twitter","relevance":112.0,"language":"en","contentURL":" >> www.twitter.com/BarbiRashid/status/502142948973502464"}}} >> {"an":{"#12:407414":{"content":"Police arrest two men after >> ","sentiment":-0.105240874,"time":1408081610000,"content_id":"9abDQbd7U6E","source":"youtube","relevance":5.7620435,"contentURL":" >> http://www.youtube.com/watch?v=9abDQbd7U6E"}}} >> {"an":{"#12:267322":{"content":"Stand together for Gaza demonstration >> Edinburgh Saturday 9 August, 2pm, In solidarity with the Palestinian >> people, Assemble top of >> Mound","sentiment":0.45883146,"time":1407508761000,"content_id":"497753939966963712","source":"Twitter","relevance":106.941574,"language":"en","contentURL":" >> www.twitter.com/PCS_Scotland/status/497753939966963712"}}} >> {"an":{"#12:277711":{"content":"Photo: hadaes: >> theworldstandswithpalestine: Melbourne protest for Gaza, July 19. 2014. >> everyone fucking... http://t.co/pWtj1beALN >> ","sentiment":-0.42426407,"time":1407516638000,"content_id":"497786977060937729","source":"Twitter","relevance":79.7132,"language":"en","contentURL":" >> www.twitter.com/nic_ftw/status/497786977060937729"}}} >> {"an":{"#12:376770":{"content":"Poignant message by a Congress worker at >> rally to protest against the killings in Gaza on Saturday, Aug 9 >> http://t.co/64iGHM6FmC >> ","sentiment":0.0,"time":1407745778000,"content_id":"498748059677777920","source":"Twitter","relevance":90.5,"language":"en","contentURL":" >> www.twitter.com/wb_pcc/status/498748059677777920"}}} >> {"an":{"#12:332947":{"content":"A special \"good morning\" to all those >> people who are London-bound to protest at the carnage taking place in Gaza. >> Well done to all of >> you.","sentiment":-0.07779408,"time":1407565366000,"content_id":"497991357051727872","source":"Twitter","relevance":64.3897,"language":"en","contentURL":" >> www.twitter.com/reddeviljp/status/497991357051727872"}}} >> >> {"ae":{"#18:136->#12:332947":{"directed":false,"source":"#12:332947","target":"#18:136"}}} >> >> {"ae":{"#12:332947->#13:247444":{"directed":false,"source":"#13:247444","target":"#12:332947"}}} >> >> {"ae":{"#18:152->#12:376770":{"directed":false,"source":"#12:376770","target":"#18:152"}}} >> >> {"ae":{"#12:376770->#15:28":{"directed":false,"source":"#15:28","target":"#12:376770"}}} >> >> {"ae":{"#12:376770->#13:278674":{"directed":false,"source":"#13:278674","target":"#12:376770"}}} >> >> {"ae":{"#18:4->#12:277711":{"directed":false,"source":"#12:277711","target":"#18:4"}}} >> >> {"ae":{"#12:277711->#13:208623":{"directed":false,"source":"#13:208623","target":"#12:277711"}}} >> >> {"ae":{"#12:267322->#15:0":{"directed":false,"source":"#15:0","target":"#12:267322"}}} >> >> {"ae":{"#12:267322->#13:201174":{"directed":false,"source":"#13:201174","target":"#12:267322"}}} >> >> {"ae":{"#12:267322->#16:1":{"directed":false,"source":"#16:1","target":"#12:267322"}}} >> >> {"ae":{"#12:267322->#16:0":{"directed":false,"source":"#16:0","target":"#12:267322"}}} >> >> {"ae":{"#18:0->#12:267322":{"directed":false,"source":"#12:267322","target":"#18:0"}}} >> >> {"ae":{"#18:1->#12:267322":{"directed":false,"source":"#12:267322","target":"#18:1"}}} >> >> {"ae":{"#18:2->#12:267322":{"directed":false,"source":"#12:267322","target":"#18:2"}}} >> >> {"ae":{"#12:407414->#13:171731":{"directed":false,"source":"#13:171731","target":"#12:407414"}}} >> >> {"ae":{"#12:407414->#15:13":{"directed":false,"source":"#15:13","target":"#12:407414"}}} >> >> {"ae":{"#12:407414->#15:12":{"directed":false,"source":"#15:12","target":"#12:407414"}}} >> >> {"ae":{"#12:407414->#16:60":{"directed":false,"source":"#16:60","target":"#12:407414"}}} >> >> {"ae":{"#18:78->#12:407414":{"directed":false,"source":"#12:407414","target":"#18:78"}}} >> >> {"ae":{"#18:104->#12:407414":{"directed":false,"source":"#12:407414","target":"#18:104"}}} >> >> {"ae":{"#18:415->#12:519499":{"directed":false,"source":"#12:519499","target":"#18:415"}}} >> >> {"ae":{"#12:519499->#13:200252":{"directed":false,"source":"#13:200252","target":"#12:519499"}}} >> >> {"ae":{"#12:528388->#16:2":{"directed":false,"source":"#16:2","target":"#12:528388"}}} >> >> {"ae":{"#12:519499->#16:2":{"directed":false,"source":"#16:2","target":"#12:519499"}}} >> >> {"ae":{"#12:519338->#16:2":{"directed":false,"source":"#16:2","target":"#12:519338"}}} >> >> {"ae":{"#12:516933->#16:2":{"directed":false,"source":"#16:2","target":"#12:516933"}}} >> >> {"ae":{"#12:510447->#16:2":{"directed":false,"source":"#16:2","target":"#12:510447"}}} >> >> {"ae":{"#12:407414->#16:2":{"directed":false,"source":"#16:2","target":"#12:407414"}}} >> >> {"ae":{"#12:376770->#16:2":{"directed":false,"source":"#16:2","target":"#12:376770"}}} >> >> {"ae":{"#12:332947->#16:2":{"directed":false,"source":"#16:2","target":"#12:332947"}}} >> >> {"ae":{"#18:248->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:248"}}} >> >> {"ae":{"#18:263->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:263"}}} >> >> {"ae":{"#18:252->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:252"}}} >> >> {"ae":{"#18:136->#12:387378":{"directed":false,"source":"#12:387378","target":"#18:136"}}} >> >> {"ae":{"#12:387378->#14:4588":{"directed":false,"source":"#14:4588","target":"#12:387378"}}} >> >> {"ae":{"#12:387378->#16:2":{"directed":false,"source":"#16:2","target":"#12:387378"}}} >> >> {"ae":{"#12:387378->#15:29":{"directed":false,"source":"#15:29","target":"#12:387378"}}} >> >> {"ae":{"#12:387378->#13:285641":{"directed":false,"source":"#13:285641","target":"#12:387378"}}} >> >> {"ae":{"#18:415->#12:505677":{"directed":false,"source":"#12:505677","target":"#18:415"}}} >> >> {"ae":{"#12:505677->#16:2":{"directed":false,"source":"#16:2","target":"#12:505677"}}} >> >> {"ae":{"#12:505677->#12:510447":{"directed":false,"source":"#12:510447","target":"#12:505677"}}} >> >> {"ae":{"#12:505677->#13:200252":{"directed":false,"source":"#13:200252","target":"#12:505677"}}} >> >> {"ae":{"#12:445320->#13:324694":{"directed":false,"source":"#13:324694","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5619":{"directed":false,"source":"#14:5619","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5618":{"directed":false,"source":"#14:5618","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5617":{"directed":false,"source":"#14:5617","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5616":{"directed":false,"source":"#14:5616","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5615":{"directed":false,"source":"#14:5615","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5614":{"directed":false,"source":"#14:5614","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5613":{"directed":false,"source":"#14:5613","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5612":{"directed":false,"source":"#14:5612","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5611":{"directed":false,"source":"#14:5611","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5610":{"directed":false,"source":"#14:5610","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#14:5609":{"directed":false,"source":"#14:5609","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:2":{"directed":false,"source":"#16:2","target":"#12:445320"}}} >> >> {"ae":{"#18:243->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:243"}}} >> >> {"ae":{"#18:248->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:248"}}} >> >> {"ae":{"#18:254->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:254"}}} >> >> {"ae":{"#18:252->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:252"}}} >> >> {"ae":{"#18:246->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:246"}}} >> >> {"ae":{"#18:247->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:247"}}} >> >> {"ae":{"#18:244->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:244"}}} >> >> {"ae":{"#18:273->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:273"}}} >> >> {"ae":{"#18:267->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:267"}}} >> >> {"ae":{"#18:266->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:266"}}} >> >> {"ae":{"#18:263->#12:445320":{"directed":false,"source":"#12:445320","target":"#18:263"}}} >> >> {"ae":{"#12:445320->#16:5":{"directed":false,"source":"#16:5","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:12":{"directed":false,"source":"#16:12","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:16":{"directed":false,"source":"#16:16","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:33":{"directed":false,"source":"#16:33","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:50":{"directed":false,"source":"#16:50","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:59":{"directed":false,"source":"#16:59","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:141":{"directed":false,"source":"#16:141","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:142":{"directed":false,"source":"#16:142","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:143":{"directed":false,"source":"#16:143","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#16:144":{"directed":false,"source":"#16:144","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#15:52":{"directed":false,"source":"#15:52","target":"#12:445320"}}} >> >> {"ae":{"#12:445320->#15:53":{"directed":false,"source":"#15:53","target":"#12:445320"}}} >> >> {"ae":{"#18:247->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:247"}}} >> >> {"ae":{"#18:246->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:246"}}} >> >> {"ae":{"#18:254->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:254"}}} >> >> {"ae":{"#18:267->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:267"}}} >> >> {"ae":{"#18:266->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:266"}}} >> >> {"ae":{"#18:244->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:244"}}} >> >> {"ae":{"#18:243->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:243"}}} >> >> {"ae":{"#18:273->#12:428264":{"directed":false,"source":"#12:428264","target":"#18:273"}}} >> >> {"ae":{"#12:428264->#16:2":{"directed":false,"source":"#16:2","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:5":{"directed":false,"source":"#16:5","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:12":{"directed":false,"source":"#16:12","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:16":{"directed":false,"source":"#16:16","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:33":{"directed":false,"source":"#16:33","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:50":{"directed":false,"source":"#16:50","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:59":{"directed":false,"source":"#16:59","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:141":{"directed":false,"source":"#16:141","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:142":{"directed":false,"source":"#16:142","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:143":{"directed":false,"source":"#16:143","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#16:144":{"directed":false,"source":"#16:144","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#15:52":{"directed":false,"source":"#15:52","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#15:53":{"directed":false,"source":"#15:53","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5070":{"directed":false,"source":"#14:5070","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5071":{"directed":false,"source":"#14:5071","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5072":{"directed":false,"source":"#14:5072","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5073":{"directed":false,"source":"#14:5073","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5074":{"directed":false,"source":"#14:5074","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5075":{"directed":false,"source":"#14:5075","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5076":{"directed":false,"source":"#14:5076","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5077":{"directed":false,"source":"#14:5077","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5078":{"directed":false,"source":"#14:5078","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5079":{"directed":false,"source":"#14:5079","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#14:5080":{"directed":false,"source":"#14:5080","target":"#12:428264"}}} >> >> {"ae":{"#12:428264->#13:313798":{"directed":false,"source":"#13:313798","target":"#12:428264"}}} >> >> {"ae":{"#12:515383->#13:200252":{"directed":false,"source":"#13:200252","target":"#12:515383"}}} >> >> {"ae":{"#12:515383->#12:519338":{"directed":false,"source":"#12:519338","target":"#12:515383"}}} >> >> {"ae":{"#12:515383->#16:2":{"directed":false,"source":"#16:2","target":"#12:515383"}}} >> >> {"ae":{"#18:415->#12:515383":{"directed":false,"source":"#12:515383","target":"#18:415"}}} >> >> {"ae":{"#18:147->#12:361554":{"directed":false,"source":"#12:361554","target":"#18:147"}}} >> >> {"ae":{"#18:146->#12:361554":{"directed":false,"source":"#12:361554","target":"#18:146"}}} >> >> {"ae":{"#12:361554->#16:102":{"directed":false,"source":"#16:102","target":"#12:361554"}}} >> >> {"ae":{"#12:361554->#16:2":{"directed":false,"source":"#16:2","target":"#12:361554"}}} >> >> {"ae":{"#12:361554->#13:268419":{"directed":false,"source":"#13:268419","target":"#12:361554"}}} >> >> {"ae":{"#12:512955->#13:200252":{"directed":false,"source":"#13:200252","target":"#12:512955"}}} >> >> {"ae":{"#12:512955->#12:516933":{"directed":false,"source":"#12:516933","target":"#12:512955"}}} >> >> {"ae":{"#12:512955->#16:2":{"directed":false,"source":"#16:2","target":"#12:512955"}}} >> >> {"ae":{"#18:415->#12:512955":{"directed":false,"source":"#12:512955","target":"#18:415"}}} >> >> {"ae":{"#12:267322->#16:2":{"directed":false,"source":"#16:2","target":"#12:267322"}}} >> >> {"ae":{"#12:277711->#16:2":{"directed":false,"source":"#16:2","target":"#12:277711"}}} >> >> >> here if you see, according to my query I should get only those links >> which are in to the central node, I have given 'extracted_by' edge name to >> connecting link between these two nodes. So according to my DB structure I >> should get link which shows the relationship of "#16 and #12" but I am >> getting #14, #15, #18 also. >> Because of this it is taking lot of time to execute the query, for some >> of the nodes I have more than 5k connecting nodes, so if you can suggest >> any way out to rid of this it will be very helpful to me. >> please let me know if any clarification is needed. >> >> Thanks >> >> >> On Wednesday, August 27, 2014 6:13:35 PM UTC+5:30, Lvc@ wrote: >>> >>> Hi Sachchidanand, >>> To understand what you did the query could help. Can you write it here? >>> >>> Lvc@ >>> >>> >>> On 27 August 2014 13:16, sachchidanand singh <[email protected]> wrote: >>> >>>> Hi All, >>>> >>>> I am facing the same issue, I am limiting my traversal, but the result >>>> which I am getting is unexpected, It shows the nodes according to the >>>> limit >>>> i have provided but along with this it is showing all the links connected >>>> to these nodes, for example if i have traversed to depth <=1 and limited >>>> it >>>> by 10, but actually this node is connected with 100 other nodes(lets say), >>>> then it will give result as all the 100 links along with these 10 nodes >>>> even though i have queried for 10 only. so is there any way which can >>>> restrict the unexpected links and i will get the only those links which >>>> are >>>> falling in to my traversal. >>>> I am using 1.6.0 SNAPSHOT and gephi end point. >>>> >>>> Thanks, >>>> Sachchidanand singh >>>> >>>> >>>> On Thursday, October 10, 2013 6:58:44 PM UTC+5:30, Brian O'Keefe wrote: >>>>> >>>>> Thanks Luca. I'll probably just wait for 1.6 general release and use >>>>> my proxy for the proof of concept. >>>>> >>>>> On Wednesday, October 9, 2013 2:58:28 PM UTC-4, Lvc@ wrote: >>>>>> >>>>>> Hi Brian, >>>>>> I think that output is because the edges are lightweight, namely have >>>>>> no identity. You can avoid this with performance penalty by using: >>>>>> >>>>>> alter database custom useLightweightEdges=false >>>>>> >>>>>> Or you can pull last "develop" branch (or last 1.6.0-SNAPSHOT) where >>>>>> this has been fixed. >>>>>> >>>>>> Lvc@ >>>>>> >>>>>> >>>>>> On 9 October 2013 11:49, Brian O'Keefe <[email protected]> wrote: >>>>>> >>>>>>> Luca, >>>>>>> >>>>>>> I worked around this issue by writing a proxy that intercepts the >>>>>>> JSON being returned and substitutes a unique id for the edge id. >>>>>>> However, >>>>>>> that is not optimal and I tested this situation again using your >>>>>>> suggestion >>>>>>> of rewriting the query to: >>>>>>> >>>>>>> TRAVERSE * FROM (SELECT FROM V WHERE name='Me') >>>>>>> >>>>>>> Encoded: http://localhost:2480/gephi/testing/sql/TRAVERSE%20*% >>>>>>> 20FROM%20(SELECT%20FROM%20V%20WHERE%20name%3D%27Me%27)%20while%20% >>>>>>> 24depth%20%3C%3D%206/-1 >>>>>>> >>>>>>> Again, the result is still duplicate edge ids: >>>>>>> >>>>>>> {"an":{"#11:2":{"name":"Paternal Grandfather"}}} >>>>>>> {"an":{"#11:1":{"name":"Maternal Grandmother"}}} >>>>>>> {"an":{"#11:0":{"name":"Maternal Grandfather"}}} >>>>>>> {"an":{"#11:7":{"name":"Junior"}}} >>>>>>> {"an":{"#11:6":{"name":"Me"}}} >>>>>>> {"an":{"#11:5":{"name":"Dad"}}} >>>>>>> {"an":{"#11:4":{"name":"Mom"}}} >>>>>>> {"an":{"#11:3":{"name":"Paternal Grandmother"}}} >>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:5","target":"#11:3"} >>>>>>> }} >>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:6","target":"#11:5"} >>>>>>> }} >>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:6","target":"#11:4"} >>>>>>> }} >>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:7","target":"#11:6"} >>>>>>> }} >>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:4","target":"#11:0"} >>>>>>> }} >>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:4","target":"#11:1"} >>>>>>> }} >>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:5","target":"#11:2"} >>>>>>> }} >>>>>>> >>>>>>> Thanks, >>>>>>> >>>>>>> Brian >>>>>>> >>>>>>> On Monday, October 7, 2013 4:28:46 PM UTC-4, Lvc@ wrote: >>>>>>>> >>>>>>>> Hi Brian, >>>>>>>> sorry I wrote the select statement instead of traverse. This is the >>>>>>>> traverse: >>>>>>>> >>>>>>>> TRAVERSE both("IsParentOf") FROM ( >>>>>>>> SELECT FROM V WHERE name='Me' >>>>>>>> ) WHILE $depth <= 6 >>>>>>>> >>>>>>>> if you want the >>>>>>>> >>>>>>>> SELECT expand(rel) FROM ( >>>>>>>> TRAVERSE both("IsParentOf") as rels FROM ( >>>>>>>> SELECT FROM V WHERE name='Me' >>>>>>>> ) WHILE $depth <= 6 >>>>>>>> ) >>>>>>>> >>>>>>>> Lvc@ >>>>>>>> >>>>>>>> On Monday, 7 October 2013, Brian O'Keefe wrote: >>>>>>>> >>>>>>>>> Thank you Luca. Is there a way to traverse N levels recursively >>>>>>>>> using this model? For instance, I want to get the entire tree in >>>>>>>>> this >>>>>>>>> case, but in other cases I may want to get, say, 6 hops as it grows. >>>>>>>>> This >>>>>>>>> query seems to only provide the immediate parents/children. I tried >>>>>>>>> "TRAVERSE * FROM (SELECT FROM V WHERE name='Me')" as well, but >>>>>>>>> that also has the invalid edge ids. If there isn't an easy solution, >>>>>>>>> I'll >>>>>>>>> just create a proxy that rewrites the edge ids as a sequence. >>>>>>>>> >>>>>>>>> Thanks, >>>>>>>>> >>>>>>>>> Brian >>>>>>>>> >>>>>>>>> On Saturday, October 5, 2013 4:12:37 PM UTC-4, Lvc@ wrote: >>>>>>>>>> >>>>>>>>>> Hi Brian, >>>>>>>>>> you could use the TRAVERSE command instead of Traverse() function: >>>>>>>>>> >>>>>>>>>> SELECT expand( both("IsParentOf") ) FROM V WHERE name='Me' >>>>>>>>>> >>>>>>>>>> Lvc@ >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> Lvc@ >>>>>>>>>> >>>>>>>>>> >>>>>>>>>> On 4 October 2013 10:21, Brian O'Keefe <[email protected]> >>>>>>>>>> wrote: >>>>>>>>>> >>>>>>>>>>> Hi all, >>>>>>>>>>> >>>>>>>>>>> I'm not sure if I am doing this incorrectly, or if something is >>>>>>>>>>> wrong with the Gephi plugin functionality, so I outline the steps >>>>>>>>>>> to >>>>>>>>>>> reproduce below: >>>>>>>>>>> >>>>>>>>>>> Assuming a local database exists called "Testing": >>>>>>>>>>> >>>>>>>>>>> 1. I create the schema >>>>>>>>>>> CREATE CLASS Person extends V; >>>>>>>>>>> CREATE CLASS IsParentOf extends E; >>>>>>>>>>> CREATE PROPERTY Person.name STRING; >>>>>>>>>>> >>>>>>>>>>> 2. I add the vertices >>>>>>>>>>> CREATE VERTEX Person SET name = 'Maternal Grandfather' >>>>>>>>>>> CREATE VERTEX Person SET name = 'Maternal Grandmother' >>>>>>>>>>> CREATE VERTEX Person SET name = 'Paternal Grandfather' >>>>>>>>>>> CREATE VERTEX Person SET name = 'Paternal Grandmother' >>>>>>>>>>> CREATE VERTEX Person SET name = 'Mom' >>>>>>>>>>> CREATE VERTEX Person SET name = 'Dad' >>>>>>>>>>> CREATE VERTEX Person SET name = 'Me' >>>>>>>>>>> CREATE VERTEX Person SET name = 'Junior' >>>>>>>>>>> CREATE VERTEX Person SET name = 'Neighbor' >>>>>>>>>>> >>>>>>>>>>> 3. I add the edges >>>>>>>>>>> CREATE EDGE IsParentOf FROM (SELECT FROM Person where name = >>>>>>>>>>> 'Maternal Grandfather') TO (SELECT FROM Person where name = 'Mom') >>>>>>>>>>> CREATE EDGE IsParentOf FROM (SELECT FROM Person where name = >>>>>>>>>>> 'Maternal Grandmother') TO (SELECT FROM Person where name = 'Mom') >>>>>>>>>>> CREATE EDGE IsParentOf FROM (SELECT FROM Person where name = >>>>>>>>>>> 'Paternal Grandfather') TO (SELECT FROM Person where name = 'Dad') >>>>>>>>>>> CREATE EDGE IsParentOf FROM (SELECT FROM Person where name = >>>>>>>>>>> 'Paternal Grandmother') TO (SELECT FROM Person where name = 'Dad') >>>>>>>>>>> CREATE EDGE IsParentOf FROM (SELECT FROM Person where name = >>>>>>>>>>> 'Mom') TO (SELECT FROM Person where name = 'Me') >>>>>>>>>>> CREATE EDGE IsParentOf FROM (SELECT FROM Person where name = >>>>>>>>>>> 'Dad') TO (SELECT FROM Person where name = 'Me') >>>>>>>>>>> CREATE EDGE IsParentOf FROM (SELECT FROM Person where name = >>>>>>>>>>> 'Me') TO (SELECT FROM Person where name = 'Junior') >>>>>>>>>>> >>>>>>>>>>> My goal is to get the part of the graph dealing with "Me and my >>>>>>>>>>> family" (e.g., exclude "Neighbor") >>>>>>>>>>> The query SELECT * FROM (TRAVERSE any() FROM (SELECT FROM V >>>>>>>>>>> WHERE name='Me')) achieves this, so the url I query is: >>>>>>>>>>> http://localhost:2480/gephi/testing/sql/SELECT%20*%20FROM%20 >>>>>>>>>>> (TRAVERSE%20any()%20FROM%20(SELECT%20FROM%20V%20WHERE%20name >>>>>>>>>>> %3D%27Me%27))/-1 >>>>>>>>>>> >>>>>>>>>>> The result is: >>>>>>>>>>> {"an":{"#11:2":{"name":"Paternal Grandfather"}}} >>>>>>>>>>> {"an":{"#11:1":{"name":"Maternal Grandmother"}}} >>>>>>>>>>> {"an":{"#11:0":{"name":"Maternal Grandfather"}}} >>>>>>>>>>> {"an":{"#11:7":{"name":"Junior"}}} >>>>>>>>>>> {"an":{"#11:6":{"name":"Me"}}} >>>>>>>>>>> {"an":{"#11:5":{"name":"Dad"}}} >>>>>>>>>>> {"an":{"#11:4":{"name":"Mom"}}} >>>>>>>>>>> {"an":{"#11:3":{"name":"Paternal Grandmother"}}} >>>>>>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:5","target": >>>>>>>>>>> "#11:3"}}} >>>>>>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:6","target": >>>>>>>>>>> "#11:5"}}} >>>>>>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:6","target": >>>>>>>>>>> "#11:4"}}} >>>>>>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:7","target": >>>>>>>>>>> "#11:6"}}} >>>>>>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:4","target": >>>>>>>>>>> "#11:0"}}} >>>>>>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:4","target": >>>>>>>>>>> "#11:1"}}} >>>>>>>>>>> {"ae":{"#-1:-1":{"directed":false,"source":"#11:5","target": >>>>>>>>>>> "#11:2"}}} >>>>>>>>>>> >>>>>>>>>>> The issue is that Gephi will only add the first edge, and then >>>>>>>>>>> reports that "Edge added event ignored for edge #-1:-1: Edge >>>>>>>>>>> already exi >>>>>>>>>>> >>>>>>>>>>> -- >>>>>>>>>>> >>>>>>>>>>> --- >>>>>>>>>>> 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 [email protected]. >>>>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out >>>>>>>>>>> . >>>>>>>>>>> >>>>>>>>>> >>>>>>>>>> -- >>>>>>>>> >>>>>>>>> --- >>>>>>>>> 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 [email protected]. >>>>>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>>>>> >>>>>>>> -- >>>>>>> >>>>>>> --- >>>>>>> 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 [email protected]. >>>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>>> >>>>>> >>>>>> -- >>>> >>>> --- >>>> 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 [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- >> >> --- >> You received this message because you are subscribed to a topic in the >> Google Groups "OrientDB" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/orient-database/3AUBqkNM5ks/unsubscribe >> . >> To unsubscribe from this group and all its topics, send an email to >> [email protected] <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > -- --- 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 [email protected]. For more options, visit https://groups.google.com/d/optout.
