How to sort all lists in a specific bin in Aerospike using aql?

Question

I have a few question about ordered lists in Aerospike:

How can I see in the DB, using aql, if the list is ordered or not?
Does ordered list means it’s sorted?
I want to scan the db and change all lists (in a specific bin) to be ordered. I want to do is using set_type, but I can’t seem to make it work. Is that possible? how can I do it?

Thanks

Cross linked here:https://discuss.aerospike.com/t/list-oprations/5282 — Ronen Botzer, Jun 29 '18 at 00:29

Ronen Botzer · Accepted Answer · 2018-06-29T15:48:23.707

3

I'm posting my answer from your cross-posted question here https://discuss.aerospike.com/t/list-oprations/5282:

You could scan the namespace with a ScanPolicy.includeBinData=false and for each record digest you get back use operate() to wrap the following operations into a single transaction:

You will only need to run this once to clean up your database.

The ordering type will stick for all future operations. You'd just continue to use the ListWriteFlags.ADD_UNIQUE list policy.

This is for the Java client, but all other clients have these operations and policies in them.

edited Jun 29 '18 at 15:48

answered Jun 29 '18 at 15:05

Ronen Botzer

6,951
22
41

All future operations .. on those records that you just updated. If you insert new records, must use the correct flags again. Correct? – pgupta Jun 29 '18 at 22:51
As far as I know? Doesn’t hurt to be explicit, but I’ll check – Ronen Botzer Jul 01 '18 at 14:32

score 2 · Answer 2 · answered Jun 28 '18 at 17:28

I don't think AQL is the right tool to exploit the full power of lists. Perhaps it is not yet updated to the full functionality of lists. It is built on top of the C client. At least AQL ver 3.15.2.1 that I checked with is not. You might want to write a java client application.

How to sort all lists in a specific bin in Aerospike using aql?

2 Answers2