[
https://issues.apache.org/jira/browse/DRILL-1510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14164401#comment-14164401
]
Mehant Baid commented on DRILL-1510:
------------------------------------
The error seems to indicate that the join condition has varbinary data type on
one side and int data type on the other. Currently we don't support such
implicit cast in the join condition, only straight forward casts like
(int->bigint, int->float etc).
However since the query is against HBase it shouldn't have int datatype and
both sides should be of varbinary datatype. Could you please provide the plan,
I want to check if Drill is injecting a cast for some reason.
> Join does not work in Hbase
> ---------------------------
>
> Key: DRILL-1510
> URL: https://issues.apache.org/jira/browse/DRILL-1510
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Reporter: Rahul Challapalli
> Attachments: error.txt, studenttab, votertab
>
>
> git.commit.id.abbrev=29dde76
> The below query which joins 2 hbase tables fails with the below error
> {code}
> select student.onecf['name'] name from student inner join voter on
> (student.onecf['name'] = voter.onecf['name']);
> Query failed: Failure while running fragment. Failure finding function that
> runtime code generation expected. Signature: compare_to(
> VARBINARY:OPTIONALINT:OPTIONAL, ) returns INT:REQUIRED
> [0ffd82e9-43ac-4a29-934f-b72fa76ddb78]
> {code}
> Attached the data and log files
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
