[jira] [Created] (HIVE-20597) full table scan in WHERE clause OR condition

[lishiyang (JIRA)]

lishiyang created HIVE-20597:
--------------------------------

             Summary: full table scan in WHERE clause OR condition
                 Key: HIVE-20597
                 URL: https://issues.apache.org/jira/browse/HIVE-20597
             Project: Hive
          Issue Type: Bug
          Components: HiveServer2, hpl/sql
    Affects Versions: 2.3.2
         Environment: hive server2; hive version is 2.3.2; 
            Reporter: lishiyang


*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！



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)