by simonc » Mon Jul 07, 2014 6:37 am When I do a SELECT I don’t seem to be able to get the PK of a row. Example: aql> select firstName, PK from test.user +-----------------+ | firstName | +-----------------+ | "firstNameTEST" | +-----------------+ When I do “SELECT * from test.user” I don’t the P…

by Bhuvana » Wed Jul 09, 2014 11:51 am Hi Simonc, Which version of Aerospike (server, client) are you using ? We have recently added the ability to store and retrieve primary-keys along with the other bins in the record. This is specific to the C-client and I dont think other clients support it y…

I am using AeroSpike Server Community Edition 3.3.12 and AeroSpike Python Client 1.0.27 which does not have support to SELECT PK along with bins. When AeroSpike will add this MUST needed functionality to Python Client? Is there any way to see “what all keys are in my cluster?” I appreciate if Ae…

In the Python client release 1.0.30 the default behavior is to send the key: pip search aerospike aerospike - Aerospike Client Library for Python INSTALLED: 1.0.30 (latest) The following script from __future__ import print_function import aerospike import sys try: client =…

EXPLAIN requires PK as condition to show any record. So is this really possible to see primary key usiing EXPLAIN ? @rbotzer

Ignore my previous post. However it’s being worked on now.

https://discuss.aerospike.com/t/how-do-i-get-the-primary-key-pk-using-aql/7517

AQL: PK in a SELECT

Tools AQL

AnilKumar_Valluri April 21, 2016, 2:24pm 5

still it is not supported in aql ?

Topic		Replies	Views
AQL select with PK AQL query , pk , java , aql	9	19131	June 9, 2020
AQL: how to get primary key aql	4	14979	February 5, 2018
How to get record PK (primary key) with aql Feature Discussion pk	3	4940	April 26, 2016
How to fetch primary key in Aerospike Node.js Client	1	2268	May 4, 2016
Primary Key search Java Client key , query , secondary , primary , index	6	4936	November 28, 2014

AQL: PK in a SELECT

Related topics