Stack Overflow
Stack Overflow

Questions tagged [agens-graph]

AgensGraph is a graph database based-on PostgreSQL. It is a robust and fully-featured graph database. AgensGraph can store graph data with relational data. And it also process Cypher and SQL queries and two query languages can be integrated in a single query.

Resources

114 questions
0
votes
1 answer

Cypher relating many nodes to one node

Say I have all these objects in a graph: 5ffcedc70cc70 5ffd73259ad18 5ffd7394311bf 5ffd740fd836c 5ffd74b7001fe 5ffd746b3f457 5ffd74fc7d21d 5ffd75428691b 5ffd75f0509e0 5ffd7586a2916 5ffd789434539 5ffd78e65bae8 5ffd794fcb91a And I want to relate them…
Spatial Digger
  • 1,883
  • 1
  • 19
  • 37
0
votes
1 answer

How to find all labels and graphs on AgensGraph?

I want to migrate all graphs and labels of AgensGraph. How to find all graphs and labels on AgensGraph? Is there special table on AgensGraph?
jagger
  • 13
  • 2
0
votes
1 answer

How to drop all graphs on AgensGraph?

I want to drop all graphs on agensgraph with drop database. Is there query finding all graphs? agens=# SELECT GRAPHNAME FROM ?????; graphname ----------- graph1 graph2
santino
  • 9
  • 1
0
votes
1 answer

How to get max location id of label more faster on AgensGraph?

I want to get largest location id of label. But, It is very slow on follow query. agens=# match (n:v) return max(graphid_locid(id(n))); max ----- 6 (1 row) How to get max location id of label more faster on AgensGraph?
mekhi
  • 13
  • 3
0
votes
1 answer

How to abort failed statement on AgensGraph?

After statement failure, no other statement can success. See the following example. agens=# create graph graph; CREATE GRAPH agens=# create vlabel v; CREATE VLABEL agens=# create unique property index on v ( id ); CREATE PROPERTY INDEX agens=# begin…
cullen
  • 51
  • 4
0
votes
1 answer

Deeply Nested Data - Properties in AgensGraph

Can we have highly nested properties in AgensGraph for our vertexes or edges?
Sam
  • 103
  • 1
  • 1
  • 7
0
votes
1 answer

How to increase creation speed on AgensGraph?

I try to load vertex on AgensGraph. But, upload speed is too slow. agens=# \timing on Timing is on. agens=# create (:v1{id:1}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) Time: 23.285 ms How can I increase creation speed on AgensGraph?
cullen
  • 51
  • 4
0
votes
1 answer

How to find all property names of label on AgensGraph?

I want to find all property names of specific label on AgensGraph. Which command am I use?
mekhi
  • 13
  • 3
0
votes
1 answer

How to change ELABEL on AgensGraph?

I want to change elabel of edge. agens=# create (:v1{id:1})-[:e1{id:3}]->(:v1{id:2}); GRAPH WRITE (INSERT VERTEX 2, INSERT EDGE 1) agens=# match ()-[r1:e1{id:3}]->() set r1:v2 remove r1:v1; ERROR: syntax error at or near ":" LINE 1: match…
santino
  • 9
  • 1
0
votes
1 answer

The efficiency about big data into node on AgensGraph

As far as I know, wide-column cannot be applicable. But is there a difference in efficiency to put big data into the node? I'd like to put an index to distinguish the value and want to know the efficiency.
Kevin Lee
  • 121
  • 7
0
votes
1 answer

How to find type of properties on AgensGraph?

I want to find type of every properties on AgensGraph? agens=# create (:v1{key:1,value:2}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) How can I find it?
jagger
  • 13
  • 2
0
votes
1 answer

Is there alternative of "similar to" on AgensGraph?

I want to find string using regular expression on AgensGraph. agens=# create (:v1{value:'text'}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) agens=# match (n:v1) where n.value similar to 't%' return n; ERROR: syntax error at or near…
jagger
  • 13
  • 2
0
votes
1 answer

How to delete vertex on AgensGraph?

I want to delete vertex on AgensGraph. agens=# create (:v1{id:1})-[:e1{id:2}]->(:v1{id:3}); GRAPH WRITE (INSERT VERTEX 2, INSERT EDGE 1) agens=# match (n:v1{id:1}) delete n; ERROR: vertices with edges can not be removed But, there is an error on…
korey
  • 23
  • 2
0
votes
1 answer

How to avoid duplicate vertex node on AgensGraph?

I want to create edge on two vertexes. agens=# create (:v1{id:1}), (:v1{id:2}); GRAPH WRITE (INSERT VERTEX 2, INSERT EDGE 0) agens=# create (:v1{id:1})-[:e1{id:3}]->(:v1{id:2}); GRAPH WRITE (INSERT VERTEX 2, INSERT EDGE 1) agens=# match (n:v1)…
mekhi
  • 13
  • 3
0
votes
1 answer

How to change VLABEL on AgensGraph?

I want to change vlabel of vertex. agens=# create (:v1{id:1})-[:e1{id:3}]->(:v1{id:2}); GRAPH WRITE (INSERT VERTEX 2, INSERT EDGE 1) agens=# match (n:v1{id:1}) set n:v2 remove n:v1; ERROR: syntax error at or near ":" LINE 1: match (n:v1{id:1}) set…
santino
  • 9
  • 1
1 2 3
4
5 6 7 8