[
https://issues.apache.org/jira/browse/HIVE-12021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14948403#comment-14948403
]
Jesus Camacho Rodriguez commented on HIVE-12021:
------------------------------------------------
[~jpullokkaran], I do not understand the case above.
1) x=f\(y) would not be picked, as f\(y) is not a literal constant. We would
bail out of the rule for safety (lines 180, 181). In follow-up HIVE-12044, we
could study if/how we could extend the rule for these cases.
2) If we have the following predicate:
(x=2 and x=10 and expr1) or (x=10 and expr2)
we can infer the condition (x=2 or x=10), even if x=2 is not in both disjuncts;
what matters is that x is in both CNF disjuncts.
> HivePreFilteringRule may introduce wrong common operands
> --------------------------------------------------------
>
> Key: HIVE-12021
> URL: https://issues.apache.org/jira/browse/HIVE-12021
> Project: Hive
> Issue Type: Bug
> Components: CBO
> Affects Versions: 1.3.0, 1.2.1, 2.0.0
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Fix For: 1.3.0, 2.0.0, 1.2.2
>
> Attachments: HIVE-12021.01.patch, HIVE-12021.02.patch,
> HIVE-12021.02.patch
>
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)