read_parquet : Not showing File Filter/Partition Filter in Physical Plan
- Dominant language
- C++
- Stars
- 60
- Forks
- 100
- Avg merge
- 1h 50m
- Merged PRs (30d)
- 25
Description
We are reading below parquet file with partitions on file system, when we see Explain physical plan, one of the File Filter is missing from Plan. If this is not pushed down due to some reason then it should somewhere should be shown in the plan.
Parquet files

read_parquet query
EXPLAIN SELECT * FROM read_parquet('', hive_partitioning = true) where date = 20221201 and id= 'ID';
EXPLAIN plan output -> ID file filter is missing

Contributor guide
No contributing guide indexed for this repository
Research direction
Start by running the provided EXPLAIN SELECT query against the partitioned Parquet data with hive_partitioning enabled and compare the physical plan output. Trace how the file and partition filters are represented in the plan; done means the ID filter is shown, including when pushdown is not applied.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- cpp, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100