# \#query **URL:** https://discuss.aerospike.com/tag/query/8.md [Latest](https://discuss.aerospike.com/latest.md) · [Categories](https://discuss.aerospike.com/categories.md) · [Tags](https://discuss.aerospike.com/tags.md) --- ## [About Community edition limitations on storage per node hard limit](https://discuss.aerospike.com/t/about-community-edition-limitations-on-storage-per-node-hard-limit/12695)
**Author:** [@Saksham\_Srivastava](https://discuss.aerospike.com/u/Saksham_Srivastava)\ **Replies:** 0\ **Last updated:** [January 14, 2026, 8:08am UTC](https://discuss.aerospike.com/t/about-community-edition-limitations-on-storage-per-node-hard-limit/12695 "2026-01-14T08:08:39Z")
I have few questions realted to aerospike community edition Is there a hard limit of 640gb per node ( wihout replication ).If so then how is my single node able to achieve 1 TB storage ? Screenshot below My use cas… --- ## [Aggregation of records in a set using TTL and LUT](https://discuss.aerospike.com/t/aggregation-of-records-in-a-set-using-ttl-and-lut/12559)
**Author:** [@ghrahul](https://discuss.aerospike.com/u/ghrahul)\ **Replies:** 1\ **Last updated:** [October 12, 2025, 9:57pm UTC](https://discuss.aerospike.com/t/aggregation-of-records-in-a-set-using-ttl-and-lut/12559 "2025-10-12T21:57:32Z")
How can I count the number of records and do a comparison between TTL and age of the records(derived from LUT). What is the best way to do it? --- ## [Query: Aerospike cache implementation frequent update usecase](https://discuss.aerospike.com/t/query-aerospike-cache-implementation-frequent-update-usecase/11889)
**Author:** [@Kapoor](https://discuss.aerospike.com/u/Kapoor)\ **Replies:** 4\ **Last updated:** [December 14, 2024, 7:55pm UTC](https://discuss.aerospike.com/t/query-aerospike-cache-implementation-frequent-update-usecase/11889 "2024-12-14T19:55:22Z")
Hi community members, We were exploring Aerospike as a cache based solution for keeping ephemeral data (say sessional data) which also requires frequent update request on the initial record created (say ~100 to 1000 / se… --- ## [Impact of List Operations in Aerospike CDT: Append, Remove, and Update Behavior](https://discuss.aerospike.com/t/impact-of-list-operations-in-aerospike-cdt-append-remove-and-update-behavior/12132)
**Author:** [@Tamilarasu](https://discuss.aerospike.com/u/Tamilarasu)\ **Replies:** 5\ **Last updated:** [March 14, 2025, 12:09am UTC](https://discuss.aerospike.com/t/impact-of-list-operations-in-aerospike-cdt-append-remove-and-update-behavior/12132 "2025-03-14T00:09:22Z")
I was researching the impact of list operations—such as updating, appending, and removing elements—but couldn’t reach a definitive conclusion. Does appending to an existing list trigger a full list rewrite? From my … --- ## [Batch Writes Thread Executor Overhead: Worth It for Large or Small Batch Sizes?](https://discuss.aerospike.com/t/batch-writes-thread-executor-overhead-worth-it-for-large-or-small-batch-sizes/12124)
**Author:** [@Tamilarasu](https://discuss.aerospike.com/u/Tamilarasu)\ **Replies:** 5\ **Last updated:** [March 4, 2025, 5:01pm UTC](https://discuss.aerospike.com/t/batch-writes-thread-executor-overhead-worth-it-for-large-or-small-batch-sizes/12124 "2025-03-04T17:01:48Z")
I’m analyzing the client.operate(BatchPolicy policy, List\ records) method in Aerospike and found that it calls BatchExecutor.execute(cluster, policy, commands, status), where a new ExecutorService is created… --- ## [Filter expression formation for a nested Map field (C# Aerospike.Client 5.3.2)](https://discuss.aerospike.com/t/filter-expression-formation-for-a-nested-map-field-c-aerospike-client-5-3-2/11819)
**Author:** [@G\_Singh](https://discuss.aerospike.com/u/G_Singh)\ **Replies:** 5\ **Last updated:** [December 9, 2024, 8:15pm UTC](https://discuss.aerospike.com/t/filter-expression-formation-for-a-nested-map-field-c-aerospike-client-5-3-2/11819 "2024-12-09T20:15:33Z")
Hi there, Help is needed in creating filter expression on a set with below bins: bCustId (int) bMonth (Secondary index) bCategory (int) bOrdDtls (Map\\>) \[ { "status": "shipped", "propert… --- ## [Aerospike Cache for very high rate of updates](https://discuss.aerospike.com/t/aerospike-cache-for-very-high-rate-of-updates/11886)
**Author:** [@ashuk89](https://discuss.aerospike.com/u/ashuk89)\ **Replies:** 1\ **Last updated:** [December 4, 2024, 7:09pm UTC](https://discuss.aerospike.com/t/aerospike-cache-for-very-high-rate-of-updates/11886 "2024-12-04T19:09:24Z")
We have usecase where we wont want to store text data into database. We explored aerospike and wanted to implement Aerospike Cache for fast retrieval of data, stored in cache. As are not storing data into database, we ha… --- ## [Obtain generation of record's master and prole version](https://discuss.aerospike.com/t/obtain-generation-of-records-master-and-prole-version/11740)
**Author:** [@kuskmen](https://discuss.aerospike.com/u/kuskmen)\ **Replies:** 5\ **Last updated:** [November 19, 2024, 4:32pm UTC](https://discuss.aerospike.com/t/obtain-generation-of-records-master-and-prole-version/11740 "2024-11-19T16:32:58Z")
Hello, we are investigating an interesting edge case in our system that the only way to happen is if a record has multi-generation values. Our cluster is known to be unstable - constant timeouts with inDoubts=true/false… --- ## [Batch Writes Failing with NO\_AVAILABLE\_CONNECTIONS\_TO\_NODE](https://discuss.aerospike.com/t/batch-writes-failing-with-no-available-connections-to-node/11479)
**Author:** [@iamitpatil1993](https://discuss.aerospike.com/u/iamitpatil1993)\ **Replies:** 1\ **Last updated:** [September 13, 2024, 3:19pm UTC](https://discuss.aerospike.com/t/batch-writes-failing-with-no-available-connections-to-node/11479 "2024-09-13T15:19:14Z")
Hi All, We are using Aerospike on production for one of our use case. We perform both read as well as write transactions on the DB. Currently, in one of the flow, we update ~1.5K records with individual DB calls one aft… --- ## [Does operations.add() provide consistency guarantee](https://discuss.aerospike.com/t/does-operations-add-provide-consistency-guarantee/11198)
**Author:** [@Daksh\_Verma](https://discuss.aerospike.com/u/Daksh_Verma)\ **Replies:** 3\ **Last updated:** [September 5, 2024, 6:21am UTC](https://discuss.aerospike.com/t/does-operations-add-provide-consistency-guarantee/11198 "2024-09-05T06:21:13Z")
We are having a multi threaded application (using java) that is updating value in bin using Operations.add(). We are seeing inconsistency in the results. Also, we are updating the keys in batch update. So there can be mu… --- ## [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 … --- ## [Unable to get a record by filter 'contains' if bin array includes \> 1 element](https://discuss.aerospike.com/t/unable-to-get-a-record-by-filter-contains-if-bin-array-includes-1-element/11254)
**Author:** [@IvanR](https://discuss.aerospike.com/u/IvanR)\ **Replies:** 0\ **Last updated:** [June 28, 2024, 8:57am UTC](https://discuss.aerospike.com/t/unable-to-get-a-record-by-filter-contains-if-bin-array-includes-1-element/11254 "2024-06-28T08:57:09Z")
Hello! I encountered an unusual issue. I’m not sure if it’s a bug or if I’m mistaken, but I would appreciate some clarification :slight\_smile: So the summary is: while trying to search across the indexed array bin, If th… --- ## [How do I insert a json object that includes a boolean field](https://discuss.aerospike.com/t/how-do-i-insert-a-json-object-that-includes-a-boolean-field/11244)
**Author:** [@bobbyajp](https://discuss.aerospike.com/u/bobbyajp)\ **Replies:** 1\ **Last updated:** [June 26, 2024, 5:24pm UTC](https://discuss.aerospike.com/t/how-do-i-insert-a-json-object-that-includes-a-boolean-field/11244 "2024-06-26T17:24:12Z")
I’m trying to insert a record that contains json using aql with the following: insert into myns.myset (PK, field) VALUES ("mykey", LIST('\[{"useful": false}\]')); but when I select it I see select \* from myns.myset wher… --- ## [Querying for records with a large number of keys](https://discuss.aerospike.com/t/querying-for-records-with-a-large-number-of-keys/11214)
**Author:** [@Brent212](https://discuss.aerospike.com/u/Brent212)\ **Replies:** 7\ **Last updated:** [June 20, 2024, 4:57am UTC](https://discuss.aerospike.com/t/querying-for-records-with-a-large-number-of-keys/11214 "2024-06-20T04:57:09Z")
I need to query up to 2 million records using a set of keys. Memory restrictions prevent the application from reading them all in at once, so I need to write the record data out to files as it comes in rather than receiv… --- ## [Getting InvalidNamespace: Error 20,1: Partition map empty with java client only, go client is fine](https://discuss.aerospike.com/t/getting-invalidnamespace-error-20-1-partition-map-empty-with-java-client-only-go-client-is-fine/11205)
**Author:** [@bobbyajp](https://discuss.aerospike.com/u/bobbyajp)\ **Replies:** 4\ **Last updated:** [June 13, 2024, 8:10pm UTC](https://discuss.aerospike.com/t/getting-invalidnamespace-error-20-1-partition-map-empty-with-java-client-only-go-client-is-fine/11205 "2024-06-13T20:10:41Z")
Running a 7.1.0.1 local aero server, the following code in go works (v7 sdk) cp := aero.NewClientPolicy() cp.User = "" cp.Password = "" cp.Timeout = 1 \* time.Second ash := aero.NewHost("127.0.0.1", 3000) client, e… --- ## [Golang-client write fails with ResultCode: PARAMETER\_ERROR](https://discuss.aerospike.com/t/golang-client-write-fails-with-resultcode-parameter-error/11179)
**Author:** [@Rupinder\_Guron](https://discuss.aerospike.com/u/Rupinder_Guron)\ **Replies:** 0\ **Last updated:** [June 8, 2024, 12:48am UTC](https://discuss.aerospike.com/t/golang-client-write-fails-with-resultcode-parameter-error/11179 "2024-06-08T00:48:26Z")
Hi, I am writing to a Set — Upsert operation, It works in a POC Snippet but exact same fails with PARAMETER\_ERROR in a docker container. I get the following error: ResultCode: PARAMETER\_ERROR, Iteration: 0, InDoubt: … --- ## [How to search list items by regex with Aerospike Expressions](https://discuss.aerospike.com/t/how-to-search-list-items-by-regex-with-aerospike-expressions/11166)
**Author:** [@Rupinder\_Guron](https://discuss.aerospike.com/u/Rupinder_Guron)\ **Replies:** 5\ **Last updated:** [June 5, 2024, 12:07am UTC](https://discuss.aerospike.com/t/how-to-search-list-items-by-regex-with-aerospike-expressions/11166 "2024-06-05T00:07:59Z")
Hi, We have a bin with a string-list in it. And we want to do a search with a “matches” pattern on a List String element. In the old world, we do that with following code: as.NewPredExpStringVar("v"), as.NewPredExpStri… --- ## [Record level locking and latency](https://discuss.aerospike.com/t/record-level-locking-and-latency/5181)
**Author:** [@swayamraina](https://discuss.aerospike.com/u/swayamraina)\ **Replies:** 6\ **Last updated:** [May 19, 2018, 12:00am UTC](https://discuss.aerospike.com/t/record-level-locking-and-latency/5181 "2018-05-19T00:00:28Z")
Hi, we all know for consistency locking is required, I wanted to know what strategy does aerospike use to handle locking. I mean, I have an aerospike set with records. Will there be latency if I am trying to update a BI… --- ## [RecordExistsAction.CREATE\_ONLY and SendKey isnt working on Java Object Mapper](https://discuss.aerospike.com/t/recordexistsaction-create-only-and-sendkey-isnt-working-on-java-object-mapper/11111)
**Author:** [@vamsi.koneru1](https://discuss.aerospike.com/u/vamsi.koneru1)\ **Replies:** 6\ **Last updated:** [May 17, 2024, 4:10pm UTC](https://discuss.aerospike.com/t/recordexistsaction-create-only-and-sendkey-isnt-working-on-java-object-mapper/11111 "2024-05-17T16:10:44Z")
Hello, We are using Java Object Mapper to save and read the records from the Database. We have Configured our write policy to make sure we store the key in DB by using writePolicy.sendKey = true; and RecordExistsActio… --- ## [In Java using Batch, query the data using the secondary index](https://discuss.aerospike.com/t/in-java-using-batch-query-the-data-using-the-secondary-index/11042)
**Author:** [@Tom](https://discuss.aerospike.com/u/Tom)\ **Replies:** 15\ **Last updated:** [May 1, 2024, 9:25pm UTC](https://discuss.aerospike.com/t/in-java-using-batch-query-the-data-using-the-secondary-index/11042 "2024-05-01T21:25:57Z")
Primary Key :: EmployeeIdValueEmployeeIdType Secondary Index :: AlternateEmployeeId 1.we are fetching all the keys from the input and storing it in the KeystoFetch. List\ keysToFetch = new ArrayList\<\>(); … --- ## [Spring Data Aerospike - Multisite strong consistency - Read from local replica](https://discuss.aerospike.com/t/spring-data-aerospike-multisite-strong-consistency-read-from-local-replica/11034)
**Author:** [@shubham3582](https://discuss.aerospike.com/u/shubham3582)\ **Replies:** 3\ **Last updated:** [April 25, 2024, 11:18pm UTC](https://discuss.aerospike.com/t/spring-data-aerospike-multisite-strong-consistency-read-from-local-replica/11034 "2024-04-25T23:18:54Z")
Hi All, We are running 9 nodes aerospike cluster (3 nodes in each site - total 3 sites with rack-id 1,2 and 3 in strong consistency mode). Currently the reads (1 record or multiple records) response time is inconsistent… --- ## [Query records by using record's metadata (lut) and filter expressions](https://discuss.aerospike.com/t/query-records-by-using-records-metadata-lut-and-filter-expressions/11000)
**Author:** [@kuskmen](https://discuss.aerospike.com/u/kuskmen)\ **Replies:** 20\ **Last updated:** [April 22, 2024, 5:31am UTC](https://discuss.aerospike.com/t/query-records-by-using-records-metadata-lut-and-filter-expressions/11000 "2024-04-22T05:31:39Z")
Hello, I’ve been looking for a way to query efficiently records and I came up with idea to build an expression that will rely on its metadata since its in the index metadata and hopefully some storage access can be saved… --- ## [Does queryAggregate() return Single or Multiple results or rows from ResultSet](https://discuss.aerospike.com/t/does-queryaggregate-return-single-or-multiple-results-or-rows-from-resultset/10949)
**Author:** [@griffinjm](https://discuss.aerospike.com/u/griffinjm)\ **Replies:** 6\ **Last updated:** [April 11, 2024, 2:20pm UTC](https://discuss.aerospike.com/t/does-queryaggregate-return-single-or-multiple-results-or-rows-from-resultset/10949 "2024-04-11T14:20:47Z")
Looking for help if anyone can help explain queryAggregate() behaviour in a clustered environment using an aggregation UDF. It’s not exactly clear to me what queryAggregate() returns when multiple nodes are present. The… --- ## [Secondary Index query performance](https://discuss.aerospike.com/t/secondary-index-query-performance/10973)
**Author:** [@ekirianov](https://discuss.aerospike.com/u/ekirianov)\ **Replies:** 7\ **Last updated:** [April 11, 2024, 1:40pm UTC](https://discuss.aerospike.com/t/secondary-index-query-performance/10973 "2024-04-11T13:40:45Z")
Hi, I’m using single instance of Aerospike 5.6, holding approximately 25 millions of records (new records are constantly arriving, but they are set to expire in 30 minutes) in memory. Each record contains 30 bins and occ… --- ## [Filters record using the json property when json present in a bin](https://discuss.aerospike.com/t/filters-record-using-the-json-property-when-json-present-in-a-bin/10913)
**Author:** [@amanjain08](https://discuss.aerospike.com/u/amanjain08)\ **Replies:** 3\ **Last updated:** [March 21, 2024, 9:15pm UTC](https://discuss.aerospike.com/t/filters-record-using-the-json-property-when-json-present-in-a-bin/10913 "2024-03-21T21:15:20Z")
Hi, I have JSON stored in one bin with ‘data’ as key. Now I want to filter records based on one of the JSON property value. bin → "data" : { "entity\_id": "1234567", "store\_id": "", "sub\_merchant\_id": "", … --- ## [After upgrading the aerospike from 6.2 to 6.4 I am not getting the metrics](https://discuss.aerospike.com/t/after-upgrading-the-aerospike-from-6-2-to-6-4-i-am-not-getting-the-metrics/10673)
**Author:** [@Pawan](https://discuss.aerospike.com/u/Pawan)\ **Replies:** 5\ **Last updated:** [February 2, 2024, 7:15pm UTC](https://discuss.aerospike.com/t/after-upgrading-the-aerospike-from-6-2-to-6-4-i-am-not-getting-the-metrics/10673 "2024-02-02T19:15:22Z")
In 6.2 version I am was gettting below metrices “aerospike\_latencies\_read\_ms\_bucket” “aerospike\_latencies\_read\_ms\_bucket”.But after upgrading to 6.4 I am not getting it. I have upgraded the promethues exporter from 1.8 t… --- ## [UNSUPPORTED\_FEATURE on aerospike server 6+](https://discuss.aerospike.com/t/unsupported-feature-on-aerospike-server-6/10782)
**Author:** [@Mazdak\_Mansouri](https://discuss.aerospike.com/u/Mazdak_Mansouri)\ **Replies:** 2\ **Last updated:** [January 23, 2024, 3:31pm UTC](https://discuss.aerospike.com/t/unsupported-feature-on-aerospike-server-6/10782 "2024-01-23T15:31:17Z")
When we upgrade to server 6.4+ from 5.0.0.4, we get unsupported\_feature error on all codes that we have with Secondary Index. Same code was working for server 5.X but not with 6.4+. The error appear on recordset.Error(). … --- ## [Network Disconnection Impact on Cluster State and Data Queries in a Multi-Node Cluster with Replicas](https://discuss.aerospike.com/t/network-disconnection-impact-on-cluster-state-and-data-queries-in-a-multi-node-cluster-with-replicas/10765)
**Author:** [@1028501412](https://discuss.aerospike.com/u/1028501412)\ **Replies:** 1\ **Last updated:** [January 11, 2024, 7:15pm UTC](https://discuss.aerospike.com/t/network-disconnection-impact-on-cluster-state-and-data-queries-in-a-multi-node-cluster-with-replicas/10765 "2024-01-11T19:15:03Z")
If a cluster with multiple nodes and two replicas experiences a network-related disconnection on one of the nodes, it can lead to an abnormal cluster state where data queries may fail without generating an AerospikeExcep… --- ## [Aerospike outbound source connector 2.2.0](https://discuss.aerospike.com/t/aerospike-outbound-source-connector-2-2-0/10700)
**Author:** [@neha\_Mittal](https://discuss.aerospike.com/u/neha_Mittal)\ **Replies:** 2\ **Last updated:** [December 18, 2023, 7:59pm UTC](https://discuss.aerospike.com/t/aerospike-outbound-source-connector-2-2-0/10700 "2023-12-18T19:59:34Z")
I am using com.aerospike aerospike-connect-outbound-sdk 2.2.0 provided with custom formatter, recordTransformer and Routing config provided in /etc/aerospike-kafka-outbound/aerospike-kafka-outbound.yml file When I sta… --- ## [Query fails during migration](https://discuss.aerospike.com/t/query-fails-during-migration/10533)
**Author:** [@darktaiga01](https://discuss.aerospike.com/u/darktaiga01)\ **Replies:** 5\ **Last updated:** [December 18, 2023, 7:00pm UTC](https://discuss.aerospike.com/t/query-fails-during-migration/10533 "2023-12-18T19:00:58Z")
Hello everyone, I’m new to Aerospike, and I’m currently using the Community Edition. My setup consists of three nodes with a Replication Factor of 2. I use Java Client with Default Query Policy and JDBC to retrieve data… [Next page](https://discuss.aerospike.com/tag/query/8.md?match_all_tags=true&page=1&tags%5B%5D=query)