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

exists ( ) function not working as expected

I used exists() function to check if a given vertex is present in graph. It should have returned true but it is giving a error. SELECT * FROM cypher ('test', $$ MATCH (n {val: 13}) RETURN EXISTS(n) $$) AS (res agtype);
Muhammad Abdullah
  • 1
  • 5
0
votes
9 answers

How to get MATCH ... WHERE {path_with_properties} to work in AGE

According to the Neo4j documentation about the WHERE clause, I should be able to filter the search using patterns with properties such as this: SELECT * FROM cypher('test', $$ MATCH (n:Person) WHERE (n)-[:KNOWS]-({name: 'Timothy'}) …
Ken W.
  • 397
  • 1
  • 13
0
votes
7 answers

Recommened way to create from a table generally

What is the recommended way to create a graph from a table (or from an SQL query, in general)? Say, we have a table A with fields id and parent_id, where the latter refers back to the former of some row. How would I go about and cast this into an…
Aadil Bashir
  • 111
  • 5
0
votes
2 answers

Returning vertices if the relationship is not present or if property in the edge is less than necessary

I have created a graph to store LEGO products, the pieces of which each product requires, and the pieces that users already have. There are three labels for the vertices: Piece, Product, and User, and there are two labels for the edges: REQUIRES and…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
1 answer

How to upload edges via CSV file if nodes have null IDs in Apache AGE - Error: "label_id must be 1 .. 65535"

So I'm trying to upload graphs from CSV file in apache age. For that I'm using the following commands, SELECT create_graph('test_graph'); SELECT create_vlabel('test_graph','movie'); SELECT…
Sarthak
  • 380
  • 7
0
votes
7 answers

How can we use filter in Apache age for condition?

In postgreSQL, we can use filter such as- SELECT column_name, SUM(sales) FILTER (WHERE year = 2022) AS total_sales_2022, SUM(sales) FILTER (WHERE year = 2023) AS total_sales_2023 FROM sales_table GROUP BY column_name; How can we…
MAHMUDUL
  • 1
  • 2
0
votes
4 answers

Error "Named_Labels" already exist in Apache-age

I am attempting to use the Apache-AGE query SELECT create_vlabel('testdb', 'cities');, but it returns the error message: "Label 'cities' already exists." How can I modify the query to ensure that it only runs if the label does not already exist?
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
5 answers

Conflicts on Trying to Prevent SQL Clauses Entering Cypher Parser

I am working on a project to add support for Cypher queries on psql to Apache AGE. Currently, to create a graph with Apache AGE, we need to specify a Cypher query inside the SQL query. For example: SELECT * FROM cypher('graph_name', $$ MATCH…
Carla
  • 326
  • 1
  • 7
0
votes
6 answers

Facing an error :could not connect to replication endpoint

I am trying to connect to the replication endpoint in a data replication setup. I am using Apache Age. I am not able to establish a connection to the replication endpoint even after making the necessary settings and configuration and getting this…
Prachi
  • 39
  • 3
0
votes
1 answer

Alternative to loading CSV files in Apache-age without acessing the local-path

I am implementing the functionality to upload CSV files on the Apache-age browser to generate graphs. However, the query for generating nodes or edges from CSV files requires the local path to the CSV files. Web browsers do not provide access to the…
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
5 answers

Getting ERROR: replication slot 'slot_name' does not exist

I'm trying to set up data replication between PostgreSQL databases using Apache Age and I am getting an error message like this: "replication slot 'slot_name' does not exist". I was expecting the primary database's replication slot to be established…
Prachi
  • 39
  • 3
0
votes
7 answers

pg_regress: initdb failed , while trying to run make installcheck command for Apache AGE

I have installed PostgreSQL ( PG11 ) and using the AGE source code of master branch ( supports PG11 ), also I do the make install command successfully , LOAD AGE and use it smoothly without problems. But now I am trying to run the make installcheck…
David George
  • 318
  • 1
  • 5
0
votes
1 answer

How to add "expensive_meter" property to vertices in a graph database based on their relation to item prices?

I have a graph database that stores data for restaurants and their menu items. The database has vertices labeled "Restaurant" and "Item", and an "Item" vertex is connected to a "Restaurant" vertex by an "OFFERS" edge. Each item in the database has…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
6 answers

Integration of PostgreSQL Native Functions in AGE

Is there any method to incorporate PostgreSQL native functions into AGE? I'm aware that PostgreSQL functions can be invoked using DirectFunctionCallX, but this requires modifying the AGE code. Is there an alternative approach available?
Muhammad Abdullah
  • 1
  • 5
0
votes
8 answers

How to delete and return an edge in Age (Apache AGE) by matching its properties

I am using Age (Apache AGE), a PostgreSQL extension for graph databases. I have a graph called sample_graph with Car and Country nodes, connected by MadeIn edges. Currently, my MadeIn edges do not have any properties. I want to delete a specific…
AmrShams07
  • 96
  • 1
  • 7
1 2 3
…
27 28