drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1663) Implicit cast to variable width type does not work in join conditions
Date Fri, 07 Nov 2014 23:54:33 GMT

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

Jinfeng Ni commented on DRILL-1663:
-----------------------------------

The code fix in ChainedHashTable looks good to me. 

Do we also need fix Merge Join as well? Can you try to disable hash join, and run merge join
with the original failing query, to see how it goes?



> Implicit cast to variable width type does not work in join conditions
> ---------------------------------------------------------------------
>
>                 Key: DRILL-1663
>                 URL: https://issues.apache.org/jira/browse/DRILL-1663
>             Project: Apache Drill
>          Issue Type: Bug
>            Reporter: Mehant Baid
>            Assignee: Mehant Baid
>            Priority: Minor
>         Attachments: DRILL-1663.patch
>
>
> Currently if the two sides of a join condition are of different types then we implicitly
add a cast on one side so that the join condition works as expected. However when we apply
a cast to variable width type (varchar or varbinary) we don't include the length parameter
as part of the arguments. This causes the function resolver to not match against any function
implementation and return a NULL expression. 



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

Mime
View raw message