Search code examples
aerospikeaql

Aerospike AQL Query Against List of Values


In AQL I can do

select * from ns.set where PK='some val'

How can I query against a list of values? Something like

select * from ns.set where PK in ('val1', 'val2'...)

When trying to run above code I get 'Unsupported command format'


Solution

  • Not supported in AQL.

    Aerospike clients (what you will use in production) support this functionality. Its called Batch Index Read. http://www.aerospike.com/docs/guide/batch.html