[DRILL-546] Query across Hive and HBase fails with Unsupported operation exception

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Query Planning & Optimization
• Assignee: Krystal
• Reporter: Neeraja
• Created: 18/Apr/14 23:57
• Updated: 20/Aug/14 22:47
• Resolved: 18/Aug/14 15:43

Description

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. ]"