Stack Overflow
Stack Overflow

Questions tagged [apache-age]

Use this tag for programming, integration and configuration questions related to using Apache AGE in your software project. Apache AGE is a extension to PostgreSQL which provides graph database capabilities.

Apache AGE is an extension to PostgreSQL providing graph database capabilities.

A core objective of Apache AGE, from their overview, is:

"to create single storage that can handle both relational and graph model data so that users can use standard ANSI SQL along with openCypher, the Graph query language."

Resources:

420 questions
0
votes
9 answers

How to use SQL with Agens Graph in AGCloud's AGViewer if possible

I'm trying to use the SQL syntax in Agens Graph but I don't know to use it. I tried the following query SELECT * FROM MATCH result = ()-[]->() RETURN result; Or SELECT * FROM GRAPH MATCH result = ()-[]->() RETURN result; but both gives me the…
Muhammad Farooq
  • 204
  • 10
0
votes
8 answers

Cannot connect to pgadmin runtime developer server

I am trying to follow the README for building the pgadmin runtime from https://github.com/pgadmin-org/pgadmin4/tree/master. As instructed, I activate my python virtual environment, then go into the runtime directory and run the following…
Ahmad Tashfeen
  • 21
  • 2
0
votes
3 answers

What are the necessary changes in AGE's source code to create functions to be used with openCypher syntax?

I wanted to create a function in AGE's source code so that it can be used with the openCypher syntax. I noticed that there are some commits that add these kinds of functions, such as #710 which implements the isEmpty() predicate function, and also…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
5 answers

How to use Apache AGE to connect one node to all nodes within a group of nodes?

So I have a csv with this header: start_id,strength,start_verse,end_verse Two line examples are these: 01001001,15,38012001,00000000 01001001,16,20008022,20008030 The first line means that the node with id 01001001 connects with strength 15 with…
MarkSoulz
  • 33
  • 4
0
votes
3 answers

Replication process terminated unexpectedly

I've set up Apache Age to replicate data in a PostgreSQL environment, however I'm running into a problem where the replication process abruptly ends. ERROR: replication process terminated unexpectedly I restarted the application again but the error…
Prachi
  • 39
  • 3
0
votes
7 answers

Cypher query to find locations in a given radius using latitude and longitude

I am trying to use Apache AGE to store geographical information. I have a table called locations that contains the following columns: id: The unique identifier of the location name: The name of the location latitude: The latitude of the…
Abdullah Zia
  • 17
  • 4
0
votes
5 answers

How to differentiate a Cypher clause from an SQL clause in C?

I am working on adding support for Cypher clauses on Postgres psql. So far, we have added if clauses with string comparison to separate Cypher clauses from SQL clauses, with one parser for each. The HandleCypherCmds() function calls the Cypher…
Carla
  • 326
  • 1
  • 7
0
votes
10 answers

Is there a way to see all the AGE created tables?

For example in a PostgreSQL database, all the other tables can be seen using \dt Or with SELECT * FROM pg_catalog.pg_tables; And we know that AGE creates its own label tables, vertex table, edge table. How can I see those tables, and how can I…
Bhaskar Sharma
  • 158
  • 8
0
votes
5 answers

Is there a way to query for vertices and edges in a single column in AGE?

Suppose that I want all vertices and edges (and paths) to be listed in a single column, ordered by their type, is it a possibility? The documentation does not say anything about that even though it does mention edge, path, vertex, map in…
Bhaskar Sharma
  • 158
  • 8
0
votes
7 answers

Cannot create node with label `User` in AGCloud

I'm using AGViewer on cloud with AGCloud, and I can not create a Node with Label User. I tried to create a Node with label User using the following query Create(u:User {name: 'user1', email: 'user1@email.com', phone: '1234-5678'}) RETURN u but I…
Muhammad Farooq
  • 204
  • 10
0
votes
2 answers

Loading nodes CSV to AGE with provided IDs returns "label_id must be 1 ... 65535"

I have a csv file that is not formatted in the correct way for AGE to load. I was on the task to transform it into a new one so that AGE could read it and create nodes, like it is specified in the documentation. For that, I created a python script…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
7 answers

Installing pl-debugger in Ubuntu 22.04

Facing issues while installing pl-debugger in Ubuntu 22.04 and following installation from this link. I tried to install pl-debugger in Ubuntu 22.04 but facing an error shown below: Error: ■ vinay@Vinay-Kumar-Tcarejo.: $ git clone…
Vinay Kumar Talreja
  • 1
  • 1
  • 8
0
votes
1 answer

Not able to Understand how to proceed with AgensGraph_v2.5.0

I am new to AgensGraph and I am done with the installation in Windows. After going through the installation guide, agens=# create graph test_graph; CREATE GRAPH agens=# set graph_path=test_graph; SET agens=# create(:test {name:’lastNotice’}); UPDATE…
Mahina Sheikh
  • 43
  • 5
0
votes
4 answers

How to use YAML to create a common node between two functions in Apache Age?

have two Python functions that each create a Person node in an Apache Age graph. I want to create a common Person node between these two functions that has the same properties. I've been told that YAML can be used to define a common configuration…
AmrShams07
  • 96
  • 1
  • 7
0
votes
2 answers

Retrieving Specific Characters with Specific Items in Database on Apache AGE

I'm currently working with a database that represents an RPG game. It contains nodes for characters, items, and locations. The relationships between these nodes are represented as 'HAS_ITEM' (between characters and items) and 'VISITED' (between…
MarkSoulz
  • 33
  • 4
1 2 3
…
27 28