[jira] [Updated] (DRILL-1510) Join does not work in Hbase

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rahul Challapalli updated DRILL-1510:
-------------------------------------
    Attachment: votertab
                studenttab
                error.txt

Same is the case with a full outer join

{code}
select student.onecf['name'] name from student full outer 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 [f57b842d-d7ae-496b-85b9-9f375a1fa679]
{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: 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)