[
https://issues.apache.org/jira/browse/DRILL-1510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14279555#comment-14279555
]
Rahul Challapalli commented on DRILL-1510:
------------------------------------------
Plan for the failing query
{code}
| 00-00 Screen
00-01 UnionExchange
01-01 Project(name=[$1])
01-02 HashJoin(condition=[=($0, $2)], joinType=[inner])
01-04 HashToRandomExchange(dist0=[[$0]])
02-01 Project($f6=[ITEM($0, 'name')], ITEM=[ITEM($0, 'name')])
02-02 Scan(groupscan=[HBaseGroupScan
[HBaseScanSpec=HBaseScanSpec [tableName=student, startRow=null, stopRow=null,
filter=null], columns=[`onecf`.`name`]]])
01-03 HashToRandomExchange(dist0=[[$0]])
03-01 Project($f5=[ITEM($0, 'name')])
03-02 Scan(groupscan=[HBaseGroupScan
[HBaseScanSpec=HBaseScanSpec [tableName=voter, startRow=null, stopRow=null,
filter=null], columns=[`onecf`.`name`]]])
{code}
> 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
> Fix For: 0.8.0
>
> 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)
