# AQL **URL:** https://discuss.aerospike.com/c/tools/aql/49.md [Latest](https://discuss.aerospike.com/latest.md) · [Categories](https://discuss.aerospike.com/categories.md) · [Tags](https://discuss.aerospike.com/tags.md) --- ## [About the AQL category](https://discuss.aerospike.com/t/about-the-aql-category/291)
**Author:** [@kporter](https://discuss.aerospike.com/u/kporter)\ **Replies:** 0
Discuss the Aerospike Query Language (AQL) Tool. --- ## [Meaning of edigest field being "n/a" in a record?](https://discuss.aerospike.com/t/meaning-of-edigest-field-being-n-a-in-a-record/11399)
**Author:** [@iandntran](https://discuss.aerospike.com/u/iandntran)\ **Replies:** 3\ **Last updated:** [August 21, 2024, 4:03pm UTC](https://discuss.aerospike.com/t/meaning-of-edigest-field-being-n-a-in-a-record/11399 "2024-08-21T16:03:35Z")
Hi, I noticed that in a select query I ran, with record print metadata set to true, the edigest of the field was set to “n/a”. I thought the digest is always calculated using the primary key, or is it dependent on some … --- ## [How to sindex in aql queries on map bins](https://discuss.aerospike.com/t/how-to-sindex-in-aql-queries-on-map-bins/11058)
**Author:** [@PKuchibhatla](https://discuss.aerospike.com/u/PKuchibhatla)\ **Replies:** 22\ **Last updated:** [May 28, 2024, 6:18am UTC](https://discuss.aerospike.com/t/how-to-sindex-in-aql-queries-on-map-bins/11058 "2024-05-28T06:18:33Z")
How to use sindex in aql queries on map bins --- ## [How to create and use sindex in aql for mapbins](https://discuss.aerospike.com/t/how-to-create-and-use-sindex-in-aql-for-mapbins/11057)
**Author:** [@PKuchibhatla](https://discuss.aerospike.com/u/PKuchibhatla)\ **Replies:** 1\ **Last updated:** [May 3, 2024, 5:01pm UTC](https://discuss.aerospike.com/t/how-to-create-and-use-sindex-in-aql-for-mapbins/11057 "2024-05-03T17:01:25Z")
Can any one help me out with the sindex for map bin in a set . how to set index on a specific key --- ## [Select \* from \.\ ------ throws UNSUPPORTED\_FEATURE Error](https://discuss.aerospike.com/t/select-from-namespace-set-name-throws-unsupported-feature-error/10863)
**Author:** [@Rupinder\_Guron](https://discuss.aerospike.com/u/Rupinder_Guron)\ **Replies:** 2\ **Last updated:** [March 1, 2024, 4:38am UTC](https://discuss.aerospike.com/t/select-from-namespace-set-name-throws-unsupported-feature-error/10863 "2024-03-01T04:38:34Z")
Select \* from dev.foo ----fails with AEROSPIKE\_ERR\_UNSUPPORTED\_FEATURE while select \* from dev.foo where PK='134' works fine I am running both aerospikedb and aerospike-tools on mac — Docker Docker images being used: a… --- ## [Is it possible to insert multiple records at a time in aerospike server through a single query?](https://discuss.aerospike.com/t/is-it-possible-to-insert-multiple-records-at-a-time-in-aerospike-server-through-a-single-query/10332)
**Author:** [@sagar](https://discuss.aerospike.com/u/sagar)\ **Replies:** 2\ **Last updated:** [July 18, 2023, 5:14am UTC](https://discuss.aerospike.com/t/is-it-possible-to-insert-multiple-records-at-a-time-in-aerospike-server-through-a-single-query/10332 "2023-07-18T05:14:56Z")
I want to insert multiple records at a time by using a single query just like we are doing in SQL.is it possible in aerospike or not? --- ## [AQL is missing in new version of Aerospike docker image](https://discuss.aerospike.com/t/aql-is-missing-in-new-version-of-aerospike-docker-image/9939)
**Author:** [@Stepanov](https://discuss.aerospike.com/u/Stepanov)\ **Replies:** 2\ **Last updated:** [January 3, 2023, 8:16pm UTC](https://discuss.aerospike.com/t/aql-is-missing-in-new-version-of-aerospike-docker-image/9939 "2023-01-03T20:16:48Z")
Hi guys, I pulled an aerospike:ce-6.2.0.2 docker image. I found that version doesn’t have AQL support like a version before. I’m trying to run Aerospike on MacOS with arm64 architecture. --- ## [How to create a AQL query corresponding to a Java Key object](https://discuss.aerospike.com/t/how-to-create-a-aql-query-corresponding-to-a-java-key-object/8571)
**Author:** [@shan.p](https://discuss.aerospike.com/u/shan.p)\ **Replies:** 1\ **Last updated:** [June 27, 2021, 5:58pm UTC](https://discuss.aerospike.com/t/how-to-create-a-aql-query-corresponding-to-a-java-key-object/8571 "2021-06-27T17:58:38Z")
I have a Java project where I can view (debug) the Key of every record saved in the namespace. This is my Key value when printed to String: {Key@11379} "namespace:null:u17c3304e-9c9b-4905-9889-a9cf2b26dc9c:948b5799fd2f6d… --- ## [How to pass multiple PK in the AQL Select query?](https://discuss.aerospike.com/t/how-to-pass-multiple-pk-in-the-aql-select-query/8543)
**Author:** [@vivekjha155](https://discuss.aerospike.com/u/vivekjha155)\ **Replies:** 4\ **Last updated:** [June 22, 2021, 5:14pm UTC](https://discuss.aerospike.com/t/how-to-pass-multiple-pk-in-the-aql-select-query/8543 "2021-06-22T17:14:29Z")
How to pass multiple PK in the AQL Select \* from namespace.setName where PK command? --- ## [Specifying Infinite timeout in aql](https://discuss.aerospike.com/t/specifying-infinite-timeout-in-aql/7612)
**Author:** [@asifansari80](https://discuss.aerospike.com/u/asifansari80)\ **Replies:** 0\ **Last updated:** [July 6, 2020, 9:41am UTC](https://discuss.aerospike.com/t/specifying-infinite-timeout-in-aql/7612 "2020-07-06T09:41:20Z")
Is there any way to give an infinite timeout with option -T on aql ? Will specifying -1 is the solution ? I checked the aql doc here, there is no info. --- ## [Aerospike\_err\_server\_full](https://discuss.aerospike.com/t/aerospike-err-server-full/7497)
**Author:** [@bindto](https://discuss.aerospike.com/u/bindto)\ **Replies:** 21\ **Last updated:** [June 15, 2020, 5:10pm UTC](https://discuss.aerospike.com/t/aerospike-err-server-full/7497 "2020-06-15T17:10:25Z")
Please explain how deletion works in term to release resources. Aerospike Community Edition build 5.0.0.3 Filled in set “test” by data until defined memory for namespace is full and got AEROSPIKE\_ERR\_SERVER\_FULL. Delet… --- ## [AQL select with PK](https://discuss.aerospike.com/t/aql-select-with-pk/3314)
**Author:** [@Brent212](https://discuss.aerospike.com/u/Brent212)\ **Replies:** 9\ **Last updated:** [June 9, 2020, 5:02pm UTC](https://discuss.aerospike.com/t/aql-select-with-pk/3314 "2020-06-09T17:02:30Z")
I’m using a Java application to write/read records. It inserts a record with the key in the form of a byte array as illustrated with the following code, where client is an AerospikeClient object: void insertRow(byte\[\] k… --- ## [AQL: PK in a SELECT](https://discuss.aerospike.com/t/aql-pk-in-a-select/292)
**Author:** [@kporter](https://discuss.aerospike.com/u/kporter)\ **Replies:** 7\ **Last updated:** [June 9, 2020, 5:01pm UTC](https://discuss.aerospike.com/t/aql-pk-in-a-select/292 "2020-06-09T17:01:26Z")
by simonc » Mon Jul 07, 2014 6:37 am When I do a SELECT I don’t seem to be able to get the PK of a row. Example: aql\> select firstName, PK from test.user +-----------------+ | firstName | +-----------------+ | "firstNa… --- ## [AQL redirecting to old openssl libary](https://discuss.aerospike.com/t/aql-redirecting-to-old-openssl-libary/6980)
**Author:** [@lioz](https://discuss.aerospike.com/u/lioz)\ **Replies:** 1\ **Last updated:** [December 30, 2019, 7:21pm UTC](https://discuss.aerospike.com/t/aql-redirecting-to-old-openssl-libary/6980 "2019-12-30T19:21:43Z")
Hi, so i upgraded my OpenSSL yesterday, and today when i try to run aql, this is the error im getting: (i’m running it on MacOS) $ aql dyld: Library not loaded: /usr/local/opt/openssl/lib/libssl.1.0.0.dylib Referenced fr… --- ## [Unknown Namespace Error with AQL](https://discuss.aerospike.com/t/unknown-namespace-error-with-aql/6770)
**Author:** [@abhishek.pathak](https://discuss.aerospike.com/u/abhishek.pathak)\ **Replies:** 5\ **Last updated:** [November 1, 2019, 11:11pm UTC](https://discuss.aerospike.com/t/unknown-namespace-error-with-aql/6770 "2019-11-01T23:11:17Z")
Hello Devs, So I just started with Aerospike and I am facing this unknown namespace error quite frequently. Specs: Ubuntu 18.04 Aerospike 4.7.0.2 - Community edition Steps: I configured aerospike.conf with new nam… --- ## [AQL Syntax: Insert multiple records](https://discuss.aerospike.com/t/aql-syntax-insert-multiple-records/6498)
**Author:** [@arthur.putnam](https://discuss.aerospike.com/u/arthur.putnam)\ **Replies:** 1\ **Last updated:** [July 23, 2019, 1:16am UTC](https://discuss.aerospike.com/t/aql-syntax-insert-multiple-records/6498 "2019-07-23T01:16:08Z")
I am trying to find the proper syntax for inserting multiple records via aql. I have found this to be helpful: AQL | Aerospike Documentation but I am having trouble finding the proper syntax for inserting multiple rows. … --- ## [Enabling durable-delete in AQL](https://discuss.aerospike.com/t/enabling-durable-delete-in-aql/5782)
**Author:** [@vishal14101993](https://discuss.aerospike.com/u/vishal14101993)\ **Replies:** 1\ **Last updated:** [December 17, 2018, 7:16pm UTC](https://discuss.aerospike.com/t/enabling-durable-delete-in-aql/5782 "2018-12-17T19:16:53Z")
In C client, by default the deleted records are not tombstoned. However, we can enable durable delete in the ‘remove policy’. Likewise, I’m assuming that AQL doesn’t tombstone the deleted record by default. So, when dele… --- ## [AQL command for getting the count of distinct values in a particular bin of the set](https://discuss.aerospike.com/t/aql-command-for-getting-the-count-of-distinct-values-in-a-particular-bin-of-the-set/5731)
**Author:** [@vishal14101993](https://discuss.aerospike.com/u/vishal14101993)\ **Replies:** 1\ **Last updated:** [November 30, 2018, 5:21pm UTC](https://discuss.aerospike.com/t/aql-command-for-getting-the-count-of-distinct-values-in-a-particular-bin-of-the-set/5731 "2018-11-30T17:21:54Z")
Is there an AQL command for getting the count of the number of distinct values in a particular bin of a given set? If not is there any other shorter way? --- ## [List Append with JSON](https://discuss.aerospike.com/t/list-append-with-json/5694)
**Author:** [@Rajczyk](https://discuss.aerospike.com/u/Rajczyk)\ **Replies:** 3\ **Last updated:** [November 23, 2018, 12:56am UTC](https://discuss.aerospike.com/t/list-append-with-json/5694 "2018-11-23T00:56:28Z")
Hello, I’ve just started looking into aerospike as it might be a solution to a problem I am looking at. I want to be able to do something like this: OPERATE LIST\_APPEND(ListBin, 'JSON\[1,2,3\]'), MAP\_INCREMENT(countBin,… --- ## [Not able to login using "admin":"admin" password in AQL](https://discuss.aerospike.com/t/not-able-to-login-using-admin-admin-password-in-aql/5359)
**Author:** [@rocky](https://discuss.aerospike.com/u/rocky)\ **Replies:** 5\ **Last updated:** [July 23, 2018, 2:06am UTC](https://discuss.aerospike.com/t/not-able-to-login-using-admin-admin-password-in-aql/5359 "2018-07-23T02:06:19Z")
I am trying to login to aql using below command. aql -Uadmin -P Seed: 127.0.0.1 User: admin Config File: /etc/aerospike/astools.conf /home/username/.aerospike/astools.conf Enter Password: and using pa… --- ## [Issues when selecting an existing row in AQL](https://discuss.aerospike.com/t/issues-when-selecting-an-existing-row-in-aql/4909)
**Author:** [@Stanimir\_Genov](https://discuss.aerospike.com/u/Stanimir_Genov)\ **Replies:** 1\ **Last updated:** [February 2, 2018, 8:37pm UTC](https://discuss.aerospike.com/t/issues-when-selecting-an-existing-row-in-aql/4909 "2018-02-02T20:37:15Z")
I have a namespace and a set in aerospike with information inside. After performing a SELECT \* FROM mytecache.search\_results I get around 600 rows of this: "bdee9a37e3217f28a057b5e0ebbef43f\_Sabre\_13" | "a:11:{s:5:"pr… --- ## [Last version OSX AQL not working](https://discuss.aerospike.com/t/last-version-osx-aql-not-working/4871)
**Author:** [@Oxy](https://discuss.aerospike.com/u/Oxy)\ **Replies:** 2\ **Last updated:** [January 20, 2018, 11:50am UTC](https://discuss.aerospike.com/t/last-version-osx-aql-not-working/4871 "2018-01-20T11:50:07Z")
Hello, Just installed last version Aerospike Tools on OSX (10.13.2 (17C205)) and aql stopped working. dyld: Library not loaded: /usr/local/lib/libssl.1.1.dylib Referenced from: /usr/local/bin/aql Reason: image not foun… --- ## [Aerospike\_err\_index](https://discuss.aerospike.com/t/aerospike-err-index/4688)
**Author:** [@ivcode](https://discuss.aerospike.com/u/ivcode)\ **Replies:** 2\ **Last updated:** [December 12, 2017, 2:49pm UTC](https://discuss.aerospike.com/t/aerospike-err-index/4688 "2017-12-12T14:49:52Z")
I’m considering aerospike for one of our projects. So I currently created a 3 node cluster and loaded some data on it. Sample data ns = imei, set = imei\_data +-------------------+-----------------------+---------------… --- ## [Trouble With Spatial Query in AQL](https://discuss.aerospike.com/t/trouble-with-spatial-query-in-aql/4804)
**Author:** [@jmaupin](https://discuss.aerospike.com/u/jmaupin)\ **Replies:** 0\ **Last updated:** [December 11, 2017, 5:00am UTC](https://discuss.aerospike.com/t/trouble-with-spatial-query-in-aql/4804 "2017-12-11T05:00:30Z")
Hi all, I am unable to get the following to work in AQL. The query returns all results, disregarding the WHERE predicate. Java API works fine. Any thoughts? Thanks in advance. // Aerospike Community Edition build 3.15.… --- ## [Select statement not showing all bins at client aql](https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656)
**Author:** [@nikhil\_bandal](https://discuss.aerospike.com/u/nikhil_bandal)\ **Replies:** 4\ **Last updated:** [October 4, 2017, 5:57am UTC](https://discuss.aerospike.com/t/select-statement-not-showing-all-bins-at-client-aql/4656 "2017-10-04T05:57:12Z")
I have install aerospike on one server and client on another server and insert a record from server side AQL. Inserted record have 55 bins, when i query it from server side aql it shows all 55 bins for that record, but i… --- ## [AQL: drop set](https://discuss.aerospike.com/t/aql-drop-set/1007)
**Author:** [@Alexey\_Martynov](https://discuss.aerospike.com/u/Alexey_Martynov)\ **Replies:** 14\ **Last updated:** [July 21, 2017, 5:43pm UTC](https://discuss.aerospike.com/t/aql-drop-set/1007 "2017-07-21T17:43:44Z")
Which aql command I can use to drop set? ex: drop test.testset --- ## [Aerospike\_err\_cluster](https://discuss.aerospike.com/t/aerospike-err-cluster/4217)
**Author:** [@Akita](https://discuss.aerospike.com/u/Akita)\ **Replies:** 2\ **Last updated:** [July 6, 2017, 5:46am UTC](https://discuss.aerospike.com/t/aerospike-err-cluster/4217 "2017-07-06T05:46:57Z")
Hi all, I have a new error. When i run “select \* from test.users where pk=1” or run a query to insert into, result always is: “Error: (11) AEROSPIKE\_ERR\_CLUSTER” I spend over 1 hour but cannot fix it. Anyone can take … --- ## [How to get null values of record using AQL](https://discuss.aerospike.com/t/how-to-get-null-values-of-record-using-aql/4334)
**Author:** [@Ashu](https://discuss.aerospike.com/u/Ashu)\ **Replies:** 1\ **Last updated:** [July 6, 2017, 7:32am UTC](https://discuss.aerospike.com/t/how-to-get-null-values-of-record-using-aql/4334 "2017-07-06T07:32:17Z")
Hello I want to fetch the data of null values in the records using aql in that attached file one of record does not have name ,so how can i get that record ?? ex : select emails from test.demo where name = NULL If i… --- ## [Aerospike support map with integer type key?](https://discuss.aerospike.com/t/aerospike-support-map-with-integer-type-key/4196)
**Author:** [@RockyTu](https://discuss.aerospike.com/u/RockyTu)\ **Replies:** 2\ **Last updated:** [May 30, 2017, 11:07pm UTC](https://discuss.aerospike.com/t/aerospike-support-map-with-integer-type-key/4196 "2017-05-30T23:07:15Z")
I use Aerospike community 3.8.3, I found a wired behavior. The behavior is different between java client and AQL tool. I suppose Aerospike don’t support MAP with integer type key. for example as following, aql\> INSERT IN… --- ## [Aql select command encounters timeout issue when another scan job for different set is running](https://discuss.aerospike.com/t/aql-select-command-encounters-timeout-issue-when-another-scan-job-for-different-set-is-running/4056)
**Author:** [@RockyTu](https://discuss.aerospike.com/u/RockyTu)\ **Replies:** 6\ **Last updated:** [April 13, 2017, 2:56am UTC](https://discuss.aerospike.com/t/aql-select-command-encounters-timeout-issue-when-another-scan-job-for-different-set-is-running/4056 "2017-04-13T02:56:43Z")
I meet this issue on Aerospike community version 3.8.3. Aql select command encounters timeout issue when another scan job which scanning another set is running issue : aql\> select userId from test.dealer Error: (9) Tim… [Next page](https://discuss.aerospike.com/c/tools/aql/49.md?page=1)