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
2 answers

migrating to agensgraph create foreign table error

So, I'm taking a first look at migrating a PostgreSQL db to agensgraph db. I'm using the manual https://bitnine.net/wp-content/uploads/2016/11/AgensGraph_Quick_Guide.pdf first export as csv: SET CLIENT_ENCODING TO 'utf8'; \COPY samples.samples TO…
Spatial Digger
  • 1,883
  • 1
  • 19
  • 37
0
votes
1 answer

"LIKE" operator does not work on agensgraph

I want to find a name using LIKE operator. There is no LIKE operator on AgensGraph. santino=# match (n:v) where n.name like 'j%' return n.name; ERROR: syntax error at or near "like" LINE 1: match (n:v) where n.name like 'j%' return n.name; Is…
santino
  • 9
  • 1
0
votes
1 answer

How to load file on AgensGraph?

I tried to load comma separated file on agensgraph. But agensgraph does not have load utility on package. How can I load file on agensgraph?
mekhi
  • 13
  • 3
0
votes
1 answer

How to use graph data type using by pl/python in AgensGraph?

I am using AgensGraph. I know the PostgreSQL supports pl/python driver. So I think the AgensGraph supports it, too. If I want to use a graph data type using by pl/python, is the way same with general data?
Kevin Lee
  • 121
  • 7
0
votes
2 answers

Inserting nodes in Agensgraph through Python and cypher

In this example I am trying to add a new author node taking the variables from outside the cypher code. This method works on normal PostgreSQL code but I'm trying to get the syntax right to allow python to do it for me. I've imported pyscopg2 and…
Spatial Digger
  • 1,883
  • 1
  • 19
  • 37
0
votes
1 answer

Can I use AgensGraph just to migrate data?

AgensGraph is installed and used on my other servers. Well, I am using PostgreSQL on one server. I would like to change that server to AgensGraph, which has a lot of data stored there. So can I do data migration to AgensGraph like using pg_dump?…
Kevin Lee
  • 121
  • 7
0
votes
0 answers

Can I use full PostgreSQL functions on AgensGraph?

AgensGraph is multi-model database based on PostgreSQL. The thing what I wonder is, so can I use the PostgreSQL function like abs(), go_dist() with graph data? If so, is there something to set configurations for that?
Kevin Lee
  • 121
  • 7
0
votes
2 answers

How to create index on AgensGraph?

When traverse vertex or egde, It is very slow. I want to create index for accelerating speed. # match (n:v{id:1}) return n; n ----------------- v[3.1]{"id": 1} (1 row) Time: 693.100 ms How can I create index for vertex or edge?
Kurt Bender
  • 31
  • 3
0
votes
2 answers

How to use "group by" query on AgensGraph?

I tried to use "group by" query on AgensGraph. But, there is no "group by" clause on CYPHER. How can I use "group by" on query.
Lee Owens
  • 11
  • 2
0
votes
1 answer

How to remove all nodes & edges on AgensGraph?

After testing several cases on AgensGraph. I try to new test. but undesired result returns. How can I remove all old data.
Kurt Bender
  • 31
  • 3
0
votes
1 answer

How to delete node on AgensGraph?

I try to delete node on agens graph and failed. lee=# match (n:v{id:1}) delete n; ERROR: vertex 4 in "v" has edge(s) How to delete node?
Lee Owens
  • 11
  • 2
0
votes
1 answer

How to create node on AgensGraph?

After connected to AgensGraph. I try to create node on AgensGraph. But, there is a error on action. kurt=# create (:v{id:1}); ERROR: graph_path is NULL HINT: Use SET graph_path How to set graph_path?
Kurt Bender
  • 31
  • 3
0
votes
1 answer

How can I make node or edge label CREATE in AgensGraph?

I have been making a text analysis system with AgensGraph. And I use the SPO model of RDF triple structure as graph-schema. But I faced one problem: AgensGraph doesn't allow CREATE labels. I think CREATE is one of reserved word in AgensGraph. Is…
G.-G.
  • 62
  • 6
0
votes
1 answer

ERROR: only one relationship type is allowed for MERGE open cypher query agensgraph

Is the below realtionship creation allowed in open cypher query I am trying this in agensgraph, MATCH (mc: mat_comp) MATCH (p:plant) MATCH (mb: material) WHERE mc.component = mb.material and mc.plant=p.b_plant MERGE (mc) <- [ comp_2_p] - (…
vinsent paramanantham
  • 953
  • 3
  • 15
  • 34
0
votes
1 answer

Cypher query: How to compute cosine similarity in Agensgraph, and SAP HANA

I wanna test simple graph analysis performance among GraphDBes using cypher. I referred this site and reproduce the example in Neo4j, Agensgraph, SAP HANA, and Redis. but the cypher query(see below) is not operate in Agensgraph, and SAP HANA. MATCH…
G.-G.
  • 62
  • 6
1 2 3 4 5 6
7
8