Jitendra Nath Pandey created HIVE-5495:
------------------------------------------
Summary: Jobs should not be launched if filter predicate is known
to be false.
Key: HIVE-5495
URL: https://issues.apache.org/jira/browse/HIVE-5495
Project: Hive
Issue Type: Bug
Reporter: Jitendra Nath Pandey
Hive launches job for the following query, which is not needed:
select * from Table where False;
In many cases the planner can determine that predicate will always be false,
for example:
select * from Table where intCol = 1.5 and x = 3; // intCol is of int type
Hive optimizes (intCol = 1.5) to false and results in following predicate:
"false and x = 3"
This can be further optimized to evaluate to false and no job needs to be
launched.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
