# Dremio 3.3.2 CE version only support 1 pushdown filter on ParquetScan?

**URL:** <https://community.dremio.com/t/dremio-3-3-2-ce-version-only-support-1-pushdown-filter-on-parquetscan/3983>\
**Category:** Uncategorized\
**Created:** [September 2, 2019, 8:53am UTC](https://community.dremio.com/t/dremio-3-3-2-ce-version-only-support-1-pushdown-filter-on-parquetscan/3983 "2019-09-02T08:53:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fengliu77](https://avatars.discourse-cdn.com/v4/letter/f/ebca7d/32.png) [@fengliu77](https://community.dremio.com/u/fengliu77)\
**Post date:** [September 2, 2019, 8:53am UTC](https://community.dremio.com/t/dremio-3-3-2-ce-version-only-support-1-pushdown-filter-on-parquetscan/3983/1 "2019-09-02T08:53:34Z")

</div>

Today I ran a SQL on parquet though Dremio 3.3.2 with 2 filters. But when I looked at the physical plan, only 1 filter push downed into parquet scan. I ran the same SQL on Apache Drill and 2 filters are push downed.

---

<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:** [September 3, 2019, 5:36am UTC](https://community.dremio.com/t/dremio-3-3-2-ce-version-only-support-1-pushdown-filter-on-parquetscan/3983/2 "2019-09-03T05:36:13Z")

</div>

@fengliu77

Please send us the job profile from the jobs page

[Share a query profile](https://www.dremio.com/tutorials/share-query-profile-dremio/)

---

<div class="post-metadata">

**Author:** ![fengliu77](https://avatars.discourse-cdn.com/v4/letter/f/ebca7d/32.png) [@fengliu77](https://community.dremio.com/u/fengliu77)\
**Post date:** [September 4, 2019, 3:04am UTC](https://community.dremio.com/t/dremio-3-3-2-ce-version-only-support-1-pushdown-filter-on-parquetscan/3983/3 "2019-09-04T03:04:28Z")

</div>

[71add1dd-d654-4f90-9688-055b54f510e1.zip](https://community.dremio.com/uploads/short-url/2I0d1uPHJ8usIMxq1vyas4LSw5P.zip) (10.9 KB)

Hi Balaji,

I have attached the job profile. I ran the following query in Dremio 3.3.2 UI  
SELECT \* FROM “yelp-business” where ADDRESS=‘3077 Mayfield Rd’ and CITY=‘Cleveland Heights’

yelp-business is a yelp dataset in parquet format.

In physical plan, only 1 filter is push-down into parquet scan.  
ParquetScan(table=["@fliu".“yelp-business”], columns=[`ADDRESS`, `ATTRIBUTES`, `BUSINESS_ID`, `CATEGORIES`, `CITY`, `HOURS`, `IS_OPEN`, `LATITUDE`, `LONGITUDE`, `NAME`, `POSTAL_CODE`, `REVIEW_COUNT`, `STARS`, `STATE`], splits=[1], filters=[[Filter on `CITY`: equal(`CITY`, ‘Cleveland Heights’)]]) : rowType = RecordType(VARCHAR(65536) ADDRESS, ANY ATTRIBUTES, VARCHAR(65536) BUSINESS\_ID, VARCHAR(65536) CATEGORIES, VARCHAR(65536) CITY, ANY HOURS, BIGINT IS\_OPEN, DOUBLE LATITUDE, DOUBLE LONGITUDE, VARCHAR(65536) NAME, VARCHAR(65536) POSTAL\_CODE, BIGINT REVIEW\_COUNT, DOUBLE STARS, VARCHAR(65536) STATE): rowcount = 28891.35, cumulative cost = {28891.35 rows, 1675698.2999999998 cpu, 1675698.2999999998 io, 1675698.2999999998 network, 0.0 memory}, id = 407

Today I ran the same query using Spark and Drill. Both are pushdown 2 filters in parquet scan. I am not sure why Dremio only support 1 filter in ParquetScan. This will introduce much more data from parquet to Dremio.

---

<div class="post-metadata">

**Author:** ![fengliu77](https://avatars.discourse-cdn.com/v4/letter/f/ebca7d/32.png) [@fengliu77](https://community.dremio.com/u/fengliu77)\
**Post date:** [September 5, 2019, 8:22am UTC](https://community.dremio.com/t/dremio-3-3-2-ce-version-only-support-1-pushdown-filter-on-parquetscan/3983/4 "2019-09-05T08:22:50Z")

</div>

I investigated this issue more and just want to check if dremio is doing row group filter on parquet scan?