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

Queries against hbase table with multiple regions return null

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.5.0
    • Storage - HBase
    • None

    Description

      git.commit.id.abbrev=894037a

      This is a regression. Ran the following query in sqlline:
      0: jdbc:drill:schema=dfs> select cast(row_key as integer) voter_id, cast(onecf['name'] as varchar(30)) name, cast(twocf['age'] as integer) age, cast(twocf['registration'] as varchar(20)) registration, cast(threecf['contributions'] as decimal(6,2)) contributions, cast(threecf['voterzone'] as integer) voterzone,cast(fourcf['create_date'] as timestamp) create_date from hbase.voter where row_key = 5;
      ------------------------------------------------------------------------------

      voter_id name age registration contributions voterzone create_date

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

      5 null null null null null 1970-01-01 00:00:00.0

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

      The same query returns expected data against an hbase table that resides in single partition.

      Attachments

        1. votertab
          62 kB
          Krystal
        2. DRILL-1039.patch
          3 kB
          Mehant Baid

        Issue Links

          Activity

            People

              DrillCommitter DrillCommitter
              knguyen Krystal
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: