[DRILL-3788] Directory based partition pruning not taking effect with metadata caching

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Fix Version/s: 1.2.0
• Component/s: Query Planning & Optimization
• Assignee: Mehant Baid
• Reporter: Rahul Kumar Challapalli
• Created: 16/Sep/15 01:05
• Updated: 10/Dec/15 01:29
• Resolved: 01/Oct/15 22:07

Description

git.commit.id.abbrev=240a455

Partition Pruning did not take place for the below query after I executed the "refresh table metadata command"

 explain plan for 
select
  l_returnflag,
  l_linestatus
from
  `lineitem/2006/1`
where
  dir0=1 or dir0=2

The logs did not indicate that "pruning did not take place"

Before executing the refresh table metadata command, partition pruning did take effect

I am not attaching the data set as it is larger than 10MB. Reach out to me if you need more information