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

What is used array variables in AgensGraph ver1.3 release?

I used in AgensGraph release 1.3 but I don't used where clause in operator. e.g: eya=# CREATE (a:person {name:['ljh','jhlee'], age:102}); GRAPH WRITE (INSERT VERTEX 1, INSERT EDGE 0) CREATE TABLE t_name ( name text, age int ); CREATE…
이정학
  • 1
0
votes
1 answer

How to get labels of array on AgensGraph?

I tried to get labels of array on AgensGraph? But, It returns a error about type conversion. How can I get labels of array? agens=# match (n:o) with collect(n) as n return labels(n[0]); ERROR: cannot cast type jsonb to vertex agens =# match…
mekhi
  • 13
  • 3
0
votes
1 answer

How to use property constraint in shortest-path on AgensGraph?

I tried to search shortest-path on two vertices. But, there is a error on CYPHER query on mime. How can I find shortest-path between vertices? agens (AgensGraph 1.3.1, based on PostgreSQL 9.6.2) Type "help" for help. agens =# match p =…
korey
  • 23
  • 2
0
votes
1 answer

How to find internal vertices in variable-length-edges on AgensGraph?

I tried to find internal vertices in variable-length-edges on AgensGraph. But, It returns error message like following. Is there problem on CYPHER query on mime? How can I view internal vertices of VLE? Attaching sample script follow. create graph…
santino
  • 9
  • 1
0
votes
1 answer

How can I increase performance of shortest-path on AgensGraph?

I tried to use shortest-path on AgensGraph. But, It is quietly slower than other graph database. How can I increase performance of shortest-path on AgensGraph? I want to some tips or configuration parameters. Attaching sample script follow. create…
jagger
  • 13
  • 2
0
votes
1 answer

Does AgensGraph support sharding?

I'm using AgensGraph Community edition on my server. And I have a question. Does AgensGraph support sharding? If not, how does AgensGraph support a distributed environment? Or.. is there any workaround for that?
Kevin Lee
  • 121
  • 7
0
votes
1 answer

Can I download only the desired portion of data in the form of a csv file from the Agensgraph?

I am using Agensgraph. I want to download the data I want in the form of a csv file through the cypher syntax. Please tell me what to do.
jin
  • 1
0
votes
1 answer

Errors are occurred about Match - Set in AgensGraph

This problem occurs when I use the set clause multiple times in AgensGraph. There seems to be a problem with the optimizer. Is there a way to bypass it? MATCH (q:QST{ qst_id:1})
SET q.prop_solv_time_default = 10
, q.qst_lvl_default =…
Kevin Lee
  • 121
  • 7
0
votes
1 answer

How to find lock-wait queries on AgentGraph?

I'm suffering from slow transaction of AgensGraph. CPU Usage is extremely low. I'm guessing that lock-wait situation. How to find lock-wait queries?
santino
  • 9
  • 1
0
votes
1 answer

How to log ddl commands on AgensGraph?

I'm administrator of AgensGraph, and want to log all ddl. Also, I want to know about that user who running ddl. Is there good ideas about it?
korey
  • 23
  • 2
0
votes
1 answer

How to trace connections from users on AgensGraph?

I'm setting up a new AgensGraph server, and want to trace connections from user. Also how much times they spend.
jagger
  • 13
  • 2
0
votes
1 answer

How can I increase performance of AgensGraph?

My project entered testing phase. But I suffered lack of performance, when large dataset over than GigaBytes. Is there turnable parameters on AgensGraph?
santino
  • 9
  • 1
0
votes
1 answer

Unable to access to created graph on AgensGraph

Unalbe to access on graph after re-login. $ agens agens (AgensGraph 1.3, based on PostgreSQL 10.3) Type "help" for help. agens=# create graph graph; CREATE GRAPH agens=# match (n) return n; n --- (0 rows) agens=# \q $ agens agens (AgensGraph…
korey
  • 23
  • 2
0
votes
3 answers

How do i clear Screen on AGENS command line

How do i clear screen on the AGENS Command Line ? I tried using the following command cl scr clear screen clear cls Ctrl + L and most i could think of. Can you please help me?
Anish
  • 155
  • 1
  • 13
0
votes
1 answer

pg_dump is available in AgensGraph?

I know the function "pg_dump" for backup and restore. But I never tried because so scared. Question is simple. Can I use that function for graph data? Or Is the other function supported for that? There's no information in their documentation.
Kevin Lee
  • 121
  • 7
1 2 3 4 5
6
7 8