Large list scan and remove from different set


Hi, Here is my use case. I have one set which has Large List that contains reference of guid (PK) of other set.

Set 1: Customer: id(PK) | cities (large list containing guid of city) Set 2: City: guid(PK) | name

I want to achieve the below use case using lua script.

  1. For specific city it should scan the large list of customer table.
  2. If no customer have reference of city in large list then delete customer.




Effective immediately, we will no longer actively support the LDT feature and will eventually remove the API. The exact deprecation and removal timeline will depend on customer and community requirements. Instead of LDTs, we advise that you use our newer List and SortedMap APIs, which are now available in all Aerospike-supported clients at the General Availability level. Read our blog post for details.