# \#secondary **URL:** https://discuss.aerospike.com/tag/secondary/23.md [Latest](https://discuss.aerospike.com/latest.md) · [Categories](https://discuss.aerospike.com/categories.md) · [Tags](https://discuss.aerospike.com/tags.md) --- ## [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… --- ## [Secondary Index - can a Value straddle nodes? Or all records for Value be on same Node](https://discuss.aerospike.com/t/secondary-index-can-a-value-straddle-nodes-or-all-records-for-value-be-on-same-node/11159)
**Author:** [@Rupinder\_Guron](https://discuss.aerospike.com/u/Rupinder_Guron)\ **Replies:** 2\ **Last updated:** [May 30, 2024, 1:37am UTC](https://discuss.aerospike.com/t/secondary-index-can-a-value-straddle-nodes-or-all-records-for-value-be-on-same-node/11159 "2024-05-30T01:37:51Z")
Hi, Given a Secondary-Index on a String, would it be prudent to assume for a bin with a Secondary Index (used to model one - to - many relationship ) – All records with One Value of the Bin would be on One Node ? It… --- ## [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\<\>(); … --- ## [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": "", … --- ## [Range Query using Index of Type String](https://discuss.aerospike.com/t/range-query-using-index-of-type-string/10888)
**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")
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… --- ## [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… --- ## [findByIndexed fails "Id must not be null"](https://discuss.aerospike.com/t/findbyindexed-fails-id-must-not-be-null/10586)
**Author:** [@Hetal\_Rathod](https://discuss.aerospike.com/u/Hetal_Rathod)\ **Replies:** 6\ **Last updated:** [November 20, 2023, 5:02pm UTC](https://discuss.aerospike.com/t/findbyindexed-fails-id-must-not-be-null/10586 "2023-11-20T17:02:46Z")
Hi Team, Can anyone please help me on the below issue - I am trying to fetch an entity based on an indexed field. Spring Data is actually able to retrieve the entity from Aerospike DB but unfortunately, it is not sendi… --- ## [Aerospike Filter and Expressions](https://discuss.aerospike.com/t/aerospike-filter-and-expressions/10618)
**Author:** [@Nandish](https://discuss.aerospike.com/u/Nandish)\ **Replies:** 1\ **Last updated:** [November 3, 2023, 4:25pm UTC](https://discuss.aerospike.com/t/aerospike-filter-and-expressions/10618 "2023-11-03T16:25:48Z")
I have an aerospike client setup in spring boot Java, and I am trying to query a set with one filter and 2 or more expressions since aerospike does not support multiple secondary index filters. Now with this setup , whe… --- ## [Does filter expression benifit from secondary index](https://discuss.aerospike.com/t/does-filter-expression-benifit-from-secondary-index/10200)
**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")
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… --- ## [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)
**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")
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… --- ## [Secondary index missing records, can it be repaired?](https://discuss.aerospike.com/t/secondary-index-missing-records-can-it-be-repaired/1366)
**Author:** [@hubt](https://discuss.aerospike.com/u/hubt)\ **Replies:** 8\ **Last updated:** [February 26, 2023, 10:58pm UTC](https://discuss.aerospike.com/t/secondary-index-missing-records-can-it-be-repaired/1366 "2023-02-26T22:58:13Z")
We have a situation where we recently upgraded a 3 node cluster from 3.4.1 to 3.5.9 and since the upgrade, secondary index queries sometimes fail to find records that we know are available by the primary index. The stat… --- ## [Multiple FilterExp query with aggregation](https://discuss.aerospike.com/t/multiple-filterexp-query-with-aggregation/9281)
**Author:** [@c.fanton](https://discuss.aerospike.com/u/c.fanton)\ **Replies:** 4\ **Last updated:** [March 17, 2022, 3:40am UTC](https://discuss.aerospike.com/t/multiple-filterexp-query-with-aggregation/9281 "2022-03-17T03:40:01Z")
Hello, I am not sure on how to query a setname based on multiple filters and aggregate the results count based on some values. For the sake of the argument, let’s suppose that the dataset has this structure: CUSTOMER\_I… --- ## [How to search MAPKEY index](https://discuss.aerospike.com/t/how-to-search-mapkey-index/9229)
**Author:** [@pradeepgururani](https://discuss.aerospike.com/u/pradeepgururani)\ **Replies:** 6\ **Last updated:** [February 17, 2022, 6:27am UTC](https://discuss.aerospike.com/t/how-to-search-mapkey-index/9229 "2022-02-17T06:27:04Z")
I have gone through https://download.aerospike.com/docs/guide/cdt-map-index-and-query.html page and successfully created an index on MAP bin. I can query as well from aql. However I am finding it difficult to write the … --- ## [Is it possible to use primary key along with secondary key in Aerospike for fetching a record?](https://discuss.aerospike.com/t/is-it-possible-to-use-primary-key-along-with-secondary-key-in-aerospike-for-fetching-a-record/7537)
**Author:** [@Myst](https://discuss.aerospike.com/u/Myst)\ **Replies:** 7\ **Last updated:** [March 30, 2021, 5:11am UTC](https://discuss.aerospike.com/t/is-it-possible-to-use-primary-key-along-with-secondary-key-in-aerospike-for-fetching-a-record/7537 "2021-03-30T05:11:50Z")
Is it possible to use primary key along with secondary key. I want to get all records on the basis of primary key and then apply secondary index over it? Is it the correct way to do it or some other approach should be us… --- ## [Definition of Set and Secondary Index in aerospike.conf](https://discuss.aerospike.com/t/definition-of-set-and-secondary-index-in-aerospike-conf/7640)
**Author:** [@fschaeffler](https://discuss.aerospike.com/u/fschaeffler)\ **Replies:** 1\ **Last updated:** [July 21, 2020, 5:40pm UTC](https://discuss.aerospike.com/t/definition-of-set-and-secondary-index-in-aerospike-conf/7640 "2020-07-21T17:40:54Z")
The configuration for the aerospike.conf here indicates that it’s possible to define a set within the context of namespace. Are there any other configuration options to it other than the name and the set-stop-writes-coun… --- ## [java.net.SocketException: Connection reset, Error -8 on large set query](https://discuss.aerospike.com/t/java-net-socketexception-connection-reset-error-8-on-large-set-query/7458)
**Author:** [@nishant.nitjsr](https://discuss.aerospike.com/u/nishant.nitjsr)\ **Replies:** 7\ **Last updated:** [June 9, 2020, 6:47pm UTC](https://discuss.aerospike.com/t/java-net-socketexception-connection-reset-error-8-on-large-set-query/7458 "2020-06-09T18:47:28Z")
Hi, I am getting Connection reset error sometimes while querying a large set. I am using secondary index value (always 1) as a filter. This query should return approx ~1.5M record (all records in the set). I am using 4.… --- ## [Drop all secondary indexes](https://discuss.aerospike.com/t/drop-all-secondary-indexes/7366)
**Author:** [@Rod\_McCutcheon](https://discuss.aerospike.com/u/Rod_McCutcheon)\ **Replies:** 3\ **Last updated:** [June 9, 2020, 7:11am UTC](https://discuss.aerospike.com/t/drop-all-secondary-indexes/7366 "2020-06-09T07:11:46Z")
Today we maxed out the number of secondary indexes and get the following error using the Java client: com.aerospike.client.AerospikeException: Error Code 206: Create index failed: FAIL:206:Reached maximum number of sinde… --- ## [Is it recommended to use aerospike to filter on some field](https://discuss.aerospike.com/t/is-it-recommended-to-use-aerospike-to-filter-on-some-field/7264)
**Author:** [@ankitmittal](https://discuss.aerospike.com/u/ankitmittal)\ **Replies:** 1\ **Last updated:** [March 30, 2020, 6:06pm UTC](https://discuss.aerospike.com/t/is-it-recommended-to-use-aerospike-to-filter-on-some-field/7264 "2020-03-30T18:06:00Z")
I have around 2 millions records, each record having 10-12 fields(mostly are string). Now I want to filter records on the basis of some field. Is it advisable to do this using secondary index or some other better option … --- ## [Query by range does not return all data](https://discuss.aerospike.com/t/query-by-range-does-not-return-all-data/421)
**Author:** [@tx\_user](https://discuss.aerospike.com/u/tx_user)\ **Replies:** 14\ **Last updated:** [November 8, 2019, 4:23pm UTC](https://discuss.aerospike.com/t/query-by-range-does-not-return-all-data/421 "2019-11-08T16:23:32Z")
Hi all, We have a problem with the requests to the numeric index by range. We get a data that does not correspond to the expected result. The dump of data you can download from DropMeFiles – free one-click file sharing… --- ## [Multiple filter in the statement](https://discuss.aerospike.com/t/multiple-filter-in-the-statement/409)
**Author:** [@bharatkasodariya](https://discuss.aerospike.com/u/bharatkasodariya)\ **Replies:** 15\ **Last updated:** [August 22, 2019, 7:05am UTC](https://discuss.aerospike.com/t/multiple-filter-in-the-statement/409 "2019-08-22T07:05:29Z")
Trying multiple filter in the statement but it doesnt work. throwing exception com.aerospike.client.AerospikeException: Error Code 4: Parameter error Here is the code Statement statement = new Statement(); statement.set… --- ## [Delete record instantly while reading that record using java client in aerospike set](https://discuss.aerospike.com/t/delete-record-instantly-while-reading-that-record-using-java-client-in-aerospike-set/4845)
**Author:** [@kumar\_gaurav](https://discuss.aerospike.com/u/kumar_gaurav)\ **Replies:** 3\ **Last updated:** [June 24, 2019, 3:53pm UTC](https://discuss.aerospike.com/t/delete-record-instantly-while-reading-that-record-using-java-client-in-aerospike-set/4845 "2019-06-24T15:53:18Z")
Hi All I need to delete record instantly while reading that record using java client .I want to use aerospike set as a queue where i want parallel read processing where no consumer will read same record . Please help . … --- ## [I'm I able to do a unique scan based on bins?](https://discuss.aerospike.com/t/im-i-able-to-do-a-unique-scan-based-on-bins/5978)
**Author:** [@Arlus](https://discuss.aerospike.com/u/Arlus)\ **Replies:** 6\ **Last updated:** [March 3, 2019, 11:56pm UTC](https://discuss.aerospike.com/t/im-i-able-to-do-a-unique-scan-based-on-bins/5978 "2019-03-03T23:56:12Z")
Hello, I’m a newbie to Aerospike. I’m using the C client library and I have had a taste of UDFs. The issue I have is; is there a way for me to scan or query the following way in Aerospike? select all records with uniqu… --- ## [Secondary Index Creation Time](https://discuss.aerospike.com/t/secondary-index-creation-time/5766)
**Author:** [@Janardhanan\_V\_S](https://discuss.aerospike.com/u/Janardhanan_V_S)\ **Replies:** 1\ **Last updated:** [December 13, 2018, 1:46am UTC](https://discuss.aerospike.com/t/secondary-index-creation-time/5766 "2018-12-13T01:46:14Z")
Are there any bench marks available regarding the secondary index creation timings. I’m having a 6 node cluster with 100 Million Records with a replication factor of 2 (200 M records in total). The data is already there… --- ## [Secondary index gc issue](https://discuss.aerospike.com/t/secondary-index-gc-issue/5266)
**Author:** [@aman.choudhary](https://discuss.aerospike.com/u/aman.choudhary)\ **Replies:** 1\ **Last updated:** [June 21, 2018, 8:25pm UTC](https://discuss.aerospike.com/t/secondary-index-gc-issue/5266 "2018-06-21T20:25:01Z")
Hi, I am using aerospike cluster of size 7 and I am getting SocketTimeoutException from aerospike for some of the requests. I am having 2 billion records in my namespace and I am also using secondary indexes. When I am u… --- ## [Secondary index corruption and newly created indexes not readable](https://discuss.aerospike.com/t/secondary-index-corruption-and-newly-created-indexes-not-readable/3139)
**Author:** [@Anand\_Mahajan](https://discuss.aerospike.com/u/Anand_Mahajan)\ **Replies:** 2\ **Last updated:** [June 19, 2018, 4:45am UTC](https://discuss.aerospike.com/t/secondary-index-corruption-and-newly-created-indexes-not-readable/3139 "2018-06-19T04:45:49Z")
We modified the default-ttl, set it to 0 for one the namespaces and restarted the cluster one node at at time. Its a 6 node cluster. The data size on each node is about 400GB and rebuilding the secondary indexes take any… --- ## [Max sindex-builder-threads value](https://discuss.aerospike.com/t/max-sindex-builder-threads-value/5165)
**Author:** [@pedrodevoto](https://discuss.aerospike.com/u/pedrodevoto)\ **Replies:** 9\ **Last updated:** [May 10, 2018, 2:20am UTC](https://discuss.aerospike.com/t/max-sindex-builder-threads-value/5165 "2018-05-10T02:20:45Z")
Hi. I have a cluster which had some node restarts and now it is rebalancing and reindexing since a few hours. There’s only one server left reindexing, and until it completes I can’t perform queries. I’ve already changed… --- ## [Not all records are returned on secondary index query during migration](https://discuss.aerospike.com/t/not-all-records-are-returned-on-secondary-index-query-during-migration/3594)
**Author:** [@jin\_dev](https://discuss.aerospike.com/u/jin_dev)\ **Replies:** 2\ **Last updated:** [May 7, 2018, 7:40am UTC](https://discuss.aerospike.com/t/not-all-records-are-returned-on-secondary-index-query-during-migration/3594 "2018-05-07T07:40:44Z")
I am performing few experiments with secondary index and node migration. I have about 800k records in a 3 node cluster with replication factor of 2. There is a integer bin having secondary index. I am running on Aerospik… --- ## [Secondary index on huge number of records](https://discuss.aerospike.com/t/secondary-index-on-huge-number-of-records/4886)
**Author:** [@Rafiq\_Ahmed](https://discuss.aerospike.com/u/Rafiq_Ahmed)\ **Replies:** 7\ **Last updated:** [January 31, 2018, 2:33pm UTC](https://discuss.aerospike.com/t/secondary-index-on-huge-number-of-records/4886 "2018-01-31T14:33:56Z")
Hi, Is it advisable creating secondary index on the set having huge number of records (like 30 million records, and all records having the bin for which I want to create the secondary index) ? If it is not the good opt… --- ## [Poor streaming UDF performance](https://discuss.aerospike.com/t/poor-streaming-udf-performance/4833)
**Author:** [@Ernest](https://discuss.aerospike.com/u/Ernest)\ **Replies:** 3\ **Last updated:** [December 26, 2017, 10:53am UTC](https://discuss.aerospike.com/t/poor-streaming-udf-performance/4833 "2017-12-26T10:53:43Z")
New to Aerospike from MongoDB and found hundreds times slower using streaming UDF than query with WHERE clause. I’d like to do custom query on a set of ~2700 Book records (~30 bins) with OwnerID\_Hex=“57120d7151c643ab42a… --- ## [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 +-------------------+-----------------------+---------------… [Next page](https://discuss.aerospike.com/tag/secondary/23.md?match_all_tags=true&page=1&tags%5B%5D=secondary)