# Partition filter not used when in clause
**URL:** https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879
**Category:** Uncategorized
**Created:** [May 27, 2024, 3:21pm UTC](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879 "2024-05-27T15:21:59Z")
**Posts on this page:** 7
**Page:** 2
### Author:  [@dacopan](https://community.dremio.com/u/dacopan)
#### Post date: [July 27, 2024, 4:13pm UTC](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879/21 "2024-07-27T16:13:51Z")
Hello @balaji.ramaswamy @Ivan_Chesnov any news?
---
### Author:  [@dacopan](https://community.dremio.com/u/dacopan)
#### Post date: [August 3, 2024, 2:12pm UTC](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879/22 "2024-08-03T14:12:08Z")
Hello @balaji.ramaswamy and @Ivan_Chesnov sorry by insistence, do you have any news about this ?
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [August 12, 2024, 5:02am UTC](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879/23 "2024-08-12T05:02:43Z")
@dacopan
Was trying to reproduce the issue but do not find the “show create table” statement for `ID_SPACE`, can you please give that also and will try a repro
---
### Author:  [@dacopan](https://community.dremio.com/u/dacopan)
#### Post date: [August 12, 2024, 2:21pm UTC](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879/24 "2024-08-12T14:21:37Z")
Hello this is the DDL of space
```sql
CREATE TABLE lake.prod.spaces
(
ID_SPACE varchar,
ID_PAGE varchar,
RED varchar
)
```
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [August 12, 2024, 2:24pm UTC](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879/25 "2024-08-12T14:24:06Z")
@dacopan Just so I am clear, `spaces` is also a Iceberg table and none of the columns are partition columns, correct?
---
### Author:  [@dacopan](https://community.dremio.com/u/dacopan)
#### Post date: [August 12, 2024, 2:28pm UTC](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879/26 "2024-08-12T14:28:27Z")
yes is a iceber table and has few rows \< 2k and this table has no partitions
---
### Author:  [@balaji.ramaswamy](https://community.dremio.com/u/balaji.ramaswamy)
#### Post date: [August 12, 2024, 2:37pm UTC](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879/27 "2024-08-12T14:37:27Z")
Thanks @dacopan Was able to reproduce your exact same symptom, let me investigate on my local repro
[Previous page](https://community.dremio.com/t/partition-filter-not-used-when-in-clause/11879.md?page=1)