[DRILL-7022] Partition pruning is not happening the first time after the metadata auto refresh - ASF JIRA

XML

Word

Printable

JSON

Data creation:

Create table:

create table dfs.tmp.`orders` 
partition by (o_orderstatus)
as select * from cp.`tpch/orders.parquet`

Create table metadata:

refresh table metadata dfs.tmp.`orders`

Steps:

Modify the table to trigger metadata auto refresh:
```
hadoop fs -mkdir /tmp/orders/111
```

Run the query:

explain plan for 
select * from dfs.tmp.`orders` 
where o_orderstatus = 'O' and o_orderdate < '1995-03-10'

Expected result:
Partition pruning happens:

... numFiles=1, numRowGroups=1, usedMetadataFile=true ...

Actual result:
Partition pruning doesn't happen:

... numFiles=1, numRowGroups=3, usedMetadataFile=true

Note: It is being reproduced only the first time after auto refresh, after repeating the query it works as expected.

links to

GitHub Pull Request #1638