You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2015/12/15 01:03:46 UTC

[jira] [Commented] (DRILL-3991) Support schema changes in hash join operator

    [ https://issues.apache.org/jira/browse/DRILL-3991?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15057008#comment-15057008 ] 

ASF GitHub Bot commented on DRILL-3991:
---------------------------------------

GitHub user amithadke opened a pull request:

    https://github.com/apache/drill/pull/299

    DRILL-3991 Initial patch to support schema changes in hash join.

    

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/amithadke/drill hash-join-schema

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/drill/pull/299.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #299
    
----
commit 9aaca44f06b0fed4c1070df18b32f6a8ad6eb8bd
Author: Amit Hadke <am...@gmail.com>
Date:   2015-12-14T23:44:17Z

    DRILL-3991 Initial patch to support schema changes in hash join.

----


> Support schema changes in hash join operator
> --------------------------------------------
>
>                 Key: DRILL-3991
>                 URL: https://issues.apache.org/jira/browse/DRILL-3991
>             Project: Apache Drill
>          Issue Type: Improvement
>            Reporter: amit hadke
>            Assignee: amit hadke
>
> Hash join should be able to support schema changes during execution.
> It should resolve edge cases when join columns are missing.
> Example:
> |Table A | Table B|
> | k1&nbsp;&nbsp;&nbsp; v1 | k2 &nbsp;&nbsp;&nbsp; v2|
> | 1 &nbsp;&nbsp;&nbsp;  "a" | "2" &nbsp;&nbsp;&nbsp; "b"|
> | 2 &nbsp;&nbsp;&nbsp; "b" | 1  &nbsp;&nbsp;&nbsp;  "a"|
> | 2.0 &nbsp;&nbsp;&nbsp;"b" | 2.0  &nbsp;&nbsp;&nbsp;"b"|
> | 3 &nbsp;&nbsp;&nbsp;"c" | |
>    
> A INNER JOIN B on A.k1=B.k2
> |k1 |  v1  |     k2|    v2|
> | 1 | "a" | 1 | "a" | 
> | 2  | "b" | 2.0 | "b" |
> | 2.0 | "b" | 2.0 | "b" |
> Where in output
>     
>     k1 is of union type (INTEGER, DOUBLE)
>     k2 is of union type (INTEGER, DOUBLE, VARCHAR)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)