drill-issues mailing list archives

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

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

Mehant Baid commented on DRILL-1663:

The implicit cast was added only for hash join. Reason being that we apply the cast only on
top of the expression for hash function and not comparison functions. We have implementations
of comparison functions which can take different inputs so we don't need cast for those. Hence
this bug exists only in hash join code path. I disabled hash join and the query works fine
for merge join.

> 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

View raw message