You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Mani M (JIRA)" <ji...@apache.org> on 2018/12/26 10:25:00 UTC
[jira] [Commented] (HIVE-18167) Optimizer: Rewrite Constant BETWEEN
col1 and col2 for PPD
[ https://issues.apache.org/jira/browse/HIVE-18167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16728976#comment-16728976 ]
Mani M commented on HIVE-18167:
-------------------------------
Hi Team
I can take this up, but let me know which sources need to be changed.
> 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)