Select * from <namespace>.<set-name> ------ throws UNSUPPORTED_FEATURE Error

Tools AQL
1

Select * from dev.foo ----fails with AEROSPIKE_ERR_UNSUPPORTED_FEATURE

while select * from dev.foo where PK='134' works fine

I am running both aerospikedb and aerospike-tools on mac — Docker Docker images being used: aerospike/aerospike-tools:3.15.0.3 aerospike/aerospike-server:latest

Not sure if I am missing any config option.

2 
aql> run "aqlScripts/insert.aql"
INSERT INTO test.testset (PK, name, age) VALUES ('key1', 'Jack', 26)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key2', 'Jill', 20)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key3', 'James', 38)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key4', 'Jim', 46)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key5', 'Julia', 62)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key6', 'Sally', 32)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key7', 'Sean', 24)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key8', 'Sam', 12)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key9', 'Susan', 42)
OK, 1 record affected.

INSERT INTO test.testset (PK, name, age) VALUES ('key0', 'Sandra', 34)
OK, 1 record affected.

aql> select * from test.testset
select * from test.testset
+--------+----------+-----+
| PK     | name     | age |
+--------+----------+-----+
| "key6" | "Sally"  | 32  |
| "key7" | "Sean"   | 24  |
| "key0" | "Sandra" | 34  |
| "key2" | "Jill"   | 20  |
| "key4" | "Jim"    | 46  |
| "key1" | "Jack"   | 26  |
| "key8" | "Sam"    | 12  |
| "key3" | "James"  | 38  |
| "key5" | "Julia"  | 62  |
| "key9" | "Susan"  | 42  |
+--------+----------+-----+
10 rows in set (0.039 secs)
aql> select * from test.testset where pk="key5"
select * from test.testset where pk="key5"
+--------+---------+-----+
| PK     | name    | age |
+--------+---------+-----+
| "key5" | "Julia" | 62  |
+--------+---------+-----+
1 row in set (0.002 secs)

OK

Only difference is I am running on an AWS instance. My AQL version is:

aql> help
Aerospike Query Client
Version 8.1.0
C Client Version 6.3.0
Copyright 2012-2022 Aerospike. All rights reserved.

Server version: E-6.2.0.7

3

thanks @pgupta for a quick response. After upgrading the tool to

aql> help
Aerospike Query Client
Version 7.0.4
C Client Version 6.0.0
Copyright 2012-2021 Aerospike. All rights reserved.

it works well. we can close the issue. Regards