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
1
vote
1 answer

How to set offset with limit clause on AgensGraph?

I want to set offset with limit clause on AgensGraph. But, there is no "offset" token. agens=# create (:v1{id:1}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) agens=# create (:v1{id:2}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) agens=# create…
jagger
  • 13
  • 2
1
vote
1 answer

cypher flip flop sequence: traversal with alternate edge directions (AgensGraph)

Suppose, we model couples with 2 vertex labels, female and male, and with a single edge label, dates. The direction of the edge is always from female to male. The expected query result list are couples, where there is a non-directed path from a…
jupi
  • 105
  • 5
1
vote
1 answer

What is the casting in AgensGraph ver 1.3 double quote

I used agensgraph version 1.3. Following query 'MATCH (a:movie) RETURN a.title gives result: title --------------------------------- "The Matrix" "The Matrix Reloaded" "The Matrix Revolutions" "The Devils Advocate" "A Few Good…
전현수
  • 11
  • 1
1
vote
1 answer

How to find slow queries on AgensGraph?

I'm developing graph application on AgensGraph, and suffering poor performance of transaction. I want to list long-term queries from log of AgensGraph. How to extract slow queries from log?
mekhi
  • 13
  • 3
1
vote
3 answers

Does AgensGraph support connection pool?

In some project, I need to use a connection pool in AgensGraph. I found "pgpool-II" and "pg bouncer" that support a connection pool function in PostgreSQL. So can I use those modules in AgensGraph without any configuration or specific libraries?
Kevin Lee
  • 121
  • 7
1
vote
1 answer

Can I use ANSI SQL for graph data in AgensGraph?

I know AgensGraph supports ANSI SQL and Cypher language both. If so, can I use ANSI SQL for graph data? and the opposite too. What I want to know is, should I choose and use the language for each data?
Kevin Lee
  • 121
  • 7
1
vote
1 answer

How to drop "GRAPH" on AgensGraph?

I tried to drop graph. An error occurred when dropping graph. # drop graph graph; ERROR: cannot drop graph graph because other objects depend on it DETAIL: sequence graph.ag_label_seq depends on schema graph label ag_vertex depends on schema…
Lee Owens
  • 11
  • 2
1
vote
1 answer

RDB + GDB use case in AgensGraph

Is there any person to let me know RDB + GDB use case? I'm looking for some use cases by using AgensGraph which is multi-model database based on RDB + GDB. Furthermore, also need to know how to migrate data from RDB to GDB, because data models…
Chris K
  • 26
  • 2
1
vote
0 answers

How can I change the collate of database in AgensGraph (under Windows OS)

I want to deal UTF-8 format data using AgensGraph under Windows operation system. AgensGraph is based on Postgres. Therefore I think that if I declare the LC_COLLATE of database as 'en_US.utf8', then I'll be able to deal UTF-8 format…
G.-G.
  • 62
  • 6
1
vote
1 answer

Geospatial data usage in AgensGraph

I want to know how the geospatial data like .shp file stored in AgensGraph? I mean, does AgensGraph support the geo data? I know the PostGIS extension, but I'm not trying to use the PostGIS. I think AgensGraph should have a some structure like…
Kevin Lee
  • 121
  • 7
1
vote
1 answer

What is the AgensGraph syntax to specify a mandatory property constraint?

AgensGraph Developer documentation at https://bitnine.net/documentations/developer-manual-en.html#introduction says that the product "Supports Unique, Mandatory, Check constraints". The online help shows the syntax for creating a unique property…
Bruce Smith
  • 33
  • 3
1
vote
1 answer

org.postgresql.util.PSQLException: ERROR: graph_path is NULL

I think agens-graph is a good Graph Database , and i make some demo. But it doesn't work . some body help me? Class.forName("net.bitnine.agensgraph.Driver"); String connectionString = "jdbc:agensgraph://127.0.0.1:5433/agens"; …
juntao liu
  • 61
  • 1
  • 1
  • 3
1
vote
0 answers

Option for printing more start-up messages

there I posted this question to ask whether there is an option or a way to turn on and off more start-up messages of AgensGraph. I am looking for an answer because I can only see the message stating "server starting" when the server is starting up…
KingKwan
  • 43
  • 6
1
vote
2 answers

Reserved words of AgensGraph

I am trying to load 1,000,000 lines of data into AgensGraph. It is simple data with fake user profiles, and I named the label as "user". However, ERROR statement popped out, and I believe it is because the word "user" is reserved as one of the…
KingKwan
  • 43
  • 6
1
vote
1 answer

How do I add a new property to the node in AgensGraph?

I want to add a new property to the node using SET clause. But an error is occurred and query is not executed. 1) 1st command and error message : MATCH (j {name:'Jack'}) SET j.hobby = 'Playing the guitar'; ERROR: invalid input syntax for type…
Gil Su Lee
  • 13
  • 2
1
2
3 4 5 6 7 8