[DRILL-1603] For hive tables partitioned by date, Drill scan all partitions even when there is a filter

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Component/s: Query Planning & Optimization
• Assignee: Unassigned
• Reporter: Rahul Kumar Challapalli
• Created: 29/Oct/14 17:58
• Updated: 04/Jan/15 23:57
• Resolved: 04/Jan/15 23:57

Description

git.commit.id.abbrev=6dca24a

When we have a hive table whose partition column data type is 'DATE', Drill scans all the partitions even when we apply a filter on the partition column. This does not happen with 'INT' and 'STRING' partition datatypes

explain plan for select l_orderkey from lineitem_text_partitioned_hive_date where dt= date '2014-10-20';

Attached the output of the above query, the hive ddl, and the sample data files used