You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2019/04/09 08:06:00 UTC

[jira] [Work logged] (HIVE-21231) HiveJoinAddNotNullRule support for range predicates

     [ https://issues.apache.org/jira/browse/HIVE-21231?focusedWorklogId=224806&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-224806 ]

ASF GitHub Bot logged work on HIVE-21231:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 09/Apr/19 08:05
            Start Date: 09/Apr/19 08:05
    Worklog Time Spent: 10m 
      Work Description: miklosgergely commented on pull request #580: HIVE-21231 HiveJoinAddNotNullRule support for range predicates
URL: https://github.com/apache/hive/pull/580
 
 
   
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

    Worklog Id:     (was: 224806)
    Time Spent: 20m  (was: 10m)

> HiveJoinAddNotNullRule support for range predicates
> ---------------------------------------------------
>
>                 Key: HIVE-21231
>                 URL: https://issues.apache.org/jira/browse/HIVE-21231
>             Project: Hive
>          Issue Type: Improvement
>          Components: CBO
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Miklos Gergely
>            Priority: Major
>              Labels: newbie, pull-request-available
>             Fix For: 4.0.0
>
>         Attachments: HIVE-21231.01.patch, HIVE-21231.02.patch, HIVE-21231.03.patch, HIVE-21231.04.patch, HIVE-21231.05.patch, HIVE-21231.06.patch, HIVE-21231.07.patch, HIVE-21231.08.patch, HIVE-21231.09.patch, HIVE-21231.10.patch, HIVE-21231.11.patch, HIVE-21231.12.patch, HIVE-21231.13.patch, HIVE-21231.14.patch
>
>          Time Spent: 20m
>  Remaining Estimate: 0h
>
> For instance, given the following query:
> {code:sql}
> SELECT t0.col0, t0.col1
> FROM
>   (
>     SELECT col0, col1 FROM tab
>   ) AS t0
>   INNER JOIN
>   (
>     SELECT col0, col1 FROM tab
>   ) AS t1
> ON t0.col0 < t1.col0 AND t0.col1 > t1.col1
> {code}
> we could still infer that col0 and col1 cannot be null for any of the inputs. Currently we do not.



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