[
https://issues.apache.org/jira/browse/DRILL-1510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14297933#comment-14297933
]
Hanifi Gunes commented on DRILL-1510:
-------------------------------------
Marking this as minor with the thinking that it is a seldom case that occurs
only if user executes a join on top of empty schema-free table(s).
Unfortunately, current HashJoin implementation does not consider the situation
where a file is empty. It handles just fine if an incoming batch is empty
though. I think we should discuss at first if spending many engineering hours
on this worth the result. This is my two cents.
> 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: Query Planning & Optimization
> Reporter: Rahul Challapalli
> Assignee: Hanifi Gunes
> Priority: Minor
> Fix For: Future
>
> 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)
