Is there 'and' query in aerospike shell?



Is there ‘and’ query in aerospike shell, I want to get data from this query, if not how to get data with two combinations of bin values

" select * from test.demo where id = 1 and name = ‘john’ "

Thanks !


You could perform a sindex query on the most selective, and do additional filtering in the app. Or use a predicate filter; . I don’t think its possible in AQL though