You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/07/31 07:53:45 UTC

[jira] [Updated] (DRILL-546) Query across Hive and HBase fails with Unsupported operation exception

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

Jacques Nadeau updated DRILL-546:
---------------------------------

    Fix Version/s:     (was: 0.4.0)
                   0.5.0

> Query across Hive and HBase fails with Unsupported operation exception
> ----------------------------------------------------------------------
>
>                 Key: DRILL-546
>                 URL: https://issues.apache.org/jira/browse/DRILL-546
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>            Reporter: Neeraja
>            Assignee: Jinfeng Ni
>            Priority: Critical
>             Fix For: 0.5.0
>
>
> Trying to perform a join across Hive table and HBase table using following queries (with and without sub-query). HBase just has one row corresponding one of the users in Hive table.
>  
> select c_custkey from hive.customer where c_custkey in (select cast(up.`row_key` as int) from hbase.`userprofile` up);
> select c.c_custkey from hive.customer c JOIN hbase.`userprofile` up ON c.c_custkey=cast(up.`row_key` as int) ;
> The second query returns no results and the first one returns the exception below.
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "850c9f38-9e97-4153-93da-9e700a7d20a6"
> message: "Failure while running fragment. < UnsupportedOperationException:[ Attemped to access a DeadBuf. This would happen if you attempted to interact with a buffer that has been moved or not yet initialized. ]"



--
This message was sent by Atlassian JIRA
(v6.2#6252)