Stack Overflow
Stack Overflow

Questions tagged [opencypher]

For questions related to openCypher, a declarative graph query language

openCypher, a declarative graph database query language, is an open source project, including a language specification, located at here and the specification is available here.

105 questions
0
votes
1 answer

Find all nodes containing capital letter in specific property value

I'm new to Neo4j. I want to fetch all nodes whose one of property for example name contains a capital character at any position. I saw the CONTAINS clause provided but was unable to use it with RegEx as Compiler does not accept =~ after CONTAINS…
nik
  • 1,464
  • 4
  • 18
  • 32
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
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
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
1 answer

Exists function in RedisGraph

I have a cypher query that works as expected in Neo4j but is failing for me in RedisGraph. So I have a query like this: MATCH (dp:DataProduct {name: 'DataProduct1'})-[:CONTAINS]->(t:Table {name: 'output_table'})-[:HAS_COLUMN]->(c:Column {name:…
Jonck van der Kogel
  • 2,983
  • 3
  • 23
  • 30
0
votes
5 answers

How to load elabels or vlabels from the name of CSV file in Apache-age

When loading edges or vertex from a CSV file in Apache-age We have to create Elabels and Vlabels manually and then mention those in queries for loading data. So the query becomes SELECT create_vlabel('agload_test_graph', 'Country'); //to create…
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
3 answers

Error while loading edges from CSV file in Apache-AGE, Errors says: Label_id must be 1 .. 65535

I am using this query to load edges from a CSV file in agload_test_graph, this graph is already being created. SELECT load_edges_from_file('agload_test_graph', 'has_city', …
Kamlesh Kumar
  • 351
  • 1
  • 7
0
votes
11 answers

Is it possible for a node to have multiple labels in Apache-AGE

Is it possible for a node to have more than one label attached to it? Is there a way to have something like this… CREATE (n:label1:label2)
Peter
  • 43
  • 4
0
votes
4 answers

Reading csv file produces error in Apache agedb

I am using Apache ageDB and trying to load data from the CSV file, but the reading operation fails after executing the program for some time. SELECT * FROM create_graph('neurond'); SELECT create_vlabel('neurond','entity'); SELECT * FROM…
Abdul
  • 69
  • 5
0
votes
10 answers

Apache Age: Regex in opencypher queries

Does Apache Age support opencypher queries with full regular expressions? I know you can use “.”, “*”, ”+”… but can full regex be used in comparison operators like =~, string functions like replace() etc…
Peter
  • 43
  • 4
0
votes
1 answer

db.contraints() is not known in higher version of Neo4j. Error while using GraphXR to save to database

I am using GraphXR with Neo4j. When trying to save the graph to neo4j, I am presented with the following error:- There is no procedure name 'db.constraints()'. I am using v5.3.0. I know that the above procedure is deprecated but is there a…
Aibhinav Upadhyay
  • 1
0
votes
1 answer

Optimizing / rewriting redisgraph query / schema

I am working on an OSS project called deps-graph, basically I download data from https://static.crates.io/db-dump.tar.gz and then pre-process them and connect crate versions together based on how they depend on each other (meaning that I work with a…
TDiblik
  • 522
  • 4
  • 18
0
votes
3 answers

How to make calculations with properties from different edges

I was making a graph for a recommendation system and added vertices for users, categories and products and edges to represent the connections between them. One product may have connections to categories and a rating as a property for them. Users can…
Matheus Farias
  • 716
  • 1
  • 10
1 2 3
4
5 6 7