[HIVE-20597] full table scan in WHERE clause OR condition

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.3.2
• Component/s: HiveServer2, hpl/sql
• Labels: patch

Environment

hive server2; hive version is 2.3.2; 

• Hadoop Flags: Incompatible change, Reviewed
• Flags: Patch
• Assignee: Unassigned
• Reporter: lishiyang
• Created: 19/Sep/18 12:57
• Updated: 19/Sep/18 12:57

Description

In strict mode, I query my hql on a partitioned table:

select * from tbl where date = '2018-08-08' or age > 18

The table tbl is partitioned, and its partition key is date, age is just a attribute column.

This hql in strict mode can be executed, when the condition is "date = '2018-08-08' " this query scans one partition only but when the condition is "age > 18" ,the query will scan the full table.

It seems that in strict mode,Hive checks the condition of table partition but ignores the logic of where clause?

Any help is useful！

Thanks！