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
1
vote
13 answers

Measuring Query Execution Time in Apache AGE Using AGE-Viewer-GO

I am currently working with Apache AGE for graph data management and I'm executing a set of queries using AGE-Viewer-GO. What I want to do now is measure the execution time of this (and other) queries. Is there a built-in function or feature in…
Kamlesh Kumar
  • 351
  • 1
  • 7
1
vote
6 answers

Loading JSON data into apache age viewer?

I want to load the following data to age. How to do that? what would be a good approach? Are there any specific tools to do it. Data: { "vertices": [ { "id": 1, "label": "Person", "properties": { "name": "John", …
Hammad Saleem
  • 375
  • 8
1
vote
2 answers

Graph is not showing in AGE Viewer for Edges

I am connecting the instance of AGE running on WSL to AGE Viewer running on Window. It is working fine. When I run query: SELECT * FROM cypher('university', $$ MATCH (v) RETURN v $$) as (v agtype); It works fine and show all the…
Muneeb Khan
  • 1
  • 11
1
vote
12 answers

Deleting vertex using cypher queries

While using the DELETE clause to delete a vertex in age. For example the following query SELECT * FROM cypher('graph_name', $$ MATCH (v:Useless) DELETE v $$) as (v agtype); Matches the vertex with the label Useless and thus deleting the vertex that…
Peter
  • 43
  • 4
1
vote
7 answers

How does `count` aggregation function in Apache AGE work?

This is the data setup from documentation: SELECT * FROM cypher('graph_name', $$ CREATE (:L {a: 1, b: 2, c: 3}), (:L {a: 2, b: 3, c: 1}), (:L {a: 3, b: 1, c: 2}) $$) as (a agtype); and this is the query: SELECT * FROM…
ahmed_131313
  • 142
  • 6
1
vote
2 answers

What's the correct typecast for a variable inside this query?

I was writing this cypher query as a function: CREATE OR REPLACE FUNCTION public.count_friends(name agtype) RETURNS agtype AS $function$ BEGIN SELECT * FROM cypher('graph_name', $$ MATCH (v:Person)-[]-(w) WHERE…
Wendel
  • 763
  • 1
  • 12
1
vote
1 answer

What is the ListCell struct hold in an apacheAGE list?

Im using the debugger on apacheAGE to understand better the source code. Ive come across multiple times the List struct and the ListeCell struct, since they are very common in holding and fetching information. Im having trouble what the ListCell…
Panagiotis Foliadis
  • 254
  • 1
  • 1
  • 8
1
vote
2 answers

Creating graphs and inserting vertices/edges in AGE's source code with GRAPH_global_context

I've been studying some of AGE's source code so that I can create functions to generate different kinds of graphs, such as the Barabási–Albert graph. Although another function like the create_complete_graph does show how to create a graph and insert…
Matheus Farias
  • 716
  • 1
  • 10
1
vote
2 answers

Is this supposed to be the expected behavior in context of orderability?

In regards to orderability between different agtypes: - https://age.apache.org/age-manual/master/intro/comparability.html I was testing the orderability between path and an edge, and I found this odd behavior: - Comparing a path with an edge with p…
Bhaskar Sharma
  • 158
  • 8
1
vote
9 answers

Predicting missing links using apache age

So I'm working on a project and I want to use Apache-Age to predict missing links or edges in a grapgh. I've searched through the documentation and forums, but I couldn't find any specific information on link/edge prediction with Apache Age. Here's…
Muhammad Awais Bin Adil
  • 51
  • 4
1
vote
4 answers

Cycle detection using directed graph with Apache-AGE and PostgreSQL

I am trying to detect cycles in a graph created on postgreSQl and Apache AGE. The schema for the graph is as follows: CREATE TABLE modules ( id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL, version VARCHAR(255) NOT NULL ); CREATE…
Muhammad Awais Bin Adil
  • 51
  • 4
1
vote
2 answers

Is it possible to update the type of property in Apache AGE?

Suppose I have an Apache AGE graph database 'books' in which some vertices have the pages property stored in different types, as shown in the examples below: SELECT * FROM cypher('books', $$ CREATE (v:Book {title: 'A book', pages: 10}) RETURN…
Carla
  • 326
  • 1
  • 7
1
vote
3 answers

Problem in usage of Apache AGE python driver after installation

I am getting start with Apache AGE python driver and learning about it, at the current time I am exploring the samples that was provided on GitHub so I have decided to go on with an online jupyter platform to test on [google-colab] is the selected…
Mohamed Mokhtar - rrrokhtar
  • 678
  • 5
  • 12
1
vote
2 answers

Managing and querying time-based events in Apache AGE graph database

I am working with the Apache AGE graph database extension for PostgreSQL, and I have a use case where I need to store and query time-based events. My dataset consists of various events occurring at different timestamps, and I want to efficiently…
leBoltzmann
  • 31
  • 5
1
vote
1 answer

execution plan modification

I was looking at how does the query works basically through EXPLAIN keyword which gives you an execution plan about what happens in order when you execute the query. So I was wondering if there is some way in which we can change the execution plan…
Umer Freak
  • 21
  • 3
1 2 3
…
27 28