[HIVE-15782] query on parquet table returns incorrect result when hive.optimize.index.filter is set to true

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.2.0
• Fix Version/s: 2.3.0
• Component/s: File Formats
• Assignee: Aihua Xu
• Reporter: Aihua Xu
• Created: 01/Feb/17 18:46
• Updated: 21/Jul/17 18:36
• Resolved: 06/Feb/17 14:23

Description

When hive.optimize.index.filter is set to true, the parquet table is filtered using the parquet column index.

set hive.optimize.index.filter=true;
CREATE TABLE t1 (
  name string,
  dec decimal(5,0)
) stored as parquet;

insert into table t1 values('Jim', 3);
insert into table t1 values('Tom', 5);

select * from t1 where (name = 'Jim' or dec = 5);

Only one row Jim, 3 is returned, but both should be returned.