# Upcoming support for query Apache Iceberg deleted data?

**URL:** https://community.dremio.com/t/upcoming-support-for-query-apache-iceberg-deleted-data/8302
**Category:** Uncategorized
**Created:** [November 8, 2021, 11:52am UTC](https://community.dremio.com/t/upcoming-support-for-query-apache-iceberg-deleted-data/8302 "2021-11-08T11:52:12Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![littleT](https://avatars.discourse-cdn.com/v4/letter/l/779978/32.png) [@littleT](https://community.dremio.com/u/littleT)
#### Post date: [November 8, 2021, 11:52am UTC](https://community.dremio.com/t/upcoming-support-for-query-apache-iceberg-deleted-data/8302/1 "2021-11-08T11:52:12Z")

</div>

Hi all, dremio19 support for apache iceberg V2 format table.However we found that the data has been deleted in iceberg can also been query by using (select \* from tableName/select count(1) from tableName). Is that a bug or has not been support for?

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [November 10, 2021, 6:56am UTC](https://community.dremio.com/t/upcoming-support-for-query-apache-iceberg-deleted-data/8302/2 "2021-11-10T06:56:43Z")

</div>

@littleT Have you refreshed metadata after the data got deleted?

---

<div class="post-metadata">

### Author: ![littleT](https://avatars.discourse-cdn.com/v4/letter/l/779978/32.png) [@littleT](https://community.dremio.com/u/littleT)
#### Post date: [November 11, 2021, 5:38am UTC](https://community.dremio.com/t/upcoming-support-for-query-apache-iceberg-deleted-data/8302/3 "2021-11-11T05:38:06Z")

</div>

Thanks for reply. yes,i did refreshed metadata after the data got deleted.  
Now I found the reason why the deleted data can be queried . It because the iceberg table was created by flink, and the data was process by flink cdc . When I used spark3.0 everything is OK.  
Now a new question is that I can not use spark to process cdc data, so I want to konow ,Is dremio plan to support Apache Iceberg using flink?

---

<div class="post-metadata">

### Author: ![balaji.ramaswamy](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/balaji.ramaswamy/32/843_2.png) [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [November 11, 2021, 7:07am UTC](https://community.dremio.com/t/upcoming-support-for-query-apache-iceberg-deleted-data/8302/4 "2021-11-11T07:07:00Z")

</div>

@littleT Need to check if this is supported or Dremio plans to support

---

<div class="post-metadata">

### Author: ![littleT](https://avatars.discourse-cdn.com/v4/letter/l/779978/32.png) [@littleT](https://community.dremio.com/u/littleT)
#### Post date: [November 15, 2021, 8:52am UTC](https://community.dremio.com/t/upcoming-support-for-query-apache-iceberg-deleted-data/8302/5 "2021-11-15T08:52:15Z")

</div>

@balaji.ramaswamy Hi,sorry for bothering you again.Recently I test the problem again and again,I am sure that the data dealed with flink cdc can be queried OK on my own spark3.0 ,but the dremio can also query out the deleted data,I read the dremio source code ,but can not found how the dremio use spark3.0 to deal with iceberg,no configre file ,no spark code in dremio,so I want to know how did dremio dealed the data using spark3.0. That should be useful for me

---

<div class="post-metadata">

### Author: ![chulucninh09](https://sea2.discourse-cdn.com/flex020/user_avatar/community.dremio.com/chulucninh09/32/3677_2.png) [@chulucninh09](https://community.dremio.com/u/chulucninh09)
#### Post date: [November 25, 2021, 1:57pm UTC](https://community.dremio.com/t/upcoming-support-for-query-apache-iceberg-deleted-data/8302/6 "2021-11-25T13:57:01Z")

</div>

Dremio uses iceberg Java API, check this code

> <https://github.com/dremio/dremio-oss/blob/master/sabot/kernel/src/main/java/com/dremio/exec/store/iceberg/model/IcebergCatalogType.java>
