Is there 'and' query in aerospike shell?


#1

Hello,

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 !


#2

You could perform a sindex query on the most selective, and do additional filtering in the app. Or use a predicate filter; http://www.aerospike.com/docs/guide/predicate.html . I don’t think its possible in AQL though