Stack Overflow
Stack Overflow

Questions tagged [aql]

ArangoDB Query Language (or AQL) is a declarative querying language used inside the multi-model database ArangoDB.

448 questions
0
votes
0 answers

How to do an effective Arangodb search which has 1,000 nodes' hop[1..1] and then merge all into one graph?

I'm getting stuck in such a problem now, I'd like to run 1,000 AQLs, each of them does a one node hop[1..1] search with a filter[in the rest 999 nodeIds]. And then I need to merge all 1,000 graphs into one result. Timeout issues(60s) always come…
Billy Yuan
  • 1
  • 1
0
votes
1 answer

How to store locations in ArangoDB?

I am building a web application where I need to store a large number of unique addresses as nodes in ArangoDB. One approach would be using a hierarchical graph model: a country node connected to county nodes, county nodes connected to cities and…
Peter Agoston
  • 3
  • 1
0
votes
1 answer

Retrieve all documents from ArangoDB collection, with an offset

Is there a way to retrieve all documents, but with an offset? or do I need to specify the amount of doucments i want? For example: LIMIT 5,"ALL" to retrieve all documents except the first 5.
Jason
  • 387
  • 3
  • 13
0
votes
1 answer

Set all Attributes of Document to the values of nested query

In my ArangoDB I'm trying to implement some kind of inheritance. I have a parent-document which defines all of its children. So, the values are all the same, except for an Inheritance-ID. So given the case the parent-document has values like: ID:…
Qohelet
  • 1,459
  • 4
  • 24
  • 41
0
votes
1 answer

Slow AQL and data type conversion, how can I improve my AQL performance?

Hello ArangoDB community, I have imported two collections from sqlite to ArangoDB with arangoimport (via a CSV). Next, I try to run a simple AQL to cross reference these collections (with an end goal to connect them via edges). Collection1 has…
Marumba
  • 359
  • 3
  • 12
0
votes
1 answer

ArangoDB AQL Updating Strange Attribute Names

In arangodb I have a Lookup Table as per below: { '49DD3A82-2B49-44F5-A0B2-BD88A32EDB13' = 'Human readable value 1', 'B015E210-27BE-4AA7-83EE-9F754F8E469A' = 'Human readable value 2', 'BC54CF8A-BB18-4E2C-B333-EA7086764819' = 'Human readable…
DWD
  • 1
0
votes
2 answers

How to check if ArangoDB query is not empty?

I would like to make an exists PostgreSQL query. Let's say I have a Q ArangoDB query (AQL). How can I check if Q returns any result? Example: Q = "For u in users FILTER 'x@example.com' = u.email" What is the best way to do it (most performant)? I…
Robert Zaremba
  • 8,081
  • 7
  • 47
  • 78
0
votes
1 answer

ArangoDB HTTP/AQL CREATE INDEX

To ensure unique edges in my edge collection I can index _from and _to fields as mentioned in the documentation db.edges.ensureIndex({ type: "hash", fields: [ "_from", "_to" ], unique: true }); The above operation can only be performed from…
Neel Basu
  • 12,638
  • 12
  • 82
  • 146
0
votes
0 answers

How to find edges with Spring Data ArangoDB

When using AQL directly to find edge documents, with a query like FOR x IN coll1ToColl2 FILTER x._from == 'coll1/1234' RETURN x the expected edge documents are returned, but when supplying 'coll1/1234' to a Spring Data ArangoDB repository query…
Bjorn Thor Jonsson
  • 827
  • 1
  • 10
  • 21
0
votes
1 answer

Can I filter multiple collections?

I want to filter multiple collections, to return only documents who have those requirements, the problem is when there is more than one matching value in one collection, the elements shown are repeated. FOR TurmaA IN TurmaA FOR TurmaB IN…
P3TAR
  • 5
  • 3
0
votes
2 answers

Query code for finding highest value of collections?

I'm new to arango, and want to find the highest value(located in a content object) from a group of collections, i have tried to use MAX but that didn't work.
P3TAR
  • 5
  • 3
0
votes
1 answer

ArangoDB graph traversal not utilizing combined index

I have those two queries, which should - based on my understanding - do basically the same. One is doing a filter on my edge collection and is performing very well, while the other query is doing a graph traversal of depth 1 and performs quite poor,…
Horrorente
  • 314
  • 3
  • 13
0
votes
1 answer

Multiple text search in Qradar AQL

how can i search multiple text in Qradar AQL? the IN function works only for IP address. I want to search like below, any alternate options? WHERE URL NOT ILIKE IN ('%.com%', '%.net%')
SJL
  • 1
  • 2
0
votes
2 answers

Generate a random string using ArangoDB's AQL?

Using AQL (preferably in the ArangoDB WebUI), is it possible to generate a random string or letters and numbers similar to this: 4EKH5G3AN6HH? If not, what is another way to do it without doing it in application code?
BugBuddy
  • 576
  • 2
  • 5
  • 19
0
votes
1 answer

How to enforce constraints on document attribute values in ArangoDB?

I would like documents in a collection to have values that are restricted to a small set of values. For example, a document's my_type attribute can be set to a value of only one of a, b, c, or d. How can this be done in ArangoDB? I do not wish to do…
BugBuddy
  • 576
  • 2
  • 5
  • 19
1 2 3
…
29 30