# Feature Discussion

**URL:** https://discuss.aerospike.com/c/aerospike-features/29.md

[Latest](https://discuss.aerospike.com/latest.md) · [Categories](https://discuss.aerospike.com/categories.md) · [Tags](https://discuss.aerospike.com/tags.md)

---

## [Hands on with Aerospike (video: 23 min)](https://discuss.aerospike.com/t/hands-on-with-aerospike-video-23-min/6347)

<div class="topic-metadata">

**Author:** [@kporter](https://discuss.aerospike.com/u/kporter)\
**Replies:** 0\
**Last updated:** [June 17, 2019, 5:42pm UTC](https://discuss.aerospike.com/t/hands-on-with-aerospike-video-23-min/6347 "2019-06-17T17:42:04Z")

</div>

---

## [Introduction to Aerospike (video: 24 min)](https://discuss.aerospike.com/t/introduction-to-aerospike-video-24-min/6341)

<div class="topic-metadata">

**Author:** [@kporter](https://discuss.aerospike.com/u/kporter)\
**Replies:** 0\
**Last updated:** [June 14, 2019, 5:59pm UTC](https://discuss.aerospike.com/t/introduction-to-aerospike-video-24-min/6341 "2019-06-14T17:59:57Z")

</div>

---

## [About the Feature Discussion category](https://discuss.aerospike.com/t/about-the-feature-discussion-category/51)

<div class="topic-metadata">

**Author:** [@kporter](https://discuss.aerospike.com/u/kporter)\
**Replies:** 0

</div>

Use this category to discuss Aerospike’s existing features.

---

## [Possibe behaviour with Aerospike Java client, Statement.setMaxRecords when it's set to 1](https://discuss.aerospike.com/t/possibe-behaviour-with-aerospike-java-client-statement-setmaxrecords-when-its-set-to-1/12815)

<div class="topic-metadata">

**Author:** [@iandntran](https://discuss.aerospike.com/u/iandntran)\
**Replies:** 0\
**Last updated:** [April 21, 2026, 9:22pm UTC](https://discuss.aerospike.com/t/possibe-behaviour-with-aerospike-java-client-statement-setmaxrecords-when-its-set-to-1/12815 "2026-04-21T21:22:36Z")

</div>

Hi, For version info, using the aerospike client version: 9.0.5 (jdk21 version) From reading the javadoc, it states the following for the Statement.setMaxRecords() method: Set maximum number of records returned (for for…

---

## [Query: Aerospike cache implementation frequent update usecase](https://discuss.aerospike.com/t/query-aerospike-cache-implementation-frequent-update-usecase/11889)

<div class="topic-metadata">

**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")

</div>

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)

<div class="topic-metadata">

**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")

</div>

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 …

---

## [Aerospike connect Trino - Error listing schemas for catalog](https://discuss.aerospike.com/t/aerospike-connect-trino-error-listing-schemas-for-catalog/11827)

<div class="topic-metadata">

**Author:** [@zeckem](https://discuss.aerospike.com/u/zeckem)\
**Replies:** 0\
**Last updated:** [November 25, 2024, 3:10pm UTC](https://discuss.aerospike.com/t/aerospike-connect-trino-error-listing-schemas-for-catalog/11827 "2024-11-25T15:10:09Z")

</div>

Followed the docs here Configuration Properties for Aerospike Connect for Trino | Aerospike Documentation supplied clientpolicy params aerospike.clientpolicy.user: xxx aerospike.clientpolicy.password: xxx …

---

## [Aerospike Lua Protobuf pb.so: undefined symbol: lua\_settop](https://discuss.aerospike.com/t/aerospike-lua-protobuf-pb-so-undefined-symbol-lua-settop/11448)

<div class="topic-metadata">

**Author:** [@sleshJdev](https://discuss.aerospike.com/u/sleshJdev)\
**Replies:** 5\
**Last updated:** [September 26, 2024, 11:15pm UTC](https://discuss.aerospike.com/t/aerospike-lua-protobuf-pb-so-undefined-symbol-lua-settop/11448 "2024-09-26T23:15:37Z")

</div>

I try to run simple lua udf in docker and keep getting this error: ERROR lua create error: error loading module 'protobuf.pb' from file '/usr/local/lib/lua/5.1/protobuf/pb.so': /usr/local/lib/lua/5.1/protobuf/pb…

---

## [Aerospike lua protobuf](https://discuss.aerospike.com/t/aerospike-lua-protobuf/11451)

<div class="topic-metadata">

**Author:** [@sleshJdev](https://discuss.aerospike.com/u/sleshJdev)\
**Replies:** 0\
**Last updated:** [September 6, 2024, 11:18am UTC](https://discuss.aerospike.com/t/aerospike-lua-protobuf/11451 "2024-09-06T11:18:06Z")

</div>

In this example Protobuf Module Example | Developer, it installs protobuf directly using luarocks which suppose that lua already installed on the machine. What lua is actually used in that example - the one from Aerospil…

---

## [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)

<div class="topic-metadata">

**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")

</div>

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…

---

## [Fetch Secondary Index results from a Single Node using replication factor 128](https://discuss.aerospike.com/t/fetch-secondary-index-results-from-a-single-node-using-replication-factor-128/11094)

<div class="topic-metadata">

**Author:** [@Abhishek\_Singla](https://discuss.aerospike.com/u/Abhishek_Singla)\
**Replies:** 17\
**Last updated:** [May 17, 2024, 3:26pm UTC](https://discuss.aerospike.com/t/fetch-secondary-index-results-from-a-single-node-using-replication-factor-128/11094 "2024-05-17T15:26:33Z")

</div>

Server Version: 6.3 Two namespaces: one which will have millions of records and will be queried by PK only and other which will have \< 100 records and will be queried using secondary indexes. This question is regarding …

---

## [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)

<div class="topic-metadata">

**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")

</div>

Primary Key :: EmployeeIdValueEmployeeIdType Secondary Index :: AlternateEmployeeId 1.we are fetching all the keys from the input and storing it in the KeystoFetch. List\<String\> keysToFetch = new ArrayList\<\>(); …

---

## [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)

<div class="topic-metadata">

**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")

</div>

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…

---

## [Secondary Index query performance](https://discuss.aerospike.com/t/secondary-index-query-performance/10973)

<div class="topic-metadata">

**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")

</div>

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)

<div class="topic-metadata">

**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")

</div>

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": "", …

---

## [Registering UDFs](https://discuss.aerospike.com/t/registering-udfs/3831)

<div class="topic-metadata">

**Author:** [@Tals](https://discuss.aerospike.com/u/Tals)\
**Replies:** 6\
**Last updated:** [March 19, 2024, 9:09pm UTC](https://discuss.aerospike.com/t/registering-udfs/3831 "2024-03-19T21:09:44Z")

</div>

Hi, Is there a way to put the UDF on the server and the Aerospike will register it automatically? if not, I was wondering what is the way to know if a UDF already registered? I guess re-registering is an expansive operat…

---

## [Range Query using Index of Type String](https://discuss.aerospike.com/t/range-query-using-index-of-type-string/10888)

<div class="topic-metadata">

**Author:** [@Rupinder\_Guron](https://discuss.aerospike.com/u/Rupinder_Guron)\
**Replies:** 2\
**Last updated:** [March 12, 2024, 5:28pm UTC](https://discuss.aerospike.com/t/range-query-using-index-of-type-string/10888 "2024-03-12T17:28:40Z")

</div>

Hi, Aerospike Rookie. aerospike client context: golang Use Case: we have a Set with a bin Time of data type String. We store Time String in the format specified by RFC-3339( YYYY-MM-DDThh:mm:ssZ), which is a specific…

---

## [UNSUPPORTED\_FEATURE on aerospike server 6+](https://discuss.aerospike.com/t/unsupported-feature-on-aerospike-server-6/10782)

<div class="topic-metadata">

**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")

</div>

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(). …

---

## [Is it Can What Point in time reocvery in Aerospike](https://discuss.aerospike.com/t/is-it-can-what-point-in-time-reocvery-in-aerospike/10683)

<div class="topic-metadata">

**Author:** [@lee](https://discuss.aerospike.com/u/lee)\
**Replies:** 3\
**Last updated:** [December 12, 2023, 9:52pm UTC](https://discuss.aerospike.com/t/is-it-can-what-point-in-time-reocvery-in-aerospike/10683 "2023-12-12T21:52:36Z")

</div>

is it Can What Point in time reocvery in Aerospike? I wanna restore about specific time If point-in-time recovery is not possible, are there files that are created after a backup, such as MySQL’s Binary log? Can it be …

---

## [Delete sets matching regex. Code Injection](https://discuss.aerospike.com/t/delete-sets-matching-regex-code-injection/10542)

<div class="topic-metadata">

**Author:** [@zingoba](https://discuss.aerospike.com/u/zingoba)\
**Replies:** 1\
**Last updated:** [September 26, 2023, 1:18am UTC](https://discuss.aerospike.com/t/delete-sets-matching-regex-code-injection/10542 "2023-09-26T01:18:08Z")

</div>

Hi guys, We have run into a peculiar problem. Due to a bad legacy code, our cluster was exposed to code injection attack. The adversary was able to breach and ended up creating lots of sets in our namespace. We have plu…

---

## [Expiring an entire set using a lua script](https://discuss.aerospike.com/t/expiring-an-entire-set-using-a-lua-script/10512)

<div class="topic-metadata">

**Author:** [@srikumarkpz](https://discuss.aerospike.com/u/srikumarkpz)\
**Replies:** 4\
**Last updated:** [September 14, 2023, 9:02pm UTC](https://discuss.aerospike.com/t/expiring-an-entire-set-using-a-lua-script/10512 "2023-09-14T21:02:51Z")

</div>

Hi, Came across this solution in stackoverflow where you can delete entire contents of a set by updating the TTL: Changing TTL for a set in Aerospike with AQL - Stack Overflow Would like to apply this solution in our p…

---

## [Does filter expression benifit from secondary index](https://discuss.aerospike.com/t/does-filter-expression-benifit-from-secondary-index/10200)

<div class="topic-metadata">

**Author:** [@dzhhh](https://discuss.aerospike.com/u/dzhhh)\
**Replies:** 3\
**Last updated:** [September 7, 2023, 3:38pm UTC](https://discuss.aerospike.com/t/does-filter-expression-benifit-from-secondary-index/10200 "2023-09-07T15:38:48Z")

</div>

Hi, I need to query data from a set with two bins, one is string type, the other is boolean type. Because of only one bin can be used as filter when query, I use the string-typed bin as filter, and make a filter expressi…

---

## [Query Aerospike DB with Multiple Filters](https://discuss.aerospike.com/t/query-aerospike-db-with-multiple-filters/10367)

<div class="topic-metadata">

**Author:** [@Siva\_Samraj\_S](https://discuss.aerospike.com/u/Siva_Samraj_S)\
**Replies:** 1\
**Last updated:** [July 27, 2023, 12:36am UTC](https://discuss.aerospike.com/t/query-aerospike-db-with-multiple-filters/10367 "2023-07-27T00:36:04Z")

</div>

Team, I have an Aerospike DB with one set. Here by using the Java Client, I am trying to query the data with a date filter and ID filter. But with Aerospike, I couldn’t able to achieve it. Is there any way I can query t…

---

## [I have a Lua script which is designed to filter records based on the value of the "age" bin. The filter\_by\_age function is used to filter the stream of records, and the count\_records function is used to count the number of records that meet the age condit](https://discuss.aerospike.com/t/i-have-a-lua-script-which-is-designed-to-filter-records-based-on-the-value-of-the-age-bin-the-filter-by-age-function-is-used-to-filter-the-stream-of-records-and-the-count-records-function-is-used-to-count-the-number-of-records-that-meet-the-age-condit/10336)

<div class="topic-metadata">

**Author:** [@sagar](https://discuss.aerospike.com/u/sagar)\
**Replies:** 3\
**Last updated:** [July 26, 2023, 11:56pm UTC](https://discuss.aerospike.com/t/i-have-a-lua-script-which-is-designed-to-filter-records-based-on-the-value-of-the-age-bin-the-filter-by-age-function-is-used-to-filter-the-stream-of-records-and-the-count-records-function-is-used-to-count-the-number-of-records-that-meet-the-age-condit/10336 "2023-07-26T23:56:33Z")

</div>

public class AerospikeStreamExample { public static void main(String\[\] args) { AerospikeClient client = new AerospikeClient("15.206.70.97", 3000); // Register the Lua script String luaScript …

---

## [Removal of paxos-single-replica-limit and fail\_on\_cluster\_change](https://discuss.aerospike.com/t/removal-of-paxos-single-replica-limit-and-fail-on-cluster-change/10329)

<div class="topic-metadata">

**Author:** [@mvk](https://discuss.aerospike.com/u/mvk)\
**Replies:** 2\
**Last updated:** [July 19, 2023, 5:31am UTC](https://discuss.aerospike.com/t/removal-of-paxos-single-replica-limit-and-fail-on-cluster-change/10329 "2023-07-19T05:31:47Z")

</div>

Hello, I revisited the latest version of Aerospike and have following queries about it. Can any one please clarify them? “paxos-single-replica-limit” configuration parameter seems to be removed in the server version 6…

---

## [100% Read load test in zipfian distribution (80% operation on 20% data) with YCSB benchmark shows 3 times less IOPS. But improves after running 95% Read and 5% Update](https://discuss.aerospike.com/t/100-read-load-test-in-zipfian-distribution-80-operation-on-20-data-with-ycsb-benchmark-shows-3-times-less-iops-but-improves-after-running-95-read-and-5-update/10273)

<div class="topic-metadata">

**Author:** [@Sovit\_Patnaik](https://discuss.aerospike.com/u/Sovit_Patnaik)\
**Replies:** 3\
**Last updated:** [June 20, 2023, 11:50pm UTC](https://discuss.aerospike.com/t/100-read-load-test-in-zipfian-distribution-80-operation-on-20-data-with-ycsb-benchmark-shows-3-times-less-iops-but-improves-after-running-95-read-and-5-update/10273 "2023-06-20T23:50:53Z")

</div>

Hi Community, I am facing a very weird scenario while running 100% Read load test using YCSB specifically using Zipfian distribution (80% operations on 20% records) just after freshly loading the database with records. W…

---

## [Fetch all keys based on some pattern](https://discuss.aerospike.com/t/fetch-all-keys-based-on-some-pattern/10203)

<div class="topic-metadata">

**Author:** [@unverifieduser](https://discuss.aerospike.com/u/unverifieduser)\
**Replies:** 3\
**Last updated:** [May 22, 2023, 7:07pm UTC](https://discuss.aerospike.com/t/fetch-all-keys-based-on-some-pattern/10203 "2023-05-22T19:07:32Z")

</div>

i have thousands of records on namepace:set. keys are of pattern: lastname/firstname/state/zip example: brown/chris/fl/32514 i want to get all keys based on the pattern “\*/chris/\*/32514” and perform delete operation on…

---

## [How to delete a record based on secondary index?](https://discuss.aerospike.com/t/how-to-delete-a-record-based-on-secondary-index/2262)

<div class="topic-metadata">

**Author:** [@shamik](https://discuss.aerospike.com/u/shamik)\
**Replies:** 4\
**Last updated:** [May 19, 2023, 5:59pm UTC](https://discuss.aerospike.com/t/how-to-delete-a-record-based-on-secondary-index/2262 "2023-05-19T17:59:41Z")

</div>

Hi, I’m trying to delete a record based on a secondary index value. I’m using java API and the only thing it supports right now seemed to be based on PK. Here’s an example on what I’m trying to do :smile: Following are…

---

## [How to touch the records by udf if it LUT lies between specific date range](https://discuss.aerospike.com/t/how-to-touch-the-records-by-udf-if-it-lut-lies-between-specific-date-range/10189)

<div class="topic-metadata">

**Author:** [@digvijay.it18](https://discuss.aerospike.com/u/digvijay.it18)\
**Replies:** 2\
**Last updated:** [May 5, 2023, 2:36am UTC](https://discuss.aerospike.com/t/how-to-touch-the-records-by-udf-if-it-lut-lies-between-specific-date-range/10189 "2023-05-05T02:36:13Z")

</div>

how to implement udf in a way that it will touch only those records those LUT lies between specific date range, I have a udf to touch record function touch\_rec(rec,sec) local CITRUSLEAF\_EPOCH\_S=1262304000000 local ser…

---

## [Massive leaderboards usecase](https://discuss.aerospike.com/t/massive-leaderboards-usecase/7546)

<div class="topic-metadata">

**Author:** [@ayyappa99](https://discuss.aerospike.com/u/ayyappa99)\
**Replies:** 5\
**Last updated:** [June 20, 2020, 4:00pm UTC](https://discuss.aerospike.com/t/massive-leaderboards-usecase/7546 "2020-06-20T16:00:44Z")

</div>

We have an use-case where we need to solve the following Find rank of a player in real time (In order of 100ms is fine) Store more than 10 million scores per leaderboard Cost efficient Currently we are researching Aer…

[Next page](https://discuss.aerospike.com/c/aerospike-features/29.md?page=1)
