ArangoDB Query Language (or AQL) is a declarative querying language used inside the multi-model database ArangoDB.
Questions tagged [aql]
448 questions
0
votes
1 answer
How to iterate nested JSON with ArangoDB?
I have JSON with next structure:
[[{"QID":1,"AID":1},{"SubAID":[]}],[{"QID":2,"AID":1},{"SubAID":[2,4]}],[{"QID":3,"AID":1},{"SubAID":[]}],{"MaxArea":"90","MinArea":"16"}]
Is this ok for ArangoDB? I tried to push it's with http-api (I don't have a…
Dmitry Bubnenkov
- 9,415
- 19
- 85
- 145
0
votes
2 answers
ArangoDB Getting the Index of a Document
Is there a way to get the index of a particular document in ArangoDB so as to use it in a LIMIT operation? For instance, let's say I look up a Document by it's ID and find that it's index is 534, then I would use that like this:
LIMIT 534,…
skinneejoe
- 3,921
- 5
- 30
- 45
0
votes
1 answer
Fulltext Search in arangodb using AQL and python
i have stored the data in arangodb in the following format:
{"data": [
{
"content": "maindb",
"type": "string",
"name": "db_name",
"key": "1745085839"
},
{
"type": "id",
"name": "rel",
"content": "1745085840",
"key":…
Mrityunjay Singh
- 477
- 5
- 11
0
votes
1 answer
ArangoDB - Performance issue with AQL query
I'm using ArangoDB for a Web Application through Strongloop.
I've got some performance problem when I run this query:
FOR result IN Collection SORT result.field ASC RETURN result
I added some index to speed up the query like skiplist index on the…
carmelolg
- 493
- 5
- 17
0
votes
1 answer
how to use indexes in arangodb graph search?
i'm evaluating ArangoDb for my application.
I have a data model like a file system, with a Items document collection and a ItemsParents edge collection with parent-child relations about Items.
Now i would like to find all childs of a specific item,…
Claudio
- 133
- 2
- 11
0
votes
1 answer
ArangoDB Query for consecutive matches to an array
In ArangoDB I need to search for a certain number of consecutive matches to an array within a document with an integer matrix.
Example document (all are int[5][5]):
nums:
25, 32, 26, 27, 29
01, 22, 15, 17, 99
12, 14, 17, 19, 88
16, 14, 12, 17,…
JosephG
- 3,111
- 6
- 33
- 56
0
votes
1 answer
ArangoDB - How can I return only the _id from AQL TRAVERSAL?
I want to return only the _id from edges and vertices from the p.path below.
LET from = (
FOR u IN products
FILTER u.name == 'pagfr21'
RETURN u._id
)
FOR p IN TRAVERSAL(products, productsrelated, from[0], 'outbound',
…
Ralf Stein
- 209
- 1
- 12
0
votes
1 answer
How to approximate execution time of ArangoDB count function
I am considering using ArangoDB for a new project of mine, but I have been unable to find very much information regarding its scalability.
Specifically, I am looking for some information regarding the count function. Is there a reliable way…
JosephG
- 3,111
- 6
- 33
- 56
0
votes
2 answers
ArangoDB graph operations via REST API
Is it possible to use AQL query language via REST API to make graph queries?
Thanks.
Ralf Stein
- 209
- 1
- 12
0
votes
1 answer
How to avoid footer using UTL function in plsql?
I have a csv file having header ,data and footer. The file(ABC.csv) look like this :
"A00",391,3456 --- header
"abcd",2324,"sdddd",58955
"dfgg",3444,"fffff',14455
"Z99",2 ----footer
I am using UTL…
y2j
- 207
- 3
- 5
- 13
0
votes
1 answer
KSH Script won't correctly when ran via Crontab job
I have KSH script.
If I run it manually using ./scriptname.ksh then it would work fine.
but if I set up a crontab job, I get error that AQL not found. (AQL is like SQL but not different).
Here is my script code.
#!/usr/bin/ksh
AQL << EOF
select…
user206168
- 1,015
- 5
- 20
- 40
-2
votes
1 answer
Arango single tree response using AQL only
I have found several questions that are similar but no solution worked as needed, or used internal functions. This is the most relevant one:
Getting data for d3 from ArangoDB using AQL (or arangojs)
I'm unable to understand how to return a single…
