[HIVE-11035] PPD: Orc Split elimination fails because filterColumns=[-1]

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0, 1.0.0, 1.1.0, 1.2.0, 1.3.0, 2.0.0
• Fix Version/s: 1.2.1
• Assignee: Prasanth Jayachandran
• Reporter: Gopal Vijayaraghavan
• Created: 17/Jun/15 15:56
• Updated: 19/Jun/15 23:30
• Resolved: 18/Jun/15 06:56

Description

create temporary table xx (x int) stored as orc ;
insert into xx values (20),(200);
set hive.fetch.task.conversion=none;
select * from xx where x is null;

This should generate zero tasks after optional split elimination in the app master, instead of generating the 1 task which for sure hits the row-index filters and removes all rows anyway.

Right now, this runs 1 task for the stripe containing (min=20, max=200, has_null=false), which is broken.

Instead, it returns YES_NO_NULL from the following default case

https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/io/orc/OrcInputFormat.java#L976

Issue Links

• is related to: HIVE-7052 Optimize split calculation time