|
Query Optimisation
Hi Marc, Thank you for your reply. I understand the queries are big, so there is a problem viewing them. Actually I am not interested in either of v1 or v2. I want to apply limit on edges, and don't c
Hi Marc, Thank you for your reply. I understand the queries are big, so there is a problem viewing them. Actually I am not interested in either of v1 or v2. I want to apply limit on edges, and don't c
|
By
Vinayak Bali
· #5883
·
|
|
Query Optimisation
Hi All, g.inject(1).union(V().has('property1', 'vertex1').as('v1').union(outE().has('property1', 'edge1').as('e').inV().has('property1', 'vertex1'),outE().has('property1', 'edge2').as('e').inV().has('
Hi All, g.inject(1).union(V().has('property1', 'vertex1').as('v1').union(outE().has('property1', 'edge1').as('e').inV().has('property1', 'vertex1'),outE().has('property1', 'edge2').as('e').inV().has('
|
By
Vinayak Bali
· #5880
·
|
|
Configured graph factory not working after making changes to gremlin-server.yaml
Hi, To investigate the issue please share the recent logs and gremlin-server.yaml and janusgraph.sh which is used to start the service.. Thanks & Regards Vinayak
Hi, To investigate the issue please share the recent logs and gremlin-server.yaml and janusgraph.sh which is used to start the service.. Thanks & Regards Vinayak
|
By
Vinayak Bali
· #5848
·
|
|
Configured graph factory not working after making changes to gremlin-server.yaml
Hi, Make changes in gremlin-server-cql-es.yaml file. Thanks
Hi, Make changes in gremlin-server-cql-es.yaml file. Thanks
|
By
Vinayak Bali
· #5845
·
|
|
Configured graph factory not working after making changes to gremlin-server.yaml
Hi, Which is the janusgraph version being used ??? Regards, Vinayak
Hi, Which is the janusgraph version being used ??? Regards, Vinayak
|
By
Vinayak Bali
· #5843
·
|
|
Union Query Optimization
Hi Amiya, Thank you for the query. It also increased the performance. But, it's still 35 seconds. Is there any other way to optimize it further, there are only 10 records returned by the query. Counts
Hi Amiya, Thank you for the query. It also increased the performance. But, it's still 35 seconds. Is there any other way to optimize it further, there are only 10 records returned by the query. Counts
|
By
Vinayak Bali
· #5831
·
|
|
Union Query Optimization
Hi, cmilowka, The property title has a composite index created on it. Further modified the query as follows: g.V().has('title',within('V1','V2')).union(has('title', 'V1').as('v1').outE().hasLabel('E1'
Hi, cmilowka, The property title has a composite index created on it. Further modified the query as follows: g.V().has('title',within('V1','V2')).union(has('title', 'V1').as('v1').outE().hasLabel('E1'
|
By
Vinayak Bali
· #5829
·
|
|
Union Query Optimization
Hi All, I need to select multiple nodes and edges and display the content in v1 - e - v2 format. The query generated is as follows: g.V().union(has('title', 'V1').as('v1').outE().hasLabel('E1').as('e'
Hi All, I need to select multiple nodes and edges and display the content in v1 - e - v2 format. The query generated is as follows: g.V().union(has('title', 'V1').as('v1').outE().hasLabel('E1').as('e'
|
By
Vinayak Bali
· #5825
·
|
|
ERROR org.apache.spark.scheduler.cluster.StandaloneSchedulerBackend - Application has been killed. Reason: All masters are unresponsive! Giving up.
Hi All, gremlin> graph = GraphFactory.open('conf/hadoop-graph/read-cql-standalone-cluster.properties') ==>hadoopgraph[cqlinputformat->nulloutputformat] gremlin> g = graph.traversal().withComputer(Spar
Hi All, gremlin> graph = GraphFactory.open('conf/hadoop-graph/read-cql-standalone-cluster.properties') ==>hadoopgraph[cqlinputformat->nulloutputformat] gremlin> g = graph.traversal().withComputer(Spar
|
By
Vinayak Bali
· #5802
·
|
|
Count Query Optimisation
Hi All, The Data Model of the graph is as follows: Nodes: Label: Node1, count: 130K Label: Node2, count: 183K Label: Node3, count: 437K Label: Node4, count: 156 Relations: Node1 to Node2 Label: Edge1,
Hi All, The Data Model of the graph is as follows: Nodes: Label: Node1, count: 130K Label: Node2, count: 183K Label: Node3, count: 437K Label: Node4, count: 156 Relations: Node1 to Node2 Label: Edge1,
|
By
Vinayak Bali
· #5799
·
|
|
Count Query Optimization
Hi All, query.batch = true AND query.fast-property = true this doesn't work. facing the same problem. Is there any other way?? Thanks & Regards, Vinayak
Hi All, query.batch = true AND query.fast-property = true this doesn't work. facing the same problem. Is there any other way?? Thanks & Regards, Vinayak
|
By
Vinayak Bali
· #5795
·
|
|
Count Query Optimization
Hi All, Adding these properties in the configuration file affects edge traversal. Retrieving a single edge takes 7 mins of time. 1) Turn on query.batch 2) Turn off query.fast-property Count query is f
Hi All, Adding these properties in the configuration file affects edge traversal. Retrieving a single edge takes 7 mins of time. 1) Turn on query.batch 2) Turn off query.fast-property Count query is f
|
By
Vinayak Bali
· #5775
·
|
|
Count Query Optimization
Amiya - I need to check the data, there is some mismatch with the counts. Consider we have more than one relation to get the count. How can we modify the query? For example: A->E->B query is as follow
Amiya - I need to check the data, there is some mismatch with the counts. Consider we have more than one relation to get the count. How can we modify the query? For example: A->E->B query is as follow
|
By
Vinayak Bali
· #5766
·
|
|
Count Query Optimization
Hi Amiya, With dedup: g.V().has('property1', 'A'). outE().has('property1','E'). where(inV().has('property1', 'B')). fold(). project('edgeCount', 'vertexCount'). by(count(local)). by(unfold().bothV().d
Hi Amiya, With dedup: g.V().has('property1', 'A'). outE().has('property1','E'). where(inV().has('property1', 'B')). fold(). project('edgeCount', 'vertexCount'). by(count(local)). by(unfold().bothV().d
|
By
Vinayak Bali
· #5764
·
|
|
Count Query Optimization
Hi Marc, Using local returns the output after each count. For example: ==>[vetexCount:184439,edgeCount:972] ==>[vetexCount:184440,edgeCount:973] ==>[vetexCount:184441,edgeCount:974] ==>[vetexCount:184
Hi Marc, Using local returns the output after each count. For example: ==>[vetexCount:184439,edgeCount:972] ==>[vetexCount:184440,edgeCount:973] ==>[vetexCount:184441,edgeCount:974] ==>[vetexCount:184
|
By
Vinayak Bali
· #5758
·
|
|
Count Query Optimization
Hi All, The solution from BO XUAN LI to change config files worked for the following query: g.V().has('property1', 'A').as('v1').outE().has('property1','E').as('e').inV().has('property1', 'B').as('v2'
Hi All, The solution from BO XUAN LI to change config files worked for the following query: g.V().has('property1', 'A').as('v1').outE().has('property1','E').as('e').inV().has('property1', 'B').as('v2'
|
By
Vinayak Bali
· #5755
·
|
|
Threads are unresponsive for some time after a particular amount of data transfer(119MB)
Hi Marc, That is where the problem lies. I am not using the gremlin console. Want to execute queries through API built-in Java. Thanks & Regards, Vinayak
Hi Marc, That is where the problem lies. I am not using the gremlin console. Want to execute queries through API built-in Java. Thanks & Regards, Vinayak
|
By
Vinayak Bali
· #5748
·
|
|
Threads are unresponsive for some time after a particular amount of data transfer(119MB)
Hi Marc, I am using cluster mode to connect to janusgraph after creating the gremlin query. A sample of code is as follows: Cluster cluster = Cluster.build().addContactPoint("xx.xx.xx.xx") .port(8182)
Hi Marc, I am using cluster mode to connect to janusgraph after creating the gremlin query. A sample of code is as follows: Cluster cluster = Cluster.build().addContactPoint("xx.xx.xx.xx") .port(8182)
|
By
Vinayak Bali
· #5739
·
|
|
Threads are unresponsive for some time after a particular amount of data transfer(119MB)
Hi Marc, I went through some blogs but didn't get a method to connect to janusgraph using embedded mode using java. We are using Cassandra as a backend and cql to connect to it. Not sure how I will be
Hi Marc, I went through some blogs but didn't get a method to connect to janusgraph using embedded mode using java. We are using Cassandra as a backend and cql to connect to it. Not sure how I will be
|
By
Vinayak Bali
· #5734
·
|
|
JMX authentication for cassandra
Hi Marc, The article was useful and complete the JMX authentication successfully. But when I allow password authentication for Cassandra by changing the following lines in Cassandra.yaml, it stops wor
Hi Marc, The article was useful and complete the JMX authentication successfully. But when I allow password authentication for Cassandra by changing the following lines in Cassandra.yaml, it stops wor
|
By
Vinayak Bali
· #5733
·
|