Apache Drill
  1. Apache Drill
  2. DRILL-546

Query across Hive and HBase fails with Unsupported operation exception

    Details

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

        Activity

        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12860057 ] Drill workflow [ 12934601 ]
        Hide
        Krystal added a comment -

        git.commit.id.abbrev=654c879

        Verified that joins between hive and hbase tables work.

        Show
        Krystal added a comment - git.commit.id.abbrev=654c879 Verified that joins between hive and hbase tables work.
        Suresh Ollala made changes -
        Assignee Suresh Ollala [ sollala_drill ] Krystal [ knguyen ]
        Aman Sinha made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Assignee Aman Sinha [ amansinha100 ] Suresh Ollala [ sollala_drill ]
        Resolution Fixed [ 1 ]
        Hide
        Aman Sinha added a comment -

        Marking as fixed as per previous comments and assigning to QA to add regression test if necessary.

        Show
        Aman Sinha added a comment - Marking as fixed as per previous comments and assigning to QA to add regression test if necessary.
        Hide
        Aman Sinha added a comment -

        This is an older bug and is not reproducible anymore...also confirmed with Neeraja. Marking this as fixed. Please re-open another bug if new issues related to this are found.

        Show
        Aman Sinha added a comment - This is an older bug and is not reproducible anymore...also confirmed with Neeraja. Marking this as fixed. Please re-open another bug if new issues related to this are found.
        Jacques Nadeau made changes -
        Assignee Jinfeng Ni [ jni ] Aman Sinha [ amansinha100 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.5.0 [ 12324880 ]
        Fix Version/s 0.4.0 [ 12324963 ]
        Jacques Nadeau made changes -
        Fix Version/s 1.0.0-BETA1 [ 12324963 ]
        Jacques Nadeau made changes -
        Priority Major [ 3 ] Critical [ 2 ]
        Jacques Nadeau made changes -
        Assignee Jinfeng Ni [ jni ]
        Component/s Query Planning & Optimization [ 12322681 ]
        Jake Farrell made changes -
        Field Original Value New Value
        Workflow no-reopen-closed, patch-avail [ 12856798 ] no-reopen-closed, patch-avail, testing [ 12860057 ]
        Neeraja created issue -

          People

          • Assignee:
            Krystal
            Reporter:
            Neeraja
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development