drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "amit hadke (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3991) Support schema changes in hash join operator
Date Wed, 28 Oct 2015 19:05:27 GMT

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

amit hadke commented on DRILL-3991:
-----------------------------------

Design Document:

https://docs.google.com/document/d/1XVaq4dD_62-EYjQKuye5rPCOT_MZrR0c9Rjy0bx99Aw/edit?usp=sharing

> 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)

Mime
View raw message