[
https://issues.apache.org/jira/browse/HIVE-18167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16736997#comment-16736997
]
Peter Vary commented on HIVE-18167:
-----------------------------------
[[email protected]]: I would start from here:
[https://github.com/apache/hive/blob/b3ef75eaa1e828f8c80d95ea7c32abcd1f000ef4/ql/src/java/org/apache/hadoop/hive/ql/optimizer/Optimizer.java#L96],
but not exactly sure what would be the best way to solve this myself :D
> Optimizer: Rewrite Constant BETWEEN col1 and col2 for PPD
> ---------------------------------------------------------
>
> Key: HIVE-18167
> URL: https://issues.apache.org/jira/browse/HIVE-18167
> Project: Hive
> Issue Type: Improvement
> Components: Logical Optimizer
> Reporter: Gopal V
> Priority: Major
> Labels: newbie++
>
> {code}
> CURRENT_DATE between start_date and end_date
> {code}
> is not pushed down to the predicate layer, while the inclusive comparison ops
> {code}
> start_date <= CURRENT_DATE and end_date >= CURRENT_DATE
> {code}
> are evaluated at the row-index level.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
