# Select \* from \<namespace\>.\<set-name\> ------ throws UNSUPPORTED\_FEATURE Error

**URL:** <https://discuss.aerospike.com/t/select-from-namespace-set-name-throws-unsupported-feature-error/10863>\
**Category:** AQL\
**Created:** [March 1, 2024, 2:50am UTC](https://discuss.aerospike.com/t/select-from-namespace-set-name-throws-unsupported-feature-error/10863 "2024-03-01T02:50:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rupinder\_Guron](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rupinder_guron/32/2213_2.png) [@Rupinder\_Guron](https://discuss.aerospike.com/u/Rupinder_Guron)\
**Post date:** [March 1, 2024, 2:50am UTC](https://discuss.aerospike.com/t/select-from-namespace-set-name-throws-unsupported-feature-error/10863/1 "2024-03-01T02:50:30Z")

</div>

`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.

---

<div class="post-metadata">

**Author:** ![pgupta](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/pgupta/32/2351_2.png) [@pgupta](https://discuss.aerospike.com/u/pgupta)\
**Post date:** [March 1, 2024, 4:08am UTC](https://discuss.aerospike.com/t/select-from-namespace-set-name-throws-unsupported-feature-error/10863/2 "2024-03-01T04:08:44Z")

</div>

```auto
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:

```auto
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

---

<div class="post-metadata">

**Author:** ![Rupinder\_Guron](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rupinder_guron/32/2213_2.png) [@Rupinder\_Guron](https://discuss.aerospike.com/u/Rupinder_Guron)\
**Post date:** [March 1, 2024, 4:38am UTC](https://discuss.aerospike.com/t/select-from-namespace-set-name-throws-unsupported-feature-error/10863/3 "2024-03-01T04:38:34Z")

</div>

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

```auto
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