Skip to content

read_parquet : Not showing File Filter/Partition Filter in Physical Plan #302

@diwanmail

Description

@diwanmail

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

Image

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

Image

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions