Neeraja created DRILL-546:
-----------------------------

             Summary: 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
            Reporter: Neeraja


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)

Reply via email to