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

Unable to access graph after re-login

I created graph on AgensGraph. $ agens agens (AgensGraph 2.1.0, based on PostgreSQL 10.4) Type "help" for help. agens=# create graph g; CREATE GRAPH agens=# create (:v{id:1}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) agens=# \q $ agens agens…
cullen
  • 51
  • 4
0
votes
1 answer

How to create star shaped graph on AgensGraph?

I want to create star shaped graph using single "CREATE" statement of CYPHER. How to create star shaped graph on AgensGraph?
korey
  • 23
  • 2
0
votes
1 answer

How to drop property constraint on AgensGraph?

I want to drop property index on AgensGraph. agens=# create vlabel v; CREATE VLABEL agens=# create elabel e; CREATE ELABEL agens=# create property index on v ( id ); CREATE PROPERTY INDEX agens=# create property index on e ( id ); CREATE PROPERTY…
santino
  • 9
  • 1
0
votes
1 answer

How to create unique constraints on AgensGraph

I want to use "id" property as primary key on label. agens=# create vlabel v; CREATE VLABEL agens=# create (:v{id:1}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) agens=# create (:v{id:1}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) But, I don't…
jagger
  • 13
  • 2
0
votes
1 answer

How to copy data from one GRAPH to another?

I am running database Agens Graph v.2.1.0. I have created two graphs with the same structure such as 1 vertex label "VERTEX" and 1 edge label "EDGE". How can I copy data from one graph to another? I can`t copy data with sql query from ag_edge,…
tamani
  • 3
  • 3
0
votes
3 answers

Hybrid Query Example in AgensGraph

I am using agensgraph but I dont know how to write a hybrid query, any examples of hybrid query in agensgraph would help a lot.
Sam
  • 103
  • 1
  • 1
  • 7
0
votes
1 answer

How to search star query on AgensGraph?

I want to find star pattern on AgensGraph using CYPHER? But CYPHER pattern present linear pattern only? How to find star pattern on AgensGraph? I want to get following result from query. agens=# create…
santino
  • 9
  • 1
0
votes
1 answer

How to modify property of label on AgensGraph?

I created new vertex on AgensGraph using CREATE statement. How can I modify the properties of created vertex? agens=# create (:v{prop:1}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) agens=# match (n:v{prop:1}) return n; n …
mekhi
  • 13
  • 3
0
votes
1 answer

How to bind array value on AgensGraph?

How to decompose array value bound? I tried to use UNWIND clause. But, Unable to access it. Is there alternative of array binding or method for decomposing array?
santino
  • 9
  • 1
0
votes
1 answer

How to remove needless quotes on AgensGraph?

There is quotes on result of AgensGraph. I don't want ne agens=# match (n) return n.value; value -------- "test" (1 row) I expect function or procedure for trimming quotes.
jagger
  • 13
  • 2
0
votes
1 answer

How to access graph after re-login on AgensGraph?

Unable to access graph after re-login. I created new graph named "graph" and access my graph. But, Unable to access my graph after re-login. $ agens agens (AgensGraph 2.1.0, based on PostgreSQL 10.4) Type "help" for help. agens=# create graph…
korey
  • 23
  • 2
0
votes
1 answer

How to use with clause on first of CYPHER statement on AgensGraph?

Unable to use with clause on beginning of CYPHER statement. I want to set some parameter variable on with clause. But, AgensGraph returns error. agens=# with 1 as value return value; ERROR: syntax error at or near "1" LINE 1: with 1 as value return…
santino
  • 9
  • 1
0
votes
1 answer

How to use ODBC on AgensGraph?

Is there ODBC Driver on AgensGraph?
jagger
  • 13
  • 2
0
votes
1 answer

How to change server port number of AgensGraph?

AgensGraph can not startup. When AgensGraph installed multiple instance on same server, Some AgensGraph can't startup. $ ag_ctl start ag_ctl: another server might be running; trying to start server anyway server starting Is there config parameter…
korey
  • 23
  • 2
0
votes
1 answer

Aggregation function does not work on AgensGraph

The message pop up like "Function min(jsonb) is not unique". Aggregation function like count() in return clause does not work. When I try implicit type cast, functions are detected in multiple. Is there any workaround?
Kevin Lee
  • 121
  • 7