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

Query for returning edge

MATCH (a:Person)-[l:workWith]-(b:Person) RETURN a, l, b If I execute a query and it returns three values (start node, edge, and end node), how can I modify the query to retrieve only the information about the edge
M Jin
  • 11
  • 1
0
votes
2 answers

Returning edges taking too much times

SELECT * from cypher('age', $$ MATCH (V)-[R]-(V2) RETURN V,R,V2 as (V agtype, R agtype, V2 agtype); If there are only a few edges (e.g. around 100), queries can be executed quickly without much delay. However, if there are 500 or 1000 edges, it can…
M Jin
  • 11
  • 1
0
votes
1 answer

Error: received unencrypted data after SSL request

I have opened a TCP connection with the database server using: conn, err := net.Dial("tcp", "localhost:5432") Which is successful after that I am running this piece of code: _, err = conn.Write([]byte(query)) if err != nil { …
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
3 answers

Why is the ID of the 3 different vertices in the regression tests of apacheAGE the same?

So im reading through the apacheAGE regression tests and specifically this one https://github.com/apache/age/blob/master/regress/expected/age_global_graph.out and I've noticed that the ID returned for each vertex is the same. As far as i know the…
Panagiotis Foliadis
  • 254
  • 1
  • 1
  • 8
0
votes
3 answers

Convert Data in Relational Database to Apache AGE

I have data in structured from Tables (Rows and Columns). The tables have relations as well. I want to use that structured Data that is stored in PostgreSQL to convert it to Graph Data (Edges and Vertices). Is there any way to convert that data…
Muneeb Khan
  • 1
  • 11
0
votes
1 answer

Why the same query is being executed two times with the two methods?

def execCypher(conn:ext.connection, graphName:str, cypherStmt:str, cols:list=None, params:tuple=None) -> ext.cursor : if conn == None or conn.closed: raise _EXCEPTION_NoConnection cursor = conn.cursor() #clean up the string for…
Jawad Ali Abbasi
  • 32
  • 5
0
votes
2 answers

Why a query for a certain data type can also output other data type?

While going through the documentation (data-types) of Apache AGE, I ran into some interesting queries that demonstrated the input/output format of data types. Such as: - SELECT * FROM cypher('graph_name', $$ RETURN 1 $$) AS (int_result…
Bhaskar Sharma
  • 158
  • 8
0
votes
1 answer

Flags for ./configure During PostgreSQL Installation

I have blindly followed this tutorial for installing PostgreSQL and Apache AGE and would like to understand more about the process better. In the video, he has used a lot of options and flags for the ./configure command which I have copied…
Ken W.
  • 397
  • 1
  • 13
0
votes
2 answers

How to get Function arguments in Postgresql

I am changing pg-pool to cater cypher queries for Apache AGE and I have the following code, which takes the select statement. From that it gets the FROM clause, then from the FROM clause it gets the function names. So now I want that function…
Muhammad Zahid
  • 154
  • 8
0
votes
1 answer

Making shortest path with Apache AGE

I have been reading Jasper Blues' blog post : ROCK ’N’ ROLL TRAFFIC ROUTING, WITH NEO4J but I wanted to port it to AGE. He makes a graph with multiple vertices labeled as Metro and each vertex is connected to another one with an edge labeled as…
Matheus Farias
  • 716
  • 1
  • 10
0
votes
1 answer

What if PostgreSql introduce a new function with name "cypher" then how to distingush between cypher and sql query with cypher function

Currently, the structure of Apache-age query is: SELECT * FROM cypher(, ) I am not sure how PostgreSQL is able to distinguish between regular sql queries and Cypher queries after loading age extension. For now parsers can…
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
2 answers

Value of type 'Any' has no member 'int'. Unable to fetch count of rows from PostgresClientKit

I am trying to fetch the count of rows from the PostgreSQL database using PostgresClientKit but I am getting the following error Value of type 'Any' has no member 'int'. This is the code let rows = fetchSQL(statement: "SELECT count(*) FROM ag_graph…
Fahad Zaheer
  • 47
  • 1
  • 7
0
votes
2 answers

How to change the default directory structure of dh_make so that dpkg-buildpackage does not throw any errors

I am trying to create a debian package for a postgreSQL extension Apache-age release 1.1.1 and created the directory structure using dh_make command. The directory structure is as follows: age-1.1.1 (project root) ├── debian │   ├── changelog │  …
Sarthak
  • 380
  • 7
0
votes
1 answer

How to query using auto generated id and get know if it is an edge id or vertex id

Hot to query using the auto generated id in the apache age graph database. I want to get to know if it is edge id or a vertex id. For example i have an id 844424930131970. I know its somewhere within graph. But I don't know if its id for a vertex or…
Moontasir Mahmood
  • 107
  • 5
0
votes
3 answers

Apache AGE - Changing Labels of Nodes and Edges

Is there any possible way to change the current label of a vertex or an edge? For example, if I create a graph to store movies and series and then create the following vertex: SELECT * FROM cypher ('visual_arts', $$ CREATE (v:Movie {title: "The Last…
Matheus Farias
  • 716
  • 1
  • 10
1 2 3
…
27 28