# How to extract bin level LUT on Aerospike?

**URL:** <https://discuss.aerospike.com/t/how-to-extract-bin-level-lut-on-aerospike/8684>\
**Category:** General Discussion\
**Created:** [August 1, 2021, 2:14pm UTC](https://discuss.aerospike.com/t/how-to-extract-bin-level-lut-on-aerospike/8684 "2021-08-01T14:14:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Zvi\_Mints](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/zvi_mints/32/1704_2.png) [@Zvi\_Mints](https://discuss.aerospike.com/u/Zvi_Mints)\
**Post date:** [August 1, 2021, 2:14pm UTC](https://discuss.aerospike.com/t/how-to-extract-bin-level-lut-on-aerospike/8684/1 "2021-08-01T14:14:18Z")

</div>

How can i extract specific **PK** record bin LUT?

```auto
aql> set RECORD_PRINT_METADATA true
RECORD_PRINT_METADATA = true
aql> select * from dv.page-avoidance-classifications where PK = <PK>
+--------------------------+-------------+-----------------+------------------------+------------------------------+-------+-------+
| A | B | C | D | E | {ttl} | {gen} |
+--------------------------+-------------+-----------------+------------------------+------------------------------+-------+-------+
| MAP('{266:NIL, 20:NIL}') | MAP('{}') | MAP('{20:NIL}') | MAP('{266:2, 20:NIL}') | LIST('[[20, -1], [266, 2]]') | -1 | 3200 |
+--------------------------+-------------+-----------------+------------------------+------------------------------+-------+-------+
1 row in set (0.001 secs)

```

I cannot find anything that matches `LUT` on the metadata

---

<div class="post-metadata">

**Author:** ![meher](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/meher/32/1644_2.png) [@meher](https://discuss.aerospike.com/u/meher)\
**Post date:** [August 2, 2021, 10:55pm UTC](https://discuss.aerospike.com/t/how-to-extract-bin-level-lut-on-aerospike/8684/2 "2021-08-02T22:55:13Z")

</div>

This is actually currently not supported. Even the record level LUT is not returned as part of the metadata at this point. I do hope that it will eventually be available but would require a client/server protocol change I believe.

Having said that, there may be ways to work around this and have a UDF return this data. Maybe others more knowledgeable on how to do this will provide some input here.

---

<div class="post-metadata">

**Author:** ![meher](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/meher/32/1644_2.png) [@meher](https://discuss.aerospike.com/u/meher)\
**Post date:** [August 3, 2021, 3:10am UTC](https://discuss.aerospike.com/t/how-to-extract-bin-level-lut-on-aerospike/8684/3 "2021-08-03T03:10:24Z")

</div>

Similar post on Stackoverflow it seems: [How to query bin level LUT on Aerospike 5.5? - Stack Overflow](https://stackoverflow.com/questions/68611392/how-to-query-bin-level-lut-on-aerospike-5-5)

---

<div class="post-metadata">

**Author:** ![system](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/system/32/2274_2.png) [@system](https://discuss.aerospike.com/u/system)\
**Post date:** [August 3, 2022, 3:10am UTC](https://discuss.aerospike.com/t/how-to-extract-bin-level-lut-on-aerospike/8684/4 "2022-08-03T03:10:55Z")

</div>

Closed on August 3, 2022, 3:10am UTC

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.