[ 
https://issues.apache.org/jira/browse/DRILL-3991?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

amit hadke reassigned DRILL-3991:
---------------------------------

    Assignee: amit hadke

> 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    v1 | k2     v2|
> | 1      "a" | "2"     "b"|
> | 2     "b" | 1       "a"|
> | 2.0    "b" | 2.0     "b"|
> | 3    "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)

Reply via email to