I have created two secondary indexes (customer and orderID). It works well with single filter but when I try to chain two or more filters I run into the following bug: { code: 4, message: 'AEROSPIKE_ERR_REQUEST_INVALID', func: 'as_query_parse_records', file: 'src/main/aerospike/aerospike_quer…

Aerospike doesnt support multiple secondary index predicates in a single query call: [image] Secondary Index (SI) Query | Aerospike Documentation Use Aerospike's fast, high-concurrency queries to perform value-based searches on secondary indexes. Features a…

This pretty much makes Aerospike a cache machine rather than a database. I would love the Aerospike team to comment on this… Rafi

It’s a key/value store so that’s what it works well for, actions on a primary key. It’ll never be as flexible as a relational database with SQL but you can use Lua to create UDFs that do whatever filtering you need in Aerospike and I think the team is working on adding multiple filter ability in a …

Can you please share an example on how to use multi query filters using udf.

Client queries using multiple filters

Client Libraries Node.js Client

pgupta January 26, 2017, 9:36pm 6

Please see How to use Aggregation? and Record manipulation with more than one filter - lua

Topic		Replies	Views
Multiple filter in the statement Java Client secondary , filter , multiple , index	15	8016	August 22, 2019
Nodejs Client equal filter on secondary index (int) Node.js Client secondary , index	1	1773	March 10, 2015
Is it possible to use primary key along with secondary key in Aerospike for fetching a record? Query & Indexing primarykey , secondary , record , index	7	1750	March 30, 2021
Multiple filter using php client PHP Client Library filter , predicate	2	2007	October 28, 2016
How to create secondary index on multiple fields (composite key) Operations	4	1793	October 18, 2021

Client queries using multiple filters

Related topics