drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1510) Join does not work in Hbase
Date Fri, 16 Jan 2015 00:01:34 GMT

    [ 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)

Mime
View raw message