Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-1809

Select * from multi-regions hbase table fails

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 0.7.0
    • Fix Version/s: Future
    • Component/s: Storage - HBase
    • Labels:
      None

      Description

      git.commit.id=58994af57cb65752027b121acc659ca8afa0ae45

      Selecting "*" from a hbase table with mulitple regions fails. For example,

      0: jdbc:drill:schema=hbase> select * from voter limit 10;
      Query failed: Query failed: Failure while running fragment.[ 9c1091d4-6714-46d9-afbc-1a812442c383 on qa-node114.qa.lab:31010 ]
      [ 9c1091d4-6714-46d9-afbc-1a812442c383 on qa-node114.qa.lab:31010 ]

      Error: exception while executing query: Failure while executing query. (state=,code=0)
      0: jdbc:drill:schema=hbase> select * from voter limit 10;
      Query failed: Query failed: Failure while running fragment.[ da56e55a-ca96-4df8-b6f4-e1726282941f on qa-node114.qa.lab:31010 ]
      [ da56e55a-ca96-4df8-b6f4-e1726282941f on qa-node114.qa.lab:31010 ]

      Attached is the server log for the above query.

      If perform a select "*" without a limit, partial rows are returned then failed:

      0: jdbc:drill:schema=hbase> select * from voter;
      ----------------------------------------------------

      row_key fourcf onecf threecf twocf

      ----------------------------------------------------

      [B@2ed26659 {"create_date":"MjAxNC0wNS0yNyAwMTo1Njo0Mw=="} {"name":"eGF2aWVyIHdoaXRl"} {"contributions":"OTUxLjA1","voterzone":"NzMwMA=="} {"age":"NDc=","registration":"aW5kZXBlbmRlbnQ="}
      [B@773d7512 {"create_date":"MjAxNC0wNC0xMCAwNDozNTowNg=="} {"name":"aG9sbHkgaGVybmFuZGV6"} {"contributions":"NjIxLjQ0","voterzone":"Mjk3MTQ="} {"age":"Mzc=","registration":"Z3JlZW4="}
      [B@63d12de6 {"create_date":"MjAxNC0xMi0xMSAxMTo0Njo1Nw=="} {"name":"aG9sbHkgYnJvd24="} {"contributions":"NTMyLjA2","voterzone":"MTA0Nw=="} {"age":"MzM=","registration":"bGliZXJ0YXJpYW4="}
      [B@3a1c8a3c {"create_date":"MjAxNC0wNS0yMSAwNDoxMjozMQ=="} {"name":"Ym9iIGVsbGlzb24="} {"contributions":"ODc0LjE4","voterzone":"OTk1Mg=="} {"age":"MzA=","registration":"cmVwdWJsaWNhbg=="}
      [B@27b786f2 {"create_date":"MjAxNS0wMS0xOSAwMDo1NDo0NA=="} {"name":"ZnJlZCBsYWVydGVz"} {"contributions":"ODEuNDQ=","voterzone":"MjU1OTA="} {"age":"MzY=","registration":"Z3JlZW4="}

      .
      .
      .

      [B@748f2244 {"create_date":"MjAxNC0xMS0wMyAxNTo1NTozNg=="} {"name":"aG9sbHkgc3RlaW5iZWNr"} {"contributions":"ODEwLjY=","voterzone":"MTQ4MDk="} {"age":"Mzg=","registration":"cmVwdWJsaWNhbg=="}

      java.lang.RuntimeException: java.sql.SQLException: Failure while executing query.
      at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
      at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
      at sqlline.SqlLine.print(SqlLine.java:1809)
      at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
      at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
      at sqlline.SqlLine.dispatch(SqlLine.java:889)
      at sqlline.SqlLine.begin(SqlLine.java:763)
      at sqlline.SqlLine.start(SqlLine.java:498)
      at sqlline.SqlLine.main(SqlLine.java:460)

        Attachments

        1. hbase.log
          131 kB
          Krystal
        2. Alex_drillbit.out
          22 kB
          Alexander Zarei
        3. alex_drillbit.log
          139 kB
          Alexander Zarei

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              knguyen Krystal
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: