How to write wildcard seach statement


#1

I am trying to search data based on secondery index column. How to fetch data for the wildcard string.


#2

This can’t be done yet. You can only do quality and range searches on secondary indexes.


#3

A way to implement a wild card search could be through the use of a StreamUDF as part of an Aggregation. Take a look at the example in Aerospike labs:

http://www.aerospike.com/community/labs/query_multiple_filters.html

You do need to initiate a query on a secondary index first, but the output of that query can be passed into a Filter UDF that can do any king of wild card checking on the tuple. Because its a UDF you are only limited by what you can code in Lua.