AQL - How to show PK in SELECT

Question

How to enable PK when choosing AQL?

Example:

SELECT * by test.users

Return:

FirstName, LastName, etc.

What I really want to know is a PC or a key so that I can delete the line. How to include PK in a SELECT AQL statement.

Answer 1

By default, Aerospike does not store the actual primary key in the database. By default, it saves a 20-byte digest (key hash). This will be a huge savings for big keys. However, in the latest version, this can be changed using put () to save the key. But the AQL client has not yet been improved to use this fact. I will make an internal ticket for this improvement.

Average time ...

• option-1: , ( ) base64. .
• option-2: C/Java API, . .

Answer 2

. , API scanAll, . scanCallback .

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

AQL, , , , , sendKey WritePolicy. strong > . SendKey - . .

Answer 3

Alternative solution

create an extra bit to save the primary key and index it. Then you can get this primary key using the AQL statement.